Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 2008 Sales Profit Industry Code Competitive Rating $170.00 $86.70 1 2 $181.00 $57.92 3 4 $203.00 $40.60 2 2 $249.00 $54.78 5 1 $476.00 $99.96 5 1 $476.00 $99.96 5 4 $635.00 $139.70 2 3 $856.00 $291.04 3 3 $1,062.00 $276.12 4 2 $1,110.00 $183.71 7 3 $1,153.00 $230.60 7 3 $1,392.00 $501.12 4 2 $1,743.00 $313.74 4 2 $2,307.00 $461.40 7 3 $2,534.00 $126.70 4 5 $2,683.00 $778.07 7 2 $2,780.00 $278.00 2 3 $3,272.00 $1,210.64 5 3 $3,864.00 $2,318.40 7 1 $3,988.00 $957.12 6 3 $4,072.00 $366.48 7 3 $4,190.00 $2,095.00 5 3 $4,219.00 $717.23 3 4 $4,711.00 $1,507.52 7 1 $4,824.00 $723.60 6 3 $4,878.00 $487.80 7 4 $5,157.00 $670.41 7 2 $5,552.00 $1,221.44 2 3 $5,876.00 $998.92 1 3 $5,888.00 $1,118.72 6 4 $7,632.00 $457.92 5 4 $8,058.00 $1,853.34 3 3 $12,056.00 $2,772.88 7 2 $12,981.00 $1,817.34 2 4 $13,406.00 $2,949.32 2 3 $15,882.00 $2,223.48 7 3 $16,343.00 $4,576.04 3 3 $19,985.00 $5,395.95 5 3 $20,160.00 $604.80 5 5 $26,616.00 $12,243.36 5 2 $28,018.00 $7,284.68 5 3 $28,950.00 $3,184.50 4 4 $29,646.00 $5,336.28 4 3 $31,019.00 $11,477.03 6 1 $31,305.00 $6,261.00 2 3 $34,769.00 $7,301.49 7 1 $34,817.00 $3,481.70 4 3 $38,609.00 $5,405.26 1 3 $38,923.00 $3,503.07 2 5 $40,536.00 $6,485.76 4 3 $54,851.00 $12,067.22 6 2 $54,861.00 $11,520.81 7 2 $58,063.00 $9,870.71 5 4 54 55 56 57 58 59 60 $62,862.00 $78,574.00 $92,776.00 $112,837.00 $115,999.00 $120,854.00 $179,101.00 $6,914.82 $5,500.18 $12,988.64 $16,925.55 $15,079.87 $25,379.34 $25,074.14 4 3 4 1 4 5 6 5 5 3 4 5 4 3 Problem 2 [10 pts] A study on the pay of CEO's examined the percentage increase in cash compensation of the CEO's of 104 companies, adjusted for ination, in recent years. The mean percentage increase in real compensation was i = 6.8% and sample standard deviation of 5.3%. Is this good evidence that the mean percentage increase p. in real compensation of all CEO's is larger than zero? a. Write down the test hypotheses b. Compute the test statistic and the p-value Is the result signicant at the 5% signicance level? d. Compute a 95% Condence Interval for the mean increase of real compensation of CEO's. Based on this C.I., are you convinced that the mean percentage compensation has been increasing? e. Are you surprised that the results in c) and d) lead to the same conclusions? .0 Problem 3 [15pts] The Excel le Sales.xls attached to this assignment provides data on a sample of customers. Consider the variable \"PROFIT\" in the Excel dataset. An industry trade publication stated that the average prot per customer for this industry was $4500. Using either a test of hypothesis or a condence interval, can this company claim that they are exceeding the standard? If you decide to compute a statistical test, you should specify the test hypotheses, the test statistic and p-value,. If you rather use a condence interval, write down the computed condence interval for the average prot per customer