13. Mathematical Methods for Spreadsheet Calculations

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch13

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Mathematical Methods for Spreadsheet Calculations, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch13

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • spreadsheet calculations;
  • table lookup;
  • interpolation;
  • linear interpolation;
  • determinants

Summary

This chapter contains sections titled:

  • Interpolation

  • Arrays, Matrices and Determinants

  • Numerical Differentiation

  • Numerical Integration

  • Finding Roots of Equations

  • Solving Sets of Simultaneous Linear Equations

  • Polar to Cartesian Coordinates

  • Significant Figures