Excel 2016 for Social Science Statistics: A Guide to Solving Practical Problems

271 Pages·2016·12.5 MB·English

by  Thomas J. Quirk (auth.)

Excel for Statistics
Thomas J. Quirk
Excel 2016 for
Social Science
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, Excel 2016 for Business Statistics: A Guide to Solving Practical Problems, Excel for
Statistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,Excel2016forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2016forBiologicalandLifeSciencesStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,E.Rhiney,Excel2016forMarketingStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk.Excel2016forEducationalandPsychologicalStatistics:AGuidetoSolvingPracticalProblems,
ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,Excel2016forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,M.Quirk,H.Horton,Excel2016forPhysicalSciencesStatistics:AGuidetoSolvingPractical
Problems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk, S.Cummings, Excel 2016for HealthServicesManagement Statistics: AGuide toSolving
PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,J.Palmer-Schuyler,Excel2016forHumanResourceManagementStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,M.Quirk,H.F.Horton.Excel2016forEnvironmentalSciencesStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,J.Palmer-Schuyler,Excel2013forHumanResourceManagementStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk, S.Cummings, Excel 2013for HealthServicesManagement Statistics: AGuide toSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J. Quirk, M. Quirk, H. Horton, Excel 2013 for Physical Sciences Statistics: A Guide to Solving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J.Quirk,J.Palmer-Schuyler,Excel2010forHumanResourceManagementStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2014.
T.J. Quirk, Excel 2013 for Business Statistics: A Guide to Solving Practical Problems, Excel for
Statistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forBiologicalandLifeSciencesStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,Excel2013forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,Excel2013forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2015.
T.J. Quirk, Excel 2013 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forEnvironmentalSciencesStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2010forEnvironmentalSciencesStatistics:AGuidetoSolving
PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015.
AdditionalStatisticsbooksbyDr.TomQuirkthathavebeenpublishedbySpringer
T.J. Quirk, Excel 2010 for Engineering Statistics: A Guide to Solving Practical Problems. Springer
InternationalPublishingSwitzerland2014.
T.J.Quirk,S.Cummings,Excel2010forHealthServicesManagementStatistics:AGuidetoSolving
PracticalProblems.SpringerInternationalPublishingSwitzerland2014.
T.J. Quirk, M. Quirk, H. Horton, Excel 2010 for Physical Sciences Statistics: A Guide to Solving
PracticalProblems.SpringerInternationalPublishingSwitzerland2013.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2010forBiologicalandLifeSciencesStatistics:AGuideto
SolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2007forBiologicalandLifeSciencesStatistics:AGuideto
SolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013.
T.J.Quirk,Excel2010forSocialScienceStatistics:AGuidetoSolvingPracticalProblems.Springer
Science+BusinessMediaNewYork2012.
T.J. Quirk, Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems.SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2007forBusinessStatistics:AGuidetoSolvingPracticalProblems.SpringerScience
+BusinessMediaNewYork2012.
T.J.Quirk,Excel2007forSocialScienceStatistics:AGuidetoSolvingPracticalProblems.Springer
Science+BusinessMediaNewYork2012.
T.J. Quirk, Excel 2007 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems.SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2010forBusinessStatistics:AGuidetoSolvingPracticalProblems.SpringerScience
+BusinessMedia2011.
Moreinformationaboutthisseriesathttp://www.springer.com/series/13491
Thomas J. Quirk
Excel 2016 for Social
Science Statistics
A Guide to Solving Practical Problems
ThomasJ.Quirk
WebsterUniversity
St.Louis,MO,USA
ExcelforStatistics
ISBN978-3-319-39710-8 ISBN978-3-319-39711-5 (eBook)
DOI10.1007/978-3-319-39711-5
LibraryofCongressControlNumber:2016941691
©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.
Thomas J. Quirk

