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
 Would you recommend this review? yes no
 Other reviews under "Statistical Computing": Date Fuzzy least squaresDiamond P. Information Sciences 46(3): 141-157, 1988. Type: Article May 1 1989 Outlier analysisAggarwal C., Springer Publishing Company, Incorporated, New York, NY, 2013.  461, Type: Book (978-1-461463-95-5) Aug 6 2014 Numerical methods of statisticsMonahan J., Cambridge University Press, New York, NY, 2001.  442, Type: Book (9780521791687) Jul 1 2001 more...

E-Mail This Printer-Friendly
Reproduction in whole or in part without permission is prohibited.   Copyright 2004 Reviews.com™