Overview
- Presents practical examples of problems taken from a diverse array of statistical fields
- Addresses both how to write statistical formulas and how to use drop-down menus to create formulas in Excel
- Includes over 150 color screenshots to show the reader how to perform Excel steps correctly
Part of the book series: Excel for Statistics (EXCELSTAT)
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (8 chapters)
-
Front Matter
-
Back Matter
Keywords
About this book
This textbook is a step-by-step guide for high school, community college, and undergraduate students who are taking a course in applied statistics and wish to learn how to use Excel to solve statistical problems. All of the statistics problems in this book come from the following fields of study: business, education, psychology, marketing, engineering and advertising. Students will learn how to perform key statistical tests in Excel without being overwhelmed by statistical theory.
Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific statistics problems. The book offers guidance in using Excel in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two-group t-test, correlation) and (2) using Excel’s drop-down formula menus (e.g., simple linear regression, multiple correlations and multiple regression, and one-way ANOVA). Three practice problems are provided at the end of each chapter, along with their solutions in an appendix. An additional practice test allows readers to test their understanding of each chapter by attempting to solve a specific statistics problem using Excel; the solution to each of these problems is also given in an appendix. This book is a tool that can be used either by itself or along with any good statistics book.​Authors and Affiliations
About the author
Bibliographic Information
Book Title: Excel 2019 in Applied Statistics for High School Students
Book Subtitle: A Guide to Solving Practical Problems
Authors: Thomas J. Quirk
Series Title: Excel for Statistics
DOI: https://doi.org/10.1007/978-3-030-66756-6
Publisher: Springer Cham
eBook Packages: Mathematics and Statistics, Mathematics and Statistics (R0)
Copyright Information: The Editor(s) (if applicable) and The Author(s), under exclusive license to Springer Nature Switzerland AG 2021
Softcover ISBN: 978-3-030-66755-9Published: 16 March 2021
eBook ISBN: 978-3-030-66756-6Published: 15 March 2021
Series ISSN: 2570-4605
Series E-ISSN: 2570-4613
Edition Number: 2
Number of Pages: XVII, 244
Number of Illustrations: 7 b/w illustrations, 162 illustrations in colour
Topics: Statistics for Social Sciences, Humanities, Law, Assessment, Testing and Evaluation, Higher Education