research

Using spreadsheets to discover meaning for parameters in nonlinear models

Abstract

Using spreadsheets one can develop an exploratory environment where mathematics students can develop their own understanding of the relationship between the parameters of commonly encountered families of functions (linear, logarithmic, exponential and power) and a natural interpretation of “rate of change” for those functions. The key to this understanding involves expanding the concept of rate of change to include percent changes. Through the use of the spreadsheet model, students can explore and easily determine which type of change is most natural for a given family of functions. This, in turn, provides a mechanism for interpreting the parameters of the function numerically, rather than graphically, as is common

    Similar works