View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default Least Squares Regression ST. Dev.

Kris -

If you're referring to the standard deviation of residuals or "standard
error of estimate," try the STEYX worksheet function.

- Mike
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

"Kris@CEC" wrote in message
...
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).