Is there a way to make a line of best fit for my spreadsheet? | Joshkorlork | 1/15/09 4:19 PM | I am doing a simple scatter plot in order to compare two things. It could be a chart or a gadget, I just need the line of best fit |

Re: Is there a way to make a line of best fit for my spreadsheet? | ahab | 1/16/09 3:56 AM | Can't you use the INTERCEPT and SLOPE functions`?
See for example the referenced spreadsheet. The formula in C2 creates a linear regression best fit set of Y-data to correspond to the X-data. This is used to create the
Best fit lineThe simple straight line formula in C2 looks like this:
C2: =ARRAYFORMULA(INTERCEPT(B2:B11; A2:A11)+A2:A11*SLOPE(B2:B11;A2:A11)) |