One-Variable Statistics (Chapter 2)
Lesson 2: Use of Technology for Graphical Data Displays (2.1)
In this course, we are using Microsoft Excel 2007 to create graphical displays.
Visit YouTube playlist from ExcelsFun for Excel 2010 tutorials.
In this course, we are using Microsoft Excel 2007 to create graphical displays.
Visit YouTube playlist from ExcelsFun for Excel 2010 tutorials.
Video 1: Excel 2007 Basic Functions: Sum, Mode, Median & Mean/Average
Video 2: Creating Frequency Table from Raw Data
Video 3: Creating Bar Graph with Given Frequency Table
Video 4: Creating Relative Frequency Table and Histogram
Note: When graphing histograms by hand, avoid labelling with the intervals if possible.
Video 5: Creating Frequency Polygon from Frequency Table
Note: The intervals for the classes/categories must be equidistant for calculating the midpoints
Video 6: Creating Pie Chart from Frequency Table (3D)
Video 7: Creating Pie Chart from Frequency Table (2D)
Video 8: Creating Cumulative Frequency Diagram or Ogive
Note: When graphing histograms by hand, avoid labelling with the intervals if possible.
Assignment (Due via email on September 10, 2014 by 11:59 pm):
1. eBook 2.1: Do exercises on p. 102 - #8, #9, #13
2. eBook 2.7: Do exercises on p. 151 - #2, #3
Use only one Excel file and name it using the format MDM4U_Assign1_Yourfullname.
Within the file, use one worksheet for each question.
Ms. Chor's Email: [email protected]
Late Assignment: 10% deducted per day (after Sept. 10, 2014 11:59 pm)