Spreadsheet Applications in Chemistry Using Microsoft Excel

Spreadsheet Applications in Chemistry Using Microsoft Excel
Author: Aoife Morrin
Publisher: John Wiley & Sons
Total Pages: 196
Release: 2022-09-14
Genre: Science
ISBN: 1119182972

SPREADSHEET APPLICATIONS IN CHEMISTRY USING MICROSOFT® EXCEL® Find step-by-step tutorials on scientific data processing in the latest versions of Microsoft® Excel® The Second Edition of Spreadsheet Applications in Chemistry Using Microsoft® Excel® delivers a comprehensive and up-to-date exploration of the application of scientific data processing in Microsoft® Excel®. Written to incorporate the latest updates and changes found in Excel® 2021, as well as later versions, this practical textbook is tutorial-focused and offers simple, step-by-step instructions for scientific data processing tasks commonly used by undergraduate students. Readers will also benefit from an online repository of experimental datasets that can be used to work through the tutorials to gain familiarity with data processing and visualization in Excel®. 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 navigation and utility between Windows and MacOS versions of the software, and integrates with an online dataset repository for the tutorial exercises. Spreadsheet Applications in Chemistry Using Microsoft® Excel® also includes: A thorough introduction to Microsoft® Excel® workbook and worksheet basics, including Excel® toolbar navigation, entering and manipulating formulas and functions and charting experimental chemical data Comprehensive explorations of statistical functions and regression analysis Generating calibration plots from instrumental data Visualizing concepts in physical chemistry Perfect for undergraduate and graduate students of analytical and physical chemistry, Spreadsheet Applications in Chemistry Using Microsoft® Excel® is also an ideal resource for students and practitioners of physics, engineering, and biology.

Advanced Excel for Scientific Data Analysis

Advanced Excel for Scientific Data Analysis
Author: Robert De Levie
Publisher: Oxford University Press, USA
Total Pages: 631
Release: 2004
Genre: Computers
ISBN: 0195152751

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).

Mathematics for Physical Chemistry

Mathematics for Physical Chemistry
Author: Robert G. Mortimer
Publisher: Elsevier
Total Pages: 274
Release: 2023-02-20
Genre: Science
ISBN: 0443189463

Mathematics for Physical Chemistry, Fifth Edition includes exercises that enable readers to test their understanding and put theory into practice. Chapters are constructed around a sequence of mathematical topics, progressing gradually into more advanced material, before discussing key mathematical skills, including the analysis of experimental data and—new to this edition—complex variables. Includes additional new content on Mathematica and its advanced applications. Drawing on the experience of its expert authors, this book is the ideal supplementary text for practicing chemists and students wanting to sharpen their mathematics skills and understanding of key mathematical concepts for applications across physical chemistry. - Includes updated coverage of key topics, including a review of general algebra and an introduction to group theory - Features previews, objectives, and numerous examples and problems throughout the text to aid learning - Provides chemistry-specific instruction without the distraction of abstract concepts or theoretical issues in pure mathematics - Includes new chapters on complex variables and Mathematica for advanced applications

Excel for Scientists and Engineers

Excel for Scientists and Engineers
Author: E. Joseph Billo
Publisher: John Wiley & Sons
Total Pages: 480
Release: 2007-03-16
Genre: Computers
ISBN: 0470126701

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package

Quantitative Chemical Analysis, Sixth Edition

Quantitative Chemical Analysis, Sixth Edition
Author: Daniel C. Harris
Publisher: Macmillan
Total Pages: 948
Release: 2003
Genre: Science
ISBN: 9780716744641

For instructors who wish to focus on practical, industrial, or research chemistry. Includes case studies, applications boxes, and spreadsheet applications.

Analytical Chemistry

Analytical Chemistry
Author: Gary D. Christian
Publisher: John Wiley & Sons
Total Pages: 852
Release: 2013-10-07
Genre: Science
ISBN: 0470887575

The 7th Edition of Gary Christian's Analytical Chemistry focuses on more in-depth coverage and information about Quantitative Analysis (aka Analytical Chemistry) and related fields. The content builds upon previous editions with more enhanced content that deals with principles and techniques of quantitative analysis with more examples of analytical techniques drawn from areas such as clinical chemistry, life sciences, air and water pollution, and industrial analyses.

Paint and Surface Coatings

Paint and Surface Coatings
Author: R Lambourne
Publisher: Elsevier
Total Pages: 799
Release: 1999-08-23
Genre: Science
ISBN: 1855737000

