Question

In: Math

The following regression output was obtained from a study of architectural firms. The dependent variable is...

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.

Predictor     

Coef

SE Coef      

T     

P

Constant

7.987

2.967

2.69

-

X1

0.12242

0.03121

3.92

0.0000

X2

-0.12166

0.05353

-2.27

0.028

X3

-0.06281

0.03901

-1.61

0.114

X4

0.5235

0.1420

3.69

0.001

X5

-0.06472

0.03999

-1.62

0.112

Analysis of Variance

Source         

DF

SS    

MS     

F    

P

Regression

5

3710.00

742.00

12.89

0.000

Residual Error

46

2647.38

57.55

Total

51

6357.38

X1 - # of architects employed by the company

X2 - # of engineers employed by the company

X3 - # of years involved with health care projects

X4 - # of states in which the firm operates

X5 - % of the firms work that is health care-related

  1. Write out the regression equation
  2. How large is the sample? How many independent variables are there?
  3. 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?
  4. Conduct a test of hypothesis for each independent variable. Use the .05 significance level. Which variable would you consider eliminating first?
  5. Outline a strategy for deleting independent variables in this cas

Solutions

Expert Solution


Related Solutions

The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.617 2.998 2.541 0.010 x1 0.224 0.069 3.246 0.000 x2 ? 1.144 0.559 ? 2.047 0.028 x3 ? 0.071 0.120 ? 0.592 0.114 x4 0.675 0.354 1.907 0.001 x5 ? 0.057 0.025 ? 2.280 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,113.40 422.7...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE T P-vaule Constant 7.096 3.245 2.187 0.010 x1 0.222 0.117 1.897 0.000 x2 -1.024 0.562 -1.822 0.028 x3 -0.337 0.192 -1.755 0.114 x4 0.623 0.263 2.369 0.001 x5 -0.056 0.029 -2.000 0.112 Analysis of Variance Source DF SS MS F P-Value Regression 5 2009.28 401.9 7.33 0.000 Residual Error 50 2741.54 54.83...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.166 3.075 2.330 0.010 x1 0.228 0.302 0.755 0.000 x2 − 1.184 0.586 − 2.020 0.028 x3 − 0.193 0.110 − 1.755 0.114 x4 0.572 0.293 1.952 0.001 x5 − 0.056 0.022 − 2.545 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,847.24 369.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 7.131 3.085 2.312 0.010 x1 0.203 0.170 1.194 0.000 x2 − 1.176 0.553 − 2.127 0.028 x3 − 0.089 0.311 − 0.286 0.114 x4 0.682 0.381 1.790 0.001 x5 − 0.030 0.025 − 1.200 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 1,946.79 389.4...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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.    Predictor Coef SE Coef T     Constant 10.237 3.447 2.97 X1 0.392 -0.209 -1.88 X2 -0.392 -0.099 3.96 X3 0.207 -0.110 -1.88 X4 0.794 0.201 3.95 X5 -0.335 -0.126 2.66      Analysis of Variance   Source DF SS MS F   Regression 5 3710.00 742.00 15.14   Residual Error 48 2647.38 57.55   Total 53 6357.38    X1...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor Coefficient SE Coefficient t p-value Constant 8.870 3.128 2.836 0.010 x1 0.212 0.050 4.240 0.000 x2 − 1.004 0.545 − 1.842 0.028 x3 − 0.246 0.387 − 0.636 0.114 x4 0.669 0.326 2.052 0.001 x5 − 0.062 0.030 − 2.067 0.112 Analysis of Variance Source DF SS MS F p-value Regression 5 2,029.13 405.8...
The following regression output was obtained from a study of architectural firms. The dependent variable is...
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. Predictor      Coef SE Coef       T      P Constant 7.987 2.967 2.69 - X1 0.12242 0.03121 3.92 0.0000 X2 -0.12166 0.05353 -2.27 0.028 X3 -0.06281 0.03901 -1.61 0.114 X4 0.5235 0.1420 3.69 0.001 X5 -0.06472 0.03999 -1.62 0.112 Analysis of Variance Source          DF SS     MS      F     P Regression 5 3710.00 742.00 12.89 0.000 Residual Error 46 2647.38...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT