This supplement can be used in any analytical chemistry course. The exercises teaches you how to use Microsoft Excel using applications from statistics, data analysis equilibrium calculations, curve fitting, and more. Operations include everything from basic arithmetic and cell formatting to Solver, Goal Seek, and the Data Analysis Toolpak. The authors show you how to use a spreadsheet to construct log diagrams and to plot the results. Statistical data treatment includes descriptive statistics, linear regression, hypothesis testing, and analysis of variance. Tutorial exercises include nonlinear regression such as fitting the Van Deemter equation, fitting kinetics data, determining error coefficients in spectrophotometry, and calculating titration curves. Additional features include solving complex systems of equilibrium equations and advanced graphical methods: error bars, charts with insets, matrices and determinants, and much more. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
This supplement helps you learn to use spreadsheets as a problem-solving tool within the context of analytical chemistry applications.
Advanced chemistry textbook on use of spreadsheets in analytical chemistry.
This guidebook is different from the majority of existing Excel books in that it emphasizes the design of solutions to unique problems rather than simply the mechanics of spreadsheet use.
This latest edition incorporates new and revised content to use to learn the basics of Excel® for scientific data processing and now includes statistical analysis and regression analysis using Excel® add-ins, accounts for differences in ...
Through a conceptual presentation of chemical principles, this text will allow the reader to produce and digest large assemblies of numerical data/calculations while still focusing on the chemistry.
This book introduces the use of statistics to solve a variety of problems in exercise science and health and provides readers with a solid foundation for future research and data analysis.
The book is a core reference for chemists, lab technicians, undergraduate students studying the sciences, an undergraduate analytical chemistry class, or a graduate analytical chemistry class.
Solutions Manual to accompany Introduction to Quantitative Methods in Business: With Applications Using Microsoft Office Excel Solutions Manual to accompany Introduction to Quantitative Methods in Business: With Applications Using ...
Worked examples are included throughout the book, and student-tested problems are featured at the end of each chapter. Spreadsheet commands for QuattroPro, Quattro, and Lotus 1-2-3 are embedded in the text.
O'Reilly's Excel Hacks book, written by David and Raina Hawley, contains a couple of sorting hacks you might find useful. Hack #29 shows you how to sort using more than three columns, while Hack #30 shows you how to perform random sorts ...