Question

FREQUENCY DISTRIBUTION TABLE EXERCISE As part of a larger study, a long-distance company wanted to acquire information about monthly bills of new subscribers in the first month after signing with the company. The company's marketing manager conducted a survey of 200 new residential subscribers wherein the first month's bills were recorded. These data are listed below in dollar amounts. 42.19 39.21 75.71 8.37 1.62 28.77 35.52 13.90 114.67 15.30 38.45 48.54 88.62 7.18 91.10 9.12 117.69 9.22 27.57 75.49 29.23 93.31 99.50 11.07 10.88 118.75 106.84 109.94 64.78 68.69 89.35 104.88 85.00 1.47 30.62 0 8.40 10.70 45.81 35.00 118.04 30.61 0 26.40 100.05 13.95 90.04 0 56.04 9.12 110.46 22.57 8.41 13.26 26.97 14.34 3.85 11.27 20.39 18.49 0 63.70 70.48 21.13 15.43 79.52 91.56 72.02 31.77 84.12 72.88 104.84 92.88 95.03 29.25 2.72 10.13 7.74 94.67 13.68 83.05 6.45 3.20 29.04 1.88 9.63 5.72 5.04 44.32 20.84 95.73 16.47 115.50 5.42 16.44 21.34 33.69 33.40 3.69 100.04 103.15 89.50 2.42 77.21 109.08 104.40 115.78 6.95 19.34 112.94 94.52 13.36 1.08 72.47 2.45 2.88 0.98 6.48 13.54 20.12 26.84 44.16 76.69 0 21.97 65.90 19.45 11.64 18.89 53.21 93.93 92.97 13.62 5.64 17.12 20.55 0 83.26 1.57 15.30 90.26 99.56 88.51 6.48 19.70 3.43 27.21 15.42 0 49.24 72.78 92.62 55.99 6.95 6.93 10.44 89.27 24.49 5.20 9.44 101.36 78.89 12.24 19.60 10.05 21.36 14.49 89.13 2.80 2.67 104.80 87.71 119.63 8.11 99.03 24.42 92.17 111.14 5.10 4.69 74.01 93.57 23.31 9.01 29.24 95.52 21.00 92.64 3.03 41.38 56.01 0 11.05 84.77 15.21 6.72 106.59 53.90 9.16 45.77 1. Construct a frequency distribution table. 2. Compute for the mean, median, mode, standard deviation, variance, range, mean absolute deviation, coefficient of variation and coefficient of skewness of the grouped data. 3. Draw the frequency polygon for the above data. 4. Construct the Box and Whisker Plot for the raw data. Are there any outliers? If so, identify them. 5. Describe the shape of the distribution. What can you say about the monthly bills of the new subscribers in the first month after signing with the company? Use pareto chart for your analyses.

          FREQUENCY DISTRIBUTION TABLE EXERCISE
As part of a larger study, a long-distance company wanted to acquire information about monthly bills of new subscribers in the first month after signing with the company. The company's marketing manager conducted a survey of 200 new residential subscribers wherein the first month's bills were recorded. These data are listed below in dollar amounts.

42.19 39.21 75.71 8.37 1.62 28.77 35.52 13.90 114.67 15.30
38.45 48.54 88.62 7.18 91.10 9.12 117.69 9.22 27.57 75.49
29.23 93.31 99.50 11.07 10.88 118.75 106.84 109.94 64.78 68.69
89.35 104.88 85.00 1.47 30.62 0 8.40 10.70 45.81 35.00
118.04 30.61 0 26.40 100.05 13.95 90.04 0 56.04 9.12
110.46 22.57 8.41 13.26 26.97 14.34 3.85 11.27 20.39 18.49
0 63.70 70.48 21.13 15.43 79.52 91.56 72.02 31.77 84.12
72.88 104.84 92.88 95.03 29.25 2.72 10.13 7.74 94.67 13.68
83.05 6.45 3.20 29.04 1.88 9.63 5.72 5.04 44.32 20.84
95.73 16.47 115.50 5.42 16.44 21.34 33.69 33.40 3.69 100.04
103.15 89.50 2.42 77.21 109.08 104.40 115.78 6.95 19.34 112.94
94.52 13.36 1.08 72.47 2.45 2.88 0.98 6.48 13.54 20.12
26.84 44.16 76.69 0 21.97 65.90 19.45 11.64 18.89 53.21
93.93 92.97 13.62 5.64 17.12 20.55 0 83.26 1.57 15.30
90.26 99.56 88.51 6.48 19.70 3.43 27.21 15.42 0 49.24
72.78 92.62 55.99 6.95 6.93 10.44 89.27 24.49 5.20 9.44
101.36 78.89 12.24 19.60 10.05 21.36 14.49 89.13 2.80 2.67
104.80 87.71 119.63 8.11 99.03 24.42 92.17 111.14 5.10 4.69
74.01 93.57 23.31 9.01 29.24 95.52 21.00 92.64 3.03 41.38
56.01 0 11.05 84.77 15.21 6.72 106.59 53.90 9.16 45.77

