Applications of Microsoft Excel in Analytical Chemistry

Author: F. James Holler
Publisher: Cengage Learning
ISBN: 1285629574
Format: PDF
Download Now
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.

Advanced Excel for Scientific Data Analysis

Author: Robert De Levie
Publisher: Oxford University Press, USA
ISBN: 0195152751
Format: PDF
Download Now
Excel is by far the most widely distributed data analysis software but few users are aware of its full powers. Advanced Excel For Scientific Data Analysis takes off from where most books dealing with scientific applications of Excel end. It focuses on three areas-least squares, Fourier transformation, and digital simulation-and illustrates these with extensive examples, often taken from the literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. These macros and functions are provided in uncompiled, computer-readable, easily modifiable form; readers can therefore use them as starting points for making their own personalized data analysis tools. Detailed descriptions and sample applications of standard and specialized uses of least squares for fitting data to a variety of functions, including resolving multi-component spectra; standard processes such as calibration curves and extrapolation; custom macros for general "error" propagation, standard deviations of Solver results, weighted or equidistant least squares, Gram-Schmidt orthogonalization, Fourier transformation, convolution and deconvolution, time-frequency analysis, and data mapping. There are also worked examples showing how to use centering, the covariance matrix, imprecision contours, and Wiener filtering and custom functions for bisections, Lagrange interpolation, Euler and Runge-Kutta integration.

Concepts Calculations in Analytical Chemistry Featuring the Use of Excel

Author: Henry Freiser
Publisher: CRC Press
ISBN: 9780849347177
Format: PDF, Kindle
Download Now
Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach offers a novel approach to learning the fundamentals of chemical equilibria using the flexibility and power of a spreadsheet program. 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. The chapters are arranged in a logical sequence, identifying almost every equilibrium scenario that an analytical chemist is likely to encounter. The spreadsheet calculations and graphics offer an excellent solution to otherwise time-consuming operations. 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. Concepts & Calculations in Analytical Chemistry: A Spreadsheet Approach has been designed to serve both as a supplement to an undergraduate quantitative analysis course or as a text in a graduate-level advanced analytical chemistry course. Professional chemists will also find this to be an excellent introduction to spreadsheet applications in the lab and a modern overview of analytical chemistry in a self-study format.

Fundamentals of Analytical Chemistry

Author: Douglas A. Skoog
Publisher: Cengage Learning
ISBN: 1285607198
Format: PDF, ePub, Mobi
Download Now
Known for its readability and systematic, rigorous approach, this fully updated Ninth Edition of FUNDAMENTALS OF ANALYTICAL CHEMISTRY offers extensive coverage of the principles and practices of analytic chemistry and consistently shows students its applied nature. The book's award-winning authors begin each chapter with a story and photo of how analytic chemistry is applied in industry, medicine, and all the sciences. To further reinforce student learning, a wealth of dynamic photographs by renowned chemistry photographer Charlie Winters appear as chapter-openers and throughout the text. Incorporating Excel spreadsheets as a problem-solving tool, the Ninth Edition is enhanced by a chapter on Using Spreadsheets in Analytical Chemistry, updated spreadsheet summaries and problems, an Excel Shortcut Keystrokes for the PC insert card, and a supplement by the text authors, EXCEL APPLICATIONS FOR ANALYTICAL CHEMISTRY, which integrates this important aspect of the study of analytical chemistry into the book's already rich pedagogy. New to this edition is OWL, an online homework and assessment tool that includes the Cengage YouBook, a fully customizable and interactive eBook, which enhances conceptual understanding through hands-on integrated multimedia interactivity. Available with InfoTrac Student Collections http://gocengage.com/infotrac. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Principles of Instrumental Analysis

Author: Douglas A. Skoog
Publisher: Cengage Learning
ISBN: 1337468037
Format: PDF, ePub, Mobi
Download Now
PRINCIPLES OF INSTRUMENTAL ANALYSIS is the standard for courses on the principles and applications of modern analytical instruments. In the 7th edition, authors Skoog, Holler, and Crouch infuse their popular text with updated techniques and several new Instrumental Analysis in Action case studies. Updated material enhances the book's proven approach, which places an emphasis on the fundamental principles of operation for each type of instrument, its optimal area of application, its sensitivity, its precision, and its limitations. The text also introduces students to elementary analog and digital electronics, computers, and the treatment of analytical data. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Data Analysis for Chemistry

Author: D. Brynn Hibbert
Publisher: OUP USA
ISBN: 0195162102
Format: PDF, ePub, Mobi
Download Now
Annotation. Definitions, Questions, and Useful Functions: Where to Find Things and What To Do1. Introduction2. Describing Data3. Hypothesis Testing4. Analysis of Variance5. Calibration.

Practical Statistics for the Analytical Scientist

Author: S. L. R. Ellison
Publisher: Royal Society of Chemistry
ISBN: 0854041311
Format: PDF, ePub, Docs
Download Now
"Completely revised and updated, the second edition contains new sections on method validation, measurement uncertainty, effective experimental design and proficiency testing."--pub. desc.

Chemometrics in Excel

Author: Alexey L. Pomerantsev
Publisher: John Wiley & Sons
ISBN: 1118605357
Format: PDF, Kindle
Download Now
Providing an easy explanation of the fundamentals, methods, and applications of chemometrics • Acts as a practical guide to multivariate data analysis techniques • Explains the methods used in Chemometrics and teaches the reader to perform all relevant calculations • Presents the basic chemometric methods as worksheet functions in Excel • Includes Chemometrics Add In for download which uses Microsoft Excel® for chemometrics training • Online downloads includes workbooks with examples

Spreadsheet Applications in Chemistry Using Microsoft Excel

Author: Dermot Diamond
Publisher: Wiley-Interscience
ISBN: 9780471140870
Format: PDF, Docs
Download Now
This book illustrates how EXCEL can be used to help scientists process, analyze, and present scientific data. EXCEL provides a flexible environment that can be used to prepare spreadsheet solutions for scientific data processing problems. It demonstrates step-by-step how to program EXCEL to perform appropriate tasks, automate repetitive data processing tasks, and prepare integrated documents by transferring data and graphics. It covers problems such as how to perform linear regression and use the built-in statistical tools of EXCEL, as well as addressing advanced topics such as graphing complex equations, model building and the use of VBA and macros for user interface. Though the examples emphasize chemical applications, the information provided will prove useful to all scientists.

Excel for Chemists

Author: E. Joseph Billo
Publisher: John Wiley & Sons
ISBN: 047146080X
Format: PDF, ePub, Mobi
Download Now
Reviews from the First Edition: "Excel® for Chemists should be part of any academic library offering courses and programs in chemistry. There is no other book on the market that deals so thoroughly with the application of Excel for analyzing chemical data. Highly recommended, for upper-division undergraduates through professionals." -Choice "I highly recommend this book; treat yourself to it; assign it to a class; give it as a gift." -The Nucleus Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the scientific calculating power within this program. Excel is capable of helping chemists process, analyze, and present scientific data, from the relatively simple to the highly complex. Excel® for Chemists, Second Edition has been revised and updated, not only to take into account the changes that were made in Excel, but also to incorporate an abundance of new examples. Arranged in a user-friendly format, this book contains illustrations and examples of chemical applications, useful "How to" boxes outlining how to accomplish complex tasks in Excel, and step-by-step instructions for programming Excel to automate repetitive data-processing tasks. In addition, tips are provided to speed, simplify, and improve your use of Excel. Included is a CD-ROM, usable in either Macintosh or IBM/Windows environments with many helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Edition feature: Array formulas covered in depth in a separate chapter, along with a comprehensive review of using arrays in VBA How to create a worksheet with controls, such as option buttons, check boxes, or a list box An extensive list of shortcut keys-over 250 for Macintosh or PC-is provided in the appendix Whether as a text for students or as a reference for chemical professionals in industry, academia, or government, Excel® for Chemists, Second Edition provides a valuable resource for using Excel to manage various chemical calculations.