Question: Multiple regression analysis in Excel produced the following tables: Multiple regression analysis in Excel produced the following tables: Coefficients Standard Error Intercept 789.8828 126.1765 -1.0349

Multiple regression analysis in Excel produced the following tables:

Multiple regression analysis in Excel produced the following tables: Multiple regression analysis

Multiple regression analysis in Excel produced the following tables: Coefficients Standard Error Intercept 789.8828 126.1765 -1.0349 4.226114 X2 4.77045 0.611405 Statistic 3.159697 -2.66263 4.57865 pValue 0.000396 0.927682 0.000430 pValue 0.000828 Regression Residual Total of SSMS F 1 114,995 22,631.67 10.50572 1392,871.199.254.928 14 207,866.19 a. State the multiple regression equation. Enter the exact answer. Use an asterisk, .. to indicate multiplication. For example, 2 zor 3 2 +4*y> 0. b. Interpret the meaning of the coefficients X1 and X2 in the table. Enter exact, positive values for the numbers. units. For every unit increase of the X1 variable, the value of Y For every unit increase of the X2 variable, the value of Y Click for List Click for List - by Number - by Number units. c. Forecast the value of the dependent variable if X1 = 25 and X2 = 7. Enter your answer to two decimal places. Y = Number Multiple regression analysis in Excel produced the following tables: Coefficients Standard Error Intercept 789.8828 126.1765 -1.0349 4.226114 X2 4.77045 0.611405 Statistic 3.159697 -2.66263 4.57865 pValue 0.000396 0.927682 0.000430 pValue 0.000828 Regression Residual Total of SSMS F 1 114,995 22,631.67 10.50572 1392,871.199.254.928 14 207,866.19 a. State the multiple regression equation. Enter the exact answer. Use an asterisk, .. to indicate multiplication. For example, 2 zor 3 2 +4*y> 0. b. Interpret the meaning of the coefficients X1 and X2 in the table. Enter exact, positive values for the numbers. units. For every unit increase of the X1 variable, the value of Y For every unit increase of the X2 variable, the value of Y Click for List Click for List - by Number - by Number units. c. Forecast the value of the dependent variable if X1 = 25 and X2 = 7. Enter your answer to two decimal places. Y = Number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!