Spreadsheets provide one of the most easily learned routes to scientific computing. This book uses Excel®, the most powerful spreadsheet available, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of college textbooks in analytical chemistry: statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. The text contains many examples of data analysis, and uses spreadsheets for numerical simulations and testing analytical procedures. It treats modern data analysis methods such as linear and nonlinear least squares in great detail, as well as methods based on Fourier transformation. It shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet. It describes in detail how to simulate chemical kinetics on a spreadsheet. It also introduces the reader to the use of VBA, the macro language of Microsoft Office, which lets the user import higher-level computer programs into the spreadsheet.
FREE Two-Day Shipping for students on millions of items. Learn more |
| |||||||||||||||
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Editorial Reviews
Review
"...smoothly written, excellent tutorial about how such spreadsheets are created...very good book. No analytical chemistry teacher, no serious analytical chemistry student, should fail to acquire this book." The Chemical Educator
Book Description
Spreadsheets provide one of the most easily learned routes to scientific computing because of their intuitive layout, extensive mathematical capabilities, and convenient graphics. This book uses Excel, the most powerful of the presently available spreadsheets, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of textbooks in analytical chemistry: statistics, chemical equilibria, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. Additional chapters discuss Fourier transformation, simulating chemical kinetics, and using macros to make spreadsheets even more powerful and user-friendly.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
7 of 8 people found the following review helpful:
5.0 out of 5 stars
How to use Excel in Analytical Chemistry by Robert de Levie,
By
This review is from: How to Use Excel® in Analytical Chemistry: And in General Scientific Data Analysis (Paperback)
Excellent book setting out applications in Chemistry using Excel. Well chosen examples embracing spectroscopy, chromatography, electrochemistry, kinetics and acid-base theory illustrate the ease of minipulation of data via Excel. The section on Fourier Transform I really liked, and this is followed by a good coverage of noise filtering and deconvolution.
9 of 22 people found the following review helpful:
3.0 out of 5 stars
Didactic and academic,
By A Customer
This review is from: How to Use Excel® in Analytical Chemistry: And in General Scientific Data Analysis (Paperback)
This is a book which wold like to be a text book and not a popular one. No CD or disk with the exampels is provide. Only the macros could be downloaded from the web. This book contain many exampels. Most of the exampels are in the sort of instructions i.e. 1. open a new spreadsheet 2. enter the label.. 3.In row 11, starting with cell A11 enter the labels pH, [H+].... 15.anchor the graph on cell b1,... etc. The point is that there are much words in this book and less figures which show the Exell worksheet after each/everal instruction. That make this book to be less fraindly then other books on Ecell.
0 of 6 people found the following review helpful:
4.0 out of 5 stars
nice,
By
This review is from: How to Use Excel® in Analytical Chemistry: And in General Scientific Data Analysis (Paperback)
I'd give it 5 stars, but I've only used about 3 pages thus far.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
Key Phrases - Statistically Improbable Phrases (SIPs):
(learn more)
menu editor, chart type, call fourier, convoluting integers, corresponding logarithmic concentration diagram, moving polynomial, strong monoprotic base, deposit labels, copy this instruction, experimental imprecision, second equivalence point, linear sweep voltammogram, equidistant data, total analytical concentration, triprotic acid, spreadsheet exercise, monoprotic acid, proton balance, buffer strength, initial guess values, common handle, polyprotic acids, regression routine, titration vessel, diprotic acid Key Phrases - Capitalized Phrases (CAPs): (learn more)
Select Selection, Data Analysis, End Sub, Numerical Recipes, Goal Seek, End If Next, Format Data Series, Random Number Generation, Output Range, Format Axis, Select Dim, Select Tools, Call Multiply, Cambridge University Press, Times New Roman, X-values Dim, True Selection, Solver Parameters, Paste Special, Microsoft Excel, The X-range, Academic Press, Visual Basic Editor, Chart Wizard, End End If Check Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
menu editor, chart type, call fourier, convoluting integers, corresponding logarithmic concentration diagram, moving polynomial, strong monoprotic base, deposit labels, copy this instruction, experimental imprecision, second equivalence point, linear sweep voltammogram, equidistant data, total analytical concentration, triprotic acid, spreadsheet exercise, monoprotic acid, proton balance, buffer strength, initial guess values, common handle, polyprotic acids, regression routine, titration vessel, diprotic acid Key Phrases - Capitalized Phrases (CAPs): (learn more)
Select Selection, Data Analysis, End Sub, Numerical Recipes, Goal Seek, End If Next, Format Data Series, Random Number Generation, Output Range, Format Axis, Select Dim, Select Tools, Call Multiply, Cambridge University Press, Times New Roman, X-values Dim, True Selection, Solver Parameters, Paste Special, Microsoft Excel, The X-range, Academic Press, Visual Basic Editor, Chart Wizard, End End If Check Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Citations (learn more)
5
books
cite this book:
- Practical Guide To Chemometrics, Second Edition by Paul Gemperline on page 260
- Practical Inductively Coupled Plasma Spectroscopy (Analytical Techniques in the Sciences (AnTs) *) by John R. Dean on page 161
- Methods for Environmental Trace Analysis (Analytical Techniques in the Sciences (AnTs) *) by John R. Dean on page 225
- Methods for Environmental Trace Analysis (Analytical Techniques in the Sciences (AnTs) *) by John R. Dean on page 225
- Mathematics for Physical Chemistry, Third Edition by Robert G. Mortimer on page 361
What Other Items Do Customers Buy After Viewing This Item?
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product).
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
