Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems PDF
Preview Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems
Excel for Statistics Thomas J. Quirk Excel 2016 for Educational and Psychological Statistics A Guide to Solving Practical Problems Excel for Statistics ExcelforStatisticsisaseriesoftextbooksthatexplainhowtouseExceltosolve statisticsproblemsinvariousfieldsofstudy.Professors,students,andpractitioners will findthesebooksteachhow tomakeExcel work best intheir respective field. Applications include any discipline that uses data and can benefit from the power andsimplicityofExcel.Bookscoverallthestepsforrunningstatisticalanalysesin Excel 2016, Excel 2013, Excel 2010 and Excel 2007. The approach also teaches critical statistics skills, making the books particularly applicable for statistics coursestaughtoutsideofmathematicsorstatisticsdepartments. Serieseditor:ThomasJ.Quirk Thefollowingbooksareinthisseries: T.J.Quirk,Excel2016forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excel forStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,Excel2016forBusinessStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2016forBiologicalandLifeSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2016forPhysicalSciencesStatistics:AGuidetoSolving PracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. T.J.Quirk,E.Rhiney,Excel2016forMarketingStatistics:AGuidetoSolvingPracticalProblems, ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk.Excel2016forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,Excel2016forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,S.Cummings,Excel2016forHealthServicesManagementStatistics:AGuidetoSolving PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,J.Palmer-Schuyler,Excel2016forHumanResourceManagementStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,M.Quirk,H.F.Horton.Excel2016forEnvironmentalSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,J.Palmer-Schuyler,Excel2013forHumanResourceManagementStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,S.Cummings,Excel2013forHealthServicesManagementStatistics:AGuidetoSolving PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forPhysicalSciencesStatistics:AGuidetoSolving PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk.Excel2013forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015. T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forBiologicalandLifeSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2015. T.J.Quirk,Excel2013forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excel forStatistics.SpringerInternationalPublishingSwitzerland2015. T.J.Quirk,Excel2013forBusinessStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2015. T.J.Quirk.Excel2013forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excel forStatistics.SpringerInternationalPublishingSwitzerland2015. AdditionalStatisticsbooksbyDr.TomQuirkthathavebeenpublishedbySpringer T.J.Quirk,Excel2010forEngineeringStatistics:AGuidetoSolvingPracticalProblems.Springer InternationalPublishingSwitzerland2014. T.J. Quirk, S. Cummings, Excel 2010 for Health Services Management Statistics: A Guide to SolvingPracticalProblems.SpringerInternationalPublishingSwitzerland2014. T.J.Quirk,M.Quirk,H.Horton,Excel2010forPhysicalSciencesStatistics:AGuidetoSolving PracticalProblems.SpringerInternationalPublishingSwitzerland2013. T.J.Quirk,M.Quirk,H.F.Horton,Excel2010forBiologicalandLifeSciencesStatistics:AGuide toSolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013. T.J.Quirk,M.Quirk,H.F.Horton,Excel2007forBiologicalandLifeSciencesStatistics:AGuide toSolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013. T.J. Quirk, Excel 2010 for Social Science Statistics: A Guide to Solving Practical Problems. SpringerScience+BusinessMediaNewYork2012. T.J.Quirk,Excel2010forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems.SpringerScience+BusinessMediaNewYork2012. T.J.Quirk,Excel2007forBusinessStatistics:AGuidetoSolvingPracticalProblems.Springer Science+BusinessMediaNewYork2012. T.J. Quirk, Excel 2007 for Social Science Statistics: A Guide to Solving Practical Problems. SpringerScience+BusinessMediaNewYork2012. T.J.Quirk,Excel2007forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems.SpringerScience+BusinessMediaNewYork2012. T.J.Quirk,Excel2010forBusinessStatistics:AGuidetoSolvingPracticalProblems.Springer Science+BusinessMedia2011. Moreinformationaboutthisseriesathttp://www.springer.com/series/13491 Thomas J. Quirk Excel 2016 for Educational and Psychological Statistics A Guide to Solving Practical Problems ThomasJ.Quirk WebsterUniversity St.Louis,MO,USA ExcelforStatistics ISBN978-3-319-39719-1 ISBN978-3-319-39720-7 (eBook) DOI10.1007/978-3-319-39720-7 LibraryofCongressControlNumber:2016941688 ©SpringerInternationalPublishingSwitzerland2016 Thisworkissubjecttocopyright.AllrightsarereservedbythePublisher,whetherthewholeorpartof the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilarmethodologynowknownorhereafterdeveloped. The use of general descriptive names, registered names, trademarks, service marks, etc. in this publicationdoesnotimply,evenintheabsenceofaspecificstatement,thatsuchnamesareexempt fromtherelevantprotectivelawsandregulationsandthereforefreeforgeneraluse. Thepublisher,theauthorsandtheeditorsaresafetoassumethattheadviceandinformationinthis book are believed to be true and accurate at the date of publication. Neither the publisher nor the authors or the editors give a warranty, express or implied, with respect to the material contained hereinorforanyerrorsoromissionsthatmayhavebeenmade. Printedonacid-freepaper ThisSpringerimprintispublishedbySpringerNature TheregisteredcompanyisSpringerInternationalPublishingAGSwitzerland Thisbookisdedicatedtothemorethan3,000 studentsIhavetaughtatWebsterUniversity’s campuses in St. Louis, London, and Vienna; the students at Principia College in Elsah, Illinois; and the students at the Cooperative State University of Baden-Wuerttemburg in Heidenheim, Germany. These students taught me a great deal about the art of teaching. Isalutethemall,andIthankthemforhelping me to become a better teacher. Preface Excel 2016 for Educational and Psychological Statistics: A Guide to Solving PracticalProblemshelpsanyonewhowantstolearnthebasicsofapplyingExcel’s powerfulstatisticaltoolstotheirworksituationortotheirclasses.Ifunderstanding statisticsisn’tyourstrongestsuit,youare notmathematically inclined, oryou are waryofcomputers,thenthisisthebookforyou. You’ll learn how to perform key statistical tests in Excel without being overwhelmed by statistical theory. This book clearly and logically shows how to runstatisticalteststosolvepracticalproblemsineducationandpsychology. Excel is a widely available computer program for students, instructors, and managersineducationandpsychology.Itisalsoaneffectiveteachingandlearning tool for quantitative analyses in statistics courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, this is the first book to showcase Excel’s usefulness in teaching educationalandpsychologicalstatistics.Anditfocusesexclusivelyonthistopicin order to render the subject matter applicable and practical—and easy to compre- hendandapply. Uniquefeaturesofthisbook: • Includes 166 color screenshots so you can be sure you are performing Excel stepscorrectly. • Youwillbetoldeachstepoftheway,notonlyhowtouseExcelbutalsowhyyou aredoingeachstep. • Includes specific objectives embedded in the text for each concept, so you can knowthepurposeoftheExcelsteps. • YouwilllearnbothhowtowritestatisticalformulasusingExcelandhowtouse Excel’sdrop-downmenusthatwillcreatetheformulasforyou. • Statisticaltheoryandformulasareexplainedinclearlanguagewithoutbogging youdowninmathematicalfinepoints. • Practicalexamplesofproblemsaretakenfrombotheducationandpsychology. vii viii Preface • Each chapter presents key steps to solve practical problems using Excel. In addition, three practice problems at the end of each chapter enable you to test yournewknowledge.AnswerstotheseproblemsappearinAppendixA. • A“PracticeTest”isgiveninAppendixBtotestyourknowledgeattheendofthe book.AnswerstothistestappearinAppendixC. • ThisbookdoesnotcomewithaCDofExcelfileswhichyoucanuploadtoyour computer.Instead,you’llbeshownhowtocreateeachExcelfileyourself.Ina workorclassroomsituation,yourcolleaguesandprofessorswillnotgiveyouan Excel file. You will be expected to create your own. This book will give you amplepracticeindevelopingthisimportantskill. • This book is a tool that can be used either by itself or along with any good statisticsbook. Thisbookisappropriateforuseinanycourse—graduateofundergraduate—in educationalorpsychologicalstatistics,aswellasforadministrators/managerswho want to improve their Excel skills. It will also benefit students who are taking coursesinsociology,anthropology,orcomputersciencewhowanttolearnhowto useExceltosolvestatisticsproblems. Theideasinthisbookhavebeenthoroughlytestedbyitsauthor,ProfessorTom Quirk,inbothmarketingstatisticsandmarketingresearchcourses. Atthebeginningofhisacademiccareer,Prof.Quirkspent6yearsineducational researchattheAmericanInstitutesforResearchandEducationalTestingService. Hethentaughtsocialpsychology,educationalpsychology,andgeneralpsychology atPrincipiaCollegeandiscurrentlyaprofessorofmarketingintheGeorgeHerbert WalkerSchoolofBusiness&TechnologyatWebsterUniversitybasedinSt.Louis, Missouri (USA), where he teaches marketing statistics, marketing research, and pricingstrategies.HehaspublishedarticlesintheJournalofEducationalPsychol- ogy, The Journal of Educational Research, Review of Educational Research, Journal of Educational Measurement, Educational Technology, The Elementary School Journal, Journal of Secondary Education, Educational Horizons, and Phi Delta Kappan. In addition, he has written more than 60 textbook supplements in marketing and management, published more than 20 articles in professional journals, and presented more than 20 papers at professional meetings, including annualmeetingsoftheAmericanEducationalResearchAssociation,theAmerican Psychological Association, and the National Council on Measurement in Educa- tion.HeholdsaB.S.inmathematicsfromJohnCarrollUniversity,bothanM.A.in educationandaPh.D.ineducationalpsychologyfromStanfordUniversity,andan M.B.A.fromtheUniversityofMissouri–St.Louis. St.Louis,MO ThomasJ.Quirk Acknowledgments Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems is the result of inspiration from three important people: my two daughters and my wife. Jennifer Quirk McLaughlin invited me to visit her M.B.A.classes severaltimesattheUniversityofWitwatersrand inJohannesburg, SouthAfrica.Thesevisitstoafirst-rateM.B.A.programconvincedmetherewasa need for a book to teach students how to solve practical problems using Excel. Meghan Quirk-Horton’s dogged dedication to learning the many statistical tech- niquesneededtocompleteherPh.D.dissertationillustratedtheneedforastatistics bookthatwouldmakethisdauntingtaskmoreuser-friendly.AndLynneBuckley- Quirkwasthenumberonecheerleaderforthisprojectfromthebeginning,always encouragingmeandhelpingmeremaindedicatedtocompletingit. Marc Strauss, my editor at Springer, caught the spirit of this idea in our first phone conversation and shepherded this book through the idea stages until it reached its final form. His encouragement and support were vital to this book seeing the light of day. And Christine Crigler at Springer did her usual first-rate jobincoordinatingtheeditingandproductionofthisbook;sheisalwaysapleasure to work with. I thank them both for being such outstanding product champions throughoutthisprocess. ix
The list of books you might like
