| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function for max residual from linear regression
You're welcome. Glad it helped.
Jerry "Bob Nelson" wrote: Jerry, Great solution! This eliminated the need for VBA in my case. With one extra column in the worksheet, I was able to track when a new starting row was signaled for the dynamic arrays (used to generate a line), then use OFFSET in combination with TREND to return max (and min) residuals using your formula. Thanks again for the collective wisdom of the group in your solutions to this question! Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| residual plots in multiple regression | Excel Worksheet Functions | |||
| Linear Regression | Excel Worksheet Functions | |||
| The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
| Regression Residual Plots | Excel Discussion (Misc queries) | |||
| Linear Regression using the TREND function | Excel Worksheet Functions | |||
Threaded Mode
