Chap3 Descriptive statistics -numerical measures Minitab & Excel

Presentation on theme: "Chap3 Descriptive statistics -numerical measures Minitab & Excel"— Presentation transcript:

1 Chap3 Descriptive statistics -numerical measures Minitab & Excel

2 大綱 Minitab –descriptive statistic Minitab-box plot
Minitab-covariance and correlation Excel-descriptive statistic Excel-covariance and correlation Excel-descriptive statistics tool 練習

3 Minitab –descriptive statistic
1.匯入Startsalary資料－選擇stat 2.basic statistic 3.display descriptive statistic

4 Minitab-descriptive statistic
2.basic statistics 3.display descriptive statistic 4.statistics-skewness(偏度)

5 Minitab-box plot 1.選擇graph 2.boxplot 3.simple

6 Minitab-covariance and correlation
匯入Stereo 1.選擇stat 2.basic statistics 3.covariance(correlation)

7 Excel-descriptive statistic
匯入Start salary Mean=AVERAGE(B2:B13) Median=MEDIAN(B2:B13) Mode=MODE(B2:B13) Variance=VAR(B2:B13) Standard Deviation=STDEV(B2:B13)

8 Excel-covariance and correlation
匯入Stereo covariance=COVAR(B2:B11,C2:C11) correlation coefficient=CORREL(B2:B11,C2:C11)

9 Excel-descriptive statistics tool
匯入Start salary 1.選擇data 2.資料分析 – 敘述統計 3.input range: B1:B13 4.逐欄 5.labels in first row（類別軸標記是在第一列上） 6.output range :D1 7.選擇摘要統計

10 練習 1.使用Disney資料，以minitab及excel資料分析工具計算總收入、平均數、中位數，並畫出box plot(p91, exercise 12) 2.使用StockMarket資料，並以minitab及excel計算covariance和correlation coefficient(p118, exercise 50)