How to use Excel in analytical chemistry and in general scientific data analysis / Robert de Levie.
De Levie, Robert.
How to use Excel in analytical chemistry and in general scientific data analysis / Excel in analytical chemistry Robert de Levie. - Cambridge ; New York : Cambridge University Press, 2001. - xiv, 487 p. : ill. (some col.) ; 26 cm.
Includes index.
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.
0521642825 0521644844 (pbk.)
Ingeniería química--Proceso de datos
Quimiometría
Química analítica--Proceso de datos
Chemistry, Analytic--Statistical methods--Data processing.
Science--Statistical methods--Data processing.
Electronic spreadsheets.
How to use Excel in analytical chemistry and in general scientific data analysis / Excel in analytical chemistry Robert de Levie. - Cambridge ; New York : Cambridge University Press, 2001. - xiv, 487 p. : ill. (some col.) ; 26 cm.
Includes index.
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.
0521642825 0521644844 (pbk.)
Ingeniería química--Proceso de datos
Quimiometría
Química analítica--Proceso de datos
Chemistry, Analytic--Statistical methods--Data processing.
Science--Statistical methods--Data processing.
Electronic spreadsheets.