IIIOO Doredoo 48 9:13 AM @ 39% l:|' mybb.qu.edu.qa Department of Finance and Economics Qatar University Business Statistics I (STAT 220) Group Mini Project Due on May14, 2017 Use the data from the Excel le Xm03- 01 concerning the monthly Long Distance Telephone Bills of 200 subscribers. This information is obtained from a survey conducted by a company providing long-distance telephone service. 1. Compute the measures of central location: Mean, Median, and the Modal class. Interpret the results. 2. Draw the Histogram and check if the distribution is symmetric or skewed? 3. Compute the measures of variability: Range, Standard deviation, and Interquartile range. 5. Determine the Interval of the monthly Bills, [a b], so that at least 88.9% of the bills lie between a and b. 6. Summarize in one paragraph your main ndings about the consumption behavior of the company's customers. Note; Select your own groups. The minimum number of students per group is o_ne and the maximum is m. Each group should submit one HARD Copy mm on May 14, 2017. Email submissions will NOT be accepted. Bills 42.19 38.45 29.23 89.35 118.04 59.00 0.00 72.88 83.05 95.73 66.00 94.52 26.84 40.00 28.00 72.78 45.00 60.00 74.01 56.01 39.21 48.54 29.00 66.00 30.61 22.57 63.70 80.00 6.45 16.47 27.00 13.36 44.16 46.00 39.00 24.00 78.89 23.00 46.00 0.00 75.71 34.00 38.00 85.00 0.00 8.41 70.48 27.00 3.20 56.00 2.42 1.08 76.69 13.62 46.00 55.99 12.24 119.63 23.31 11.05 8.37 7.18 11.07 1.47 26.40 13.26 21.13 25.00 29.04 5.42 77.21 72.47 0.00 5.64 6.48 6.95 19.60 8.11 9.01 84.77 1.62 91.10 10.88 30.62 100.05 26.97 15.43 29.25 1.88 16.44 42.00 2.45 21.97 17.12 19.70 6.93 10.05 99.03 29.24 15.21 28.77 9.12 118.75 0.00 13.95 14.34 79.52 2.72 9.63 21.34 104.40 2.88 65.90 20.55 3.43 10.44 21.36 24.42 95.52 6.72 35.32 117.69 42.00 8.40 90.04 3.85 91.56 10.13 5.72 33.69 115.78 0.98 19.45 0.00 27.21 89.27 14.49 92.17 21.00 106.59 13.90 9.22 109.94 10.70 0.00 11.27 72.02 7.74 5.04 33.40 6.95 6.48 11.64 83.26 15.42 24.49 89.13 111.14 92.64 53.90 114.67 27.57 64.78 45.81 56.04 20.39 31.77 94.67 44.32 3.69 19.34 13.54 18.89 1.57 0.00 5.20 2.80 5.10 3.03 9.16 15.30 75.49 68.69 35.00 9.12 18.49 84.12 13.68 20.84 100.04 112.94 20.12 53.21 15.30 49.24 9.44 2.67 4.69 41.38 45.77