Question

Consider the following data for a dependent variable and two independent variables, and . x1= 30 46 24 50 41 51 74 36 60 77. x2 = 13 11 17 17 6 20 8 12 13 16. y = 95 109 112 178 94 176 170 117 142 212 Round your all answers to two decimal places. Enter negative values as negative numbers, if necessary. a. Develop an estimated regression equation relating to y to x1 . Predict y if x1=35 . b. Develop an estimated regression equation relating y to x2 . Predict y if x2=25 . c. Develop an estimated regression equation relating y to x1 and x2 . Predict if x1=35 and x2=25 .

Answer 1

We can solve this question using excel.

First, enter data into excel.

a. Develop an estimated regression equation relating to y to x1. Predict y if x1 = 35.

Click on Data -------> Data Analysis --------> Regression ------->

Input

Input Y Range : select y values

Input X Range :select values of x1.

Output Range: select an empty cell

---------> ok
We get

So the estimated regression equation is

x1 = 35

Predicted y =

----------------------------------------------------------------------------------------------------------------------

b. Develop an estimated regression equation relating y to x2. Predict y if x2=25.

Click on Data -------> Data Analysis --------> Regression ------->

Input

Input Y Range : select y values

Input X Range :select values of x2.

Output Range: select an empty cell

---------> ok
We get

So the regression equation is

x2 = 25

Predicted y =

------------------------------------------------------------------------------------------------------------------------------

c. Develop an estimated regression equation relating y to x1 and x2. Predict if x1=35 and x2=25 .

Click on Data -------> Data Analysis --------> Regression ------->

Input

Input Y Range : select y values

Input X Range :select values of x1 and x2.

Output Range: select an empty cell

---------> ok
We get

So the regression equation is

x1 = 35

x2 = 25

The predicted value is