Chap3 Descriptive statistics -numerical measures Minitab & Excel
大綱 Minitab –descriptive statistic Minitab-box plot Minitab-covariance and correlation Excel-descriptive statistic Excel-covariance and correlation Excel-descriptive statistics tool 練習
Minitab –descriptive statistic 1.匯入Startsalary資料-選擇stat 2.basic statistic 3.display descriptive statistic
Minitab-descriptive statistic 2.basic statistics 3.display descriptive statistic 4.statistics-skewness(偏度)
Minitab-box plot 1.選擇graph 2.boxplot 3.simple
Minitab-covariance and correlation 匯入Stereo 1.選擇stat 2.basic statistics 3.covariance(correlation)
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)
Excel-covariance and correlation 匯入Stereo covariance=COVAR(B2:B11,C2:C11) correlation coefficient=CORREL(B2:B11,C2:C11)
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.選擇摘要統計
練習 1.使用Disney資料,以minitab及excel資料分析工具計算總收入、平均數、中位數,並畫出box plot(p91, exercise 12) 2.使用StockMarket資料,並以minitab及excel計算covariance和correlation coefficient(p118, exercise 50)