Files To Download for Chapter 02:
Zipped Raw Data Files For Whole Textbook: HomeworkRawDataFiles.zip
Excel file: Busn210Excel2010Chapter02.xlsm
PowerPoint file: MBS4ch02a.pptx (Textbook
PowerPoints - not necessary or
required – download only if you want)
Videos To Watch:
Excel 2010 Statistics #15: Frequency Distributions, Histograms, Column Charts (11 Examples) (1 hour 20 mins) You may have to watch part, stop, come back watch another part...
If you are using Excel 2013, watch this extra video that shows how to
make a Histogram in Excel 2013:
Highline Excel 2013 Class
Video 46: Statistics: Histogram Formulas & Chart in Excel 2013
Here is workbook to
download and follow along:
Busn214-Week09.xlsm
Excel 2010 Statistics #16: Relative & Percent Frequency Distributions & Pie Chart & Histogram (17 mins)
Excel 2010 Statistics #17 Ogive Chart Formula PivotTable Data Analysis Toolpak Add-in & Pareto Chart (35 mins)
Excel 2010 Statistics #18: Frequency Distribution Shape & Histogram Skew & Sparklines (15 mins)
Excel 2010 Statistics #19: Dot Plot Chart with REPT and COUNTIFS functions (11 mins)
Excel 2010 Statistics #20: Stem and Leaf Chart with REPT and COUNTIFS functions (8 mins) Not Required To Watch for Class
Excel 2010 Statistics #21: Cross Tabulation With PivotTable Frequencies and % Column & % Row (15 mins)
Excel 2010 Statistics #22: Cross Tabulation With Formulas (5 mins) Not Required To Watch for Class
Excel 2010 Statistics #23: Scatter Diagram to show Relationship Between Two Quantitative Variables (10 mins)