Excel 2016 for Physical Sciences Statistics: A Guide to Solving Practical Problems PDF
Preview Excel 2016 for Physical Sciences Statistics: A Guide to Solving Practical Problems
Excel for Statistics Thomas J. Quirk Meghan H. Quirk Howard F. Horton Excel 2016 for Physical Sciences 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, M. Quirk, H.F. Horton, Excel 2016 for Physical Sciences Statistics: A Guide to Solving PracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. 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:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. T.J.Quirk,E.Rhiney,Excel2016forMarketingStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk.Excel2016forEducationalandPsychologicalStatistics:AGuidetoSolvingPracticalProblems, ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J. Quirk, Excel 2016 for Social Science Statistics: A Guide to Solving Practical Problems, Excel forStatistics.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.F. Horton, Excel 2013 for Physical Sciences Statistics: A Guide to Solving PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. 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,Excel2013forBiologicalandLifeSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing. T.J.Quirk,Excel2013forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2015. T.J. Quirk, Excel 2013 for Business Statistics: A Guide to Solving Practical Problems, Excel for Statistics.SpringerInternationalPublishingSwitzerland2015. T.J.Quirk.Excel2013forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.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. T.J.Quirk,J.Palmer-Schuyler,Excel2010forHumanResourceManagementStatistics:AGuidetoSolving PracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2014. 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 • Meghan H. Quirk • Howard F. Horton Excel 2016 for Physical Sciences Statistics A Guide to Solving Practical Problems ThomasJ.Quirk MeghanH.Quirk WebsterUniversity Bailey,CO,USA St.Louis,MI,USA HowardF.Horton Bailey,CO,USA ExcelforStatistics ISBN978-3-319-40074-7 ISBN978-3-319-40075-4 (eBook) DOI10.1007/978-3-319-40075-4 LibraryofCongressControlNumber:2016941349 ©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-Wuerttemberg 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 We dedicate this book to all the newly inspired students emerging into the ranks of the various fields of science. Meghan H. Quirk and Howard F. Horton Preface Excel2016forPhysicalSciencesStatistics:AGuidetoSolvingPracticalProblems is intended for anyone looking to learn the basics of applying Excel’s powerful statisticaltoolstotheirsciencecoursesorworkactivities.Ifunderstandingstatistics isn’t your strongest suit, you are not especially mathematically inclined, or if you arewaryofcomputers,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 practicalproblemsinthephysicalsciences. Excel is an easily available computer program for students, instructors, and managers.Itisalsoaneffectiveteachingandlearningtoolforquantitativeanalyses insciencecourses.Thepowerfulnumericalcomputationalabilityandthegraphical functionsavailableinExcelmakelearningstatisticsmucheasierthaninyearspast. However,thisisthefirstbooktoshowExcel’scapabilitiestomoreeffectivelyteach sciencestatistics;italsofocusesexclusivelyonthistopicinanefforttorenderthe subject matter notonly applicable andpractical,but alsoeasy to comprehendand apply. Uniquefeaturesofthisbook: • Thisbookisappropriateforuseinanycourseinthephysicalsciencesstatistics (atbothundergraduateandgraduatelevels)aswellasformanagerswhowantto improvetheusefulnessoftheirExcelskills. • Includes162colorscreenshotssothatyoucanbesureyouareperformingthe Excelstepscorrectly. • Youwillbetoldeachstepoftheway,notonlyhowtouseExcel,butalsowhy youaredoingeachstepsothatyoucanunderstandwhatyouaredoing,andnot merelylearnhowtousestatisticaltestsbyrote. • Includes specific objectives embedded in the text for each concept, so you can knowthepurposeoftheExcelsteps. vii viii Preface • This book is a tool that can be used either by itself or along with any good statisticsbook. • Statisticaltheoryandformulasareexplainedinclearlanguagewithoutbogging youdowninmathematicalfinepoints. • YouwilllearnbothhowtowritestatisticalformulasusingExcelandhowtouse Excel’sdrop-downmenusthatwillcreatetheformulasforyou. • ThisbookdoesnotcomewithaCDofExcelfileswhichyoucanuploadtoyour computer.Instead,you’llbeshownhowtocreateeachExcelfilebyyourself.Ina work situation, your colleagues will not give you an Excel file; you will be expectedtocreateyourown.Thisbookwillgiveyouamplepracticeindeveloping thisimportantskill. • Eachchapterpresentsthestepsneededtosolveapracticalscienceproblemusing Excel.Inaddition,therearethreepracticeproblemsattheendofeachchapter, soyoucantestyournewknowledgeofstatistics.Theanswerstotheseproblems appearinAppendixA. • A“PracticeTest”isgiveninAppendixBtotestyourknowledgeattheendofthe book.TheanswerstothesepracticalscienceproblemsappearinAppendixC. St.Louis,MI ThomasJ.Quirk Bailey,CO MeghanH.Quirk Bailey,CO HowardF.Horton Acknowledgements Excel2016forPhysicalSciencesStatistics:AGuidetoSolvingPracticalProblems istheresultofinspirationfromthreeimportantpeople:mytwodaughtersandmy wife. Jennifer Quirk McLaughlin invited me to visit her M.B.A. classes several times at the University of Witwatersrand in Johannesburg, South Africa. These visitstoafirst-rateM.B.A.programconvincedme therewasaneed forabookto teach students how to solve practical problems using Excel. Meghan Quirk- Horton’s dogged dedication to learning the many statistical techniques needed to completeherPh.D.dissertationillustratedtheneedforastatisticsbookthatwould make this daunting task more user-friendly. And Lynne Buckley-Quirk was the number-one cheerleader for this project from the beginning, always encouraging meandhelpingmetoremaindedicatedtocompletingit. ThomasJ.Quirk Wewouldliketoacknowledgethepatienceofourtwolittlegirls,LilaandElia,as we worked on this book with their TQ. We would also like to thank Professors Sarah Perkins, Doug Warren, John Moore, and Lee Dyer for their guidance and supportduringourcollegeandgraduateschoolcareers. MeghanH.QuirkandHowardF.Horton MarcStrauss,oureditoratSpringer,caughtthespiritofthisideainourfirstphone conversation and shepherded this book through the idea stages until it reached its finalform.Hisencouragementandsupportwerevitaltothisbookseeingthelightof day.AndChristineCriglerdidherusualgreatjobofhelpingthisbookthroughthe editing/productionprocess.Wethankthembothforbeingsuchoutstandingproduct championsthroughoutthisprocess. ThomasJ.Quirk ix
The list of books you might like
