Back To Busn 210 Home Page

1) Download files:

Excel File that goes with Videos: Section03-ESA.xlsx 
CSV File that goes along with video #15: CPAScoreData.csv

Excel Homework for Section 2: Section03-HW.xlsx

Pdf Notes for Section 3: Section03-ESA.pdf (click to view, right-click and Save As to download)

2) Click below links to watch class videos at YouTube:

Excel Statistical Analysis 09: Location, Mean, Median, Mode, Moving Average, Skew & More!   (40:24 min)
        Video #9: Skip The Covid Part: (29:18 to 37:37)"Use Power Query to Import CSV data from a covid government site"

Excel Statistical Analysis 10: Weighted Mean  (11:21 min)

Excel Statistical Analysis 11: Geometric Mean to Calculate Average Compounding Rate per Period  (15:51 min)

Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms  (19:06 min)

Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation  (26:06 min)

Excel Statistical Analysis 14: Z-Score, Empirical Rule , Chebyshev Theorem: # of Standard Deviations  (23:55 min)

Excel Statistical Analysis 15: 5-Number Summary / Box & Whiskers Chart: Power Query & Array Formulas   (26:22 min)

3) When you are done studying the videos and completing the examples from the video for practice, then you download homework Excel File and complete homework problems for practice.