001435224 000__ 03970cam\a2200529\i\4500 001435224 001__ 1435224 001435224 003__ OCoLC 001435224 005__ 20230309003843.0 001435224 006__ m\\\\\o\\d\\\\\\\\ 001435224 007__ cr\cn\nnnunnun 001435224 008__ 210327s2021\\\\sz\\\\\\ob\\\\001\0\eng\d 001435224 019__ $$a1242107079$$a1245857931 001435224 020__ $$a9783030667566$$q(electronic bk.) 001435224 020__ $$a3030667561$$q(electronic bk.) 001435224 020__ $$z9783030667559 001435224 020__ $$z3030667553 001435224 0247_ $$a10.1007/978-3-030-66756-6$$2doi 001435224 035__ $$aSP(OCoLC)1243547999 001435224 040__ $$aEBLCP$$beng$$erda$$epn$$cEBLCP$$dGW5XE$$dYDX$$dOCLCO$$dEBLCP$$dFIE$$dOCLCF$$dOCLCQ$$dCOM$$dOCLCQ 001435224 049__ $$aISEA 001435224 050_4 $$aHF5548.4.M523$$bQ57 2021 001435224 08204 $$a519.5$$223 001435224 1001_ $$aQuirk, Thomas J. 001435224 24510 $$aExcel 2019 in applied statistics for high school students :$$ba guide to solving practical problems /$$cThomas J. Quirk. 001435224 250__ $$a2nd ed. 001435224 264_1 $$aCham :$$bSpringer,$$c2021. 001435224 300__ $$a1 online resource (255 pages) 001435224 336__ $$atext$$btxt$$2rdacontent 001435224 337__ $$acomputer$$bc$$2rdamedia 001435224 338__ $$aonline resource$$bcr$$2rdacarrier 001435224 4901_ $$aExcel for Statistics Ser. 001435224 504__ $$aIncludes bibliographical references and index. 001435224 5050_ $$aPreface -- 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. 001435224 506__ $$aAccess limited to authorized users. 001435224 520__ $$aThis 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 Excels 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. 001435224 588__ $$aDescription based on print version record. 001435224 63000 $$aMicrosoft Excel (Computer file) 001435224 650_0 $$aMathematical statistics$$xComputer programs. 001435224 655_0 $$aElectronic books. 001435224 77608 $$iPrint version:$$aQuirk, Thomas J.$$tExcel 2019 in Applied Statistics for High School Students.$$dCham : Springer International Publishing AG, ©2021$$z9783030667559 001435224 830_0 $$aExcel for statistics. 001435224 852__ $$bebk 001435224 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-3-030-66756-6$$zOnline Access$$91397441.1 001435224 909CO $$ooai:library.usi.edu:1435224$$pGLOBAL_SET 001435224 980__ $$aBIB 001435224 980__ $$aEBOOK 001435224 982__ $$aEbook 001435224 983__ $$aOnline 001435224 994__ $$a92$$bISE