Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

STATISTICAL METHODS FOR INFO TECHNOLOGY PROJECT A deep-foundation engineering co

ID: 3309229 • Letter: S

Question

STATISTICAL METHODS FOR INFO TECHNOLOGY PROJECT A deep-foundation engineering contractor has bid on a foundation system for a new world headquarters building 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. Use the function polyfit in MATLAB to develop an approximation that will best fit the data. The estimated actual pile length will be a function of the estimated pile lengths.

Explanation / Answer

Since, the excel file is not attached I will just provide a method to do the above problem.

The code that should be used is:

p = polyfit(x,y,n)

Here, the x values will be the vector of "estimated pile lengths" and the y values will be the vector of "estimated actual pile lengths".

p = polyfit(x,y,n) returns the coefficients for a polynomial p(x) of degree n that is a best fit (in a least-squares sense) for the data in y. The coefficients in p are in descending powers, and the length of p is n+1.

So, for the two values you will get an equation of the form: y = p1x+p2

This will be the line of best fit.

Please provide the data so that I can do the execution for you.