B

#### Bob Nelson

2003 that will return the maximum residual value from a linear

regression. Unfortunately, this is not one of the potential outputs

from LINEST. I realize the Analysis ToolPak regression option will

generate a list of residuals from which a maximum value could be

extracted, but this requires generating a new worksheet or large array,

and I'm working with a dynamic array on a worksheet from which the

maximum residual will need to be "updated" in each row of a column.

The SLOPE and INTERCEPT built-in functions perform analogous tasks

(i.e. linear regressions are calculated before specific parameters of

the line generated are returned) but my understanding is that VBA

source code for these is not available? The Analysis ToolPak-VBA seems

promising for a template, but it is password protected-any potential

for accessing this?

So...any thoughts or directions on where to take this? Thanks in

advance for your suggestions.

Bob Nelson