View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default linest internals

On 16 Apr 2013 15:08:14 GMT, Bruce Bowler wrote:

This probably isn't the right forum to ask in, but are the equations used
by linest to calculate all of the bits that it can output documented
somewhere?


The algorithms are pretty standard. Look up "linear regression" in
any statistics textbook or Web site, such as this one:

http://www.tc3.edu/instruct/sbrown/s...m#FindShortcut


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...