1) Download files:
Excel File that goes with Videos:
Ch03-ESA.xlsm
CSV Fie that goes along with video #16:
CPAScoreData.csv
Data Set For Ch 03 Homework File #43: BestCities.csv
2) Click below links to watch class videos at YouTube:
Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average,
Skew & More!
Excel Statistical Analysis 10: Weighted Mean
Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding
Rate per Period
Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank
Functions & Algorithms
Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient
of Variation
Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of
Standard Deviations
Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power
Query & Array Formulas
3) When you are done studying the videos, then you download homework templates from Canvas, read the textbook, and complete textbook homework problems for practice.
4) After you are done studying the above videos and textbook work, download the Test #3 file and the test csv files to the Busn 210 class folder you created in video #1.
Here are the
files:
Test03
csv file
for test Problem04
csv
file for test Problem05
After you have completed your test, then upload to the Home Area of Canvas.