Multiple linear regression add-in
Powerful add-in for multiple linear regression to uncover and model relationships without leaving Microsoft Excel.
Trusted by over 60,000 users and proven for more than 30 years.
-
Simple regression & Advanced regression models
Fit simple regression models with linear, logistic, probit, polynomial, logarithmic, exponential, and power fits. Or build complex multiple regression models with simple and polynomial terms, factors, and crossed factors, all the way up to full factorial models, ANOVA, ANCOVA, all with automatic dummy variables. -
In-depth fit statistics
Fit statistics include parameter estimates, R2, R2 adjusted, AIC, BIC, VIF, Correlation/Covariance of estimates matrices, model equation. Easily examine the effect of each term using leverage (partial residual) plots and sequential (type I SS) and partial (type III SS) hypothesis tests. -
Diagnostic plots
Diagnose model fit with raw and standardized residual plots, sequence, lag and residual distribution plots. Identify outliers and cases with high influence with the Outliers & Influence plot using Cook's D and Studentized Residuals. - Save computed variables
Save Fitted Y, Residuals, Standardized Residual, Studentized Residual, Leverage, and Cook's Influence back to the dataset for further analysis. - Predict
Easily predict future observations using the model. -
Runs in Microsoft Excel for easy deployment across your team.
Analyse‑it integrates directly into Excel. It performs all calculations and is validated to ensure accuracy -- no formulas, or cell references break. Import data from instruments, analyse it immediately, then generate publication‑ready reports without learning new software or managing proprietary file formats — significantly faster and more flexible than standalone tools.
