Investors are interested in the volatility of a stock for various reasons. One investor may desire to purchase a low volatility stock for peace of mind. Another may be interested in a high volatility stock in order to have the opportunity to buy low and sell high as the price of the stock oscillates. This author had the fortunate timing of reading…

If larger and larger samples are successively drawn from a population and a running average calculated after each sample has been drawn, the sequence of averages will converge to the mean, [mu], of the population. This remarkable fact, known as the law of large numbers, holds true if samples are drawn from a population of discrete or continuous…

Presents an example from probability and statistics that ties together several topics including the mean and variance of a discrete random variable, the binomial distribution and its particular mean and variance, the sum of independent random variables, the mean and variance of the sum, and the central limit theorem. Uses Excel to illustrate these…

Indicates the importance of teaching discrete mathematics. Describes how the use of technology can enhance the teaching and learning of discrete mathematics. Explorations using Excel, Derive, and the TI-92 proved how preservice and inservice teachers experienced a new dimension in problem solving and discovery. (ASK)

Explores the relative strengths and weaknesses of the spreadsheet approach versus specialized mathematical programming software for solving a particular logic puzzle. (KHR)

Described is a classroom activity incorporating a computer spreadsheet to study number patterns generated by the Fibonacci sequence. Included are examples and suggestions for the use of the spreadsheet in other recursive relationships. (JJK)

A current project for the Allegany College of Maryland Mathematics Department is using spreadsheets in some of their General Education Mathematics courses. It is important to note that one of the key features of this project is that is does not require an introductory computer course as a prerequisite for any of the mathematics courses that will…

During the years 2000-2003, a course on Exploring Quantitative Relationships (EQR) was created at Queens College under the support of the U.S. Department of Education Fund for the Improvement of Post-Secondary Education (DOE-FIPSE Grant No. P116B000772). Exploratory in nature, the course goals were to acquaint liberal arts students with…

Presents a simple method for estimating the volatility of stock prices and uses a spreadsheet to apply the method to actual stock prices. This method is an application of parameter estimation and can be used in an introductory statistics course. (KHR)

The Optimizer in Quattro Pro and the Solver in Excel software programs make solving linear and nonlinear optimization problems feasible for business mathematics students. Proposes ways in which the Optimizer or Solver can be coaxed into solving systems of linear equations. (ASK)