- LIST OF STATISTICAL ANALYSIS IN EXCEL PROGRAMS SERIES
- LIST OF STATISTICAL ANALYSIS IN EXCEL PROGRAMS FREE
LIST OF STATISTICAL ANALYSIS IN EXCEL PROGRAMS SERIES
TIME SERIES analysis including data transformation (ex.: remove mean, lag, etc.), auto-correlation diagnostic (ACF and PACF plot), smoothing techniques (moving average, running median), control bars with a user-specified confidence interval.MULTIPLE REGRESSION analysis including 5 different regression methods (hierarchical entry, forward selection, backward elimination, stepwise selection, enter all variables), P to enter, P to remove, and tolerance criteria, ANOVA table, test of change ANOVA table, regression equation (B, standard error of B, beta, confidence, interval of B, zero-order, semi-partial and partial correlations, tolerance level, F, significance), residuals case plot, Durbin-Watson statistic, standardized residuals scatterplot, normal probability plot of residuals, ability to save predicted and residual values.
REGRESSION analysis including linear and 7 nonlinear regressions (quadratic, cubic, 4th and 5th-degree polynomial, logarithmic, exponential, inverse), regression equation, analysis of variance, Durbin-Watson statistics, scatterplot, residuals case plot, standardized residuals scatterplot, normal probability plot of residuals, ability to save predicted and residual values.PARTIAL CORRELATION MATRIX with interactive correlation matrix for the inclusion of exclusion of control variables, computation of confidence intervals, etc.CORRELATION MATRIX including covariance and cross-product deviation, user-specified confidence interval, scatterplot matrix.GLM ANOVA/ANCOVA (up to 5 factors and covariates) including detailed ANOVA table, 3 different adjustment methods for unequal cell sizes (regression, nonexperimental, hierarchical), multiple regression statistics, test of change of R-Square, regression equation (B, standard error of B, beta, confidence, interval of B, zero-order, semi-partial and partial correlations, tolerance level, F, significance), residuals case plot with Durbin-Watson statistic, standardized residuals scatterplot, normal probability plot of residuals, ability to save predicted and residual values.ONEWAY ANALYSIS OF VARIANCE with post hoc tests (LSD, Tukey’s HSD, Scheffé’s test), effect size measures, error bar graph, bar chart, deviation chart.PAIRED AND INDEPENDENT T-TESTS with effect size measures (r and d), error bar graph, barchart, dual histogram.MULTIPLE RESPONSES frequency and crosstabulation analysis.
LIST OF STATISTICAL ANALYSIS IN EXCEL PROGRAMS FREE
CROSSTABULATION: normal crosstabulation and INTER-RATERS AGREEMENT table, nominal statistics (chi-square, Pearson’s Phi, Goodman-Kruskal’s Gamma, Contingency coefficient), ordinal statistics (Kendall’s tau-b and tau-c, Pearson’s R, symmetric and asymmetric Somers’ D, Dxy and Dyx), inter-rater agreement statistics (percentage of agreement, Cohen’s Kappa, Scott’s Pi, Krippendorf’s r and R-bar, free marginal correction for nominal and ordinal measure), 3-D bar chart.FREQUENCY analysis including frequencies table, descriptive statistics, percentiles table, barchart, pie chart, Pareto chart, histogram, normal probability plot, box-&-whiskers plot, and cumulative distribution plot.DESCRIPTIVE statistics (mean, variance, standard deviation, etc.).