CURRENTLY SOLD OUT

Practical and Clear Graduate Statistics in Excel - The Excel Statistical Master by Mark Harmon (Paperback / softback, 2012)

About this product

Product Information

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 thing 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-Smirv, 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, Bimial, Negative Bimial, F, Chi-Square, Poisson, Exponential, Uniform, Geometric, Beta, Gamma, Hypergeometric, and Multimial * 19) Instructions to create user-interactive PDF and CDF graphs in Excel for the following distributions: Normal, t, Bimial, Chi-Square, Poisson, Exponential, Uniform, Beta, Gamma, and Hypergeometric * This book is complete and thorough eugh for the professional statistician but simple and clear eugh for the new statistics student. The reader of this book will become an Excel Statistical Master!

Product Identifiers

Publisher
Excel Master Series
ISBN-10
1937159132
ISBN-13
9781937159139
eBay Product ID (ePID)
190185109

Product Key Features

Author
Mark Harmon
Format
Paperback / Softback, Trade Paperback (US) ,Unsewn / Adhesive Bound
Language
English
Subject
Education & Teaching
Type
Textbook

Additional Product Features

Content Note
Black & White Illustrations
Date of Publication
19/01/2012
Country of Publication
United States

Best Selling in Adult Learning & University

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Adult Learning & University

Time Management by Peter Quarry (Paperback, 1986)
No ratings or reviews yet.
AU $16.99 New
---- Used
Complete Illustrated Encyclopedia of Dinosaurs & Prehistoric Creatures by Dixon Dougal (Paperback, 2014)
5.0 out of 5 stars based on 6 product ratings
AU $41.64 New
---- Used
Polyvagal Exercises for Safety and Connection: 50 Client-Centered Practices by Deb Dana (Paperback, 2020)
No ratings or reviews yet.
AU $53.39 New
AU $45.00 Used

Save on Adult Learning & University

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Adult Learning & University

Ford Falcon EF EL / Fairlane NF NL 1994 - 1998 Workshop Manual
AU $49.00
Trending at AU $60.40
Netter Atlas of Human Anatomy: Classic Regional Approach
AU $113.94
Trending at AU $124.20
Sapiens A Brief History of Humankind by Yuval Noah Harari Paperback Book NEW
AU $19.57
Trending at AU $19.77
BORN IN 1971?... 1951?BIRTHDAY...Australian Social History....Chrisi, Birthdays
AU $19.00
Trending at AU $22.18
Michael Price Nick Vandome Windows 11 for Seniors in easy steps (Paperback)
AU $32.73
Trending at AU $36.70
It's Not You: How to Identify and Heal from NARCISSISTIC People by Ramani Durvas
AU $35.00
Trending at AU $37.67

Shop by category

Practical and Clear Graduate Statistics in Excel - The Excel Statistical Master by Mark Harmon (Paperback / softback, 2012)

About this product

Product Information

Product Identifiers

Product Key Features

Additional Product Features

Best Selling in Adult Learning & University

Time Management by Peter Quarry (Paperback, 1986)

Complete Illustrated Encyclopedia of Dinosaurs & Prehistoric Creatures by Dixon Dougal (Paperback, 2014)

Polyvagal Exercises for Safety and Connection: 50 Client-Centered Practices by Deb Dana (Paperback, 2020)

Save on Adult Learning & University

Ford Falcon EF EL / Fairlane NF NL 1994 - 1998 Workshop Manual

Netter Atlas of Human Anatomy: Classic Regional Approach

Sapiens A Brief History of Humankind by Yuval Noah Harari Paperback Book NEW

BORN IN 1971?... 1951?BIRTHDAY...Australian Social History....Chrisi, Birthdays

Michael Price Nick Vandome Windows 11 for Seniors in easy steps (Paperback)

It's Not You: How to Identify and Heal from NARCISSISTIC People by Ramani Durvas

You may also like

Statistics Paperback School Textbooks & Study Guides

Statistics Paperback Adult Learning & University Books

Statistics School Textbooks and Study Guides

Statistics Adult Learning & University Books

Statistics Hardcover School Textbooks & Study Guides

Non-Fiction Paperback Fiction & Practical Skills Books