Question: Determine the least squares trend line for each graph, including coefficient of determination and correlation coefficient. Excel will determine a trend line and coefficient of determination (“Add Trend Line” option), but you can use any tool for this that you wish, including manual calculation or Excel’s Data Analysis Tools. You will have to compute the correlation coefficient from the coefficient of determination. Make sure the trend line, least squares equation and both coefficients are printed on each graph.