Question: A deep foundation engineering contractor has bid on a foundation system for a new building housing the world headquarters for a Fortune 500 company.A part

A deep foundation engineering contractor has bid on a foundation system for a new building housing the world headquarters for a Fortune 500 company.A part of the project consists of installing 311 auger cast piles. The contractor was given bid information for cost estimating purposes, which consisted of the estimated depth of each pile; however, actual drill footage of each pile could not be determined exactly until construction was performed. The Excel file Pile Foundation contains the estimates and actual pile lengths after the project was completed. Develop a linear regression model to estimate the actual pile length as a function of the estimated pile lengths. What do you conclude?

Step by Step Solution

3.45 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Pile Foundation Data Pile Estimated Actual Number Pile Length ft Pile Length ft 1 1058 1858 2 1058 1858 3 1058 1858 4 1058 1858 5 1058 2858 6 1058 2658 7 1058 1758 8 1058 2758 9 1058 2758 10 1058 3758 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

607-B-B-C-B-M (818).xlsx

300 KBs Excel File

Students Have Also Explored These Related Business Communication Questions!