- PHSTAT IN EXCEL 2016 HOW TO
- PHSTAT IN EXCEL 2016 LICENSE
Quantile-quantile Q-Q plots for different distributions.Soon, videos on the use of Google Sheets for statistics and quantitative methods will be added.
PHSTAT IN EXCEL 2016 HOW TO
I focus on short tutorials on how to solve statistics and quantitative methods problems using Excel and StatCrunch as well as the Excel add-in PHStat.
Bland-Altman plot with multiple measurements per subject. Get a B or better in your stats or quant class. 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. All statistical methods taught in an introductory statistics course can be done in Excel using the add-in along with the Data Analysis Tool Pack (that comes with Excel. It makes using Excel easier for statistical operations. Multivariate linear regression (residuals analysis, collinearity diagnostics, confidence and prediction bands). PHStat2 is a statistics add-in for Microsoft Excel. 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. Type chi in the Search for a Function box and then click Go.then select CHITEST from the list and then click OK. Frequency tables analysis (for discrete and continuous variables). Type your data into columns and click a blank cell where you want to show the results on the worksheet and then click the Insert Function button on the toolbar, a pop up would appear. Normality tests (Jarque-Bera, Shapiro-Wilk, Shapiro-Francia, Cramer-von Mises, Anderson-Darling, Kolmogorov-Smirnov, D'Agostino's tests). Options to emulate Excel Analysis ToolPak results and migration guide for users switching from Analysis ToolPak. PHSTAT IN EXCEL 2016 LICENSE
Permanent license and free major upgrades during the maintenance period.
'Add-in' mode for Apple Numbers v3, v4 and v5. Standalone spreadsheet with Excel (XLS and XLSX), OpenOffice/LibreOffce Calc (ODS) and text documents support. Statistical features list Phstat For Excel 2016
0 kommentar(er)
