1. A company produces electric motors for usein home appliances. One of the company’s production managers isinterested in examining the relationship between the dollars spentper month in inspecting finished motor products (X) andthe number of motors produced during that month that were returnedby dissatisfied customers (Y). He has collected the datain the file P11_32.xlsx to explore this relationship for the past36 months.
a. Estimate a simple linear regression equation usingthe given data.
If required, round your answers to three decimal places. Forsubtractive or negative numbers use a minus sign even if there is a+ sign before the blank. (Example: -300)
Q1: The predicted change in number of motorsreturned that is associated with an increase of $1,000 ininspection expenditures: (_____________)
| Month | Inspection Expenditures | Motors Returned |
| 1 | $43,549 | 67 |
| 2 | $55,831 | 64 |
| 3 | $48,529 | 65 |
| 4 | $48,551 | 65 |
| 5 | $69,286 | 65 |
| 6 | $64,390 | 64 |
| 7 | $58,323 | 64 |
| 8 | $76,902 | 67 |
| 9 | $65,976 | 64 |
| 10 | $43,437 | 67 |
| 11 | $41,495 | 67 |
| 12 | $55,067 | 64 |
| 13 | $60,743 | 64 |
| 14 | $41,061 | 68 |
| 15 | $64,578 | 64 |
| 16 | $70,219 | 65 |
| 17 | $68,254 | 65 |
| 18 | $50,930 | 65 |
| 19 | $76,354 | 67 |
| 20 | $43,927 | 67 |
| 21 | $60,250 | 64 |
| 22 | $42,219 | 67 |
| 23 | $79,183 | 68 |
| 24 | $66,628 | 64 |
| 25 | $79,675 | 68 |
| 26 | $52,793 | 65 |
| 27 | $50,579 | 65 |
| 28 | $66,856 | 64 |
| 29 | $42,954 | 67 |
| 30 | $62,449 | 64 |
| 31 | $42,732 | 67 |
| 32 | $78,455 | 67 |
| 33 | $74,487 | 66 |
| 34 | $62,685 | 64 |
| 35 | $74,411 | 66 |
| 36 | $42,407 | 67 |
