Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Excel 2019 for physical sciences statistics : a guide to solving practical problems (2nd ed.)
Quirk T., Quirk M., Horton H., Springer International Publishing, Cham, Switzerland, 2021. 264 pp. Type: Book (978-3-030632-37-3)
Date Reviewed: Oct 31 2022

This self-teaching volume belongs to a long series of similar volumes by Thomas Quirk (the main author) about the basic uses of Microsoft Excel spreadsheet software for simple statistics. This second edition covers the 2019 version of Excel, while the prior edition dealt with the 2016 version. The main features of these volumes are their simple explanations and examples of various statistics functions provided by the spreadsheet tool, supplemented by screen shots guiding readers to their own realizations of the calculations. Explanations are also provided to help format the layouts and print the numerical results. No attention is paid to graphing or plotting the data or results.

Successive chapters deal with elementary notions in statistics and the corresponding Excel calculations: sample size, mean, standard deviation, standard error, random number generation, confidence interval around the mean, hypothesis testing, one-group t-test for the mean and two-group t-test for the difference of the means, correlation, simple linear regression, multiple regression and correlation, and one-way analysis of the variance. Exercises are provided at the end of each chapter, and the volume ends with solutions, some numerical tables, and an index.

A stated in its title, the volume aims at solving “practical problems” as encountered in a wide diversity of domains by professionals or undergraduate students, for whom it is recommended. In a future update or extension, it would be wise to supplement numerical outputs with how-to-plot or graph explanations, as media and business increasingly so require. Also, emphasis should be put on multidimensional data analysis for categorical data, such as discriminant analysis, as nowadays much information is labeled and not only numerical.

Reviewer:  L.-F. Pau Review #: CR147509
Bookmark and Share
Would you recommend this review?
yes
no
Other reviews under "Statistical Computing": Date
Fuzzy least squares
Diamond P. Information Sciences 46(3): 141-157, 1988. Type: Article
May 1 1989
Outlier analysis
Aggarwal C., Springer Publishing Company, Incorporated, New York, NY, 2013.  461, Type: Book (978-1-461463-95-5)
Aug 6 2014
Numerical methods of statistics
Monahan J., Cambridge University Press, New York, NY, 2001.  442, Type: Book (9780521791687)
Jul 1 2001
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 2004 Reviews.com™
Terms of Use
| Privacy Policy