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:  Prof. L.-F. Pau, CBS Review #: CR147509 (2302-0011)
Bookmark and Share
 
Statistical Computing (G.3 ... )
 
 
Excel (H.4.1 ... )
 
 
Physical Sciences And Engineering (J.2 )
 
Would you recommend this review?
yes
no
Other reviews under "Statistical Computing": Date
Computer analysis of sequential medical trials
Duan-Zheng X., Ellis Horwood, Upper Saddle River, NJ, 1990. Type: Book (9780131618527)
Jul 1 1992
APL2 as a specification language for statistics
Thomson N. IBM Systems Journal 30(4): 539-542, 1991. Type: Article
Dec 1 1993
Multivariate statistical simulation
Johnson M., John Wiley & Sons, Inc., New York, NY, 1987. Type: Book (9789780471822905)
Dec 1 1987
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