lkpfinal.blogg.se

Linear regression excel 2013
Linear regression excel 2013








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.

linear regression excel 2013

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).

linear regression excel 2013

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.
  • linear regression excel 2013

    Fast and powerful standalone spreadsheet.










    Linear regression excel 2013