statistics/

graded_assignment_7.xlsx

#1-12

Rating	60 randomly selected shoppers have a rated a new bottle design for a popular soft drink.
34	(50 points total)
32
24	#1	Sort the data as ascending.	(2 points)
32
31	#2	Use Sturges's formula to find the number of classes that should be used to construct a frequency distribution for the bottle design ratings. (2 points)
32		Note: based on how the class width is rounded, the final table could have more or fewer classes than this.
33
25	#3	Find the range. (2 points)
30
28	#4	Find the class width. Remember to round up. (2 points)
28
30	#5	Define the nonoverlapping classes for a frequency distribution by finding the lower and upper limits. (8 points)
33
27	#6	Find the frequencies for each class and develop a frequency distribution. (4 points)
20
30	#7	Compute the relative frequencies and percent frequencies. (8 points)
33
34	#8	Find the midpoints of the classes. (4 points)
29
33	#9	Draw the frequency histogram for the ratings data, and describe the distribution shape. (4 points)
34		Label the horizontal axis with the midpoints.
31
31	#10	Approximate the standard deviation using the range rule of thumb. SD is approx range/4. (2 points)
32
26	#11	Find the summary statistics; in particular the mean, median, mode, variance, and standard deviation. (10 points)
22
31	#12	Find the coefficient of variation. (2 points)		CV = SD/Mean*100
31		Use the mean and SD from the computed statistics in #11.
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

Nicotine content (mg)	The nicotine content of 29 brands of cigarettes are listed in column A.
0.1	(48 points total)
0.2
0.5	The data is already sorted.
0.6
0.7	#13	Use Sturges's formula to find the number of classes that should be used to construct a frequency distribution for the nicotine content of cigarettes.
0.7		(2 points)	Note: based on how the class width is rounded, the final table could have more or fewer classes than this.
0.8
0.8	#14	Find the range. (2 points)
0.8
0.8	#15	Find the class width. Remember to round up. (2 points)
0.9
1.0	#16	Define the nonoverlapping classes for a frequency distribution by finding the lower and upper limits. (8 points)
1.0
1.0	#17	Find the frequencies for each class and develop a frequency distribution. (4 points)
1.0
1.0	#18	Compute the relative frequencies and percent frequencies. (8 points)
1.0
1.0	#19	Find the midpoints of the classes. (4 points)
1.1
1.1	#20	Draw the frequency histogram for the nicotine data, and describe the distribution shape. (4 points)
1.1		Label the horizontal axis with the midpoints.
1.2
1.2	#21	Approximate the standard deviation using the range rule of thumb. SD is approx range/4. (2 points)
1.2
1.2	#22	Find the summary statistics; in particular the mean, median, mode, variance, and standard deviation. (10 points)
1.2
1.3	#23	Find the coefficient of variation. (2 points)		CV = SD/Mean*100
1.4		Use the mean and SD from the computed statistics in #22.
1.4