Concepts Calculations in Analytical Chemistry Featuring the Use of Excel

Author: Henry Freiser
Publisher: CRC Press
ISBN: 1482292599
Format: PDF, ePub, Mobi
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.

Concepts Calculations in Analytical Chemistry Featuring the Use of Excel

Author: Henry Freiser
Publisher: CRC Press
ISBN: 9780849347177
Format: PDF, ePub
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.

Applications of Microsoft Excel in Analytical Chemistry

Author: F. Holler
Publisher: Cengage Learning
ISBN: 128508795X
Format: PDF, ePub, Mobi
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, ePub, Docs
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.

Chemical Engineering Primer with Computer Applications

Author: Hussein K. Abdel-Aal
Publisher: CRC Press
ISBN: 1315353040
Format: PDF, Kindle
Download Now
Taking a highly pragmatic approach to presenting the principles and applications of chemical engineering, this companion text for students and working professionals offers an easily accessible guide to solving problems using computers. The primer covers the core concepts of chemical engineering, from conservation laws all the way up to chemical kinetics, without heavy stress on theory and is designed to accompany traditional larger core texts. The book presents the basic principles and techniques of chemical engineering processes and helps readers identify typical problems and how to solve them. Focus is on the use of systematic algorithms that employ numerical methods to solve different chemical engineering problems by describing and transforming the information. Problems are assigned for each chapter, ranging from simple to difficult, allowing readers to gradually build their skills and tackle a broad range of problems. MATLAB and Excel® are used to solve many examples and the more than 70 real examples throughout the book include computer or hand solutions, or in many cases both. The book also includes a variety of case studies to illustrate the concepts and a downloadable file containing fully worked solutions to the book’s problems on the publisher’s website. Introduces the reader to chemical engineering computation without the distractions caused by the contents found in many texts. Provides the principles underlying all of the major processes a chemical engineer may encounter as well as offers insight into their analysis, which is essential for design calculations. Shows how to solve chemical engineering problems using computers that require numerical methods using standard algorithms, such as MATLAB® and Excel®. Contains selective solved examples of many problems within the chemical process industry to demonstrate how to solve them using the techniques presented in the text. Includes a variety of case studies to illustrate the concepts and a downloadable file containing fully worked solutions to problems on the publisher’s website. Offers non-chemical engineers who are expected to work with chemical engineers on projects, scale-ups and process evaluations a solid understanding of basic concepts of chemical engineering analysis, design, and calculations.

Computer Applications in Food Technology

Author: R. Paul Singh
Publisher: Elsevier
ISBN: 9780080529714
Format: PDF, Kindle
Download Now
The Institute of Food Technologists (IFT) recently endorsed the use of computers in food science education. The minimum standards for degrees in food science, as suggested by IFT,"require the students to use computers in the solution of problems, the collection and analysis of data, the control processes, in addition to word processing."Because they are widely used in business, allow statistical and graphical of experimental data, and can mimic laboratory experimentation, spreadsheets provide an ideal tool for learning the important features of computers and programming. In addition, they are ideally suited for food science students, who usually do not have an extensive mathematical background. Drawing from the many courses he has taught at UC Davis, Dr. Singh covers the general basics of spreadsheets using examples specific to food science. He includes more than 50 solved problems drawn from key areas of food science, namely food microbiology, food chemistry, sensory evaluation, statistical quality control, and food engineering. Each problem is presented with the required equations and detailed steps necessary for programming the spreadsheet. Helpful hints in using the spreadsheets are also provided throughout the text. Key Features * The first book to integrate speadsheets in teaching food science and technology * Includes more than 50 solved examples of spreadsheet use in food science and engineering * Presents a step-by-step introduction to spreadsheet use * Provides a food composition database on a computer disk

101 Ready to Use Excel Formulas

Author: Michael Alexander
Publisher: John Wiley & Sons
ISBN: 1118902599
Format: PDF, Docs
Download Now
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work. Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented. Teaches you how to implement the required Excel formula Explains and details how the formulas work Lets you reuse or customize the given formula to address your particular needs Helps you make the formulas a regular part of your new, more efficient workflow Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas.

Quantitative Chemical Analysis

Author: Daniel C. Harris
Publisher: Macmillan
ISBN: 1429218150
Format: PDF, ePub, Docs
Download Now
QCA is the bestselling textbook of choice for analytical chemistry. It offers a modern portrait of the techniques of chemical analysis, backed by a wealth of real world applications. This edition features new coverage of spectroscopy and statistics, new pedagogy and enhanced lecturer support.

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.

Key Concepts in Environmental Chemistry

Author: Grady Hanrahan
Publisher: Academic Press
ISBN: 012374993X
Format: PDF, Kindle
Download Now
Key Concepts in Environmental Chemistry provides a modern and concise introduction to environmental chemistry principles and the dynamic nature of environmental systems. It offers an intense, one-semester examination of selected concepts encountered in this field of study and provides integrated tools in explaining complex chemical problems of environmental importance. Principles typically covered in more comprehensive textbooks are well integrated into general chapter topics and application areas. The goal of this textbook is to provide students with a valuable resource for learning the basic concepts of environmental chemistry from an easy to follow, condensed, application and inquiry-based perspective. Additional statistical, sampling, modeling and data analysis concepts and exercises will be introduced for greater understanding of the underlying processes of complex environmental systems and fundamental chemical principles. Each chapter will have problem-oriented exercises (with examples throughout the body of the chapter) that stress the important concepts covered and research applications/case studies from experts in the field. Research applications will be directly tied to theoretical concepts covered in the chapter. Overall, this text provides a condensed and integrated tool for student learning and covers key concepts in the rapidly developing field of environmental chemistry. Intense, one-semester approach to learning Application-based approach to learning theoretical concepts In depth analysis of field-based and in situ analytical techniques Introduction to environmental modeling