Question

Work on excel

Design.xlsx.

(a) Contruct a Frequency Histogram with a revised Bin size. (Bin width =3 ). Hint: Use Data Analysis from Data menu, Histogram to create a Bin size of the desired bin width(=3). (b) Construct A Cumulative Percentage Histogram. (c) Contruct A Frequency Polygon. [ Hint: Use Line Graph]

Rating
34
32
24
32
31
32
33
25
30
28
28
30
33
27
20
30
33
34
29
33
34
31
31
32
26
22
31
31
32
30
33
27
32
33
28
30
28
32
30
29
26
32
25
33
35
27
29
31
32
32
33
34
32
29
33
29
31
31
34
33

Answer 1

(a) and (b) Enter the values in excel

Rating in C2 to C61 And Bins in E2 to E4 ( as we need bins width =3 , thus bin ranges are  20-23,23-26,26-29,29-32,32-35 we write only 23,26,29 etc)

	Ratings		Bins
	20		23
	22		26
	24		29
	25		31
	25		35
	26
	26
	27
	27
	27
	28
	28
	28
	28
	29
	29
	29
	29
	29
	30
	30
	30

From Data tab select Data Analysis , a drop down menu will appear , select histogram , then input range $C$2 -$C$61 and bin range $E$2 -$E$6

select cumulative percentage and chart output

The output is shown below

Bin	Frequency	Cumulative %
23	2	3.33%
26	5	11.67%
29	12	31.67%
31	14	55.00%
35	27	100.00%
More	0	100.00%

(c) Now to draw frequency polygon

Select the frequency table from the output

Bin	Frequency
23	2
26	5
29	12
31	14
35	27

Go to charts under insert tab , select line graph