Straightforward Statistics with Excel

Second Edition

Chieh-Chen Bowen - Cleveland State University, USA

Quantitative Techniques for Business & Management Research | Quantitative/Statistical Research | Quantitative Methods

September 2021 | 520 pages | Sage US

Create Flyer

If you’re in the Americas, please visit our Sage College Publishing website to purchase or sample this book:

Go to College Publishing Website

Description

Written in an accessible and clear manner, Straightforward Statistics with Excel® 2e by Chieh-Chen Bowen helps students across the social and behavioral sciences gradually build their skills to develop a better understanding of the world around them. Each chapter purposefully connects with the previous chapter for a gradual accrual of knowledge from simple to more complex concepts. This effective, cumulative approach to statistics through logical transitions eases students into statistics and prepares them for success in more advanced quantitative coursework and their own research. The second edition now features Excel instructions and exercises throughout so students can use this widely-available and applied software for statistics.

This book is designed to walk the reader through statistics at a steady but gentle pace, providing pop quizzes throughout every chapter so readers can check their knowledge along the way. By gradually stepping up difficulty in each chapter, students generate a solid foundation and are prepared for the next chapters. Straightforward Statistics with Excel looks at the big picture so that the basic statistical concepts connect to everyday and relevant research examples in multiple ways. Throughout the book the reader is reminded of what they need to be able to recall with "You Must Remember This" boxes. A rich source of practical resources are located at the end of chapters beginning with " What You Learned," followed by three sets of exercises so students can immediately apply their knowledge.

The new edition features a reorganized presentation of material, starting with measures of central tendency, separating this from measures of variability so students better understand the differences. A more thorough presentation of one-sample and dependent samples t-tests gives students a stronger foundation in these crucial tests in statistics. New examples and studies complete the update, with a focus on simplicity. Throughout, the book makes use of Excel instructions and screenshots so students can take statistics with them through research projects and into the world beyond academia.

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

Additional materials

Description

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

Additional materials

Reviews

It does not seem like a very contemporary approach to statistics in 2023. Press enter to read the full quote (will open a modal popup)
Mr Thomas Simpson, Educational Foundations, Piedmont Technical College

Straightforward Statistics with Excel

Chieh-Chen Bowen

Cancel Print

September 2021 | 520 pages | Sage US

Format	Published Date	ISBN	Price

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

Straightforward Statistics with Excel

Description

Contents

Additional materials

Description

Contents

Preface

Preface

Acknowledgments

Acknowledgments

About the Author

About the Author

Appendix A. The Standard Normal Distribution Table (Z Table)

Appendix A. The Standard Normal Distribution Table (Z Table)

Appendix B. The t-Distribution Table (t Table)

Appendix B. The t-Distribution Table (t Table)

Appendix C. The F Table

Appendix C. The F Table

Appendix D. The Critical Values of Pearson’s Correlation Table (r 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)

Appendix E. The Critical Values for the Chi-Square Tests (?2 Table)

Answers to the Learning Assessments

Answers to the Learning Assessments

Glossary

Glossary

References

References

Index

Index

Additional materials

Description

Description

Contents

Contents

Preface

Preface

Acknowledgments

Acknowledgments

About the Author

About the Author

Appendix A. The Standard Normal Distribution Table (Z Table)

Appendix A. The Standard Normal Distribution Table (Z Table)

Appendix B. The t-Distribution Table (t Table)

Appendix B. The t-Distribution Table (t Table)

Appendix C. The F Table

Appendix C. The F Table

Appendix D. The Critical Values of Pearson’s Correlation Table (r 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)

Appendix E. The Critical Values for the Chi-Square Tests (?2 Table)

Answers to the Learning Assessments

Answers to the Learning Assessments

Glossary

Glossary

References

References

Index

Index

Additional materials

Additional materials

Reviews

Straightforward Statistics with Excel

Table Of Contents:

Recent Product Reviews:

Recommendations