Free download How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis By Robert de Levie

Authors of: How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis By Robert de Levie

Robert de Levie

Table of Contents in How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis By Robert de Levie

Preface  

part i introduction to using the spreadsheet

1 How to use Excel  

1.1 Starting Windows  

1.2 A first look at the spreadsheet  

1.3 A simple spreadsheet and graph  

1.3a Making a graph in Excel 97 or a more recent version  

1.3b Making a graph in Excel 5 or Excel 95  

1.4 Addressing a spreadsheet cell  

1.5 More on graphs  

1.6 Mathematical operations  

1.7 Error messages  

1.8 Naming and annotating cells  

1.9 Viewing the spreadsheet  

1.10 Printing  

1.11 Help!  

1.12 The case of the changing options  

1.13 Importing macros and data  

1.14 Differences between the various versions of Excel  

1.15 Some often-used spreadsheet commands  

1.16 Changing the default settings  

1.17 Summary part ii statistics and related methods

2 Introduction to statistics  

2.1 Gaussian statistics  

2.2 Replicate measurements  

2.3 The propagation of imprecision from a single parameter  

2.4 The propagation of imprecision from multiple parameters  

2.5 The weighted average  

2.6 Least-squares fitting to a proportionality  

2.7 Least-squares fitting to a general straight line  

2.8 Looking at the data  

2.9 What is ‘normal’?  

2.10 Poissonian statistics  

2.11 How likely is the improbable?  

2.12 Summary  

3 More on least squares  

3.1 Multi-parameter fitting  

3.2 Fitting data to a quadratic  

3.3 Least squares for equidistant data: smoothing and differentiation  

3.4 Weighted least squares  

3.5 Another example of weighted least squares: enzyme kinetics  

3.6 Non-linear data fitting  

3.6a Some kinetic data  

3.6b A double exponential  

3.6c False minima  

3.6d Enzyme kinetics revisited  

3.6e SolverAid  

3.7 Summary  

part iii chemical equilibrium

4 Acids, bases, and salts  

4.1 The mass action law and its graphical representations  

4.2 Conservation laws, proton balance, and pH calculations  

4.3 Titrations of monoprotic acids and bases  

4.4 Schwartz and Gran plots  

4.5 The first derivative  

4.6 A more general approach to data fitting  

4.7 Buffer action  

4.8 Diprotic acids and bases, and their salts  

4.9 Polyprotic acids and bases, and their salts  

4.10 Activity corrections  

4.11 A practical example  

4.12 Summary  

5 Other ionic equilibria  

5.1 Complex formation   

5.2 Chelation  

5.3 Extraction  

5.4 Solubility  

5.5 Precipitation and dissolution  

5.6 Precipitation titrations  

5.7 The von Liebig titration  

5.8 The graphical representation of electrochemical equilibria  

5.9 Redox titrations  

5.10 Redox buffer action  

5.11 Summary  

part iv instrumental methods

6 Spectrometry, chromatography, and voltammetry  

6.1 Spectrometric pKa determination  

6.2 Multi-component spectrometric analysis 1  

6.3 Multi-component spectrometric analysis 2  

6.4 The absorbance–absorbance diagram  

6.5 Chromatographic plate theory 1  

6.6 Chromatographic plate theory 2  

6.7 Peak area, position, and width  

6.8 Determining the number of theoretical plates  

6.9 Optimizing the mobile phase velocity  

6.10 Polarography  

6.11 Linear sweep and cyclic voltammetry 1  

6.12 Linear sweep and cyclic voltammetry 2  

6.13 Summary  

part v mathematical methods

7 Fourier transformation  

7.1 Introduction to Fourier transformation  

7.2 Interpolation and filtering  

7.3 Differentiation  

7.4 Aliasing and leakage  

7.5 Convolution  

7.6 Deconvolution  

7.7 Summary  

8 Standard mathematical operations  

8.1 The Newton–Raphson method  

8.2 Non-linear least squares  

8.3 Signal averaging   

8.4 Lock-in amplification  

8.5 Data smoothing  

8.6 Peak fitting  

8.7 Integration  

8.8 Differentiation  

8.9 Semi-integration and semi-differentiation  

8.10 Interpolation  

8.11 Matrix manipulation  

8.12 Overflow  

8.13 Summary  

9 Numerical simulation of chemical kinetics  

9.1 Introduction  

9.2 The explicit method  

9.2a First-order kinetics  

9.2b Numerical accuracy  

9.2c Dimerization kinetics  

9.2d A user-defined function to make the spreadsheet more efficient  

9.2e Trimerization kinetics  

9.2f Monomer–dimer kinetics  

9.2g Polymerization kinetics  

9.3 Implicit numerical simulation  

9.3a First-order kinetics  

9.3b Dimerization kinetics  

9.3c Trimerization kinetics  

9.3d Monomer–dimer kinetics  

9.3e Polymerization kinetics  

9.4 Some applications  

9.4a Autocatalysis  

9.4b Heterogeneous catalysis  

9.4c The steady-state approximation  

9.4d Oscillating reactions: the Lotka model  

9.5 Summary  

part vi spreadsheet programming

10 Some useful macros  

10.1 What is a macro?  

10.1a The macro module  

10.1b Reading and modifying the contents of a single cell  

10.1c Reading and modifying the contents of a block of cells  

10.1d Two different approaches to modifying a block of cells  

10.1e Numerical precision   

10.1f Communication via boxes  

10.1g Subroutines  

10.2 A case study: interpolating in a set of equidistant data  

10.2a Step-by-step  

10.2b The finished product  

10.3 Propagation of imprecision  

10.4 Installing and customizing a macro  

10.4a Installing external macros  

10.4b Assigning a shortcut key  

10.4c Embedding in a menu  

10.4d Miscellany  

10.5 Fourier transformation  

10.5a Forward Fourier transformation  

10.5b Descriptive notes  

10.5c A bidirectional Fourier transformation macro  

10.6 Convolution and deconvolution  

10.7 Weighted least squares  

10.7a The algorithm  

10.7b Implementation  

10.8 More about Solver  

10.8a Adding uncertainty estimates to Solver  

10.8b Incorporating Solver into your macro  

10.9 Smoothing and differentiating equidistant data  

10.10 Semi-integration and semi-differentiation  

10.11 Reducing data density  

10.12 An overview of VBA  

10.12a Objects  

10.12b Properties and methods  

10.12c Data types  

10.12d Expressions  

10.12e Statements  

10.12f Active regions  

10.12g Cells  

10.12h Ranges  

10.12i Subroutines  

10.12j Macros  

10.12k Functions  

10.12l Message boxes  

10.12m Input boxes  

10.12n Dialog boxes  

10.12o Collective statements  

10.12p For…Next loops  

10.12q Do loops   

10.12r Conditional statements  

10.12s Exit statements  

10.13 Summary  

Index

File Size: 10.7 MB. Pages: 501 Please read Disclaimer.

Free download How to Use Excel in Analytical Chemistry and in General Scientific Data Analysis By Robert de Levie

Download Link

You may also like to download “Analytical And Physical Electrochemistry By Hubert H. Girault”.

Free download hundreds of chemistry books in pdf from HERE.

Please Subscribe to our Email list and get notified of our latest uploads (Books, documents) and new updates. Email Subscription Box is provided on the sidebar (for PC) and on the bottom of this post (for Android Devices).

Kindly Like, Follow, and Share our social media pages so that the maximum number of people can benefit from this public service!

Facebook   Instagram    LinkedIn    Twitter    Pinterest

P.S: If the download link(s) is/are not working, kindly drop a comment below, so we’ll update the download link for you.

Happy reading!