Files To Download for Chapter 02:
Excel File that goes with Videos: Excel2013StatisticsChapter02.xlsx
Zipped Folder that goes along with Video #11 (Power Query Example): Grades.zip
Data Set For Ch 02 Homework File #8,21,35,52,56: DataSetsForHomeworkProblemsChapter02.xlsx
Videos To Watch:
Excel 2013 Statistical Analysis #06: Frequency Distributions & Column Charts, Categorical Variables (33:31 minutes)
Excel 2013 Statistical Analysis #07: Subtle Chart Junk (03:25 minutes)
Excel 2013 Statistical Analysis #8: Frequency Distributions, Histograms, Skew, Quantitative Variable (41:35 minutes)
Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula (15:47 minutes)
Excel 2013 Statistical Analysis #10: Description of Dot Plot and Stem and Leaf Charts (02:48 minutes)
Not Required For Class: Excel 2013 Statistical Analysis #11: Power Query Import Multiple Text Files, Grade Histogram by Year (09:01 minutes)
Excel 2013 Statistical Analysis #12: Cross Tabulation & Charts For Two Variables, Simpson’s Paradox (18:36 minutes)
Excel 2013 Statistical Analysis #13: Scatter Chart & Trendline, X Y Data, 2 Quantitative Variables (07:21 minutes)
Excel 2013 Statistical Analysis #14: VLOOKUP to Add New Field To Table & Create Cross Tabulation (13:04 minutes)