Practical and Clear Graduate Statistics in Excel - The Excel Statistical Master

Practical and Clear Graduate Statistics in Excel - The Excel Statistical Master

Complete and practical yet easy-to-understand graduate-level statistics instruction with ALL of the problems and examples worked out in the accompanying Excel workbooks. Thoroughly covers all topics of an intense graduate statistics course using nothing but step-by-step, simple explanations. The lessons are all in bite-size chunks that are quickly absorbed for immediate use. Some of the major topics covered with easy-to-follow explanations and fully described and demonstrated in detail in Excel in the 62 chapters of this greatly-expanded 2nd edition include: <br /> <br />1) ALL types of t-Tests (1-sample, 2-sample pooled and unpooled, and paired) and z tests including verification of ALL required assumptions * <br /> <br />2) Single-variable and multiple regression (includes verification of ALL required assumptions, ALL underlying formulas used to produce Excel regression output, and detailed discussion of Excel regression output) * <br /> <br />3) Logistic regression performed with the Excel Solver (calculation of Logit and P(X), MLL, Max Log-Likelihood Function, R Square (Cox and Snell and Nagelkerke), variable significance with Likelihood Ratio, Classification Table, Hosmer-Lemeshow) * <br /> <br />4) Normality Tests (Kolmogorov-Smirnov, Anderson-Darlington, Shapiro-Wilk, Automated Histograms) * <br /> <br />5) Single-factor and two-factor ANOVA with and without replication including verification of ALL required assumptions and ALL underlying formulas used to produce Excel ANOVA output along with detailed discussion of Excel ANOVA output* <br /> <br />6) Post-Hoc tests for ANOVA (Tukey's HSD, Tukey-Kramer, Games-Howell) * <br /> <br />7) ANOVA substitute tests (Welch's ANOVA, Brown-Forsythe F test) * <br /> <br />8) Variance comparison tests (F test, Levene's test, Brown-Forsythe test) * <br /> <br />9) Effect size tests (Eta square, RMSSE, Omega square) * <br /> <br />10) Detailed description of calculating test power using the online utility G*Power for all types of statistical tests * <br /> <br />11) Nonparametric tests (Mann-Whitney U test alternative for 2-sample t-Tests, Wilcoxon Signed-Rank test alternative for 1-sample and paired t-Tests, Kruskal-Wallis test alternative for 1-way ANOVA, Scheirer-Ray-Hare test alternative for 2-way ANOVA, Sign Test) * <br /> <br />11) Chi-Square tests (Goodness-of-Fit, Independence tests, and population variance tests with verification of ALL required assumption) * <br /> <br />12) Confidence intervals of population means and of population proportions (includes calculation of min sample size and verification of ALL required assumptions) * <br /> <br />13) Combinations and Permutations (many different examples of each) * <br /> <br />14) Correlations - Pearson and Spearman (includes calculation of r Critical and p value of calculated r) * <br /> <br />15) Covariance * <br /> <br />16) Automated histograms, sorting, and charting created with formulas that automatically re-calculate when data changes * <br /> <br />17) Central Limit Theorem demonstrated in Excel * <br /> <br />18) Lots of problems solved in Excel using the following distributions: Normal, t, Binomial, Negative Binomial, F, Chi-Square, Poisson, Exponential, Uniform, Geometric, Beta, Gamma, Hypergeometric, and Multinomial * <br /> <br />19) Instructions to create user-interactive PDF and CDF graphs in Excel for the following distributions: Normal, t, Binomial, Chi-Square, Poisson, Exponential, Uniform, Beta, Gamma, and Hypergeometric * <br /> <br />This book is complete and thorough enough for the professional statistician but simple and clear enough for the new statistics student. This manual achieves two goals: teaching graduate-level statistical frameworks in an easy-to-understand way and then showing how to implement all of it in Excel. EVERYTHING in this book is taught using step-by-step instructions. Statistics students and business managers will find this manual to be, by far, the easiest and fastest way to master graduate-level statistics and to apply advanced statistics in Excel to solve difficult, real-world problems, homework assignments, and exam questions. The reader who studies this book will become an