1. A company produces electric motors for use in home appliances. One of the company’s production...

70.2K

Verified Solution

Question

Basic Math

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: (_____________)

MonthInspection ExpendituresMotors Returned
1$43,54967
2$55,83164
3$48,52965
4$48,55165
5$69,28665
6$64,39064
7$58,32364
8$76,90267
9$65,97664
10$43,43767
11$41,49567
12$55,06764
13$60,74364
14$41,06168
15$64,57864
16$70,21965
17$68,25465
18$50,93065
19$76,35467
20$43,92767
21$60,25064
22$42,21967
23$79,18368
24$66,62864
25$79,67568
26$52,79365
27$50,57965
28$66,85664
29$42,95467
30$62,44964
31$42,73267
32$78,45567
33$74,48766
34$62,68564
35$74,41166
36$42,40767

Answer & Explanation Solved by verified expert
4.1 Ratings (510 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students