1. Construct a frequency distribution table.
2. Compute for the mean, median, mode, standard deviation, variance, range, mean absolute deviation, coefficient of variation and coefficient of skewness of the grouped data.
3. Draw the frequency polygon for the above data.
4. Construct the Box and Whisker Plot for the raw data. Are there any outliers? If so, identify them.
5. Describe the shape of the distribution. What can you say about the monthly bills of the new subscribers in the first month after signing with the company? Use pareto chart for your analyses.

FREQUENCY DISTRIBUTION TABLE EXERCISE
As part of a larger study, a long-distance company wanted to acquire information about monthly bills of new subscribers in the first month after signing with the company. The company's marketing manager conducted a survey of 200 new residential subscribers wherein the first month's bills were recorded. These data are listed below in dollar amounts.

42.19 39.21 75.71 8.37 1.62 28.77 35.52 13.90 114.67 15.30
38.45 48.54 88.62 7.18 91.10 9.12 117.69 9.22 27.57 75.49
29.23 93.31 99.50 11.07 10.88 118.75 106.84 109.94 64.78 68.69
89.35 104.88 85.00 1.47 30.62 0 8.40 10.70 45.81 35.00
118.04 30.61 0 26.40 100.05 13.95 90.04 0 56.04 9.12
110.46 22.57 8.41 13.26 26.97 14.34 3.85 11.27 20.39 18.49
0 63.70 70.48 21.13 15.43 79.52 91.56 72.02 31.77 84.12
72.88 104.84 92.88 95.03 29.25 2.72 10.13 7.74 94.67 13.68
83.05 6.45 3.20 29.04 1.88 9.63 5.72 5.04 44.32 20.84
95.73 16.47 115.50 5.42 16.44 21.34 33.69 33.40 3.69 100.04
103.15 89.50 2.42 77.21 109.08 104.40 115.78 6.95 19.34 112.94
94.52 13.36 1.08 72.47 2.45 2.88 0.98 6.48 13.54 20.12
26.84 44.16 76.69 0 21.97 65.90 19.45 11.64 18.89 53.21
93.93 92.97 13.62 5.64 17.12 20.55 0 83.26 1.57 15.30
90.26 99.56 88.51 6.48 19.70 3.43 27.21 15.42 0 49.24
72.78 92.62 55.99 6.95 6.93 10.44 89.27 24.49 5.20 9.44
101.36 78.89 12.24 19.60 10.05 21.36 14.49 89.13 2.80 2.67
104.80 87.71 119.63 8.11 99.03 24.42 92.17 111.14 5.10 4.69
74.01 93.57 23.31 9.01 29.24 95.52 21.00 92.64 3.03 41.38
56.01 0 11.05 84.77 15.21 6.72 106.59 53.90 9.16 45.77

1. Construct a frequency distribution table.
2. Compute for the mean, median, mode, standard deviation, variance, range, mean absolute deviation, coefficient of variation and coefficient of skewness of the grouped data.
3. Draw the frequency polygon for the above data.
4. Construct the Box and Whisker Plot for the raw data. Are there any outliers? If so, identify them.
5. Describe the shape of the distribution. What can you say about the monthly bills of the new subscribers in the first month after signing with the company? Use pareto chart for your analyses.

Added by Charles C.

Question

Please give Ace some feedback