« Regression Analysis II : Basic functions, charting | Main | Conditional summation revisited. »
April 18, 2005
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.
Posted by Dave at April 18, 2005 11:07 AM
Comments
can u give the deviations for some input Vs output response like -50,-45,...0, are input. 220,310,298.....are output, but the deeviations must be simetrically ie =ve and max dev. must be equal
Posted by: nagen at May 20, 2005 04:06 AM