國立虎尾科技大學 |

Excel 2019 in Applied Statistics for High School Students = A Guide to Solving Practical Problems /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Excel 2019 in Applied Statistics for High School Students/ by Thomas J. Quirk.
Reminder of title:	A Guide to Solving Practical Problems /
Author:	Quirk, Thomas J.
Description:	XVII, 244 p. 169 illus., 162 illus. in color.online resource. :
Contained By:	Springer Nature eBook
Subject:	Statistics . -
Online resource:	https://doi.org/10.1007/978-3-030-66756-6
ISBN:	9783030667566

Excel 2019 in Applied Statistics for High School Students = A Guide to Solving Practical Problems /
Quirk, Thomas J.

Excel 2019 in Applied Statistics for High School StudentsA Guide to Solving Practical Problems /[electronic resource] :by Thomas J. Quirk. - 2nd ed. 2021. - XVII, 244 p. 169 illus., 162 illus. in color.online resource. - Excel for Statistics,2570-4613. - Excel for Statistics,.

Preface -- Acknowledgements -- 1 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean -- 2 Random Number Generator -- 3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing -- 4 One-Group t-Test for the Mean -- 5 Two-Group t-Test of the Difference of the Means for Independent Groups -- 6 Correlation and Simple Linear Regression -- 7 Multiple Correlation and Multiple Regression -- 8 One-Way Analysis of Variance (ANOVA) -- Appendix A: Answers to End-of-Chapter Practice Problems -- Appendix B: Practice Test -- Appendix C: Answers to Practice Test -- Appendix D: Statistical Formulas -- Appendix E: t-table -- Index.

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.

ISBN: 9783030667566

Standard No.: 10.1007/978-3-030-66756-6doiSubjects--Topical Terms:

1253516
Statistics .

LC Class. No.: QA276-280

Dewey Class. No.: 519.5

Excel 2019 in Applied Statistics for High School Students = A Guide to Solving Practical Problems /
LDR:03448nam a22003975i 4500 001 1047728
003 DE-He213
005 20210814205122.0
007 cr nn 008mamaa
008 220103s2021 sz | s |||| 0|eng d
020 $a 9783030667566 $9 978-3-030-66756-6
024 7 $a 10.1007/978-3-030-66756-6 $2 doi
035 $a 978-3-030-66756-6
050 4 $a QA276-280
072 7 $a JHBC $2 bicssc
072 7 $a SOC027000 $2 bisacsh
072 7 $a JHBC $2 thema
082 0 4 $a 519.5 $2 23
100 1 $a Quirk, Thomas J. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 883684
245 1 0 $a Excel 2019 in Applied Statistics for High School Students $h [electronic resource] : $b A Guide to Solving Practical Problems / $c by Thomas J. Quirk.
250 $a 2nd ed. 2021.
264 1 $a Cham : $b Springer International Publishing : $b Imprint: Springer, $c 2021.
300 $a XVII, 244 p. 169 illus., 162 illus. in color. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
490 1 $a Excel for Statistics, $x 2570-4613
505 0 $a Preface -- Acknowledgements -- 1 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean -- 2 Random Number Generator -- 3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing -- 4 One-Group t-Test for the Mean -- 5 Two-Group t-Test of the Difference of the Means for Independent Groups -- 6 Correlation and Simple Linear Regression -- 7 Multiple Correlation and Multiple Regression -- 8 One-Way Analysis of Variance (ANOVA) -- Appendix A: Answers to End-of-Chapter Practice Problems -- Appendix B: Practice Test -- Appendix C: Answers to Practice Test -- Appendix D: Statistical Formulas -- Appendix E: t-table -- Index.
520 $a 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.
650 0 $a Statistics . $3 1253516
650 0 $a Assessment. $3 1017002
650 0 $a Higher education. $3 1148448
650 1 4 $a Statistics for Social Sciences, Humanities, Law. $3 1211304
650 2 4 $a Assessment, Testing and Evaluation. $3 671650
650 2 4 $a Higher Education. $3 679030
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9783030667559
776 0 8 $i Printed edition: $z 9783030667573
830 0 $a Excel for Statistics, $x 2570-4605 $3 1253589
856 4 0 $u https://doi.org/10.1007/978-3-030-66756-6
912 $a ZDB-2-SMA
912 $a ZDB-2-SXMS
950 $a Mathematics and Statistics (SpringerNature-11649)
950 $a Mathematics and Statistics (R0) (SpringerNature-43713)