Regression Analysis III : LINEST
The third solution to our linear curve fitting problem is to use the LINEST function.
LINEST is an array function - returning an array of parameters extracted from the provided X-Y data.
In the example below, we opt for a minimized set of return parameters
and we get the slope and y-intercept values as shown. C29:C31 are the original formulae we saw before. C35:D35 is the array output from LINEST. Remember to use Ctrl-Shift-Enter when applying this formula.
If array functions make you break out in sweat, you can embed LINEST inside an INDEX to extract whatever return parameter you want. This is also include in the example in C37:C38. Note that INDEX is not an array function - but it likes to work with array functions.
