Spreadsheet Applications In Chemistry Using Microsoft Excel

Author : Aoife Morrin,Dermot Diamond
Publisher : John Wiley & Sons
Page : 196 pages
File Size : 49,6 Mb
Release : 2022-09-14
Category : Science
ISBN : 9781119182979

Get Book

Spreadsheet Applications in Chemistry Using Microsoft Excel by Aoife Morrin,Dermot Diamond Pdf

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.

Author : Gordon Filby
Publisher : Springer Science & Business Media
Page : 292 pages
File Size : 54,6 Mb
Release : 2013-12-18
Category : Science
ISBN : 9783642802492

Get Book

Spreadsheets in Science and Engineering by Gordon Filby Pdf

"Spreadsheets in Science and Engineering" shows scientists and engineers at all levels how to analyze, validate and calculate data and how the analytical and graphic capabilities of spreadsheet programs (ExcelR) can solve these tasks in their daily work. The examples on the CD-ROM accompanying the book include material of undergraduate to current research level in disciplines ranging from chemistry and chemical engineering to molecular biology and geology.

Author : Aoife Morrin,Dermot Diamond
Publisher : John Wiley & Sons
Page : 196 pages
File Size : 49,8 Mb
Release : 2022-08-10
Category : Science
ISBN : 9781119184034

Get Book

Spreadsheet Applications in Chemistry Using Microsoft Excel by Aoife Morrin,Dermot Diamond Pdf

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.

Author : Gordon Filby
Publisher : Wiley-VCH
Page : 440 pages
File Size : 41,6 Mb
Release : 1995
Category : Computers
ISBN : STANFORD:36105009567723

Get Book

Spreadsheets for Chemists by Gordon Filby Pdf

A practical guide 'Spreadsheets for Chemists' shows chemists of all levels how to use spreadsheet programs in their daily work. It highlights the possibilities provided by Lotus 1-2-3, the most widely used spreadsheet program in the sciences. Apart from hundreds of example fragments, it features: * Detailed discussion of the most relevant functions and all the () macro commands. * An accompanying diskette containing 57 worksheets involving many different fields of chemical research and teaching. * An extensive glossary of spreadsheet terms. * Three appendices covering 1-2-3's competitors and add-in packages, the use of Windows-based spreadsheets and how what-if analysis and back-solving is applied. Although the disk examples were developed for Lotus 1-2-3 DOS Versions 2.x (x=2-4), the worksheets are compatible with the newer Windows versions and those of their main competitors, Borland's Quattro Pro and Microsoft's Excel. Several compatible spreadsheets (AsEasyAs, Proqube) might also be as used as inexpensive alternatives. The author is a senior scientist at the Nuclear Research Centre in Karlsruhe, Germany. He has been using spreadsheet software for nearly ten years successfully in a variety of chemical problems.

Author : Robert de Levie
Publisher : Cambridge University Press
Page : 506 pages
File Size : 49,5 Mb
Release : 2001-02-05
Category : Computers
ISBN : 0521644844

Get Book

How to Use Excel® in Analytical Chemistry by Robert de Levie Pdf

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.

Author : F. James Holler,Stanley R. Crouch
Publisher : Cengage Learning
Page : 0 pages
File Size : 54,7 Mb
Release : 2013-02-27
Category : Science
ISBN : 128508795X

Get Book

Applications of Microsoft Excel in Analytical Chemistry by F. James Holler,Stanley R. Crouch Pdf

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.

Author : Douglas A. Skoog,Donald M. West,F. James Holler,Stanley R. Crouch
Publisher : Unknown
Page : 128 pages
File Size : 48,9 Mb
Release : 2021-03
Category : Electronic
ISBN : 0357451430

Get Book

Applications of Microsoft Excel in Analytical Chemistry by Douglas A. Skoog,Donald M. West,F. James Holler,Stanley R. Crouch Pdf

Author : E. Joseph Billo
Publisher : John Wiley & Sons
Page : 773 pages
File Size : 48,5 Mb
Release : 2011-09-21
Category : Science
ISBN : 9780470381236

Get Book

