using excel
Posted: Fri Dec 24, 2021 9:53 am
using excel
Section A: (Attempt Both with 20 Marks Each) Problem:1. The following regression output was obtained from a study of architectural firms. The dependent variable is the total amount of fees in millions of dollars. p-value Predictor constant X3 X3 X3 * Xs coet 7.987 0.12242 -0.12166 -0.06281 0.5235 -0.06472 SE Coef 2.967 0.03121 0.05353 0.03901 0.1420 0.03999 T 2.69 3.92 -2.27 -1.61 3.69 -1.62 0.000 0.028 0.114 0.001 0.112 Analysis of varianco Source DF Regression 5 Residual Error 46 Total 51 MS 742.00 57.55 F 12.89 SS 3710.00 2647.38 6357.38 p-value 0.000 ла Xy is the number of architects employed by the company. X2 is the number of engineers employed by the company. X3 is the number of years involved with health care projects. XA is the number of states in which the firm operates. X5 is the percent of the firm's work that is health care related. Answer the below Questions a. Write out the regression equation.
X, is the number of architects employed by the company. А X2 is the number of engineers employed by the company. X3 is the number of years involved with health care projects. X4 is the number of states in which the firm operates. Xs is the percent of the firm's work that is health care related. Answer the below Questions a. Write out the regression equation. b. How large is the sample? How many independent variables are there? c. Conduct a global test of hypothesis to see if any of the set of regression coefficients could be different from 0. Use the .05 significance level. What is your conclusion? d. Conduct a test of hypothesis for each independent variable. Use the .05 significance level. Which variable would you consider eliminating first? e. Outline a strategy for deleting independent variables in this case.
- Using Excel 1 (59.53 KiB) Viewed 92 times
- Using Excel 2 (47.46 KiB) Viewed 92 times
X, is the number of architects employed by the company. А X2 is the number of engineers employed by the company. X3 is the number of years involved with health care projects. X4 is the number of states in which the firm operates. Xs is the percent of the firm's work that is health care related. Answer the below Questions a. Write out the regression equation. b. How large is the sample? How many independent variables are there? c. Conduct a global test of hypothesis to see if any of the set of regression coefficients could be different from 0. Use the .05 significance level. What is your conclusion? d. Conduct a test of hypothesis for each independent variable. Use the .05 significance level. Which variable would you consider eliminating first? e. Outline a strategy for deleting independent variables in this case.