|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))