Consider the following data set for an office structure built by Anderson ConstructionCo. The completed building is nine stories. However, construction was interruptedby a fire after 5.3357 floors were completed. At the time of the fire, Anderson hadused 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 Excel and createa variable which is the square of FLRCOM. Call this new variable FLRCOMSQ.

Row	HOURS	FLRCOM
1	800	0.0431
2	1575	0.0864
3	2708	0.1564
4	4110	0.2498
5	5721	0.3676
6	7955	0.5319
7	8012	0.5362
8	10765	0.7508
9	13757	1.0098
10	17257	1.3273
11	21121	1.6684
12	22435	1.8007
13	26194	2.1873
14	29971	2.5881
15	30266	2.6262
16	34296	3.0633
17	37027	3.3722
18	41556	3.8899
19	46015	4.4022
20	50516	4.9333
21	54067	5.3357

a. Estimate the function:

HOURS = a + b(FLRCOM) + c(FLRCOMSQ).

b.Develop a computer generated graph of this equation.

c. Assume that the fire caused construction to slow down and caused a reduction inefficiency in completing the building. Estimate the number of labor hours needed tocomplete the building if there were no slow down related to the fire. Assume that therelationship that existed between HOURS and FLRCOM and FLRCOMSQ before the fire would havecontinued to exist to the completion of the building had the fire not occurred.

d. Estimate the extra labor hours traceable to the fire.

e. Calculate a 50% confidence interval for Hours to complete all 9 floors of the building had there been no fire.