Straightforward Statistics with Excel - Chieh-Chen Bowen

. .

Résumé :
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 ...

Biographie:

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.