80.2K

Verified Solution

Link Copied!

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 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

Answer & Explanation Solved by verified expert

See Answer