Regression Calculation Write-Up

531 Words Jan 31st, 2018 2 Pages
V values were entered by hand into a newly created column and were deleted from Column A. Both columns were summed, and sum totals were divided by 116 (the number of data points) to achieve means. Columns were also created for U^2 and U*V; the sum function was also used to total these columns and means were derived by dividing the sum by 116. a was calculated as 1094.04 using the following formula:
((SumV*SumU^2)-(SumU*SumU*V))/((116*SumU^2)-(SumX^2)).
b was calculated as -0.11 using the formula:
((116*SumU*V)-SumU*SumV)/((116*SumU^2)+a^2)
Question 2
The points and line appear on different graphs due to the constraints of the software available. However, it can clearly be seen that the scattering of the data will make any line of best fit a poor predictor of trends and values. The calculated line of y = 1094.04x 0.11 is shown in blue on the relevant graph and does not appear to predict any trend in the data.
Question 3
The data in Column B of the provided spreadsheet was split at the semi-colon, with the number to the left of the semi-colon representing U and the number to the left representing V. V values were entered by hand into a newly created column and were deleted from Column B. Both columns were summed, and sum totals were divided by…

More about Regression Calculation Write-Up

Open Document