Then type the following linear regression equasion: =LINEST(B2:B12, A2:A12, TRUE, TRUE) This function will calculate the slope of the regression line, the y-intercept, and several other statistics.