## Find a copy in the library

Finding libraries that hold this item...

## Details

Material Type: | Internet resource |
---|---|

Document Type: | Book, Internet Resource |

All Authors / Contributors: |
Les Kirkup |

ISBN: | 9780521883726 0521883725 |

OCLC Number: | 714728209 |

Notes: | Revised edition of: Data analysis with Excel. 2002. |

Description: | xv, 510 pages : illustrations ; 26 cm |

Contents: | Introduction to scientific data analysis -- Excel and data analysis -- Data distributions I -- Data distributions II -- Measurement, error and uncertainty -- Least squares I -- Least squares II -- Non-linear least squares -- Tests of significance -- Data analysis tools in Excel and the Analysis ToolPak; Appendixes : 1. Statistical tables -- 2. Propagation of uncertainties -- 3. Least squares and the principle of maximum likelihood -- 4. Standard uncertainties in mean, intercept and slope -- 5. Introduction to matrices for least squares analysis -- 6. Useful formulae. |

Responsibility: | Les Kirkup. |

More information: |

### Abstract:

## Reviews

*Editorial reviews*

Publisher Synopsis

Reviews of the first edition: 'This book is extremely well structured. It both describes the main functionality of Excel with special emphasis on scientific data analysis, as well as the statistical background to the methods ... definitely one of the best on the market in this important area ... the author should be congratulated on doing a wonderful job.' Richard Brereton, Chemistry Industry 'Overall, I found the book excellent.' S. Middleton, The Physicist Review of previous edition: '... a simple and straightforward introduction to the use of spreadsheet calculations and data display ... The coverage of this book will be more than adequate for undergraduate courses and will be sufficient for many postgraduate and research readers ... a good introduction to Excel (R) for data analysis for the first time user and covers the data analysis methods that most physical scientists will need.' B. W. James, Contemporary Physics 'The fundamental observation of experimental science is that repeated measurements of the same quantity by the same person using the same equipment do not repeatedly give the same value. ... Thus, statistical analysis of experimental data is a large part of experimental physics ... [This book] deals with all these problems at a level appropriate to an undergraduate course on data analysis. ... introduces useful ideas and many examples on data visualisation, with examples chosen from many fields of science ... data distributions, and their results are then exploited in a very extensive discussion of experimental errors. ... and provides useful information on how to combine random and calibration errors ... The rest of the book applies these statistical methods to the bread and butter of experimental data analysis - linear and non-linear least squares curve fitting, and hypothesis testing. The theoretical basis is given, and its numerical implementation through Excel (R) described.' P. T. Greenland, Contemporary Physics Read more...

*User-contributed reviews*