Question: Please help me solve this problem. Sales Data Customer Percent Gross Profit Gross Sales Gross Profit Industry Code Competitive Rating 51.0% $170.00 $86.70 $181.00 $57.92

Please help me solve this problem.

Please help me solve this problem. Sales Data Customer Percent Gross ProfitGross Sales Gross Profit Industry Code Competitive Rating 51.0% $170.00 $86.70 $181.00

Sales Data Customer Percent Gross Profit Gross Sales Gross Profit Industry Code Competitive Rating 51.0% $170.00 $86.70 $181.00 $57.92 1 32.0% 20.0% $203.00 540.60 22.0% 249.00 $54.78 21.0% $476.00 $99.96 21.0% $476.00 $99.96 22.0% $635.00 $139.70 34.0% $856.00 $291.04 26.0% $1,062.00 $276.12 16.6% $1, 110.00 $183.71 20.0% $1, 153.00 $230.60 36.0% $1,392.00 $501.12 13 18.0% $1,743.00 $313.74 14 20.0% $2,307.00 $461.40 15 5.0% $2,534.00 16 $126.70 29.0% 17 $2,683.00 $778.07 10.0% $2,780.00 $278.00 18 37.0% $3,272.00 $1,210.64 19 60.0% $3,864.00 $2,318.40 20 4.0% $3,988.00 $957.12 21 9.0% $4,072.00 $366.48 22 50.0% $4, 190.00 $2,095.00 23 17.0% $4,219.00 $717.23 24 32.0% $4,711.00 $1,507.52 25 15.0% $4,824.00 $723.60 26 10.0% $4,878.00 $487.80 27 13.0% $5, 157.00 $670.41 28 22.0% $5,552.00 61,221.44 29 17.0% $5,876.00 $998.92 30 19.0% $5,888.00 $1, 118.72 31 6.0% $7,632.00 $457.92 32 23.0% $8,058.00 $1,853.34 33 23.0% $12,056.00 $2,772.88 34 14.0% $12,981.00 $1,817.34 35 22.0% $13,406.00 $2,949.32 36 14.0% $15,882.00 $2,223.48 37 28.0% $16,343.00 $4,576.04 38 27.0% $19,985.00 $5,395.95 39 3.0% $20, 160.00 $604.80 40 46.0% $26,616.00 $12,243.36 41 26.0% 8,018.00 $7,284.68 42 11.0% $28,950.00 $3, 184.50 43 18.0% $29,646.00 $5,336.28 44 37.0% $31,019.00 $11,477.03 45 20.0% $31,305.00 $6,261.00 46 21.0% $34,769.00 $7,301.49 47 10.0% $34,817.00 $3,481.70 48 14.0% $38,609.00 $5,405.26 49 9.0% $38,923.00 $3,503.07 50 6.0% $40,536.00 $6,485.76 51 22.0% $54,851.00 $12,067.22 52 21.0% $54,861.00 $11,520.81 53 17.0% $58,063.00 $9,870.71 54 11.0% $62, 862.00 $6,914.82 55 7.0% $78,574.00 $5,500.18 56 14.0% $92,776.00 $12,988.64 57 15.0% $112,837.00 $16,925.55 58 13.0% $115,999.00 $15,079.87 59 21.0% $120,854.00 $25,379.34 60 14.0% $179, 101.00 $25,074.14 Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very competitive a=0.059) (Chapter 5:4) The Excel file Sales Data provides data on a sample of customers. The company believes that its average profit is no less than $5000. However, some analysts feel that its average profit may actually be lower. Test a hypothesis to verify this. If, for the same sample and the same value of the sample mean, the sample standard deviation equals $1000, would the conclusion change

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!