LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Least Squares Regression ST. Dev.

I created a graph and then a trendline to get the slope of the line and then
used m to determine another value which would be constant for all data in
that data set (least squares regression). HOWEVER, I also have to find the
mean and st. dev. for this data. I know the mean is obviously the same at
the constant, but what is the standard deviation and how do i calculate that
off the chart (I'm assuming i do since it seems my only option as i'll always
get 0 in the numerator in the st. dev. function).
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
chi squares Rozie Excel Discussion (Misc queries) 1 June 29th 06 09:52 PM
blue squares blue New Users to Excel 1 February 14th 06 09:46 AM
Does Excel use least squares regression to calculate trendlines? Trendy Charts and Charting in Excel 3 May 20th 05 07:03 AM
removing squares and lines in squares that really should be paragr finnadat Excel Discussion (Misc queries) 5 February 10th 05 11:12 PM
Least Squares Analysis TNMAN Excel Worksheet Functions 2 February 8th 05 03:09 PM


All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"