Is there a residual variance function

Quote:

>What function should I use to estimate the residual variance?

Least squares or maximum likelihood estimator?

One or multiple independent variables?

If Excel's statistical functions were reliable, you'd use

=INDEX(LINEST(Y,X,,True),5,2)

to get the residual sum of squares. Unfortunately, they're not reliable, so

you'd need to roll your own. See

http://groups.google.com/groups?q=g:thl1548527874d&hl=en&selm=3BB1DAE...

05%40mediaone.net

for the best approach for single independent variable least squares

estimators.