课程编码
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