Reference no: EM132479351

The attached Sales Data file contains information on Gross Sales and Gross Profit for a sample of your company's customers.

1. Use Excel Data Analysis to find the mean, median, and mode for both variables.  Make sure that you clearly state or point out which numbers are which. Don't expect me to pick the numbers I want.
2. Use Data Analysis to construct a 95% confidence interval for Gross Sales. Interpret the interval. 
3. Use Data Analysis to construct a 99% confidence interval for Gross Sales.  Interpret the interval.
4. Compare the widths of the 95% and 99% confidence intervals.
5. Use Data Analysis to construct a 98% confidence interval for Gross Profit. Interpret the interval. 

Sales Data:

Customer Gross Sales Gross Profit

1 $170.00 $86.70 

2 $181.00 $57.92 

3 $203.00 $40.60 

4 $249.00 $54.78 

5 $476.00 $99.96 

6 $476.00 $99.96 

7 $635.00 $139.70 

8 $856.00 $291.04 

9 $1,062.00 $276.12 

10 $1,110.00 $183.71 

11 $1,153.00 $230.60 

12 $1,392.00 $501.12 

13 $1,743.00 $313.74 

14 $2,307.00 $461.40 

15 $2,534.00 $126.70 

16 $2,683.00 $778.07 

17 $2,780.00 $278.00 

18 $3,272.00 $1,210.64 

19 $3,864.00 $2,318.40 

20 $3,988.00 $957.12 

21 $4,072.00 $366.48 

22 $4,190.00 $2,095.00 

23 $4,219.00 $717.23 

24 $4,711.00 $1,507.52 

25 $4,824.00 $723.60 

26 $4,878.00 $487.80 

27 $5,157.00 $670.41 

28 $5,552.00 $1,221.44 

29 $5,876.00 $998.92 

30 $5,888.00 $1,118.72 

31 $7,632.00 $457.92 

32 $8,058.00 $1,853.34 

33 $12,056.00 $2,772.88 

34 $12,981.00 $1,817.34 

35 $13,406.00 $2,949.32 

36 $15,882.00 $2,223.48 

37 $16,343.00 $4,576.04 

38 $19,985.00 $5,395.95 

39 $20,160.00 $604.80 

40 $26,616.00 $12,243.36 

41 $28,018.00 $7,284.68 

42 $28,950.00 $3,184.50 

43 $29,646.00 $5,336.28 

44 $31,019.00 $11,477.03 

45 $31,305.00 $6,261.00 

46 $34,769.00 $7,301.49 

47 $34,817.00 $3,481.70 

48 $38,609.00 $5,405.26 

49 $38,923.00 $3,503.07 

50 $40,536.00 $6,485.76 

51 $54,851.00 $12,067.22 

52 $54,861.00 $11,520.81 

53 $58,063.00 $9,870.71 

54 $62,862.00 $6,914.82 

55 $78,574.00 $5,500.18 

56 $92,776.00 $12,988.64 

57 $112,837.00 $16,925.55 

58 $115,999.00 $15,079.87 

59 $120,854.00 $25,379.34 

60 $179,101.00 $25,074.14