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. Some of the major topics covered with easy-to-follow explanations and fully described and demonstrated in detail in Excel include: 1) ALL types of t-Tests (1-sample, 2-sample pooled and unpooled, and paired) and z tests including ...
Read More
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. Some of the major topics covered with easy-to-follow explanations and fully described and demonstrated in detail in Excel include: 1) ALL types of t-Tests (1-sample, 2-sample pooled and unpooled, and paired) and z tests including verification of ALL required assumptions * 2) Single-variable and multiple regression (includes verification of ALL required assumptions and ALL underlying formulas used to produce Excel regression output) * 3) Logistic regression (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) * 4) Normality Tests (Kolmogorov-Smirnov, Anderson-Darlington, Shapiro-Wilk, Automated Histograms) * 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 * 6) Post-Hoc tests for ANOVA (Tukey's HSD, Tukey-Kramer, Games-Howell) * 7) ANOVA substitute tests (Welch's ANOVA, Brown-Forsythe F test) * 8) Variance comparison tests (F test, Levene's test, Brown-Forsythe test) * 9) Effect size tests (Eta square, RMSSE, Omega square) * 10) Detailed description of calculating test power using the online utility G*Power for all types of tests) * 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) * 11) Chi-Square tests (Goodness-of-Fit, Independence tests, and population variance tests) * 12) Confidence intervals of population means and of population proportions (includes calculation of min sample size and verification of ALL required assumptions) * 13) Combinations and Permutations (many different examples of each) * 14) Correlations - Pearson and Spearman (includes calculation of r Critical and p value of calculated r) * 15) Covariance * 16) Automated histograms, sorting, and charting created with formulas that automatically re-calculate when data changes * 17) Central Limit Theorem demonstrated in Excel * 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 * 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 * This book is complete and thorough enough for the professional statistician but simple and clear enough for the new statistics student. The reader of this book will become an Excel Statistical Master!
Read Less
Add this copy of Practical and Clear Graduate Statistics in Excel - The to cart. $66.52, like new condition, Sold by GreatBookPricesUK5 rated 4.0 out of 5 stars, ships from Castle Donington, DERBYSHIRE, UNITED KINGDOM, published 2012 by Excel Master Series.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fine. Trade paperback (US). Glued binding. 1066 p. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of Practical and Clear Graduate Statistics in Excel-the to cart. $52.96, good condition, Sold by HPB-Red rated 5.0 out of 5 stars, ships from Dallas, TX, UNITED STATES, published 2012 by Excel Master Series.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority!
Add this copy of Practical and Clear Graduate Statistics in Excel-the to cart. $53.94, good condition, Sold by BuenaWave rated 5.0 out of 5 stars, ships from Oklahoma City, OK, UNITED STATES, published 2012 by Excel Master Series.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Good. This is a pre-loved book that shows moderate signs of wear from previous reading. You may notice creases edge wear or a cracked spine but it remains in solid readable condition. Please note: -May include library or rental stickers stamps or markings. -Supplemental materials e.g. CDs access codes inserts are not guaranteed. -Box sets may not come with the original outer box. If it does the box will not be in perfect condition. -Sourced from donation centers; authenticity not verified with publisher. Your satisfaction is our top priority! If you have any questions or concerns about your order please don't hesitate to reach out. Thank you for shopping with us and supporting small business-happy reading!
Add this copy of Practical and Clear Graduate Statistics in Excel - The to cart. $65.97, new condition, Sold by Ingram Customer Returns Center rated 5.0 out of 5 stars, ships from NV, USA, published 2012 by Excel Master Series.
Add this copy of Practical and Clear Graduate Statistics in Excel - The to cart. $69.66, new condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2012 by Excel Master Series.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
New. Trade paperback (US). Glued binding. 1066 p. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of Practical and Clear Graduate Statistics in Excel - The to cart. $69.66, like new condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2012 by Excel Master Series.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Fine. Trade paperback (US). Glued binding. 1066 p. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
