Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical Problems PDF
Preview Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical Problems
Excel 2010 for Educational and Psychological Statistics Thomas Quirk Excel 2010 for Educational and Psychological Statistics A Guide to Solving Practical Problems ThomasQuirk SchoolofBusinessandTechnology WebsterUniversity St.Louis,MO63119,USA [email protected] ISBN978-1-4614-2070-5 e-ISBN978-1-4614-2071-2 DOI10.1007/978-1-4614-2071-2 SpringerNewYorkDordrechtHeidelbergLondon LibraryofCongressControlNumber:2011941800 #SpringerScience+BusinessMedia,LLC2012 Allrightsreserved.Thisworkmaynotbetranslatedorcopiedinwholeorinpartwithoutthewritten permissionof the publisher (SpringerScience+Business Media, LLC, 233 SpringStreet, New York, NY10013,USA),exceptforbriefexcerptsinconnectionwithreviewsorscholarlyanalysis.Usein connectionwithanyformofinformationstorageandretrieval,electronicadaptation,computersoftware, orbysimilarordissimilarmethodologynowknownorhereafterdevelopedisforbidden. Theuseinthispublicationoftradenames,trademarks,servicemarks,andsimilarterms,evenifthey arenotidentifiedassuch,isnottobetakenasanexpressionofopinionastowhetherornottheyare subjecttoproprietaryrights. Printedonacid-freepaper SpringerispartofSpringerScience+BusinessMedia(www.springer.com) This bookis dedicated tothe more than 3,000 students Ihave taughtat Webster University’scampusesinSt.Louis,London, and Vienna; the students atPrincipia College in Elsah, Illinois; andthe students at the Cooperative State University of Baden-Wuerttemburg in Heidenheim, Germany.Thesestudentstaughtmeagreat dealabouttheartofteaching.Isalutethem all, andIthank them for helping me to become abetterteacher. Preface Excel 2010 for Educational and Psychological Statistics: A Guide to Solving PracticalProblemshelpsanyonewhowantstolearnthebasicsofapplyingExcel’s powerfulstatisticaltoolstotheirworksituationortotheirclasses.Ifunderstanding statisticsisnotyourstrongestsuit,youarenotmathematicallyinclined,oryouare waryofcomputers,thenthisisthebookforyou. You will 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 managersineducationandinbusiness.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 educational and psychological statistics. And it focuses exclusively on this topic in order to render the subject matter applicable and practical – and, easy to comprehendandapply. Uniquefeaturesofthisbook: l Includes 163 color screen shots so you can be sure you are performing Excel stepscorrectly. l Youwillbetoldeachstepoftheway,notonlyhowtouseExcel,butalsowhy youaredoingeachstep. l Includes specific objectives embedded in the text for each concept, so you can knowthepurposeoftheExcelsteps. l YouwilllearnbothhowtowritestatisticalformulasusingExcelandhowtouse Excel’sdrop-downmenusthatwillcreatetheformulasforyou. l Statisticaltheoryandformulasareexplainedinclearlanguagewithoutbogging youdowninmathematicalfinepoints. l Practicalexamplesofproblemsaretakenfrombotheducationandpsychology. vii viii Preface l 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 testyournewknowledge.AnswerstotheseproblemsappearinAppendixA. l A“PracticeTest”isgiveninAppendixBtotestyourknowledgeattheendofthe book.AnswerstothistestappearinAppendixC. l ThisbookdoesnotcomewithaCDofExcelfileswhichyoucanuploadtoyour computer.Instead,youwillbeshownhowtocreateeachExcelfileyourself.Ina workorclassroomsituation,yourcolleaguesandprofessorswillnotgiveyouan Excel file. You will be expected to create your own. This book will give you amplepracticeindevelopingthisimportantskill. l This book is a tool that can be used either by itself or along with any good statisticsbook. Thisbookisappropriateforuseinanycourse–graduateofundergraduate–in Educational and Psychological Statistics, as well as for administrators/managers whowanttoimprovetheirExcelskills.Itwillalsobenefitstudentswhoaretaking coursesinSociology,Anthropology,orComputerSciencewhowanttolearnhow touseExceltosolvestatisticsproblems. Theideasinthisbookhavebeenthoroughlytestedbyitsauthor,ProfessorTom Quirk,inbothMarketingStatisticsandMarketingResearchcourses. At the beginning of his academic career, Prof. Quirk spent 6 years in educa- tional research at The American Institutes for Research and Educational Testing Service.HethentaughtSocialPsychology,EducationalPsychology,andGeneral Psychology at Principia College and is currently a Professor of Marketing in the GeorgeHerbert WalkerSchoolofBusiness&TechnologyatWebsterUniversity based in St. Louis, Missouri (USA) where he teaches Marketing Statistics, Marketing Research, and Pricing Strategies. He has published articles in the Journal of Educational Psychology, 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 60+ textbook supplements in Marketing and Management, published 20+ articles in professional journals, and presented 20+ papers at professional meetings, includ- ing annual meetings of The American Educational Research Association, The American Psychological Association, and the National Council on Measurement inEducation.HeholdsaBSinMathematicsfromJohnCarrollUniversity,bothan MAinEducationandaPhDinEducationalPsychologyfromStanfordUniversity, andanMBAfromTheUniversityofMissouri-St.Louis. St.Louis,MO,USA ThomasQuirk Acknowledgments Excel 2010 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 MBA classes several times at the University of Witwatersrand in Johannesburg, South Africa. These visits to a first-rate MBAprogram convinced me there was a need for a book to teach students how to solve practical business problems using Excel. Meghan Quirk-Horton’s dogged dedication to learning the many statistical techniques needed to complete her PhD dissertation illustrated the need for a statisticsbookthatwouldmakethisdauntingtaskmoreuser-friendly.And Lynne Buckley-Quirkwasthenumberonecheerleaderforthisprojectfromthebeginning, alwaysencouragingmeandhelpingmeremaindedicatedtocompletingit. Sue Gold, a reference librarian at Webster University in St. Louis, was a valuable colleague in helping me to do key research, and was a steady supporter ofthisidea.BradWolaverofWebsterUniversityimprovedmyOffice2010skillsin manyways. 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 seeingthelightofday.Ithankhimforbeingsuchanoutstandingproductchampion throughoutthisprocess. ix
The list of books you might like
