Files To Download for Chapter 11:
Excel file: Excel2013StatisticsChapter11.xlsx
PDF file: Ch11PDFBusn210.pdf
Data Set For Ch 03 Homework File #22, 24: DataSetsForHomeworkProblemsChapter11.xlsx
Videos To Watch:
Excel 2013 Statistical
Analysis #70: Sampling Distribution of Pbar1 – Pbar2, Mean & Standard Error (24:15
min)
Excel 2013 Statistical Analysis #71: Inference About Difference Between 2 Pop. Proportions Z Method (28:03 min)
Excel 2013 Statistical Analysis #72: Chi-Square Test For 2 or More Population Proportions (Formulas) (30:10 min)
Excel 2013 Statistical Analysis #73: Chi-Square Test Independence 2 Categorical Var. (PivotTables) (23:07 min)
Extra Videos:
Excel Magic Trick
1208: Combine 4 Columns into 1 Table For PivotTable Report (without Power Query)
(11:08 min)
Extra Workbook that goes with video #1208:
EMT1206-1209.xlsx
Excel Magic Trick 1210:
Power Query to Combine 4 Columns into 1 Table For PivotTable Report (08:12
min)
Extra Workbook that goes with video #1210:
EMT1210-1214..xlsx