Use a spreadsheet program to fit a straight line (y = ax = b), to tabulated (x, y) data. Your program should evaluate the slope a and intercept b of the best fit to the data, and then calculate values of y using the estimated a and b for each tabulated value of x. Calculate the average deviation (residual) of the estimated y from the calculated value, and comment upon the quality of the fit to the data. Test your program by fitting a line to the data in the following table: 

Transcribed Image Text:

1.0 1.5 2.0 2.5 3.0 y 2.35 5.53 8.92 12.15 15.38