PPRuNe Forums - View Single Post - MS Excel XY Scatter graph - Linear regression trend line
Old 13th Dec 2009, 06:55
  #4 (permalink)  
mad_jock
 
Join Date: May 2001
Posts: 10,815
Likes: 0
Received 0 Likes on 0 Posts
I would go for a google search on that function.

I seem to remember that there were some dodgy stuff about the statistics functions of excel (or there used to be pre 2000). Matlab is the way forward,

A mate of mine found this out when he submitted his Phd and had to go back a redo all his statistics again. Thankfully he was working on steel so had gnats cock sized errors in the grand scale of things so didn't alter to much.
mad_jock is offline