課程簡介
在Excel中聚合数据
- 统计函数
- 大纲
- 小计
- 数据透视表
数据关系分析
- 正态分布
- 描述性Statistics
- 线性相关
- 回归分析
- 协方差
时间数据分析
- 趋势/回归线
- 线性、对数、多项式、幂、指数、移动平均平滑
- 季节性波动分析
比较群体
- 均值的置信区间
- 关于总体均值的假设检验
- 两个总体均值的差异
- ANOVA:方差分析
- Go离散随机变量的拟合优度检验
- 独立性检验:列联表
- 关于两个总体方差的假设检验
Forecasting
- 外推法
最低要求
參與者應熟悉Excel和Statistics的基礎知識。
客戶評論 (3)
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
Course - Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Course - Excel For Statistical Data Analysis
The fact he had dif excel and data sheets with exercises for us to do.