The table containing the data needed for this problem is attached on this answer. This data is used to determine the best fit line that is extracted from this multitude of points given. Best fit line is described as a line in which the variation of each point to the line is the minimum. We plot the data using MS Excel and is shown in the figure attached as well. We determine the trendline of the graph by the function in MS Excel. The equation of the trendline is expressed as y = -26.059x + 722.63 in which the coefficient of determination, r^2 = 0.8947.
