Question

Alt Ctr End Part 3: (100 points) You will find the data need in the provided Excel document in d21. Take the dato for Weekly hours worked. Find the class width using 5 classes class width Zof classes below i of Fill out the following frequency table Hours worked Midpoint (Class Width) Cumulative Relative i Frequency Frequency-Frequency Using Excel, Make a histogram (sides of the bars must touch) using the midpoints and the frequency. Make sure the grophisied your axis are labeled. Copy and paste histogram in the space below 1530 Project Page 4 of 8 84913661437455 4551s 9 6 6 7 1 3 4 8 8 8 8 1 2 9 .9 2 5 5 5 19 .4 7 Tru 410 SO 12 36 4 2 0 6 s s 2 30 s o o s B 5 6 4 10 2 2 2 3 2 1 30 1 8 4 s s 10 10 2 3 31 24 19 35 12 40 40 40 30 26 2.5 43 30 37 26 16 2 2 40 12 8 1 2 2 45 30 40 54 64 38 2 5 5 2 2 1 3 2 3 4 7 3 2 2 3 1 1 20 4 9 5 55 2.5 1 3 5 5 2 2 1 3 3 2 2 6 9699 81517 12331

Answer 1

Class Width = (Max - Min)/No. of classes = (64 - 6)/5 = 11.6

Frequency Table is as follows:

Hours Worked (Class Width)	Midpoint	Frequency	Relative Frequency	Cumulative Frequency
6-17.6	8.8	6	0.182	0.182
17.6-29.2	23.4	10	0.303	0.485
29.2-40.8	35	12	0.364	0.848
40.8-52.4	46.6	3	0.091	0.939
52.4-64	58.2	2	0.061	1.000

Where Hours Worked range is defined using the class width calculated above, Frequency is the no. of data points in the particular class, and Relative Frequency is the fraction of data points in a particular class. Cumulative Frequency is the nothing but the running sum of the relative frequencies (total frequency of all classes upto and including this class)

The histogram using the midpoints and the frequency can be charted out in Excel (Select the data -> Insert Column or Bar Chart -> Clustered Bar, then just right click on the bars -> Format Data Series -> Set Gap Width to 0).

Histogram - Hours Worked (Midpoint) 58.2 46.6 3 35 I 23.4 8.8 4 10 12 Frequency