Finite Math Lab Assignments
Lab assignments are available below. The labs are intended for use with the
Excel spreadsheet. Podcasts are available that
illustrate ideas from many of the assignments.
Currently the labs are being revised to make them independent of the version of
Excel (2003 or 2007). Future plans are to make versions available for OpenOffice and Google
Spreadsheet Docs. For users of versions of Word or Excel prior to 2007 the Microsoft Office Compatibility
Pack can be
downloaded
to use files in the 2007 format.
(Last update, 8/15/10)
- Lab #1 Algebra and graphing
- Lab #2 Financial models: compounding
- Lab #3 Financial models: Annuities
- Lab #4 Financial models: loans and amortization schedules
- Lab #5 Simulation and resampling
- Lab #6 Probability
- Lab #7 Representing data by distributions and charts
- Lab #8 Means of distributions
- Lab #9 Variability of data
- Lab #10a Normal distributions - basic calculations
- Lab #10b Normal distributions - application to risk analysis