Files To Download for Chapter 03:
Zipped Raw Data Files For Whole Textbook: HomeworkRawDataFiles.zip
Excel file:
Excel2010StatisticsCh03.xlsm (when you download file name is "Excel2010StatisticsCh03correct.xlsm")
Second Excel File To Download:
Excel2010StatisticsCh03SecondFile.xlsm
Thrid Excel File To Download:
Excel2010StatisticsCh03ThirdFile.xlsm
Not Required for Class
PowerPoint file: MBS4ch03a.pptx
MBS4ch03b.pptx (Textbook PowerPoints - not necessary or
required – download only if you want)
Videos To Watch:
Excel 2010 Statistics #24: Conditional Formatting Cell Chart Histogram (3 mins) Not Required To Watch for Class
Excel 2010 Statistics #25: Typical Values: Mean, Median, Mode (28 mins)
Excel 2010 Statistics #26: Location: Mean, Median, Mode, Percentile, Quartile, PercentileRank (13 mins)
Excel 2010 Statistics #27: Excel 2010 Functions for Percentile, Quartile and Rank (24 mins)
Excel 2010 Statistics #28: Box & Whisker Plot: Stacked Bar with Mean Point Plotted and Outlier Lines (23 mins) Not Required To Watch for Class
Excel 2010 Statistics #29: Means: Weighted, Trimmed, From Grouped Data, Geometric Mean (16 mins)
Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points? (42 mins)
Excel 2010 Statistics #31: z-Scores, Chebyshev's Theorem and Empirical Rule (28 mins)
Excel 2010 Statistics #32: Detecting Outliers (6 mins)
Excel 2010 Statistics #33: SKEW function, Relationship between Mean Median & Mode and Skew (7 mins)
Excel 2010 Statistics #34: Data Analysis Add-in Descriptive Statistics tool (3 mins)
Excel 2010 Statistics #34.5: Z-Score IF, Standard Deviation IF, Mean IF, Mode IF, Median IF (16 mins) Not Required To Watch for Class