Question

1. A company produces electric motors for use in home appliances. One of the company’s production managers is interested in examining the relationship between the dollars spent per month in inspecting finished motor products (X) and the number of motors produced during that month that were returned by dissatisfied customers (Y). He has collected the data in the file P11_32.xlsx to explore this relationship for the past 36 months.

a. Estimate a simple linear regression equation using the given data.

If required, round your answers to three decimal places. For subtractive 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 motors returned that is associated with an increase of $1,000 in inspection 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

Answer 1