Categories: Ask a "how-to" question :

Is there a way to make a line of best fit for my spreadsheet?

Showing 1-2 of 2 messages
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 line
 
The simple straight line formula in C2 looks like this:
C2: =ARRAYFORMULA(INTERCEPT(B2:B11; A2:A11)+A2:A11*SLOPE(B2:B11;A2:A11))