文档介绍：how to use excel® in analytical chemistry
and in general scientific data analysis
how to use
excel®
in analytical
chemistry
and in general scientific
data analysis
Robert de Levie
Bowdoin College,Brunswick,ME
The Pitt Building, Trumpington Street, Cambridge, United Kingdom
The Edinburgh Building, Cambridge CB2 2RU, UK
40 West 20th Street, New York, NY 10011-4211, USA
477 Williamstown Road, Port Melbourne, VIC 3207, Australia
Ruiz de Alarcón 13, 28014 Madrid, Spain
Dock House, The Waterfront, Cape Town 8001, South Africa
© R. de Levie 2004
First published in printed format 2001
ISBN 0-511-04037-7 eBook (netLibrary)
ISBN 0-521-64282-5 hardback
ISBN 0-521-64484-4 paperback
contents
Preface[xi]
part i introduction to using the spreadsheet
1How to use Excel[1]
Starting Windows [2]
A first look at the spreadsheet [3]
A simple spreadsheet and graph [7]
Making a graph in Excel 97 or a more recent version [9]
Making a graph in Excel 5 or Excel 95 [11]
Addressing a spreadsheet cell [13]
More on graphs [15]
Mathematical operations [21]
Error messages [26]
Naming and annotating cells [27]
Viewing the spreadsheet [28]
Printing [29]
Help! [30]
The case of the changing options [31]
Importing macros and data [32]
Differences between the various versions of Excel [33]
Some often-used mands [35]
Changing the default settings [36]
Summary [37]
part ii statistics and related methods
2Introduction to statistics[39]
Gaussian statistics [39]
Replicate measurements [45]
v
vi Contents
The propagation of imprecision from a single parameter [51]
The propagation of imprecision from multiple parameters [54]
The weighted average [58]
Least-squares fitting to a proportionality [60]
Least-squares fitting to a general