Excel for Chemists, with CD-ROM by E. Joseph Billo Pdf

Reviews from previous editions: "Excel for Chemists should be part of any academic library offering courses and programs in Chemistry." —Choice "I highly recommend the book; treat yourself to it; assign it to a class; give it as a gift." —The Nucleus The newly revised step-by-step guide to using the scientific calculating power of Excel to perform a variety of chemical calculations Chemists across all subdisciplines use Excel to record data in tabular form, but few have learned to take full advantage of the program. Featuring clear step-by-step instructions, Excel for Chemists illustrates how to use the scientific calculating power of Excel to perform a variety of chemical calculations. Including a CD-ROM for Windows, this new edition provides chemists and students with a detailed guide to using the current versions of Excel (Excel 2007 and 2010) as well as Excel 2003. Additional features in this third edition include: How to perform a variety of chemical calculations by creating advanced spreadsheet formulas or by using Excel’s built-in tools How to automate repetitive tasks by programming Excel’s Visual Basic for Applications New chapters show how to import data from other language versions of Excel, and how to create automatic procedures The accompanying CD contains a number of Excel macros to facilitate chemical calculations, including molecular weight, nonlinear regression statistics, and data interpolation Several appendices provide extensive lists of useful shortcut keys and function descriptions

Author : E. Joseph Billo
Publisher : Unknown
Page : 488 pages
File Size : 48,9 Mb
Release : 1997-04-24
Category : Computers
ISBN : UOM:39015041024236

Get Book

Excel? for Chemists by E. Joseph Billo Pdf

In one volume, this book offers the reader a complete instructional and reference manual on using Microsoft Excel for chemical applications. The first half of the book is a sourcebook of instructions on Excel using chemical example throughout. The writing style and illustrations are far superior (for scientists) to manuals currently available. The second half of the book shows how to use Excel's built-in worksheet functions to perform advanced calculations, and illustrates these techniques with applications in chemistry. It also offers numerous useful macros and spreadsheets for solving a variety of chemistry problems. The book will be packaged with two diskettes, for Macintosh and Windows environments, respectively, that will include many spreadsheets and macros presented in the text.

Author : E. Joseph Billo
Publisher : John Wiley & Sons
Page : 485 pages
File Size : 43,6 Mb
Release : 2007-04-06
Category : Computers
ISBN : 9780471387343

Get Book

Excel for Scientists and Engineers by E. Joseph Billo Pdf

Learn to fully harness the power of Microsoft Excel(r) to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's(r) 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(r) 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.

Author : Robert G. Mortimer,S.M. Blinder
Publisher : Elsevier
Page : 274 pages
File Size : 50,6 Mb
Release : 2023-02-20
Category : Business & Economics
ISBN : 9780443189463

Get Book

Mathematics for Physical Chemistry by Robert G. Mortimer,S.M. Blinder Pdf

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

Author : Robert De Levie
Publisher : Oxford University Press, USA
Page : 631 pages
File Size : 52,6 Mb
Release : 2004
Category : Computers
ISBN : 9780195152753

Get Book

Advanced Excel for Scientific Data Analysis by Robert De Levie Pdf

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

Author : Henry Freiser,Monika Freiser
Publisher : CRC Press
Page : 380 pages
File Size : 42,9 Mb
Release : 1992-03-17
Category : Science
ISBN : 0849347173

Get Book

Concepts & Calculations in Analytical Chemistry, Featuring the Use of Excel by Henry Freiser,Monika Freiser Pdf

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.

Author : Henry Freiser
Publisher : Unknown
Page : 128 pages
File Size : 45,5 Mb
Release : 2017
Category : Electronic
ISBN : 0429079443

Get Book

Concepts and Calculations in Analytical Chemistry, Featuring the Use of Excel by Henry Freiser Pdf

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.

Author : R Lambourne,T A Strivens
Publisher : Elsevier
Page : 799 pages
File Size : 47,5 Mb
Release : 1999-08-23
Category : Science
ISBN : 9781855737006

Get Book

Paint and Surface Coatings by R Lambourne,T A Strivens Pdf

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