Michael Girvin - Business Department, Highline Community College

Fall:
Busn216
Busn101
Busn233
Classes:             
Busn135
Busn214
Busn210
Acc121
You Tube Excel Videos & Excel is
Fun Book


Home Page
Links

Personal Info
Business Dept

Highline

Download PowerPoint (if you want):

Busn210ch03.ppt

Download "By Hand Notes" (if you want):

Busn210Ch03.pdf (To download, right-click and point to "Save Target As")

Download Solutions To Homework (Excel Workbooks):

Busn210ch03-HW.xls

Download Excel Workbooks To Complete While Watching Videos:

Busn210Ch03StartFile
Busn210Ch03FinishedFile
Busn210Ch03ExtraArithmeticMeanVs.GeometricMeanStart&FinishedFile

 

Watch videos three different ways:

1) Custom Player, click and watch here (18 videos, 175 minutes):

 

2) Click on link to go to YouTube and watch videos (18 videos, 175 minutes):

Excel Statistics 33: Measures Of Location
Excel Statistics 34: MEAN, MEDIAN, MODE (Averages)
Excel Statistics 35: Weighted Mean & Geometric Mean
Excel Statistics 35.2: Geometric Average V Arithmetic Mean - Finance Example  (Not required for class)
Excel Statistics 36: Trimmed Mean
Excel Statistics 37: PERCENTILE & QUARTILE
Excel Statistics 38: Data Analysis Add-in Rank & Percentile
Excel & Statistics 39: Variability Chart - Visual Approach
Excel & Statistics 40: Range & Interquartile Range (Variability)
Excel & Statistics 41: Sample Standard Deviation (Variability)
Excel & Statistics 42: Coefficient of Variation
Excel & Statistics 43: Data Analysis Add-in Descriptive Statistics
Excel & Statistics 44: Skew & SKEW function
Excel & Statistics 45: Z-Score (# Standard Deviations From Mean)
Excel & Statistics 46: Chebyshev's Theorem
Excel & Statistics 47: Empirical Rule (Bell Shaped Curve)
Excel & Statistics 48: Empirical Rule vs. Chebyshev's Theorem
Excel & Statistics 49: Outliers & Box Plot with Median and Mean  

3) Click on link to go to YouTube Playlist (18 videos, 175 minutes):

Excel Statistics Business Class Ch03: Numerical Measures

Other Related YouTube Videos:
Excel Magic Trick 337: RANK function 10 Examples
Excel Magic Trick #97: AVEDEV function
Excel Magic Trick # 3: AVERAGE & Go To Blanks


Michael GirvinOffice Hours and contact information