4. Consider the following data set for an office structure built by Anderson Con
ID: 3060417 • Letter: 4
Question
4. Consider the following data set for an office structure built by Anderson Construction Co. The completed building is nine stories. However, construction was interrupted by a fire after 5.3357 floors were completed. At the time of the fire Anderson had used 54,067 hours of labor to construct the first 5.3357 stories of the building. It then took Anderson an additional 40,750 labor hours to complete this nine- story building. In this problem, FLRCOM is the number of floors completed, and HOURS is cumulative labor hours to complete the number of floors given by FLRCOM Enter the data for FLRCOM and HOURS in Minitab and use one command to create a variable which is the square of FLRCOM.Call this new variable FLRCOMSO. Print HOURS, FLRCOM, and FLRCOMSO Test whether there is a nonlinear relationship between HOURS and floors completed in the equation: HOURS-a+ KFLRCOM)+ dFLRCOMSO). Graph the foregoing equation. Where does it reach a maximum? Assume that the fire caused construction to slow down and caused a reduction in efficiency in completing the building. Estimate the number of labor hours needed to complete the building if there were no slow down related to the fire. Assume that the relationship that existed between FLORCOM and HOURS before the fire would have continued to exist to the completion of the building had the fire not occurred. Estimate the extra labor hours traceable to the fire. Calculate a 50% confidence interval and 50% prediction interval estimates for hours if there were no fire and interpret its meaning (ie, calculate an interval for hours to within a reasonable degree, to use a legal term,-of statistical certainty"). Interpret the meanings ofyour CI and PL Row HOURS 800 1575 2708 4110 5721 7955 8012 10765 13757 17257 21121 22435 FLRCOM 0.0431 0.0864 0.1564 0.2498 0.3676 0.5319 0.5362 0.7508 1.0098 1.3273 1.6684 1.8007 2.1873 10 12 13 29971 2.5881 2.6262 34296 37027Explanation / Answer
————— 13-03-2018 21:10:48 ————————————————————
MTB > Regress;
SUBC> Response 'Hours';
SUBC> Nodefault;
SUBC> Continuous 'FLRCOM' - 'FLRCOMSQ';
SUBC> Terms FLRCOM FLRCOMSQ;
SUBC> Constant;
SUBC> Confidence 50;
SUBC> Unstandardized;
SUBC> Tmethod;
SUBC> Tanova;
SUBC> Tsummary;
SUBC> Tcoefficients;
SUBC> Tequation;
SUBC> TDiagnostics 0.
Regression Analysis: Hours versus FLRCOM, FLRCOMSQ
Analysis of Variance
Source DF Adj SS Adj MS F-Value P-Value
Regression 2 5753607796 2876803898 13095.71 0.000
FLRCOM 1 728945398 728945398 3318.29 0.000
FLRCOMSQ 1 32376128 32376128 147.38 0.000
Error 18 3954155 219675
Total 20 5757561951
Model Summary
S R-sq R-sq(adj) R-sq(pred)
468.695 99.93% 99.92% 99.89%
Coefficients
Term Coef SE Coef T-Value P-Value VIF
Constant 1088 204 5.33 0.000
FLRCOM 12570 218 57.60 0.000 12.33
FLRCOMSQ -520.3 42.9 -12.14 0.000 12.33
Regression Equation
Hours = 1088 + 12570 FLRCOM - 520.3 FLRCOMSQ
Fits and Diagnostics for Unusual Observations
Std
Obs Hours Fit Resid Resid
21 54067 53344 723 2.17 R X
R Large residual
X Unusual X
MTB >
Conclusion -
a) There is Linear Relationship between hours and floors completed.
b) 12570
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.