daavista.blogg.se

How to download data analysis for excel mac
How to download data analysis for excel mac













how to download data analysis for excel mac

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

    how to download data analysis for excel mac

    Rank correlations (Kendall Tau, Spearman R, Gamma, Fechner).

    how to download data analysis for excel mac

  • 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 and free major upgrades during the maintenance period.
  • Standalone spreadsheet with Excel (XLS and XLSX), OpenOffice/LibreOffce Calc (ODS) and text documents support.














  • How to download data analysis for excel mac