課程簡介
聚合 Excel 中的數據
- 統計函數
- 概述
- 小計
- 數據透視表
數據關係分析
- 正態分佈
- 描述性 Statistics
- 線性相關
- 回歸分析
- 協方差
及時分析數據
- 趨勢/回歸線
- 線性、對數、多項式、冪、指數、移動平均平滑
- 季節性波動分析
比較種群
- 均值的置信區間
- 關於總體均值的假設檢驗
- 兩個總體的均值之間的差異
- 方差分析:方差分析
- 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.