Regression Analysis
Regression Analysis
| Function | Description |
|---|---|
LINEST | Drop-in replacement for Excel's LINEST that handles missing values |
OLS | Least-squares regression with labeled output and correlation matrix |
WLS | Weighted least-squares version of OLS |
NLS | Nonlinear least-squares regression without SOLVER |
Sres | Std dev of residuals and deleted residuals for a general linear model |
PolyLS | Polynomial least-squares regression (wraps OLS or WLS) |
PolyHat | Fitted values from polynomial regression |
PolyConf | CI for the mean response of a polynomial fit at xu |
PolyPred | Prediction interval for a future y at xu |
PolyInv | Inverse (x-from-y) prediction from polynomial regression. Returns exact inverse CI for best-fit lines. |
PolyResids | Raw, standardized, and deleted residuals for polynomial regression |
PolySres | Std dev of residuals and deleted residuals for polynomial regression |
PolySlope | Slope of a fitted polynomial at a given x (convenience function for error propagation) |
StdAddn | Standard addition calibration: analyte concentration and its CI |