86 points An industry trade publicaties stated that the average poft per customer for an industry was less than $3.000. The Toes Sales Cata proda a uni customers for the same industry your bon has asked you is check the data supports this claim aro Calourate the ontol value and we it down Quen as of Click Submit to complete this assessment. Question 86 2 points Save Anwe An industry trade publication stated that the average profit per customer for an industry was less than $3,000. The Excel file Sales Data provides data on a sample of customers for the same industry. Your boss has asked you to check if the data supports this claim or not. Calculate the critical value and write it down here as the answer (be accurate to atleast 3 decimal places) Click Submit to complete this assessment. MacBook Pro Question 86 Save and Submit B + A1 fx Sales Data B Sales Data, 2 3 Customer C D E Percent Gross Profi Gross Sales Gross Profit Industry Code Competitive Rating 4 1 -51.0% $170.00 $86.70 1 2 $ 2 32.0% $181.00 $57.92 3 4 . 3 20.0% $203.00 $40.60 2 2 7 4 22.0% $249.00 $54.78 5 1 5 21.0% $476.00 $99.96 5 1 6 21.0% $476.00 $99.96 5 4 10 7 22.0% $635.00 $139.70 2 3 11 8 34.0% $856.00 $291.04 3 3 12 9 26.0% $1,062.00 $276.12 4 2 13 10 16.6% $1,110.00 $183.71 7 3 14 11 20.0% $1,153.00 $230.60 7 3 15 12 36.0% $1,392.00 $501.12 4 2 16 13 18.0% $1,743.00 $313.74 4 2 17 14 20.0% $2,307.00 $461.40 7 3 15 5.0% $2,534.00 $126.70 4 5 19 16 29.0% $2,683.00 $778.07 7 2 20 17 10.0% $2,780.00 $278.00 2 3 21F 18 37.0% $3,272.00 $1,210.64 5 3 22 19 60.0% $3,864.00 $2,318.40 7 1 23 20 24.0% $3,988.00 5957.12 6 3 21 9.0% $4,072.00 $366.48 7 3 25 22 50.0% $4,190.00 $2,095.00 5 3 23 17.0% $4.219.00 $717.23 3 4 27 24 32.0% $4,711.00 $1,507.52 7 1 25 15.0% $4,824.00 $723.60 6 3 29 26 10.0% $4,878.00 $487.80 7 4 30 27 13.0% $5,157.00 $670.41 7 2 31 28 22.0% $5,552.00 $1,221.44 2 3 12 29 17.0% $5,876.00 $998.92 1 3 33 30 19.0% $5,888.00 $1,118.72 6 4 M 31 6.0% $7.632 00 $457.92 5 4 30 32 23.0% $8,058.00 $1,853.34 3 3 36 33 23.0% $12,056.00 $2.772.88 7 2 37 34 14.0% $12.981.00 $1,817.34 2 4 35 22.0% $13,406.00 $2.949.32 2 36 14.0% $15,882.00 $2,223.48 7 37 28.0% $16,343.00 $4,576.04 3 P Data + MacBook Pro H * Paste Arial 12 A A B I UN General $ -% Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates xfx Sales Data A1 A C D E O H . 30 31 23 34 25 37 20 40 45 42 43 M 40 A 47 40 50, M 54 12 52885238858295*******858233362SS 27 13.0% $5,157.00 $670.41 7 2 22.0% $5,552,00 $1,221.44 2 3 17.0% $5,876.00 $998.92 1 3 30 19.0% $5,888.00 $1,118.72 6 4 31 6.0% $7,632.00 $457.92 5 4 23.0% $8,058.00 $1.853.34 3 3 23.0% $12,056.00 $2.772.88 7 2 34 14.0% $12,981.00 $1,817.34 2 4 22.0% $13,406.00 $2.949.32 2 3 14.0% $15,882.00 $2,223.48 7 3 37 28.0% $16,343.00 $4,576.04 3 3 27.0% $19,985.00 $5,395.95 5 3 3.0% 40 46.0% 41 26.0% $20,160.00 $604.80 $26,616.00 $12,243.36 $28,018.00 $7.284.68 5 5 5 2 5 3 42 11.0% $28,950.00 $3,184.50 4 4 43 18.0% $29,646.00 $5,336.28 4 3 44 37.0% $31,019.00 $11.477.03 6 1 45 20.0% $31,305.00 $6,261.00 2 3 46 21.0% $34,769.00 $7,301.49 7 1 47 10.0% $34,817.00 $3,481.70 4 3 48 14.0% $38.609.00 $5.405.26 T 3 49 9.0% $38,923.00 $3,503.07 2 5 50 16.0% $40.536.00 $6,485.76 4 3 51 22.0% $54,851.00 $12.067.22 6 2 21.0% $54,861.00 $11,520.81 7 2 17.0% $58,063.00 $9,870.71 5 4 54 11.0% $62,862.00 $6,914.82 4 S 7.0% $78,574.00 $5,500.18 3 5 14.0% $92,776.00 $12,988.64 4 3 57 15.0% $16,925.55 1 4 13.0% $15,079.87 4 5 21.0% $25,379.34 5 4 60 14.0% $25,074.14 6 3 M "Rates the amount of competition for sales of the products sold to these customers: 1 very little competition to 5 very compettive 10 Data + TOO MacBook Pro a W