Excel For Statistical Data Analysis培训

课程编码

excelstatsda

课程时长

14 小时 通常来说是2天,包括中间休息。

要求

Participants should be familiar with the basics of Excel and Statistics.

课程概览

听众

分析师,研究人员,科学家,毕业生和学生以及任何有兴趣学习如何在Microsoft Excel统计分析的人。

课程目标

本课程将有助于提高您对Excel和统计数据的熟悉程度,从而提高您的工作或研究的效率和效率。

本课程介绍如何在Microsoft Excel使用Analysis ToolPack,统计函数以及如何执行基本统计过程。它将解释Excel限制以及如何克服它们。

Machine Translated

课程大纲

Aggregating Data in Excel

  • Statistical Functions
  • Outlines
  • Subtotals
  • Pivot Tables

Data Relation Analysis

  • Normal Distribution
  • Descriptive Statistics
  • Linear Correlation
  • Regression Analysis
  • Covariance

Analysing Data in Time

  • Trends/Regression line
  • Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
  • Seasonal fluctuations analysis

Comparing Populations

  • Confidence Interval for the Mean
  • Test of Hypothesis Concerning the Population Mean
  • Difference Between Mean of Two Populations
  • ANOVA: Analysis of Variances
  • Goodness-of-Fit Test for Discrete Random Variables
  • Test of Independence: Contingency Tables
  • Test Hypothesis Concerning the Variance of Two Populations

Forecasting

  • Extrapolation

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

该网站在其他国家/地区