Overview
Homework 0: Watch the
video https://www.youtube.comwww.youtube.com/watch?
V=ABIrYolc_Vo and use Excel for the following
- Enter the following in a column using Excel Age (60,35, 37, 21,38, 58, 58,59
,58,55,54, 22, 33,59,55,53, 57,40
47,48,50,58,45, 42,56,57,43,49,52,
22, 25) - Create a frequency table for classes 0-25, 26-35,36-45, 47-60 see the video _https://www.youtube.com/watc
h?v=Qd6YmOujr_A
C. Create a column for the midpoint for each class
- Create class boundaries for each class
- Create a column to represent commutative frequency
- Create a histogram between the midpoint on the x-axis and frequency on the y-axis
Homework 1, and 2: Use the files below to do homework 1 and 2
(Submit as Excel file)
Submit the file which has the work for Homework 0, 1 and 2