Cambridge - How to Use Excel in Analytical Chemistry and in.pdf - Excel VB - nien0r

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

http://www.cambridge.org

R. de Levie 2004

First published in printed format

2001

ISBN 0-521-64282-5 hardback

ISBN 0-521-64484-4 paperback

(netLibrary)

ISBN 0-511-04037-7 eBook

contents

Preface [xi]

part i introduction to using the spreadsheet

1How to use Excel [ 1]

1.1 Starting Windows [ 2 ]

1.2 A ﬁrst look at the spreadsheet [ 3]

1.3 A simple spreadsheet and graph [ 7 ]

1.3a Making a graph in Excel 97 or a more recent version [ 9]

1.3b Making a graph in Excel 5 or Excel 95 [ 11 ]

1.4 Addressing a spreadsheet cell [ 13]

1.5 More on graphs [ 15]

1.6 Mathematical operations [ 21]

1.7 Error messages [ 26 ]

1.8 Naming and annotating cells [ 27]

1.9 Viewing the spreadsheet [ 28 ]

1.10 Printing [ 29 ]

1.11 Help! [ 30 ]

1.12 The case of the changing options [ 31]

1.13 Importing macros and data [ 32 ]

1.14 Di

part ii statistics and related methods

2Introduction to statistics [ 39 ]

2.1 Gaussian statistics [ 39 ]

2.2 Replicate measurements [ 45 ]

erences between the various versions of Excel [ 33 ]

1.15 Some often-used spreadsheet commands [ 35]

1.16 Changing the default settings [ 36]

1.17 Summary [ 37 ]

ﬀ

Cambridge - How to Use Excel in Analytical Chemistry and in.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: