Files To Download for Chapter 03:
Excel File that goes with Videos: Excel2013StatisticsChapter03.xlsm
Data Set For Ch 03 Homework File #12,26,27,52,59,66,71: DataSetsForHomeworkProblemsChapter03.xlsx
Videos To Watch:
Excel 2013 Statistical Analysis #16: Location: Mean, Median, Mode for Central Location (24:14 min)
Excel 2013 Statistical Analysis #17: Weighted Mean & SUMPRODUCT Function & Accounting Example (11:48 min)
Excel 2013 Statistical Analysis #18: Geometric Mean, Average Compounding Rate GEOMEAN & RRI (19:09 min)
Excel 2013 Statistical Analysis #19: Location: Percentile, Quartile, Rank and Percentile Rank (20:54 min)
Excel 2013 Statistical Analysis #20: Standard Deviation: How Fairly Does Mean Represent Data Points? (29:58 min)
Excel 2013 Statistical Analysis #21: SKEW Function and Asymmetry in a Distribution of Data Points (5:00 min)
Excel 2013 Statistical Analysis #22: Z-Score = # of Standard Deviations, Chebshev’s &Empirical Rule (31:53 min)
Excel 2013 Statistical Analysis #23: Five Number Summary, Outliers and Box Plots (11:44 min)
Excel 2013 Statistical Analysis #24: Numerical Measures: Covariance and Correlation Coefficient (19:22 min)
Extra Video:
Excel Magic Trick 1207:
PERCENTILE.EXC, PERCENTILE.INC, QUARTILE.EXC, QUARTILE.INC Functions (12:51
min)
Extra
Workbook that goes with video #1207:
EMT1206-1209.xlsx
Percentile workbook: Chapter03-Percentiles.xlsx