[Blindmath] How to solve regression equations in XL

[Alastair Irving]

Yes this is possible using the linest function.  An example formula 
would be something like linest(b1:b10,a1:a10).  This is an array formula 
so you need to enter it in two cells simultaneously to get both return 
values.  Alternatively you could use the slope and intercept functions 
to get the two return values separately.

HTH

Alastair



On 26/03/2015 11:44, Rekha via Blindmath wrote:
> Dear All
> Could anybody please tell me about how to find a regression line for 
> figures given in a table useing XL.
> Is it possible to find a regression line useing XL?
> Thanks & Best Wishes
> Rekha
>
> _______________________________________________
> Blindmath mailing list
> Blindmath at nfbnet.org
> http://nfbnet.org/mailman/listinfo/blindmath_nfbnet.org
> To unsubscribe, change your list options or get your account info for 
> Blindmath:
> http://nfbnet.org/mailman/options/blindmath_nfbnet.org/alastair.j.irving%40gmail.com 
>
> BlindMath Gems can be found at 
> <http://www.blindscience.org/blindmath-gems-home>