Question 1 Management is considering opening an additional d
Question 1: Management is considering opening an additional dealership with 14 sales people. Using linear regression, what is the expected weekly total profit for the new dealership?
Question 2: Management asks whether using number of sales people to predict total profit is a reasonable approach. Which of the following is the best answer to that question?
A. Yes, it is intuitively logical that the more sales people the company has, the better it can serve the customers.
B. No, a correlation coefficient value of 0.02 indicates a bad linear fit to the data
C. Yes, a correlation coefficient value of 0.02 being positive indicates a positive relationship so the more sales people the better
D. No, a coefficient of determination value of 0.02 indicates a bad fit to the data.
Question 3: An old saying in car business is, “the more cars you sell, the higher your total profits will be”. Is this statement accurate for this dealership?
A. Yes, because the number of new cars sold each week and used cars sold each week both have positive correlation values with total profit.
B. Yes, because the number of new cars sold each week and used cars sold each week both have positive coefficient of determination values with total profit.
C. No, number of new cars sold each week has a positive correlation value with total profit, and used cars sold each week has a negative correlation value with total profit.
D. Yes, number of new cars sold each week and used cars sold each week both have positive intercept values from linear regression with total profit.
Question 4: Management believes that a new dealership can sell 12 new cars each week. What is the 90% confidence interval for expected total profit?
Question 5: Management is admitting that number of new cars sold each week is the key to predicting total profit and asks you to confirm their belief. Which of the following statements would you use to answer management?
A. Yes, everyone knows the more new cars you sell the higher the profit
B. Yes, number of new cars sold each week is a good predictor of profit because the coefficient of determination is 0.66 and is the population coefficient of determination is statistically different from zero at the 0.05 level.
C. Yes, number of new cars sold each week is a good predictor of profit because the coefficient of determination is 0.81 and is the population coefficient of determination is statistically different from zero at the 0.05 level.
D. No, number of new cars sold each week is not a good predictor of profit because the coefficient of determination is 0.05 and it can’t be said that the population coefficient of determination is statistically different from zero at the 0.05 level.
Question 6: Jill, an aggressive member of the management team, has suggested the company should close all their used-car lots. She proposes to simply sell every used car taken in on trade, to the wholesale market. You are asked to analyze the data and worthiness of this suggestion, and offer an opinion based on your analysis. Which of the following is the best response?
A. Jill is incorrect because every used car sold results in an additional profit of $3,298 with a correlation coefficient value of 0.81.
B. While Jill appears to be correct since a used-car sale results in an average loss of ~$1,684, you cannot say, at the 0.05 significance level, that the population slope is different than zero.
C. Jill appears to be correct since a used-car sale results in an average loss of ~$1,684, and the correlation coefficient value of 0.22 is considered good.
D. You suggest that analysis of only one week of data (which is contained in the Excel file) is not sufficient information to draw a solid conclusion.
E. Both B and D are correct.
| Dealership Identifier | Number of sales people | New Car Brand | Number of New cars sold each week | Number of Used Cars sold each week | Better Business Bureau Rating | Profit from New Car Sales | Profit from Used Car Sales | Total Profit |
| A1 | 13 | Honda | 7 | 5 | AA | $23,233.00 | $2,350.00 | $25,583.00 |
| A2 | 12 | VW | 6 | 8 | A | $17,694.00 | $5,888.00 | $23,582.00 |
| A3 | 16 | Honda | 10 | 8 | AA | $41,430.00 | $10,536.00 | $51,966.00 |
| A4 | 10 | Dodge | 7 | 5 | AA | $20,132.00 | $5,125.00 | $25,257.00 |
| A5 | 9 | Dodge | 10 | 2 | AAA | $30,280.00 | $15,226.00 | $45,506.00 |
| A6 | 19 | VW | 12 | 3 | AAA | $48,576.00 | $16,629.00 | $65,205.00 |
| A7 | 17 | VW | 15 | 4 | AAA | $52,770.00 | $18,916.00 | $71,686.00 |
| A8 | 20 | Dodge | 14 | 7 | AAA | $53,074.00 | $18,468.00 | $71,542.00 |
| A9 | 11 | Dodge | 12 | 2 | A | $46,176.00 | -$2,202.00 | $43,974.00 |
| A10 | 9 | Toyota | 11 | 4 | A | $40,304.00 | -$708.00 | $39,596.00 |
| A11 | 17 | Dodge | 10 | 5 | AA+ | $36,940.00 | $13,710.00 | $50,650.00 |
| A12 | 17 | Toyota | 12 | 4 | AAA | $41,244.00 | $15,608.00 | $56,852.00 |
| A13 | 16 | VW | 11 | 4 | A | $32,571.00 | $2,448.00 | $35,019.00 |
| A14 | 18 | Dodge | 4 | 4 | AA+ | $12,048.00 | $12,016.00 | $24,064.00 |
| A15 | 18 | Toyota | 10 | 3 | AA+ | $35,320.00 | $10,730.00 | $46,050.00 |
| A16 | 6 | Dodge | 3 | 4 | A | $9,774.00 | $2,560.00 | $12,334.00 |
| A17 | 13 | Dodge | 3 | 5 | AAA | $9,951.00 | $20,295.00 | $30,246.00 |
| A18 | 15 | Honda | 13 | 4 | AAA | $53,261.00 | $15,688.00 | $68,949.00 |
| A19 | 13 | Toyota | 8 | 7 | AA+ | $27,248.00 | $14,552.00 | $41,800.00 |
| A20 | 11 | Ford | 6 | 5 | AAA | $21,270.00 | $19,250.00 | $40,520.00 |
| A21 | 10 | Honda | 13 | 6 | AAA | $53,950.00 | $19,578.00 | $73,528.00 |
| A22 | 14 | Toyota | 12 | 3 | AA+ | $45,852.00 | $13,265.00 | $59,117.00 |
| A23 | 16 | VW | 10 | 7 | A | $32,680.00 | $6,241.00 | $38,921.00 |
| A24 | 19 | Honda | 4 | 3 | AAA | $11,700.00 | $15,279.00 | $26,979.00 |
| A25 | 18 | Dodge | 12 | 8 | A | $36,852.00 | $4,360.00 | $41,212.00 |
| A26 | 19 | Ford | 5 | 7 | AA+ | $15,180.00 | $20,201.00 | $35,381.00 |
| A27 | 9 | Toyota | 10 | 4 | AA+ | $39,140.00 | $12,656.00 | $51,796.00 |
| A28 | 7 | Dodge | 15 | 2 | AA | $54,885.00 | $766.00 | $55,651.00 |
| A29 | 9 | Honda | 3 | 7 | A | $10,827.00 | $5,415.00 | $16,242.00 |
| A30 | 16 | VW | 7 | 6 | A | $25,333.00 | $5,642.00 | $30,975.00 |
| A31 | 6 | Honda | 3 | 8 | AA+ | $11,325.00 | $18,208.00 | $29,533.00 |
| A32 | 5 | Toyota | 10 | 3 | AAA | $36,260.00 | $15,111.00 | $51,371.00 |
| A33 | 12 | Ford | 11 | 8 | A | $35,145.00 | $6,120.00 | $41,265.00 |
| A34 | 17 | Honda | 13 | 4 | AAA | $51,454.00 | $18,756.00 | $70,210.00 |
| A35 | 12 | Toyota | 11 | 3 | A | $31,449.00 | $713.00 | $32,162.00 |
| A36 | 5 | Ford | 12 | 3 | A | $39,684.00 | -$697.00 | $38,987.00 |
| A37 | 11 | Honda | 4 | 7 | AA | $14,132.00 | $6,484.00 | $20,616.00 |
| A38 | 6 | Dodge | 10 | 7 | A | $40,620.00 | $6,493.00 | $47,113.00 |
| A39 | 8 | Honda | 10 | 6 | A | $31,480.00 | $4,004.00 | $35,484.00 |
| A40 | 13 | VW | 14 | 4 | AA | $54,754.00 | $2,924.00 | $57,678.00 |
| A41 | 5 | Dodge | 14 | 3 | AA | $41,720.00 | $1,018.00 | $42,738.00 |
| A42 | 19 | VW | 4 | 6 | A | $14,832.00 | $1,592.00 | $16,424.00 |
| A43 | 11 | Honda | 8 | 6 | AA | $31,624.00 | $7,714.00 | $39,338.00 |
| A44 | 5 | Ford | 9 | 6 | AA | $37,080.00 | $5,692.00 | $42,772.00 |
| A45 | 19 | Toyota | 15 | 3 | AA | $53,130.00 | $3,250.00 | $56,380.00 |
| A46 | 9 | Toyota | 4 | 2 | AAA | $13,880.00 | $13,726.00 | $27,606.00 |
| A47 | 12 | Dodge | 9 | 7 | AA | $30,195.00 | $7,352.00 | $37,547.00 |
| A48 | 19 | Honda | 12 | 3 | AA+ | $41,412.00 | $11,936.00 | $53,348.00 |
| A49 | 17 | Dodge | 7 | 2 | AAA | $25,207.00 | $15,404.00 | $40,611.00 |
| A50 | 18 | Honda | 8 | 3 | AA | $31,112.00 | $2,182.00 | $33,294.00 |
| A51 | 5 | VW | 15 | 2 | A | $60,705.00 | -$980.00 | $59,725.00 |
| A52 | 8 | VW | 5 | 7 | AA+ | $16,540.00 | $20,145.00 | $36,685.00 |
| A53 | 7 | VW | 6 | 4 | AA+ | $17,466.00 | $12,060.00 | $29,526.00 |
| A54 | 12 | Toyota | 11 | 2 | AAA | $32,032.00 | $15,066.00 | $47,098.00 |
| A55 | 16 | Ford | 11 | 4 | A | $32,670.00 | $2,944.00 | $35,614.00 |
| A56 | 8 | Ford | 5 | 8 | AAA | $19,205.00 | $24,016.00 | $43,221.00 |
| A57 | 5 | Ford | 11 | 4 | A | $37,807.00 | $1,976.00 | $39,783.00 |
| A58 | 16 | Toyota | 9 | 7 | AAA | $26,100.00 | $21,723.00 | $47,823.00 |
| A59 | 7 | Toyota | 12 | 5 | AA | $43,116.00 | $5,950.00 | $49,066.00 |
| A60 | 8 | Dodge | 14 | 2 | AA+ | $47,992.00 | $9,640.00 | $57,632.00 |
Solution


