Straightforward Statistics with Excel 2/e

Chieh-Chen Bowen is an Associate Professor in the Department of Psychology at Cleveland State University. She received her Ph.D. in Industrial and Organizational Psychology and a doctoral minor in Statistics from Penn State. She teaches undergraduate and graduate level Statistics, Personnel Psychology, Job Analysis, and Performance Management. Her research interests are comparing cross-cultural management practices, investigating women's issues in the workplace, and validating personality questionnaires for employee selection. When she is not teaching or doing research, she can be found providing expert witness consulting services to attorneys who are involved in employment discrimination cases. On her days off, she works on figuring out the probability of a black-and-white cat selectively shedding only white fur on navy blue carpet while shedding only black fur on white ceramic tiles.

Preface Acknowledgments About the Author Chapter 1. Introduction to Statistics What Is Statistics? Random Sampling Methods Scales of Measurement Variable Classifications Required Mathematical Skills for This Course Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 2. Summarizing, Organizing Data, and Measures of Central Tendency What You Know and What Is New Frequency Distribution Table Graphs Common Distribution Shapes Measures of Central Tendency Excel Step-by-Step Instruction for Calculating SX From a Frequency Table and Constructing a Bar Graph and a Histogram Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 3. Measures of Variability What You Know and What Is New Measures of Variability Discover the Hidden Functions in Excel: Analysis Toolpak Installation Instructions Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 4. Standard Z Scores What You Know What Is New Standard Z Scores Empirical Rule for Variables With a Normal Distribution Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 5. Basic Principles of Probability What You Know and What Is New Basic Terms and Mathematical Operations in Probability Linkage Between Probability and Z Score in a Normal Distribution Probabilities, Z Scores, and Raw Scores Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 6. The Central Limit Theorem What You Know and What Is New Sampling Error Sampling Distribution of the Sample Means and the Central Limit Theorem Relationships Between Sample Means and the Population Mean The Law of Large Numbers Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 7. Hypothesis Testing What You Know and What Is New Type I Error and Type II Error The Four-Step Procedure to Conduct a Hypothesis Test Further Discussions on Directional Versus Nondirectional Hypothesis Tests Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 8. One-Sample t Test and Dependent-Sample t Test What You Know and What Is New The Unknown s and Conducting the One-Sample t Test The t Distribution With a Specific Curve for Every Degree of Freedom The Four-Step Hypothesis Test in One-Sample t Tests Confidence Intervals in One-Sample t Tests Introducing Dependent-Sample t Tests Calculations and the Hypothesis Testing Process in Dependent-Sample t Tests Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 9. Independent-Samples t Tests What You Know and What Is New Introducing Independent Samples and the Decision Rules on Equal Variances Decision Rules for Equal Variances Assumed Versus Equal Variances Not Assumed Confidence Intervals of the Mean Differences Effect Sizes Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 10. Correlation What You Know and What Is New Pearson's Correlation Hypothesis Testing for Pearson's Correlation Interpretations and Assumptions of Pearson's Correlation Partial Correlation Excel Step-by-Step Instruction for Constructing a Scatterplot Excel Step-by-Step Instruction for Calculating Pearson's r Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 11. Simple Regression What You Know and What Is New Y-Intercept and Slope Hypothesis Testing for Simple Regression Statistical Assumptions for Simple Regression Step-by-Step Instructions of Simple Regression in Excel Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 12. One-Way Analysis of Variance What You Know and What Is New Introducing One-Way ANOVA Between-Group Variance and Within-Group Variance Hypothesis Testing for One-Way ANOVA Effect Size for One-Way ANOVA Step-by-Step Instructions for Using Excel to Run an ANOVA Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Chapter 13. Chi-Square Tests for Goodness of Fit and Independence What You Know and What Is New The Chi-Square Expected Frequency Goodness-of-Fit Tests Chi-Square for Independence Test Exercise Problems Chapter Resources What You Learned Key Words Learning Assessment Appendix A. The Standard Normal Distribution Table (Z Table) Appendix B. The t-Distribution Table (t Table) Appendix C. The F Table Appendix D. The Critical Values of Pearson's Correlation Table (r Table) Appendix E. The Critical Values for the Chi-Square Tests (?2 Table) Answers to the Learning Assessments Glossary References Index