Heller Company manufactures lawn mowers and related lawn equipment. The managers believe the quantity of lawn mowers sold depends on the price of the mower and the price of a competitor's mower. The worksheet entitled "Mowers" in the hw4.xlsx contains data on Heller's price, the competitor's price and the number of units sold. Use the data to estimate a multiple linear regression model, with the number of units sold as the dependent variable and the two prices as the independent variables. Based on your model, if Heller's price increased by $1 while the competitor's price remained the same, how much do you estimate that the number of units sold would change? (If the number of units goes down, answer with a negative number; otherwise answer with a positive number) Report your answer as an integer.
Quantity Sold Competitor's price Heller's price
102,000 120 100
100,000 140 110
120,000 190 90
77,000 130 150
46,000 155 210
93,000 175 150
26,000 125 250
69,000 145 270
65,000 180 300
85,000 150 250

Respuesta :

Answer:

The answer is "The Sold quantity has decreasing by 270".

Step-by-step explanation:

The number of units selling was expected to shift by - 270.

As just a result, the number of goods sold would be reduced by 270.

Its equation of regression is provided by:

Y = Sold quantity

X1= Price of the Competitor

x2=Heller's Price

[tex]Y = 66520 + (413.9)X_1 + ( - 269.8)[/tex] Hey, X2 (By Multiple Linear regression calculator)

If the price of Heller rose by $1, the price of fresh Heller is [tex]1 + X_2[/tex]

From the above regression equation, we will substitute [tex]1+X_2 \ for \ X_2.[/tex]

[tex]Y = 66520 + (413.9)X_1 + (-269.8)(1+X_2)\\\\[/tex]

   [tex]= 66520 + 413.9X_1 - 269.8 - 269.8X2\\\\ = 66250.2 + 413.9X_1 - 269.8X2[/tex]