Preface
Excel2016forSocialScienceStatistics:AGuidetoSolvingPracticalProblemsis
intended for anyone looking to learn the basics of applying Excel’s powerful
statistical tools to their social science courses or work activities. If understanding
statisticsisn’tyourstrongestsuit,youarenotespeciallymathematicallyinclined,or
ifyouarewaryofcomputers,thenthisistherightbookforyou.
Here you’ll learn how to use key statistical tests using Excel without being
overpowered by the underlying statistical theory. This book clearly and methodi-
cally shows and explains how to create and use these statistical tests to solve
practicalproblemsinthesocialsciences.
Excel is an easily available computer program for students, instructors, and
managers.Itisalsoaneffectiveteachingandlearningtoolforquantitativeanalyses
in social science courses. The powerful numerical computational ability and the
graphicalfunctionsavailableinExcelmakelearningstatisticsmucheasierthanin
years past. However, this is the first book to show Excel’s capabilities to more
effectivelyteachsocialsciencestatistics;italsofocusesexclusivelyonthistopicin
anefforttorenderthesubjectmatternotonlyapplicableandpractical,butalsoeasy
tocomprehendandapply.
Uniquefeaturesofthisbook:
• Youwillbetoldeachstepoftheway,notonlyhowtouseExcel,butalsowhy
youaredoingeachstepsothatyoucanunderstandwhatyouaredoingandnot
merelylearnhowtousestatisticaltestsbyrote.
• Includes specific objectives embedded in the text for each concept, so you can
knowthepurposeoftheExcelsteps.
• Includes 167 color screenshots so that you can be sure you are performing the
Excelstepscorrectly.
• This book is a tool that can be used either by itself or along with any good
statisticsbook.
• Practical examples and problems are taken from the social sciences, including
politicalscience,sociology,anthropology,education,andpsychology.
vii
viii Preface
• Statisticaltheoryandformulasareexplainedinclearlanguagewithoutbogging
youdowninmathematicalfinepoints.
• YouwilllearnbothhowtowritestatisticalformulasusingExcelandhowtouse
Excel’sdrop-downmenusthatwillcreatetheformulasforyou.
• ThisbookdoesnotcomewithaCDofExcelfileswhichyoucanuploadtoyour
computer.Instead,you’llbeshownhowtocreateeachExcelfileyourself.Ina
work situation, your colleagues will not give you an Excel file; you will be
expected to create your own. This book will give you ample practice in devel-
opingthisimportantskill.
• Each chapter presents the steps needed to solve a practical social science
problem using Excel. In addition, there are three practice problems at the end
ofeachchaptersoyoucantestyournewknowledgeofstatistics.Theanswersto
theseproblemsappearinAppendixA.
• A“PracticeTest”isgiveninAppendixBtotestyourknowledgeattheendofthe
book. The answers to these practical social science problems appear in
AppendixC.
This book is appropriate for use in any course in Social Science Statistics
(at both undergraduate and graduate levels) as well as for managers who want to
improvetheusefulnessoftheirExcelskills.
Thisbookhasasingleauthor,Dr.TomQuirk,acurrentProfessorofMarketing
at the George Herbert Walker School of Business and Technology at Webster
University in St. Louis, Missouri (USA), where he teaches Marketing Statistics,
Marketing Research, and Pricing Strategies. The ideas in this book have been
thoroughly tested in Professor Quirk’s Marketing Statistics and Marketing
Research courses. At the beginning of his academic career, Prof. Quirk spent
6yearsineducationalresearchattheAmericanInstitutesforResearchandEduca-
tionalTestingService.HethentaughtSocialPsychology,EducationalPsychology,
and General Psychology at Principia College in Elsah, Illinois (USA). He has
published articles in the Journal of Educational Psychology, Journal of Educa-
tional Research, Review of Educational Research, Journal of Educational Mea-
surement, Educational Technology, The Elementary School Journal, Journal of
Secondary Education, Educational Horizons, and Phi Delta Kappan. In addition,
Professor Quirk has written more than 60 textbook supplements in Management
and Marketing, published more than 20 articles in professional journals, and
presentedmorethan20papersatprofessionalmeetings,includingannualmeetings
of the American Educational Research Association, the American Psychological
Association, and the National Council on Measurement in Education. He holds a
B.S.inMathematicsfromJohnCarrollUniversity,bothanM.A.inEducationanda
Ph.D.inEducationalPsychologyfromStanfordUniversity,andanM.B.A.fromthe
UniversityofMissouri-St.Louis.
St.Louis,MO ThomasJ.Quirk
Acknowledgments
Excel2016forSocialScienceStatistics:AGuidetoSolvingPracticalProblemsis
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 several
timesattheUniversityoftheWitwatersrandinJohannesburg,SouthAfrica.These
visitstoafirst-rateM.B.A.programconvincedme therewasaneed forabookto
teachstudentshowtosolvepracticalsocialscienceproblemsusingExcel.Meghan
Quirk-Horton’s dogged dedication to learning the many statistical techniques
neededtocompleteher Ph.D.dissertationillustratedtheneed forastatisticsbook
thatwouldmakethisdauntingtaskmoreuser-friendly.AndLynneBuckley-Quirk
was the number one cheerleader for this project from the beginning, 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
seeingthelightofday.Ithankhimforbeingsuchanoutstandingproductchampion
throughout this process. And Christine Crigler at Springer did her usual first-rate
jobincoordinatingtheeditingandproductionofthisbook;sheisalwaysapleasure
toworkwith.
ix