Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Excel 2013 for physical sciences statistics : a guide to solving practical problems
Quirk T., Quirk M., Horton H., Springer International Publishing, New York, NY, 2016. 242 pp. Type: Book (978-3-319289-63-2)
Date Reviewed: Aug 3 2016

Excel 2013 for physical sciences statistics is an interesting and valuable little book. It shows how to use Microsoft Excel functions and add-ins to accomplish basic statistical tasks such as finding the mean, standard deviation, random numbers, confidence interval about the mean, one- and two-group t-tests, correlation and linear regression (both simple and multiple), and a two-way analysis of variance (ANOVA). The book explains what these tasks are used for and how to do them step-by-step using Excel. It also has the reader perform the calculations in Excel as the author demonstrates. The book has lots of illustrations and screen shots to show what the screens should look like as you do the problems and provides additional exercises at the end of each chapter to practice the solution methods. For more complicated statistical methods and definitions, the text gives references where the information can be found.

Because Excel is not a statistical package like SPSS or others, it obviously cannot be expected to perform the same calculations as such packages, but it can perform simple calculations, and Excel or comparable spreadsheet packages are available in most offices. This book would best be described as a handbook for simple statistical calculations, a handy source for reviewing statistical concepts and how to calculate them, and a primer to use before going into a more rigorous statistics course. It would also be valuable to a manager who has not done any statistical work in some time and needs a review before dealing with subordinates who are using statistics to justify their work or recommend decisions. Although the title says it is for physical sciences, it is equally applicable to other areas where statistics are used. (Note: Although the book lists Excel 2013 as the application, I ran most of the exercises on Excel 2016 without any difficulty. See comparable texts [1,2].)

Reviewer:  Michael Moorman Review #: CR144656 (1610-0734)
1) Dretzke, B. Statistics with Microsoft Excel (5th ed.). Pearson, Upper Saddle River, NJ, 2013.
2) Schmuller, J. Statistical analysis with Excel for dummies (3rd ed.). John Wiley & Sons, Hoboken, NJ, 2013.
Bookmark and Share
  Reviewer Selected
Featured Reviewer
 
 
Excel (H.4.1 ... )
 
 
Reference (A.2 )
 
Would you recommend this review?
yes
no
Other reviews under "Excel": Date
Advanced Excel
Ashley R., Fernandez J. (ed), John Wiley & Sons, Inc., New York, NY, 1989. Type: Book (9789780471615767)
Nov 1 1989
Excel macros for the IBM
Annaloro J., Scott, Foresman & Co., Glenview, IL, 1989. Type: Book (9789780673384539)
Apr 1 1990
Excel for the IBM PC: version 2.1
Hoffman P., Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1990. Type: Book (9780201523485)
May 1 1991
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy