Excel Toolbox

The Computer Toolbox: Spreadsheeting

All programs listed below employ Microsoft Excel Version 5.0 unless otherwise listed

Tutorial (Requires Adobe Acrobat Reader Version 3.0)

Spreadsheet (Microsoft Office '97 Version)

Tutorial: EXCEL v. 5.0 (Requires Adobe Acrobat Reader Version 3.0)

Tutorial: EXCEL: Windows '97 v. (Requires Adobe Acrobat Reader Version 3.0)

Linear Regression: Finding the Slope and Intercept for the Best-Fit Straight Line to Data (Dr. Hayes)

Tutorial (Requires Adobe Acrobat Reader Version 3.0)

Curve-Fitting Data With a Polynomial Equation (Features the Excel Matrix Function 'Linest') (Dr. Hayes)

Tutorial (Requires Adobe Acrobat Reader Version 3.0)

Tutorial (Requires Adobe Acrobat Reader Version 4.0)

Spreadsheet (MS Excel '97)

Template for Blank Log-Log and Semilog Graphing Paper (spreadsheet)

Calculating the Average Molecular Weight of a hydrocarbon gas mixture (spreadsheet) (Dr. Hayes)

Solving a System of Linear Algebraic Equations using Excel's Matrix Functions (spreadsheet) (Dr. Hayes)

Estimating the Volume of a Real Gas given its Temperature, Pressure, and Identity (Ideal Gas Law, Compressibility Factor Equation of State, and the Soave-Redlich-Kwong Equation..trial and error procedure) (spreadsheet) (Dr. Hayes)

October 26, 2001