### Mathematics with Spreadsheets

Bahram Golshan

Lycoming College

Williamsport PA 17701

Phone: (717) 321-4277

E-mail: golshan@lycoming.edu

#### ABSTRACT

Most institutions would not justify offering a spreadsheet course void of any
real applications. Although most people think of a spreadsheet as a number
crunching and charting tool, today's spreadsheets are at home in variety of
other mathematical concepts. With the most recent spreadsheets such as
Microsoft Excel, one can perform tasks such as finding the maximum and
minimum of functions, approximating roots of equations, and approximating
solutions of systems of equations. In addition, they can be used to study
polynomials, normal and discrete probability distribution functions, linear
programming, binomial expansions, and amortization.
The paper details some sections from my freshmen level course notes which
is designed to teach Microsoft Excel in the context of mathematical
applications and problems. The course is designed so that it can be
used as a general mathematics distribution fulfillment. Examples shown
include, approximating roots of a polynomials, and "visually" proving
trigonometric identities such as sin (PI/2 - x ) = cos x.