Applications of Microsoft Excel in analytical chemistry:
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Belmont, CA [u.a.]
Brooks/Cole, Cengage Learning
2014
|
| Edition: | 2. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | VIII, 461 S. Ill., graph. Darst. |
| ISBN: | 9781285087955 128508795X |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV042758577 | ||
| 003 | DE-604 | ||
| 005 | 20160427 | ||
| 007 | t | ||
| 008 | 150813s2014 ad|| |||| 00||| eng d | ||
| 010 | |a 2013444352 | ||
| 020 | |a 9781285087955 |c pbk. |9 978-1-285-08795-5 | ||
| 020 | |a 128508795X |c pbk. |9 1-285-08795-X | ||
| 035 | |a (OCoLC)855888837 | ||
| 035 | |a (DE-599)GBV776763466 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-703 |a DE-19 | ||
| 082 | 0 | |a 543.028553682 | |
| 084 | |a VC 6050 |0 (DE-625)147081:253 |2 rvk | ||
| 084 | |a VC 6400 |0 (DE-625)147091:253 |2 rvk | ||
| 100 | 1 | |a Crouch, Stanley R. |d 1940- |e Verfasser |0 (DE-588)138623384 |4 aut | |
| 245 | 1 | 0 | |a Applications of Microsoft Excel in analytical chemistry |c Stanley R. Crouch ; F. James Holler |
| 250 | |a 2. ed. | ||
| 264 | 1 | |a Belmont, CA [u.a.] |b Brooks/Cole, Cengage Learning |c 2014 | |
| 300 | |a VIII, 461 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Datenverarbeitung | |
| 650 | 0 | 7 | |a Analytische Chemie |0 (DE-588)4129906-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 653 | |a Microsoft Excel (Computer file) | ||
| 653 | |a Chemometrics | ||
| 653 | |a Chemistry, Analytic -- Data processing | ||
| 653 | |a Electronic spreadsheets -- Computer programs | ||
| 689 | 0 | 0 | |a Analytische Chemie |0 (DE-588)4129906-1 |D s |
| 689 | 0 | 1 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Holler, F. James |e Verfasser |0 (DE-588)1045691720 |4 aut | |
| 856 | 4 | 2 | |m Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028189153&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-028189153 | ||
Record in the Search Index
| _version_ | 1804174976851378176 |
|---|---|
| adam_text | CONTENTS______________________________£
CHAPTER 1 Excel Basics 1
Getting Started 2
Calculating a Molar Mass 4
Entering Text and Data in the Worksheet 4
Entering an Equation 5
Documenting the Worksheet 7
Laboratory Notebook Example 8
Changing the Width of a Column 10
Entering Numbers into the Spreadsheet 10
Filling Cells Using the Fill Handle 11
Making Complex Calculations with Excel 13
An Example from Gravimetric Analysis 14
More Cell Formatting 14
Entering the Data 15
Calculating Molar Masses 16
Calculating the Percentages 16
Documenting the Spreadsheet 17
Importing and Using Molar Mass Data 19
Importing Data from Web Pages 19
Dealing with Character Strings 21
Making the Calculation 29
Summary 31
Problems 31
CHAPTER 2 Basic Statistical Analysis with Excel 34
Calculating a Mean with Excel 34
Finding the Mean 35
Using Excel’s Built-in Functions 36
Finding the Deviations from the Mean 37
Editing Formulas 38
Computing the Standard Deviation 39
Finding the Variance 39
A Shortcut for Performing a Summation 40
Finding the Standard Deviation 42
The Built-in Statistical Functions of Excel 43
The Coefficient of Variation, or Percent
Relative Standard Deviation 44
Standard Error of the Mean 45
Computing Descriptive Statistics
with the Analysis ToolPak 47
The Analysis ToolPak 47
Calculating the Pooled Standard Deviation 49
Finding the Sum of the Squares
of the Deviations 50
Finding the Total Sum of Squares 52
Confidence Intervals 54 ·
Confidence Intervals when o is Known 54
Confidence Intervals when s Must Be Used 57
Summary 59
Problems 60
iii
© 2014 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
CHAPTER 3
CHAPTER 4
CHAPTER 5
Statistical Tests with Excel 64
/Tests 64
Comparing Means Assuming Equal Variances 64
Manual Calculation 65
Using the Excel Built-in Functions 68
Paired Two-Sample t Test 70
F Test for Comparison of Variances 74
ANOVA 77
Entering ANOVA Formulas Manually 77
The Analysis ToolPak ANOVA Tool 81
Distribution-Free Methods 83
Wilcoxon Signed-Rank Test for Single Samples 84
Wilcoxon Signed-Rank Test for Paired Data 87
Summary 88
Problems 89
Least-Squares and Calibration Methods 95
Linear Least-Squares Analysis 95
The Slope and Intercept 96
Using .LINEST 99
The Analysis ToolPak Regression Tool 100
Plotting a Graph of the Data and the
Least-Squares Fit 102
Using Excel to Find Unknown Concentrations
from a Calibration Curve 105
The Internal Standard Method 109
Method of Standard Additions 111
Principles of Multiple Standard Additions 111
Finding the Unknown Concentration 113
Analyzing Errors 113
Plotting the Curve 115
Multiple Linear Regression 115
LINEST 116
Analysis T oolPak 117
Linear Regression with Polynomials 118
Summary · 122
Problems 123
Equilibrium, Activity and Solving Equations
A Quadratic Equation Solver
Using Excel to Iterate
Using Excel’s Solver
Solving a Cubic Equation
Solving a Quartic Equation
Exploring the Ionic Strength Dilemma
An Iterative Solution
Using Solver to Obtain the Solution Directly
Summary
Problems
132
132
134
136
141
143
143
144
148
151
151
։v
© 2014 Cengage Learning All Rights Reserved. May not be scanned, copied or duplicated, or posted-to a publicly accessible website, in whole or in part.
CHAPTER 6 The Systematic Approach to Equilibria: Solving Many
Equations 155
Using Solver for Complex Equilibrium Problems 156
Finding the Concentrations Simultaneously
with Solver 156
Finding A Single Concentration with Solver 158
Goal Seek 160
What is Goal Seek and How Does it Work? 160
Finding the Solubility of Mg(OH)2
with Goal Seek 160
Solving Simultaneous Linear Equations 163
Method of Determinants 164
Matrix Operations 167
Systems with Large Numbers of Equations
and Unknowns 169
Some Additional Examples of Equilibrium Problems 170
Solubility at a Fixed pH 170
Solubility When the pH is Unknown 173
Summary 175
Problems 176
CHAPTER 7 Neutralization Titrations and Graphical Representations 179
Calculating and Plotting a Strong Acid/Strong Base
Titration Curve 179
Stoichiometric Method 179
Using the Charge-Balance Equation 186
Weak Acid-Strong Base Titrations 188
Stoichiometric Method 189
P *
Master Equation Approach 193
Distribution of Species: a Plots 197
Derivative Plots 199
First Derivative Plot 200
Second Derivative Plot 203
Producing a Combination PL 206
Gran Plots 208
Summary 210
Problems . 211
CHAPTER 8 Polyfunctional Acids and Bases 214
Distribution Diagrams 214
A General Expression for a Values 214
Diprotic Acid System 215
What About Bases? 217
Logarithmic Concentration Diagrams 218
Estimating Concentrations at a Given pH Value 221
Finding pH Values 221
Titration Curves for Weak Acids 223
Stoichiometric Method 223
Alpha Values During a Titration 230
An Inverse Master Equation Approach 232
Titration Curves for Difunctional Bases 237
Amphiprotic Species, Amino Acids, and the
Isoelectric Point 239
Summary 242
Problems 243
v
© 2014 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
/
CHAPTER 9 Complexometric and Precipitation Titrations 247
Complexation Equilibria 247
a-Values for Complexes 248
Inverse Master Equations for Complexometric
Titrations 252
Ligands that Protonate 254
Complexation Reactions with Protonating
Ligands 255
Conditional Formation Constants 255
EDTA: A Ubiquitous Ligand 256
EDTA as a Tetraprotic Acid 256
Titrating EDTA with Base 259
Titrating Metals with EDTA 260
Stoichiometric Approach 261
• Inverse Master Equation Approach 264
Precipitation Titrations 267
Stoichiometric Method 267
Direct Master Equation Approach 272
Calculation of Volumes Needed to Produce
a Given pAg 274
Summary 277
Problems 278
CHAPTER 10 Potentiometry and Redox Titrations 282
Calculating Electrode Potentials 282
Cell Potentials and Equilibrium Constants 284
a-Values for Redox Species 285
Redox Titrations * 289
Stoichiometric Method 289
Inverse Master Equation Approach 291
, Calculating System Potentials from the
Master Equation 293
A More Complex Titration Example 294
Summary 296
Problems 297
CHAPTER 11 Dynamic Electrochemistry 300
Controlled-Potential Coulometry 300
Basic Principles 300
Numerical Integration 301
Coulometric Titrations 306
Voltammetry 310
Voltammetric Determination 310
Determination of Half-Wave Potentials 311
Determination of Formation Constant and
Formula of a Complex 313
Amperometric Titrations 314
Summary 318
Problems 320
vi
© 2014 Cengage I ֊earning All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part
CHAPTER 12 Spectrochemical Methods 325
Beer’s Law 325
Absorptivity 326
Deviations from Beer’s Law 327
Precision of Absorption Measurements 333
Calibration Methods 336
External Standard Methods 336
Adding Error Bars to a Chart 338
Standard Additions Methods 340
Weighted Linear Regression 341
Multicomponent Methods 347
Iteration 348
Method of Determinants 350
Matrix Methods 352
Spectrophotometric Titrations 352
Spectrophotometric Study of Complex Ions 356
Method of Continuous Variations 357
Producing Charts with Insets 358
Summary 359
Problems 360
CHAPTER 13 Kinetic Methods 368
Rate Laws for Simple Reactions 368
Comparing First- and Second-Order Reactions 368
Determining Reaction Orders 371
Pseudo First-Order Systems 374
Enzyme-Catalyzed Reaction 379
Linear Transformation 379
Nonlinear Regression Approach 382
Kinetic Methods of Analysis 385
Summary 389
Problems 390
CHAPTER 14 Chromatography 394
Chromatographic Terminology and Basic Equations 394
Simulating a Chromatogram 397
F inding the Number of Plates to Achieve a Given
Resolution 400
Nonideal Peak Shapes 401
Optimizing Chromatographic Methods: van Deemter
Equation 404
Van Deemter Plots 404
Using Solver to Find van Deemter Coefficients 406
Quantitative Chromatography 409
Method of External Standards 410
Internal Standard Method 411
Summary 413
Problems 415
vii
© 2014 Cengage Learning, All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part
CHAPTER 15 Electrophoresis and Other Separation Methods 419
Resolution of Overlapped Gaussian Peaks 419
Electrophoresis 423
Determining Mobilities of Inorganic Ions 424
Determining the pKa Values of Weak Acids 427
Micellar Electrokinetic Capillary Chromatography 430
Summary 433
Problems 434
CHAPTER 16 Data Processing with Excel 436
Smoothing of Data 436
Generating Noise 437
Moving Average Smoothing 439
Exponential Moving Averages 442
Savitzky-Golay Smoothing 444
Feature Removal and Enhancement 446
Feature Removal 447
Feature Enhancement 449
Recursive Estimation Methods 453
Summary 458
Problems 459
vm
© 2014 Cengage Learning. All Rights Reserved. May not be scanned, Copied or duplicated, or posted to a publicly accessible website, in whole or in
|
| any_adam_object | 1 |
| author | Crouch, Stanley R. 1940- Holler, F. James |
| author_GND | (DE-588)138623384 (DE-588)1045691720 |
| author_facet | Crouch, Stanley R. 1940- Holler, F. James |
| author_role | aut aut |
| author_sort | Crouch, Stanley R. 1940- |
| author_variant | s r c sr src f j h fj fjh |
| building | Verbundindex |
| bvnumber | BV042758577 |
| classification_rvk | VC 6050 VC 6400 |
| ctrlnum | (OCoLC)855888837 (DE-599)GBV776763466 |
| dewey-full | 543.028553682 |
| dewey-hundreds | 500 - Natural sciences and mathematics |
| dewey-ones | 543 - Analytical chemistry |
| dewey-raw | 543.028553682 |
| dewey-search | 543.028553682 |
| dewey-sort | 3543.028553682 |
| dewey-tens | 540 - Chemistry and allied sciences |
| discipline | Chemie / Pharmazie |
| edition | 2. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01880nam a2200469 c 4500</leader><controlfield tag="001">BV042758577</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160427 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">150813s2014 ad|| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2013444352</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781285087955</subfield><subfield code="c">pbk.</subfield><subfield code="9">978-1-285-08795-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">128508795X</subfield><subfield code="c">pbk.</subfield><subfield code="9">1-285-08795-X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)855888837</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV776763466</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-703</subfield><subfield code="a">DE-19</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">543.028553682</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">VC 6050</subfield><subfield code="0">(DE-625)147081:253</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">VC 6400</subfield><subfield code="0">(DE-625)147091:253</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Crouch, Stanley R.</subfield><subfield code="d">1940-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)138623384</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Applications of Microsoft Excel in analytical chemistry</subfield><subfield code="c">Stanley R. Crouch ; F. James Holler</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Belmont, CA [u.a.]</subfield><subfield code="b">Brooks/Cole, Cengage Learning</subfield><subfield code="c">2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">VIII, 461 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Datenverarbeitung</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Analytische Chemie</subfield><subfield code="0">(DE-588)4129906-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Chemometrics</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Chemistry, Analytic -- Data processing</subfield></datafield><datafield tag="653" ind1=" " ind2=" "><subfield code="a">Electronic spreadsheets -- Computer programs</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Analytische Chemie</subfield><subfield code="0">(DE-588)4129906-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Holler, F. James</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1045691720</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028189153&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028189153</subfield></datafield></record></collection> |
| id | DE-604.BV042758577 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T07:08:57Z |
| institution | BVB |
| isbn | 9781285087955 128508795X |
| language | English |
| lccn | 2013444352 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028189153 |
| oclc_num | 855888837 |
| open_access_boolean | |
| owner | DE-703 DE-19 DE-BY-UBM |
| owner_facet | DE-703 DE-19 DE-BY-UBM |
| physical | VIII, 461 S. Ill., graph. Darst. |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Brooks/Cole, Cengage Learning |
| record_format | marc |
| spelling | Crouch, Stanley R. 1940- Verfasser (DE-588)138623384 aut Applications of Microsoft Excel in analytical chemistry Stanley R. Crouch ; F. James Holler 2. ed. Belmont, CA [u.a.] Brooks/Cole, Cengage Learning 2014 VIII, 461 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Datenverarbeitung Analytische Chemie (DE-588)4129906-1 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf Microsoft Excel (Computer file) Chemometrics Chemistry, Analytic -- Data processing Electronic spreadsheets -- Computer programs Analytische Chemie (DE-588)4129906-1 s EXCEL (DE-588)4138932-3 s DE-604 Holler, F. James Verfasser (DE-588)1045691720 aut Digitalisierung UB Bayreuth - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028189153&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Crouch, Stanley R. 1940- Holler, F. James Applications of Microsoft Excel in analytical chemistry Datenverarbeitung Analytische Chemie (DE-588)4129906-1 gnd EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4129906-1 (DE-588)4138932-3 |
| title | Applications of Microsoft Excel in analytical chemistry |
| title_auth | Applications of Microsoft Excel in analytical chemistry |
| title_exact_search | Applications of Microsoft Excel in analytical chemistry |
| title_full | Applications of Microsoft Excel in analytical chemistry Stanley R. Crouch ; F. James Holler |
| title_fullStr | Applications of Microsoft Excel in analytical chemistry Stanley R. Crouch ; F. James Holler |
| title_full_unstemmed | Applications of Microsoft Excel in analytical chemistry Stanley R. Crouch ; F. James Holler |
| title_short | Applications of Microsoft Excel in analytical chemistry |
| title_sort | applications of microsoft excel in analytical chemistry |
| topic | Datenverarbeitung Analytische Chemie (DE-588)4129906-1 gnd EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Datenverarbeitung Analytische Chemie EXCEL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028189153&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT crouchstanleyr applicationsofmicrosoftexcelinanalyticalchemistry AT hollerfjames applicationsofmicrosoftexcelinanalyticalchemistry |