Skip to content
Register Sign in Wishlist

Data Analysis for Physical Scientists
Featuring Excel®

2nd Edition

$84.99 (P)

  • Author: Les Kirkup, University of Technology, Sydney
  • Date Published: March 2012
  • availability: In stock
  • format: Hardback
  • isbn: 9780521883726
Average user rating
(1 review)

$ 84.99 (P)

Add to cart Add to wishlist

Other available formats:

Looking for an examination copy?

If you are interested in the title for your course we can consider offering an examination copy. To register your interest please contact providing details of the course you are teaching.

Product filter button
About the Authors
  • The ability to summarise data, compare models and apply computer-based analysis tools are vital skills necessary for studying and working in the physical sciences. This textbook supports undergraduate students as they develop and enhance these skills. Introducing data analysis techniques, this textbook pays particular attention to the internationally recognised guidelines for calculating and expressing measurement uncertainty. This new edition has been revised to incorporate Excel® 2010. It also provides a practical approach to fitting models to data using non-linear least squares, a powerful technique which can be applied to many types of model. Worked examples using actual experimental data help students understand how the calculations apply to real situations. Over 200 in-text exercises and end-of-chapter problems give students the opportunity to use the techniques themselves and gain confidence in applying them. Answers to the exercises and problems are given at the end of the book.

    • Updated to include new features of Excel® 2010, such as Solver, a powerful utility for solving non-linear least squares problems
    • Includes examples drawn from experimental work in the physical sciences so students can see how the techniques are applied to real data
    • Emphasises principles and underlying assumptions rather than focusing on detailed mathematical derivations
    Read more

    Reviews & endorsements

    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® 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® described.' P. T. Greenland, Contemporary Physics

    See more reviews

    Customer reviews

    04th Nov 2013 by 0989129534

    This great book.

    Review was not posted due to profanity


    , create a review

    (If you're not , sign out)

    Please enter the right captcha value
    Please enter a star rating.
    Your review must be a minimum of 12 words.

    How do you rate this item?


    Product details

    • Edition: 2nd Edition
    • Date Published: March 2012
    • format: Hardback
    • isbn: 9780521883726
    • length: 528 pages
    • dimensions: 253 x 180 x 29 mm
    • weight: 1.18kg
    • contains: 149 b/w illus. 214 exercises
    • availability: In stock
  • Table of Contents

    1. Introduction to scientific data analysis
    2. Excel and data analysis
    3. Data distributions I
    4. Data distributions II
    5. Measurement, error and uncertainty
    6. Least squares I
    7. Least squares II
    8. Non-linear least squares
    9. Tests of significance
    10. Data analysis tools in Excel and the Analysis ToolPak
    Answers to exercises and end-of-chapter problems

  • Author

    Les Kirkup, University of Technology, Sydney
    Les Kirkup is Associate Professor in the School of Physics and Advanced Materials, University of Technology, Sydney. A dedicated lecturer, many of his educational developments have focused on enhancing the laboratory experience of undergraduate students. In May 2011, he was awarded an Australian Learning and Teaching Council National Teaching Fellowship.

Sign In

Please sign in to access your account


Not already registered? Create an account now. ×

Sorry, this resource is locked

Please register or sign in to request access. If you are having problems accessing these resources please email

Register Sign in
Please note that this file is password protected. You will be asked to input your password on the next screen.

» Proceed

You are now leaving the Cambridge University Press website. Your eBook purchase and download will be completed by our partner Please see the permission section of the catalogue page for details of the print & copy limits on our eBooks.

Continue ×

Continue ×

Continue ×

Find content that relates to you

Join us online

This site uses cookies to improve your experience. Read more Close

Are you sure you want to delete your account?

This cannot be undone.


Thank you for your feedback which will help us improve our service.

If you requested a response, we will make sure to get back to you shortly.

Please fill in the required fields in your feedback submission.