![]() ![]() #Statplus in excel for mac#Quantile-quantile Q-Q plots for different distributions. StatPlus for Mac runs as a standalone spreadsheet app but also can read data from documents opened in the Microsoft Excel.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. The StatPlus add-in vastly expands Excel 2007s statistical capabilities to include advanced graphics such as box plots, control charts, scatter plots. ![]() 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.For example, the book Statistics for Management and Economics (6th edition) by Keller and Warrack includes 'Data Analysis Plus. 'Data Analysis Plus' is distributed on the CD included with some textbooks. Post-hoc comparisons - Bonferroni, Tukey-Kramer, Tukey B, Tukey HSD, Neuman-Keuls, Dunnett. Data Analysis Plus' is an add-in for Excel that has some features beyond those included in Excels Analysis ToolPak.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. #Statplus in excel license#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |