using excel

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

using excel

Post by answerhappygod »

using excel
Using Excel 1
Using Excel 1 (59.53 KiB) Viewed 91 times
Using Excel 2
Using Excel 2 (47.46 KiB) Viewed 91 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply