Data Analysis with Excel: An Introduction for Physical Scientists

Data Analysis with Excel: An Introduction for Physical Scientists

by Les Kirkup
     
 

ISBN-10: 0521793378

ISBN-13: 9780521793377

Pub. Date: 01/28/2002

Publisher: Cambridge University Press

Data analysis is of central importance in the education of scientists. This book offers a compact and readable introduction to techniques relevant to physical science students. The material is thoroughly integrated with the popular and powerful spreadsheet package Excel by Microsoft. Excel features of most relevance to the analysis of experimental data in the physical…  See more details below

Overview

Data analysis is of central importance in the education of scientists. This book offers a compact and readable introduction to techniques relevant to physical science students. The material is thoroughly integrated with the popular and powerful spreadsheet package Excel by Microsoft. Excel features of most relevance to the analysis of experimental data in the physical sciences are dealt with in some detail. Fully worked problems reinforce basic principles. Underlying assumptions and range of applicability of techniques are discussed, though detailed derivations of basic equations are mostly avoided or confined to the appendices.

Product Details

ISBN-13:
9780521793377
Publisher:
Cambridge University Press
Publication date:
01/28/2002
Pages:
464
Product dimensions:
6.85(w) x 9.72(h) x 1.10(d)

Table of Contents

Preface
1Introduction to scientific data analysis1
2Excel and data analysis39
3Data distributions I85
4Data distributions II138
5Measurement, error and uncertainty161
6Least squares I213
7Least squares II280
8Tests of significance315
9Data Analysis tools in Excel and the Analysis ToolPak364
App. 1: Statistical tables381
App. 2Propagation of uncertainties390
App. 3Least squares and the principle of maximum likelihood392
App. 4Standard errors in mean, intercept and slope398
App. 5Introduction to matrices for least squares analysis403
App. 6Useful formulae409
Answers to exercises and problems413
References438
Index441

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >