Files To Download for Chapter 09:
Zipped Raw Data Files For Whole Textbook: HomeworkRawDataFiles.zip
Excel file: Busn210ch09-First.xlsm
Busn210ch09-Second.xlsm
(huge file 10 MB - has many pictures)
PDF file: Ch09Busn210.pdf (47 pages -
full handwritten notes from Michael Girvin)
Short-FormulasAndProceduresCh09Busn210.pdf (7 pages - just Formulas and
Procedures)
DrawingsFromVideo.tiff (these are already in
Excel workbook)
PowerPoint file: ch09.pptx (Textbook PowerPoints -
NOT necessary or
required – download only if you want)
Videos To Watch:
Excel 2010 Statistics 78: 5 Steps Hypothesis Testing Population Mean: P-value & Critical Value Methods (41 mins)Excel 2010 Statistics 79: 1 Tail Left z Distribution Mean Hypothesis Testing P-value Critical Value (14 mins)
Excel 2010 Statistics 80: Two Tail z Distribution Mean Hypothesis Testing P-value Critical Value (14 mins)
Excel 2010 Statistics 81: NORM.S Functions Hypothesis Testing p-value & Critical Values (9 mins)
Excel 2010 Statistics 82: 1 Tail Right t Distribution Mean Hypothesis Testing P-value Critical Value (15 mins)
Excel 2010 Statistics 83: 1 Tail Left t Distribution Mean Hypothesis Testing P-value Critical Value (10 mins)
Excel 2010 Statistics 84: Two Tail t Distribution Mean Hypothesis Testing P-value & Critical Value (11 mins)
Excel 2010 Statistics 85: T Functions Hypothesis Testing for p-value & Critical Values 11 Examples (12 mins)
Excel 2010 Statistics 86: Hypothesis Test for Proportions using p-value or Critical Value (11 mins)