This second edition of an established and well received book has been carefully revised, in many instances by the original authors, and enlarged by the addition of two completely new chapters. These deal with the use of computers in the paint industry and with the increasingly important subject of health and safety. The chapter on pigments has also been re-written by an author new to this edition.It was the editor's intention in the first edition to provide science graduates entering the paint industry with a bridge between academia and the applied science and technology of paints. The great strength and appeal of this book remains that it deals with the technology of paints and surface coatings while also providing a basic understanding of the chemistry and physics of coatings. - Extensive revision of first edition - New chapter on computers and modelling - New chapter on health and safety

Analytical Chemistry, International Adaptation

Analytical Chemistry, International Adaptation
Author: Gary D. Christian
Publisher: John Wiley & Sons
Total Pages: 963
Release: 2020
Genre: Science
ISBN: 1119770793

With the 7th Edition of Analytical Chemistry renowned chemists, Purnendu (Sandy) Dasgupta and Kevin Schug, both of the University of Texas Arlington, join the author team. The new edition focuses on more in-depth coverage of the principles and techniques of quantitative analysis and instrumental analysis (aka Analytical Chemistry). The goal of the text is to provide a foundation of the analytical process, tools, and computational methods and resources, and to illustrate with problems that bring realism to the practice and importance of analytical chemistry. It is designed for undergraduate college students majoring in chemistry and in fields related to chemistry.

Instrumental Analytical Chemistry

Instrumental Analytical Chemistry
Author: James W. Robinson
Publisher: CRC Press
Total Pages: 920
Release: 2021-06-29
Genre: Science
ISBN: 1315301148

Analytical chemistry today is almost entirely instrumental analytical chemistry and it is performed by many scientists and engineers who are not chemists. Analytical instrumentation is crucial to research in molecular biology, medicine, geology, food science, materials science, and many other fields. With the growing sophistication of laboratory equipment, there is a danger that analytical instruments can be regarded as "black boxes" by those using them. The well-known phrase "garbage in, garbage out" holds true for analytical instrumentation as well as computers. This book serves to provide users of analytical instrumentation with an understanding of their instruments. This book is written to teach undergraduate students and those working in chemical fields outside analytical chemistry how contemporary analytical instrumentation works, as well as its uses and limitations. Mathematics is kept to a minimum. No background in calculus, physics, or physical chemistry is required. The major fields of modern instrumentation are covered, including applications of each type of instrumental technique. Each chapter includes: A discussion of the fundamental principles underlying each technique Detailed descriptions of the instrumentation. An extensive and up to date bibliography End of chapter problems Suggested experiments appropriate to the technique where relevant This text uniquely combines instrumental analysis with organic spectral interpretation (IR, NMR, and MS). It provides detailed coverage of sampling, sample handling, sample storage, and sample preparation. In addition, the authors have included many instrument manufacturers’ websites, which contain extensive resources.

Practical Data Analysis in Chemistry

Practical Data Analysis in Chemistry
Author: Marcel Maeder
Publisher: Elsevier
Total Pages: 341
Release: 2007-08-10
Genre: Mathematics
ISBN: 0080548830

The majority of modern instruments are computerised and provide incredible amounts of data. Methods that take advantage of the flood of data are now available; importantly they do not emulate 'graph paper analyses' on the computer. Modern computational methods are able to give us insights into data, but analysis or data fitting in chemistry requires the quantitative understanding of chemical processes. The results of this analysis allows the modelling and prediction of processes under new conditions, therefore saving on extensive experimentation. Practical Data Analysis in Chemistry exemplifies every aspect of theory applicable to data analysis using a short program in a Matlab or Excel spreadsheet, enabling the reader to study the programs, play with them and observe what happens. Suitable data are generated for each example in short routines, this ensuring a clear understanding of the data structure. Chapter 2 includes a brief introduction to matrix algebra and its implementation in Matlab and Excel while Chapter 3 covers the theory required for the modelling of chemical processes. This is followed by an introduction to linear and non-linear least-squares fitting, each demonstrated with typical applications. Finally Chapter 5 comprises a collection of several methods for model-free data analyses.* Includes a solid introduction to the simulation of equilibrium processes and the simulation of complex kinetic processes.* Provides examples of routines that are easily adapted to the processes investigated by the reader* 'Model-based' analysis (linear and non-linear regression) and 'model-free' analysis are covered