Examples of Analytical Data Treatment Using Microsoft Excel: Outliers, Significance Testing/ANOVA, Regression, Matrices, and Solver

Author:   Mark T Stauffer
Publisher:   John Wiley and Sons Ltd
ISBN:  

9781119535881


Pages:   336
Publication Date:   09 August 2022
Format:   Hardback
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Our Price $196.52 Quantity:  
Add to Cart

Share |

Examples of Analytical Data Treatment Using Microsoft Excel: Outliers, Significance Testing/ANOVA, Regression, Matrices, and Solver


Add your own review!

Overview

This book deals with the use of Microsoft(R) Excel(TM) for treatment of outlier data and results, significance testing in data analysis. The focus of this book centers on applications of Excel(TM)'s math and statistical functions and analysis tools to problems and questions in analytical chemistry. This book is intended as a practical, hands-on guide to the use of Excel(TM) for calculation and assessment of quantitative data and results from analytical determinations. A basic operational knowledge of Microsoft(R) Excel(TM) is assumed on the part of the reader. Methods covered in the book include Treatment of outlier data/results in the Excel(TM) worksheet environment (Dixon Q test, Grubbs (G) test, etc.); Two-sample significance testing in the Excel(TM) worksheet environment; Analysis of variance (ANOVA) in the Excel(TM) worksheet environment for more than two samples; Regression; and Matrix functions for multianalyte determination and multivariate calibration.

Full Product Details

Author:   Mark T Stauffer
Publisher:   John Wiley and Sons Ltd
Imprint:   Wiley-Blackwell
Weight:   0.666kg
ISBN:  

9781119535881


ISBN 10:   1119535883
Pages:   336
Publication Date:   09 August 2022
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Hardback
Publisher's Status:   Active
Availability:   In Print   Availability explained
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List