![]() Tests for statistical significance, autocorrelation, and multicollinearity. Multiple and individual regression of independent variables. User-friendly results display for the non-statistician. The Excel regression analysis solution provides much more functionality and more intuitive results display than the standard regression analysis provided within Excel via the Analysis Toolpak add-in.Įase and flexibility of input, with embedded help prompts. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies. While the regression analysis utilizes a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Control charts - X-bar, R-chart, S-chart, IMR-chart, P-chart, C-chart, U-chart, CUSUM-chart.The Excel Regression Analysis and Forecasting model provides a reliable basis for identifying value drivers and forecasting business and scientific data.Quantile-quantile Q-Q plots for different distributions.Bland-Altman plot with multiple measurements per subject.Sampling (random, periodic, conditional).Report includes: AUC (with confidence intervals), curve coordinates, performance indicators - sensitivity and specificity (with confidence intervals), accuracy, positive and negative predictive values, Youden's J (Youden's index), Precision-Recall plot. Receiver operating characteristic curves analysis (ROC analysis).ĪUC methods - DeLong's, Hanley and McNeil's.LD values (LD50/ED50 and others), cumulative coefficient calculation. Kaplan-Meier (log rank test, hazard ratios). ![]() Unit root tests - Dickey–Fuller, Augmented Dickey–Fuller (ADF test), Phillips–Perron (PP test), Kwiatkowski–Phillips–Schmidt–Shin (KPSS test).Tests for heteroscedasticity: Breusch–Pagan test (BPG), Harvey test, Glejser test, Engle's ARCH test (Lagrange multiplier) and White test.Stepwise (forward and backward) regression.Weighted least squares (WLS) regression.Multivariate linear regression (residuals analysis, collinearity diagnostics, confidence and prediction bands).Wilcoxon Matched Pairs Test, Sign Test, Friedman ANOVA, Kendall's W (coefficient of concordance). Mann-Whitney U Test, Kolmogorov-Smirnov test, Wald-Wolfowitz Runs Test, Rosenbaum Criterion. Rank correlations (Kendall Tau, Spearman R, Gamma, Fechner).2x2 tables analysis (Chi-square, Yates Chi-square, Exact Fisher Test, etc.).Within subjects ANOVA and mixed models.Post-hoc comparisons - Bonferroni, Tukey-Kramer, Tukey B, Tukey HSD, Neuman-Keuls, Dunnett.One-way and two-way ANOVA (with and without replications).Multiple definitions for computing quantile statistics.Frequency tables analysis (for discrete and continuous variables).Normality tests (Jarque-Bera, Shapiro-Wilk, Shapiro-Francia, Cramer-von Mises, Anderson-Darling, Kolmogorov-Smirnov, D'Agostino's tests).Migration guide for users switching from Analysis ToolPak. Options to emulate Excel Analysis ToolPak results and.Permanent license with free major upgrades during the maintenance period.Fast and powerful standalone spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |