Advanced Excel for Scientific Data Analysis


Book Description

This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).




How to Use Excel® in Analytical Chemistry


Book Description

Because of their intuitive layout, extensive mathematical capabilities, and convenient graphics, spreadsheets provide an easy, straightforward route to scientific computing. This textbook for undergraduate and entry-level graduate chemistry and chemical engineering students uses Excel, the most powerful available spreadsheet, to explore and solve problems in general and chemical data analysis. This is the only up-to-date text on the use of spreadsheets in chemistry. The book discusses topics including statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. It contains many examples of data analysis, and uses spreadsheets for numerical simulations, and testing analytical procedures. It also treats modern data analysis methods such as linear and non-linear least squares in great detail, as well as methods based on Fourier transformation. The book shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet and 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.




Statistics for Analytical Chemistry


Book Description




Excel for Chemists


Book Description

Reviews from the First Edition: "Excel® for Chemists should be part ofany academic library offering courses and programs in chemistry.There is no other book on the market that deals so thoroughly withthe application of Excel for analyzing chemical data. Highlyrecommended, for upper-division undergraduates throughprofessionals." -Choice "I highly recommend this book; treat yourself to it; assign itto a class; give it as a gift." -The Nucleus Chemists across all subdisciplines use Excel to record data intabular form, but few have learned to take full advantage of thescientific calculating power within this program. Excel is capableof helping chemists process, analyze, and present scientific data,from the relatively simple to the highly complex.Excel® for Chemists, Second Edition has beenrevised and updated, not only to take into account the changes thatwere made in Excel, but also to incorporate an abundance of newexamples. Arranged in a user-friendly format, this book containsillustrations and examples of chemical applications, useful "Howto" boxes outlining how to accomplish complex tasks in Excel, andstep-by-step instructions for programming Excel to automaterepetitive data-processing tasks. In addition, tips are provided tospeed, simplify, and improve your use of Excel. Included is aCD-ROM, usable in either Macintosh or IBM/Windows environments withmany helpful spreadsheet templates, macros, and other tools. Entirely new chapters contained in this Second Editionfeature: Array formulas covered in depth in a separate chapter, alongwith a comprehensive review of using arrays in VBA How to create a worksheet with controls, such as optionbuttons, check boxes, or a list box An extensive list of shortcut keys-over 250 for Macintosh orPC-is provided in the appendix Whether as a text for students or as a reference for chemicalprofessionals in industry, academia, or government,Excel® for Chemists, Second Edition providesa valuable resource for using Excel to manage various chemicalcalculations.




Data Analysis for Chemistry


Book Description

Chemical data analysis, with aspects of metrology in chemistry and chemometrics, is an evolving discipline where new and better ways of doing things are constantly being developed. This book makes data analysis simple by demystifying the language and whenever possible giving unambiguous ways of doing things. Based on author D. Brynn Hibberts lectures on data analysis to undergraduates and graduate students, Data Analysis for Chemistry covers topics including measurements, means and confidence intervals, hypothesis testing, analysis of variance, and calibration models. The end result is a compromise between recipes of how to perform different aspects of data analysis, and basic information on the background principles behind the recipes to be performed. An entry level book targeted at learning and teaching undergraduate data analysis, Data Analysis for Chemistry makes it easy for readers to find the information they are seeking to perform the data analysis they think they need.




Green Analytical Chemistry


Book Description

The book explains the principles and fundamentals of Green Analytical Chemistry (GAC) and highlights the current developments and future potential of the analytical green chemistry-oriented applications of various solutions. The book consists of sixteen chapters, including the history and milestones of GAC; issues related to teaching of green analytical chemistry and greening the university laboratories; evaluation of impact of analytical activities on the environmental and human health, direct techniques of detection, identification and determination of trace constituents; new achievements in the field of extraction of trace analytes from samples characterized by complex composition of the matrix; “green” nature of the derivatization process in analytical chemistry; passive techniques of sampling of analytes; green sorption materials used in analytical procedures; new types of solvents in the field of analytical chemistry. In addition green chromatography and related techniques, fast tests for assessment of the wide spectrum of pollutants in the different types of the medium, remote monitoring of environmental pollutants, qualitative and comparative evaluation, quantitative assessment, and future trends and perspectives are discussed. This book appeals to a wide readership of the academic and industrial researchers. In addition, it can be used in the classroom for undergraduate and graduate Ph.D. students focusing on elaboration of new analytical procedures for organic and inorganic compounds determination in different kinds of samples characterized by complex matrices composition.Jacek Namieśnik was a Professor at the Department of Analytical Chemistry, Gdańsk University of Technology, Poland. Justyna Płotka-Wasylka is a teacher and researcher at the same department.




Statistical Methods in Analytical Chemistry


Book Description

This new edition of a successful, bestselling book continues to provide you with practical information on the use of statistical methods for solving real-world problems in complex industrial environments. Complete with examples from the chemical and pharmaceutical laboratory and manufacturing areas, this thoroughly updated book clearly demonstrates how to obtain reliable results by choosing the most appropriate experimental design and data evaluation methods. Unlike other books on the subject, Statistical Methods in Analytical Chemistry, Second Edition presents and solves problems in the context of a comprehensive decision-making process under GMP rules: Would you recommend the destruction of a $100,000 batch of product if one of four repeat determinations barely fails the specification limit? How would you prevent this from happening in the first place? Are you sure the calculator you are using is telling the truth? To help you control these situations, the new edition: * Covers univariate, bivariate, and multivariate data * Features case studies from the pharmaceutical and chemical industries demonstrating typical problems analysts encounter and the techniques used to solve them * Offers information on ancillary techniques, including a short introduction to optimization, exploratory data analysis, smoothing and computer simulation, and recapitulation of error propagation * Boasts numerous Excel files and compiled Visual Basic programs-no statistical table lookups required! * Uses Monte Carlo simulation to illustrate the variability inherent in statistically indistinguishable data sets Statistical Methods in Analytical Chemistry, Second Edition is an excellent, one-of-a-kind resource for laboratory scientists and engineers and project managers who need to assess data reliability; QC staff, regulators, and customers who want to frame realistic requirements and specifications; as well as educators looking for real-life experiments and advanced students in chemistry and pharmaceutical science. From the reviews of Statistical Methods in Analytical Chemistry, First Edition: "This book is extremely valuable. The authors supply many very useful programs along with their source code. Thus, the user can check the authenticity of the result and gain a greater understanding of the algorithm from the code. It should be on the bookshelf of every analytical chemist."-Applied Spectroscopy "The authors have compiled an interesting collection of data to illustrate the application of statistical methods . . . including calibrating, setting detection limits, analyzing ANOVA data, analyzing stability data, and determining the influence of error propagation."-Clinical Chemistry "The examples are taken from a chemical/pharmaceutical environment, but serve as convenient vehicles for the discussion of when to use which test, and how to make sense out of the results. While practical use of statistics is the major concern, it is put into perspective, and the reader is urged to use plausibility checks."-Journal of Chemical Education "The discussion of univariate statistical tests is one of the more thorough I have seen in this type of book . . . The treatment of linear regression is also thorough, and a complete set of equations for uncertainty in the results is presented . . . The bibliography is extensive and will serve as a valuable resource for those seeking more information on virtually any topic covered in the book."-Journal of American Chemical Society "This book treats the application of statistics to analytical chemistry in a very practical manner. [It] integrates PC computing power, testing programs, and analytical know-how in the context of good manufacturing practice/good laboratory practice (GMP/GLP) . . .The book is of value in many fields of analytical chemistry and should be available in all relevant libraries."-Chemometrics and Intelligent Laboratory Systems




Modern Analytical Chemistry


Book Description

This introductory text covers both traditional and contemporary topics relevant to analytical chemistry. Its flexible approach allows instructors to choose their favourite topics of discussion from additional coverage of subjects such as sampling, kinetic method, and quality assurance.




Data Analysis with Excel®


Book Description

An essential introduction to data analysis techniques using spreadsheets, for undergraduate and graduate students.




Practical Guide To Chemometrics


Book Description

The limited coverage of data analysis and statistics offered in most undergraduate and graduate analytical chemistry courses is usually focused on practical aspects of univariate methods. Drawing in real-world examples, Practical Guide to Chemometrics, Second Edition offers an accessible introduction to application-oriented multivariate meth