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
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
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
607-B-B-C-B-M (818).xlsx
300 KBs Excel File
