Is there a residual variance function
>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
to get the residual sum of squares. Unfortunately, they're not reliable, so
you'd need to roll your own. See
for the best approach for single independent variable least squares