If you are interested in receiving gratis any, or all, of these files for the DIGMath spreadsheets and the copies of the recent articles for your personal use or to provide to your students, please feel free to contact me at the e-mail address at the very top of this page.
DIGMath Software Packages
- Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Simulations for Statistics and Probability in Excel
- Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for College Algebra and Precalculus in Excel
- Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for Calculus in Excel
- Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for Numerical Analysis in Excel
Books
- Functions, Data, and Models: An Applied Approach to College Algebra (co-author), MAA Textbooks, Mathematical Association of America, 2010.
- A Fresh Start for Collegiate Mathematics: Rethinking the Courses Below Calculus, (co-editor), Nancy Baxter Hastings, et al., Eds., MAA Notes #69, Mathematical Association of America, 2006.
- Functioning in the Real World: A PreCalculus Experience, (principal author), Math Modeling/ PreCalculus Reform Project, Addison-Wesley, 2004.
- Contemporary Statistics: A Computer Approach, textbook and software package (co-author), McGraw- Hill, 1994.
- Calculus, The Harvard Core Calculus Consortium (co-author), Wiley, 1998.
- Calculus: Single and Multivariable, The Harvard Core Calculus Consortium (co-author), Wiley, 1998.
- Multivariable Calculus, The Harvard Core Calculus Consortium (co-author), Wiley, 1997.
- Calculo, Spanish translation of Calculus, 1st Edition, by Hughes Hallett, Gleason, Gordon, et al., Mexico City, Mexico, 1996.
- Calculo, Portuguese translation of Calculus, 1st Edition, by Hughes Hallett, Gleason, Gordon, et al., Sao Paulo, Brazil.
- Calculo de Varias Variaveis, Portuguese translation of Multivariable Calculus, 1st Edition, by McCallum, Hughes Hallett, Gleason, Gordon, et al., Sao Paulo, Brazil.
- Applied Calculus for Business, Economics and Biology, The Harvard Core Calculus Consortium (co-author), Wiley, 1996.
- Brief Calculus for Business, Economics and Biology, The Harvard Core Calculus Consortium (co-author), Wiley, 1997.
- Statistics for the Twenty First Century, MAA Notes #26, 1992.
- Calculus: The Dynamics of Change, (co-editor), Wayne Roberts, et al., Eds., MAA Notes, 1996.
- Calculus and the Computer, Prindle, Weber & Schmidt, 1986.
Articles
- Visualizing and Understanding Optimization Problems Using Dynamic Software, Int'l J. of Technology in Mathematics Education, 2019, (to appear).
- Visualizing and Understanding Sampling Distributions Using Dynamic Software, (with Florence Gordon), Int'l J. of Technology in Mathematics Education, 2019.
- Using Secant Parabolas for Root Finding, (with Yajun Yang), The Mathematics Teacher, 2018).
- Visualizing and Understanding Regression and Correlation using Dynamic Software, (with Florence Gordon), Int'l J. of Technology in Mathematics Education, 2018.
- Approximating Sinusoidal Functions Using Lagrange Interpolation, (with Yajun Yang), The MathAMATYC Educator, 2018.
- Visualizing and Understanding Hypothesis Testing Using Dynamic Software, (with Florence Gordon), PRIMUS, 2018.
- Visualizing and Understanding l'Hopital's Rule, Int'l J of Math Education in Science and Technology, 2017.
- Approximating Exponential and Logarithmic Functions with Lagrange Interpolating Polynomials, (with Yajun Yang), Int'l J of Math Education in Science and Technology, 2017).
- Visualizing and Understanding Confidence Intervals Using Dynamic Software, (with Florence Gordon), Math and Computer Education, 2016.
- Taking Your Chances on Excel.
- Taking Control of Excel, Math and Computer Education, 2016.
- Visualizing the Components of Lagrange and Newton Interpolation (with Yajun Yang), PRIMUS, 2015.
- Curve Fitting and Lagrange Interpolation, (with Yajun Yang).
- Deriving Simpson's Rule Using Newton Interpolation, (with Yajun Yang), Math and Computer Education, (to appear).
- Functioning in Excel, Math and Computer Education, 2016.
- The Flavor of a Modeling Based College Algebra or Precalculus Course, UMAP Journal, 2016.
- Finding the Complex Roots of Polynomials, The MathAMATYC Educator, 2016.
- Visualizing Techniques of Integration, Math and Computer Education, 2015.
- Numerical Integration - One Step at a Time, (with Yajun Yang), PRIMUS, 2016.
- How Rational is the Tangent Function, The MathAMATYC Educator, 2015.
- Using Quartile-Quartile Lines as Linear Models, PRIMUS, 2015.
- Approximating Sinusoidal Functions with Interpolating Polynomials, (with Yajun Yang).
- Finding Polynomial Patterns and Newton Interpolation, (with Yajun Yang), Math and Computer Education, 2014.
- Developing a Mathematics Curriculum for the Biosciences, (with Matthew Bahamonde, Sarah Gross, Carlos Marques, Irina Neymotin, Jack Winn), (to appear).
- How Rational is a Logarithmic Function, Math and Computer Education, 2014.
- Subdivisions for Definite Integrals with Uniform Spacing, Math and Computer Education, 2014.
- Interpolation and Polynomial Curve Fitting (with Yajun Yang), The Mathematics Teacher, 2014.
- The Geology of Mathematics, Guest Editorial, UMAP Journal, 2014.
- Integrating Statistics into College Algebra to Meet the Needs of Biology Students, (with Florence Gordon), in Undergraduate Mathematics for the Life Sciences: Processes, Models, Assessment, and Directions, MAA Notes, 2013.
- Investigating Convergence Patterns for Numerical Methods Using Data Analysis, PRIMUS 2013.
- Adding A New Dimension to Mathematics, The Mathematics Teacher, 2013.
- Mathematics Education Must Evolve, Math and Computer Education, 2013.
- Fitting Tangent Functions to Data, Math and Computer Education, 2013.
- Time, Tides, and Temps Wait for All Students The MathAMATYC Educator, 2013.
- Some Surprising Errors in Numerical Differentiation, PRIMUS, 2012.
- Algebra Must Evolve, Vision - Potential: College Algebra Newsletter, 2012.
- Building on Errors in Numerical Integration, Math & Computer Education, 2011.
- Introducing Functions of Several Variables in Lower Division Courses, MathAMATYC Educator, 2011.
- Placement Testing: The Great Abyss, Vision -- Potential, 2011.
- Errors in Mathematics are Not Always Bad, The Mathematics Teacher, 2011.
- Finding the Best Quadratic Fit to a Function (with Yajun Yang), Int'l J. of Mathematics Education in Science and Technology, 2011.
- Exposing the Mathematical Wizard: Approximating Trigonometric and Other Transcendental Functions, The Mathematics Teacher, 2011.
- Intermediate Algebra in High School vs. College, Vision - Potential: College Algebra Newsletter, 2011.
- The Average Distance in an Ellipse, Math and Computer Education, 2010.
- The State of Mathematics Education Today: What Happens in the Classroom, J of Economics and Finance, 2010.
- What the Partner Disciplines Want from College Algebra, Vision - Potential: College Algebra Newsletter, 2010.
- The Status and Purpose of College Algebra, Vision - Potential: College Algebra Newsletter, 2010.
- The Statistics of a Function (with Florence Gordon), International J. of Mathematics Education in Science and Technology, 2010.
- Mathematics for the Laboratory Sciences, MathAMATYC Educator (premier issue), 2009.
- Visualizing and Understanding Probability and Statistics: Graphical Simulations Using Excel, (with Florence Gordon), PRIMUS, 2009.
- Doubling Time for Non-Exponential Families of Functions The Mathematics Teacher, 2009.
- Modeling Population Growth and Extinction PRIMUS, 2009.
- The Curriculum Foundations Project in Mathematics and Economics, (with Richard Vogel), MAA Focus, 2009.
- What's Wrong with College Algebra?, PRIMUS, 2008.
- A Tale of Two Students, PRIMUS, 2008.
- Taylor Approximations and Definite Integrals, PRIMUS, 2007.
- Using the Sum of the Squares, (with Florence Gordon), Mathematics and Computer Education, 2008.
- Finding the Best Linear Approximation to a Function (with Yajun Yang), Mathematics and Computer Education, 2008.
- Comparing the Continuous and Discrete Logistic Models, PRIMUS, 2008.
- College Algebra: Today's Students, Tomorrow's Courses, MAA Focus, 2008.
- Discovering the Fundamental Theorem of Calculus using Data Analysis, (with Florence Gordon), The Mathematics Teacher, 2007.
- Placement: The Shaky Bridge between School and College Mathematics, (college version), Placement and Assessment Newsletter, AMATYC, 2006
- Fitting Surge Functions to Data, PRIMUS, 2007.
- When Does a Curve Bend Most Rapidly: The Curvature Function of a Function (with Loucas Chrysafi), Mathematics and Computer Education, 2006.
- Placement: The Shaky Bridge between School and College Mathematics, The Mathematics Teacher, 2006.
- What Does Conceptual Understanding Mean? The AMATYC Review, 2006.
- Interconnected Quantitative Learning at Farmingdale State University, (with Jack Winn), in Models of Quantitative Literacy, Rick Gillman, ed, MAA Notes, 2006.
- Approximating Functions with Exponential Functions, PRIMUS, 2006.
- Rethinking Placement in Mathematics, AMATYC Committee on Articulation and Placement Newsletter, 2006.
- Preparing Students for Calculus in the Twenty First Century, in A Fresh Start for Collegiate Mathematics: Rethinking the Road Toward Calculus, Nancy Baxter Hastings, Ed., MAA Notes, 2006.
- The Need to Rethink Placement in Mathematics, in A Fresh Start for Collegiate Mathematics: Rethinking the Road Toward Calculus, Nancy Baxter Hastings, Ed., MAA Notes, 2006.
- Where Do We Go From Here: Forging a National Initiative to Refocus the Courses Below Calculus, in A Fresh Start for Collegiate Mathematics: Rethinking the Road Toward Calculus, Nancy Baxter Hastings, Ed., MAA Notes, 2006.
- The Functioning in the Real World Project, in A Fresh Start for Collegiate Mathematics: Rethinking the Preparation for Calculus, Nancy Baxter Hastings, Ed., MAA Notes, 2006.
- Discovering the Chain Rule Graphically, Mathematics and Computer Education, 2005.
- Developing a 2020 Vision for Mathematics Education, in Generating a Vision for Undergraduate Mathematics, Gary Krahn, Ed., West Point, 2005.
- What’s Wrong with College Algebra? SUNY/UUP Working Papers Discussion series.
- Deriving the Linear Regression Equations Using Algebra, Mathematics and Computer Education, 2004.
- Deriving the Quadratic Regression Equations Using Algebra, Mathematics and Computer Education, 2004.
- Taylor's Theorem and the Derivative Tests for Optima and Inflection Points, PRIMUS, 2004.
- Algebra for the New Millennium, Int'l J. of Computer Algebra in Math Education, 2004.
- An Individualized Term Project for Multivariate Calculus, PRIMUS, 2004.
- Mathematics for the New Millennium, in Proc, International Conference on Mathematics Education, Copenhagen, 2004.
- Grant Writing to Enhance Teaching and Learning, Teaching-Talk, 2002.
- Using Data Analysis to Motivate Derivative Formulas, Mathematics and Computer Education, 2002.
- Using Data Analysis to Discover the Fundamental Theorem of Calculus, PRIMUS, 2003.
- Refocusing the Courses Below Calculus, in Proc 13th Intl Conf on Tech in Collegiate Math, Addison-Wesley, 2003.
- Discovering New Trig Identities, The Mathematics Teacher, 2003.
- Rethinking the Preparation for Calculus (co-author), MAA FOCUS, 2002.
- The Implications of Hand-Held Computer Algebra System Calculators Throughout the Mathematics Curriculum (with Arlene Kleinstein), AMATYC Review, 2002.
- A Spoonful of Medicine Makes the Mathematics Go Down, The AMATYC Review, 2001.
- Renewing the Precursor Courses: New Challenges, Opportunities, and Connections, in Calculus Renewal: Issues for Undergraduate Mathematics Education in the Next Decade, Susan Ganter, Ed., Plenum Publishing, 2000.
- Mathematical Articulation in New York State: Smoothing the Mathematical Transitions of Students, MetroMath, 2000.
- Preparing Students Mathematically for the Twenty First Century, in Proc, Int' Conf. on Mathematics Education, Tokyo, 2000.
- Mathematics Education at Farmingdale State College (with Arlene Kleinstein, Jack Winn). in Proc Int'l Conf on Mathematics Education, 2000.
- Preparing Students Mathematically for the Twenty First Century, in Proc Int'l Conf on Mathematics Education, 2000.
- What Does Being a Good Math Student Mean?, in Technology in Mathematics Education, AMATYC, 2000.
- Revisiting Lanchester's Square Law for Military Stalemates, Math & Computer Education, 2000.
Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Simulations for Statistics and Probability in Excel
Most of the following graphical explorations require the use of macros to operate. In order to use these spreadsheets, Excel must be set to accept macros. To change the security setting on macros:
- When you open the spreadsheet, a new bar appears near the top of the window that says "Security Warning: Active content has been disabled".
- Click on Options.
- Click on "Enable this Content" and then click OK.
The following are the DIGMath explorations that are currently completed and ready for use. If you have any suggestions for improvements or for new topics, please pass them on also.
DIGMath Spreadsheets for Statistics and Probability |
---|
Fair Coin This DIGMath spreadsheet is a coin flipping simulation in which you have the choice of the number n of repetitions of flipping a fair coin. It shows both graphically and numerically the results of each fun of the simulation to let you visualize the shape of the distribution of outcomes and the associated likelihood (the probability) of each. |
Dice Role A dice rolling simulation in which the user can choose the number of roles of a pair of fair dice. |
Coin Flips A coin flipping simulation in which the user has the choice of the number of fair coins being flipped and the number of repetitions. |
Binomial Distribution This DIGMath module lets you investigate the binomial distribution based on n trials with a probability p of success. You can select values of n and p using sliders and the program draws the histogram for the corresponding binomial distribution. It also shows the mean and standard deviation of the distribution. |
Binomial Simulation This DIGMath spreadsheet is a simulation of binomial probabilities. You have the choice of the number of coins, the probability of success, and the number of repetitions. |
Binomial Probabilities This DIGMath module lets you investigate the probabilities associated with a binomial distribution. The spreadsheet covers six different cases, covering virtually al the standard kinds of problems with binomial probabilities. It will calculate and display the binomial probabilities of getting (1) exactly x successes in a binomial process with n trials with a probability p of success; (2) between two given numbers of successes; (3) at least a given number of successes; (4) more than a given number of successes; (5) at most a given number of successes; and (6) less than a given number of successes. In each case, you select values of n, p, and x using sliders and the program draws the histogram to show the corresponding binomial probability. |
Law of Large Numbers This DIGMath module lets you investigate the Law of Large Numbers -- what happens in the long run. You have the choice of the desired probability of success p and the number of repetitions n in a binomial experiment to see the pattern of successes over the long run. |
Chaos of Small Numbers The user has the choice of the desired probability of success and the number of repetitions (up to 25) to see the actual (simulated) outcomes and the cumulative frequency of success to demonstrate the unpredictable nature of the outcomes in the short run. |
The Effects of an Extra Point on the Mean and Standard Deviation This DIGMath module lets you investigate the effect that changing an additional point has on the values for the mean and the standard deviation (both graphically and numerically). The spreadsheet starts with a set of either 5, 10, or 20 points and you can change the value for an additional point to see how it affects the calculations and the extent of the changes depending on the number of points. |
Effect of an Extra Point on Statistics This DIGMath module lets you investigate the effects of an extra point on the mean, the median, the standard deviation, and the InterQuartile Range from two perspectives: depending on how close to or far from the center an extra point lies and depending on the size of the dataset. |
The Normal Distribution This DIGMath module lets you investigate the normal distribution with mean μ and standard deviation σ. You enter both parameters using sliders and the program draws the corresponding normal distribution curve. You can watch the effects of changing the parameter values on the resulting curve. |
Simulating the Normal Distribution This DIGMath spreadsheet lets you investigate the normal distribution in terms of a random simulation. You can enter, via sliders, values for the mean μ and standard deviation σ and then an interval of x-values from x-Min to x-Max. You can also select the number of random points you want in this normal distribution and the program will generate those points, plot them along with the graph of the normal distribution, and display graphically, with different colors, those that fall under the designated portion of the normal distribution curve and those that do not. The results are also shown numerically and compared to the theoretical values for the area under the normal curve. |
Normal Approximation to the Binomial Distribution This DIGMath program lets you investigate how well a normal distribution approximates the binomial distribution based on the parameters n and p. You enter the values for n and p via sliders and the program draws the histogram for the binomial distribution and the corresponding normal distribution curve using μ = np and σ = √np(1-p) to compare the two distributions. |
The Poisson Distribution This DIGMath spreadsheet lets you investigate two different aspects of the Poisson distribution that expresses the probability of a number of events occurring in a fixed period of time if these events occur with a known average rate and independently of the time since the last event. (1) The first looks at the shape of the Poisson distribution depending on its two parameters, the expected number of outcomes of an event in a given time period and the number of occurrences. You use a slider to vary the first parameters and see the effects on the shape of the distribution. (2) The second aspect is based on the idea that the Poisson distribution can be used to approximate the binomial distribution with probability of success p and number of trials n. Using sliders to change n and p, you can observe which combinations make for a good approximation and which do not. |
Central Limit Theorem Simulation The user can choose any of four underlying populations (normal, uniformly distributed, skewed, and bimodal), the sample size, and the number of random samples. The simulation randomly generates the samples and plots the means of each sample. From the graphical display and the associated numerical displays, it becomes apparent that (1) the distribution of sample means is centered very close to the mean of the underlying population, that (2) the spread in the sample means is a fraction of the standard deviation of the underlying population (about one-half as large when n = 4, about one-third as large when n = 9, about one-quarter as large when n = 16, etc.), so that students quickly conjecture that the formula for the standard deviation of the distribution of sample means is s/√n, and that (3) as the sample size increases, the sampling distribution looks more and more like a normal distribution. |
t-Distributions This DIGMath module lets you investigate the properties of the t-distribution based on various numbers of degrees of freedom from 2 up to 31. You enter the desired number of degrees of freedom and the program draws the corresponding t-distribution curve as well as the curves for d.f. = 1, d.f. = 11, and d.f. = 21 and the limiting normal distribution curve when d.f. = 31. |
Distribution of Sample Proportions The user chooses the probability of success π, the sample size n, and the number of random samples. The simulation randomly generates the samples, displays the corresponding proportion of successes, and displays the summary statistics. From these displays, the students quickly conjecture that (1) the mean of the distribution of sample proportions is equal to the proportion of successes in the underlying population, that (2) the simulated results with different values of the sample size n agree with the formula for the standard deviation of this sampling distribution, and that (3) the sampling distribution becomes more and more normal in appearance as the sample size increases. |
Sample Medians This DIGMath simulation is similar to the Central Limit Theorem Simulation, but with sample medians instead of sample means. |
Sample Midranges This DIGMath simulation is similar to the Central Limit Theorem Simulation, but with sample midranges instead of sample means. |
Sample Modes This DIGMath simulation is similar to the Central Limit Theorem Simulation, but with sample modes instead of sample means. |
Distribution of Sample Variances This DIGMath simulation is similar to the Central Limit Theorem Simulation, but instead of simulating sample means from a population, the program now generates and displays the sample variances. |
Distribution of Sample Standard Deviations This DIGMath simulation is similar to the Central Limit Theorem Simulation, but instead of simulating sample means from a population, the program now generates and displays the sample standard deviations. |
Sample IQR's This DIGMath simulation is similar to the Central Limit Theorem Simulation, but instead of simulating sample means from a population, the program now generates and displays the sample InterQuartile Ranges. The IQR is the difference between the first and third quartiles of a set of data and so represents a measure of the spread in the data. |
Distribution of Sample Skewnesses This is similar to the Central Limit Theorem Simulation, but instead of simulating sample means from a population, the program now generates and displays the sample skewnesses -- a measure of how far a set of values deviates from a symmetric distribution. |
Simulating Confidence Intervals The user has the choice of the same four underlying populations as in the Central Limit Theorem simulation (to see that the population does not affect the results) and the confidence level (90%, 95%, 98%, 99%), as well as the sample size n (from 10 to 50). The simulation generates random samples from the selected population, calculates and plots the corresponding confidence interval, and summarizes the number and percentage of confidence intervals that actually contain the mean of the underlying population. Students see that the actual (simulated) percentage is typically close to the selected value for the confidence level. They also see that typically the higher the confidence level, the longer the lines are that represent the actual confidence interval. They also see that typically those confidence intervals that do not contain the population mean are near-misses. |
Constructing Confidence Intervals for Means This DIGMath spreadsheet assists you in constructing a confidence interval for the mean of a population. You enter the sample data -- the sample size n, the sample mean, and the sample standard deviation, and select the level of confidence (90%, 95%, 98%, or 99%) you want. The spreadsheet constructs the corresponding confidence interval and displays it, as well as compares it in size, to the confidence intervals with other levels of confidence. |
Simulating Confidence Intervals for Proportions This DIGMath module simulates the notion of confidence intervals for the proportion of successes in a population. The user controls the choice of the population proportion for the underlying population, the confidence level (90%, 95%, 98%, 99%), and the sample size n. The simulation generates a fixed number of random samples from that population, calculates and plots the corresponding confidence interval, and summarizes the number and percentage of confidence intervals that actually contain the proportion of the underlying population. Students see that the actual (simulated) percentage is typically close to the selected value for the confidence level. They also see that typically the higher the confidence level, the longer the lines are that represent the actual confidence interval. They also see that, as the sample size increases, the lengths of the sample confidence intervals decrease and as the sample size decreases, the lengths of the confidence intervals increase. They also see that typically those confidence intervals that do not contain the population proportion are near-misses. |
Constructing Confidence Intervals for Proportions This DIGMath spreadsheet assists you in constructing a confidence interval for the proportion of a population. You enter the sample data -- the sample size n and the number of "successes" in that sample -- and select the level of confidence (90%, 95%, 98%, or 99%) you want. The spreadsheet constructs the corresponding confidence interval and displays it, as well as compares it in size, to the confidence intervals with other levels of confidence. |
Visualizing Confidence Intervals for the Mean This DIGMath spreadsheet helps you visualize what confidence intervals are for the mean of a population. You enter the sample data -- the sample size n, the sample mean, and the sample standard deviation, and select the level of confidence (90%, 95%, 98%, or 99%) you want. The spreadsheet constructs all four corresponding confidence interval and displays each of them so that you can compare their sizes, their centers, and their lengths to one another as you change the parameters using sliders. |
Visualizing Confidence Intervals for the Proportion This DIGMath spreadsheet helps you visualize what confidence intervals are for the proportion of a population. You enter the sample data -- the sample size n and the proportion p of successes, and select the level of confidence (90%, 95%, 98%, or 99%) you want. The spreadsheet constructs all four corresponding confidence interval and displays each of them so that you can compare their sizes, their centers, and their lengths to one another as you change the parameters using sliders. |
Confidence Intervals for the Difference of Means This DIGMath module helps in constructing a confidence interval for the difference of mean based on summary sample data from two samples: the size of the samples, the sample means, and the sample standard deviations. The user can choose the confidence level desired -- 90%, 95%, 98%, or 99% and the resulting intervals are shown graphically and numerically. |
Confidence Intervals for Difference of Proportions This DIGMath module helps in constructing a confidence interval for the difference in population proportion based on summary sample data from two samples: the size of the samples and the number of "successes" in each sample. The user can choose the confidence level desired -- 90%, 95%, 98%, or 99% and the resulting intervals are shown graphically and numerically. |
Simulating Hypothesis Testing This DIGMath module provides a visual simulation of the process of testing a hypothesis regarding the population mean π. You have the choice of the same four underlying populations (again, to see that the population does not affect the results) and the level of significance (10%, 5%, 2%, 1%). The simulation generates a fixed number of samples from the selected population, plots the mean of each sample with a vertical line at the appropriate location, and summarizes the number and percentage of sample means that fall into this region. The height of each line is equal to the standard deviation of that sample. Students see that the simulated percentage of sample means that fall in the rejection region is typically close to the selected level of significance. They also see that most of the sample means that fall into the rejection region tend to be quite close to the critical values. They also see that the lines representing the samples whose means are close to the population mean tend to be very tightly clustered compared to those that are near the extreme ends, which are sparsely distributed. |
Visualizing Hypothesis Testing for the Mean This DIGMath spreadsheet helps you visualize the fundamental ideas related to testing a hypothesis for the mean of a population. You enter the sample data -- the sample size n, the sample mean, and the sample standard deviation, the choice of a two-tailed test or a one-tailed test with the tail on the right or the left, and select the significance level α you want highlighted. The spreadsheet displays all four corresponding critical values for a one-tailed test or all eight critical values for a two-tailed test and shows the position of the sample mean for the data. It also displays the associated z- or t-value and the conclusion of whether you can reject or fail to reject the null hypothesis as the selected significance level. |
Hypothesis Tests for the Mean This DIGMath spreadsheet assists you in testing a hypothesis for the mean of a population. You enter the null hypothesis for the supposed value of m and select the test you want -- either two tailed or one tail with either tail. You then enter the sample data -- the sample size n, the sample mean m and the sample standard deviation s -- and the level of significance α. The spreadsheet displays the corresponding normal or t-distribution, the location of the critical value(s), and the location of the sample mean. It also shows the associated z- or t-value, as well as the corresponding P-value, and the conclusion as to whether you Reject or Fail to Reject the null hypothesis. |
Hypothesis Tests for the Proportion This DIGMath spreadsheet assists you in testing a hypothesis for the proportion of a population. You enter the null hypothesis for the supposed value of p and select the test you want -- either two tailed or one tail with either tail. You then enter the sample data -- the sample size n and the number of successes x in that sample -- and the level of significance α. The spreadsheet displays the corresponding normal distribution (when appropriate), the location of the critical value(s), and the location of the sample proportion p. It also shows the associated z-value, as well as the corresponding P-value, and the conclusion as to whether you Reject or Fail to Reject the null hypothesis. |
Hypothesis Test on the Difference of Means This DIGMath spreadsheet assists you in testing a hypothesis for the difference in means of two populations. The null hypothesis is that the two means are equal, and you have to select the alternate hypothesis test you want -- either two tailed or one tail with either tail. You then enter the sample data for the two samples -- the sample size n, the sample mean m and the sample standard deviation s -- and the level of significance α. The spreadsheet displays the corresponding normal or t-distribution for the distribution of differences of sample means, the location of the critical value(s), and the location of the difference in the two sample means. It also shows the associated z- or t-value, as well as the corresponding P-value, and the conclusion as to whether you Reject or Fail to Reject the null hypothesis. |
Hypothesis Test on the Difference of Proportions This DIGMath spreadsheet assists you in testing a hypothesis for the difference in proportions of two populations. The null hypothesis is that the two proportions are equal, and you have to select the alternate hypothesis test you want -- either two tailed or one tail with either tail. You then enter the sample data for the two samples -- the sample size n and the number of successes x in each sample -- and the level of significance α. The spreadsheet displays the corresponding normal distribution (if appropriate) for the distribution of differences of sample proportions, the location of the critical value(s), and the location of the difference in the two sample proportions. It also shows the associated z-value, as well as the corresponding P-value, and the conclusion as to whether you Reject or Fail to Reject the null hypothesis. |
The Distribution of the Difference of Means This DIGMath module lets you investigate the distribution of the difference of means based on summary sample data from two samples drawn from the choice of four underlying populations (to see that the population does not affect the results). The user can choose the sample size (from n = 2 to n = 50) from each sample and the number (from 50 to 250) of samples. The simulation generates that number of samples from the selected populations, plots the difference in the sample means of each sample, and displays the mean and standard deviation of the differences in the sample means compared to the theoretical predictions based on the population of differences of means of all possible samples. |
The Distribution of Sample Proportions This DIGMath module lets you investigate the distribution of the difference of proportions based on summary sample data from two samples drawn from two binomial populations. For each population, you can choose probability p of success and the sample size (from n = 2 to n = 100) from each sample, as well as the number of random samples (between 50 and 300). The simulation generates that number of samples from the two populations, plots the difference in the sample proportions of each set of samples, and displays the mean and standard deviation of the differences in the sample proportions compared to the theoretical predictions based on the population of differences of proportions of all possible samples. |
Linear Regression: Fitting a Line to Data This DIGMath module performs a linear regression analysis on any set of up to 50 (x, y) data points. It shows graphically the points and the associated regression line and also displays the equation of the regression line, the value for the correlation coefficient r, and the value for the Sum of the Squares that measures how close the line comes to all the data points. |
Regression Simulation This DIGMath spreadsheet performs a graphical simulation on the regression lines based on a variety of samples drawn from an underlying population. You have the choice of the sample size (n > 2) and the number of samples. The simulation generates the random samples, calculates the equation of and plots the corresponding sample regression line, and also draws the population regression line. It also displays the mean of the slopes and of the vertical intercepts, so that users can compare these values to the slope and intercept of the underlying population. The students quickly see that, with small sample sizes, the likelihood of the sample regression line being close to the population regression line may be very small with widely varying slopes for many of the sample lines. As the sample size increases, the sample regression lines become ever more closely matched to the population line. |
Simulating the Correlation Coefficient This DIGMath spreadsheet lets you investigate the sample distribution for the correlation coefficient r based on repeated random samples drawn from a bivariate population. You can choose between n = 3 and n = 50 random points for each sample and between 50 and 250 such samples from the underlying population. For each sample, it then calculates the correlation coefficient and displays a histogram showing the values of r from the samples. It also calculates and displays the mean of the sample correlation coefficients and compares it to the correlation coefficient for the underlying bivariate population. |
Simulating the Regression Coefficients This DIGMath module lets you investigate the sample distributions for the two regression coefficient a and b in the regression equation y = ax + b based on repeated random samples drawn from a bivariate population. You can choose between n = 3 and n = 40 random points for each sample and between 50 and 250 such samples from the underlying population. For each sample, the program calculates the regression equation and displays the various regression lines along with the regression line for the underlying bivariate population. It then draws two histograms -- one showing the distribution of the values of the slope a from the random samples and the other showing the distribution of the values of the vertical intercepts b from those samples. It also calculates and displays the mean of each of the sample regression coefficients and compares it to the regression coefficients for the underlying bivariate population. |
The Effects of an Extra Point on the Regression Line and the Correlation Coefficient This DIGMath module lets you investigate the effect that changing an additional point has on the regression line (both graphically and numerically) and on the correlation coefficient. You have the choice of 5, 10, or 20 fixed points and can move an additional point using sliders to see how it affects the calculations and the extent of the changes depending on the number of points. |
Fitting a Median-Median Line to Data This DIGMath module fits a median-median line to any set of up to 50 (x, y) data points. It shows graphically the points and the associated median-median line and also displays the equation of the median-median line and the value for the Sum of the Squares that measures how close the line comes to all the data points. |
Simulating the Quartile-Quartile Line This DIGMath module lets you investigate the quartile-quartile line that fits a set of data via a simulation. The quartile-quartile line is based on finding the 1st and 3rd quartiles for both the x and the y values in a set of data and then creating the line that passes through those two points. As such, it is a viable alternative to the usual least-squares regression line that is conceptually and computationally simpler. You have a choice of the sample size and the number of samples that will be drawn from an underlying population. The spreadsheet generates the random samples and draws all the corresponding quartile-quartile lines to help you see the effect of sample size on the consistency of the lines. |
Comparing Lines that Fit Data This DIGMath program lets you compare how well the least-squares line, the median-median line (that is built into many calculators), and the quartile-quartile line fit sets of data. You can choose the number of random data points from an underlying population and the spreadsheet generates a random sample and displays the three lines, along with the data points, so that you can compare how well the three lines fit the data and how they compare to one another, particularly as the sample size increases. |
DataFit: Fitting Linear, Exponential, and Power Functions to Data This DIGMath spreadsheet is provided as a visual and computational tool for investigating
the issue of fitting linear, exponential, and power functions to data and the underlying
transformations used to create the nonlinear functions. You can enter a set of data
and the spreadsheet displays six graphs: (1) For a linear fit: the regression line superimposed over the original (x, y) data; (2) For an exponential fit: the regression line superimposed over the transformed (x, log y) data values; (3) The exponential function superimposed over the original (x, y) data; (4) For a power fit: the regression line superimposed over the transformed (log x, log y) data values; (5) The power function superimposed over the original (x, y) data; (6) All three functions superimposed over the original (x, y) data. The spreadsheet also shows the values for the correlation coefficients associated with all three linear fits and the values for the sums of the squares associated with each of the three fits to the original data. On a separate page, the spreadsheet also shows the residual plots associated with each of the three function fits. |
Multivariate Linear Regression This DIGMath spreadsheet lets you perform multivariate linear regression when the dependent variable Y is a function of two independent variables X1 and X2 or a function of three independent variables X1, X2, and X3. You enter the number of data points (up to a maximum of 50) and then the values for the dependent and independent variables in the appropriate columns. The spreadsheet responds with the equation of the associated linear regression equation, the value for the sum of the squares, and the value for the coefficient of determination, R^{2}; note that this value tells you the percentage of the variation that is explained by the linear function. |
The Birthday Problem This DIGMath module lets you investigate the Birthday Problem, which asks for the probability that two people in a group of n people will have the same birthday. The program lets you decide on the number of people in a group (between 1 and 100) and displays the graph of the probability of a match versus the number of people in the group. |
Number of Boys vs. Girls Born in a Family This DIGMath spreadsheet lets you investigate the number of Boys and Girls born into a family based on the fact that 51.2% of all live births are Boys. You can choose the number of children (1-10) in a family and the number of such families. The program simulates this and displays the outcomes graphically in a histogram and numerically with a table of outcomes and the mean and standard deviation of the results. |
Simulating the Birthday Problem This DIGMath module lets you investigate the Birthday Problem from the point of view of a random simulation. You have the choice of the number of people in a group (from 2 to 50). The program then generates a random sample of birth-dates for each of the people and displays the list, including highlighting those that match. It presents the results, including the theoretical probability of a match and the number of matches. |
The Drunkard's (or Random) Walk Simulation This DIGMath module lets you investigate the notion of a random walk in the plane. You have the choice of the number of random steps (between 1 and 1000) and the length of each step. The program then generates a random collection of steps and displays the results graphically, as well as some numerical analysis on the actual distance covered from the starting point compared to the theoretical predictions. |
Buffon Needle Problem This DIGMath module lets you experiment with a graphical simulation of Buffon's Needle Problem -- the probability that a needle of length L lands on the seam between parallel strips of flooring of width W when it falls to the floor. You can select the number of random "needles" that fall, the width of the strip of flooring, and the length of the needles and see the results graphically and numerically. |
Buffon's Disk Problem This DIGMath spreadsheet lets you experiment with a graphical simulation of a variation of Buffon's Needle Problem -- the probability that a circular disk of radius r lands on the seam between parallel strips of flooring of width W when it falls to the floor. You can select the number of random "disks" that fall, the width of the strip of flooring, and the length of the needles and see the results graphically and numerically. |
Buffon's Needle Problem in Concentric Circles This DIGMath spreadsheet lets you experiment with a graphical simulation of a variation of Buffon's Needle Problem -- the probability that a circular disk of radius r lands on the seam between a group of concentric circles when it falls to the floor. You can select the number of random "disks" that fall, the fixed difference in the radii of the concentric circles on the floor, and the length of the needles and see the results graphically and numerically. |
Simulation of Dart Throwing This DIGMath module lets you investigate the process of throwing random darts at a dartboard. You can select between 100 and 1000 random darts and the spreadsheet shows the position that each dart lands and displays the breakdown of how many, and what percentage, of the darts all into each of the rings in the dartboard. |
Difference of the Faces of Two Dice This DIGMath simulation lets you investigate the differences of the faces on a pair of fair dice. You can choose up to 720 rolls of the two dice and the spreadsheet shows the distribution of the outcomes and a list of the number and percentage of each possible outcome compared to the theoretical predictions. |
Product of the Faces of Two Dice This DIGMath simulation lets you investigate the product of the faces on a pair of dice. You can choose up to 720 rolls of the two dice and the spreadsheet shows the distribution of the outcomes and a list of the number and percentage of each possible outcome compared to the theoretical predictions. |
Simulation of Rolling 4-Sided Dice This DIGMath spreadsheet lets you investigate the probability experiment of rolling a pair of fair 4-sided dice, instead of the usual 6-sided dice, so that the possible sums are now 2, 3, ..., 8. The simulation shows the results of repeated trials both graphically in a histogram and numerically in terms of the number of times each of the possible outcomes arises. |
Simulation of Rolling 8-Sided Dice This DIGMath spreadsheet lets you investigate the probability experiment of rolling a pair of fair 8-sided dice, instead of the usual 6-sided dice, so that the possible sums are now 2, 3, ..., 16. The simulation shows the results of repeated trials both graphically in a histogram and numerically in terms of the number of times each of the possible outcomes arises. |
Yahtzee: Rolling Five Dice Simulation The game of Yahtzee^{TM} involves rolling a set of five fair dice. This DIGMath module lets you investigate this experiment by simulating repeated random rolls (up to 720 times) of five dice. It displays the results in a histogram as well as a table showing the simulated outcomes and the expected theoretical outcomes. |
Visualizing Conditional Probability This DIGMath spreadsheet helps you visualize the idea of conditional probability where the usual sample space for a probability experiment is reduced by knowing some other detail of the event. The spreadsheet looks at the sum of the faces of two dice and allows you to investigate what happens if either (1) you know the result of the second die or (2) you know the product of the two faces. The spreadsheet displays the corresponding histogram and the associated numerical outcomes. |
Waiting Time Simulation This DIGMath module lets you investigate the length of time a car will wait at a red light. You can select the total length of the cycle and the length of time that the light is red. The results -- the number of times that the wait is 0, 1, 2, ..., seconds -- are shown graphically in a histogram and in a table listing the outcomes. The average wait over all repetitions is also shown. |
Chi-Square Analysis This DIGMath spreadsheet is designed to perform a complete chi-square analysis on many different sized contingency tables, including 2 by 2, 2 by 3, 2 by 4, 3 by 2, 3 by 3, and 3 by 4. On the Set-Up screen, the user first enters the number of rows and the number of columns of the desired contingency table and is then instructed to click on an appropriate tab to go to the corresponding input screen. On that screen,you then enters the observed values into the various positions in the contingency table. The spreadsheet displays the resulting table of expected frequencies, the number of degrees of freedom, and the value of the chi-square statistic based on the values in the table. It also draws the graph of the corresponding chi-square distribution and indicates the location of the critical value, based on the desired level of significance, separating the rejection region from the region where one cannot reject the null hypothesis. In addition, the program indicates the location of the chi-square statistic corresponding to the data in the contingency table. Finally, the program indicates whether or not one can reject the null hypothesis at that significance level. |
The Chi-Square Distributions This DIGMath module lets you explore the behavior of various chi-square distributions, which depend on the number n of degrees of freedom. You can enter any desired number of degrees of freedom from 2 to 31 and the program draws the graphs of that chi-square distribution as well as those with 3, 7, 11, 15, ..., 27 degrees of freedom. Because the chi-square distributions become more normal in shape as n increases, the program also draws the standard normal distribution with mean μ = 0 and standard deviation σ = 1 for comparison. |
Chi-Square Simulation This DIGMath spreadsheet lets you investigate the variation in the values that can arise for the chi-square statistic via a random simulation based on a two by three contingency table. You define the table by entering the column and row totals and the number of random samples drawn from that population and the spreadsheet generates and graphs the corresponding values of the chi-square statistic. |
One-Way Analysis of Variance (ANOVA) This DIGMath spreadsheet is designed to perform a complete one-way analysis of variance (ANOVA) to test whether the means of two or more (up to 5 sample means) may come from populations with the same mean (the null hypothesis) or from populations with different means (the alternate hypothesis). Each sample can contain up to 10 entries. The spreadsheet displays the resulting ANOVA table, including the value of the F-statistic. It also draws the graph of the corresponding F-distribution and indicates the location of the critical value, based on the 5% level of significance, separating the rejection region from the region where one cannot reject the null hypothesis. In addition, the program indicates the location of the F-statistic corresponding to the data in the table. Finally, the program indicates whether or not one can reject the null hypothesis at the 5% significance level. |
Simulating the Runs Test This DIGMath spreadsheet lets you investigate the Runs Test both graphically and numerically. When there is a collection of outcomes consisting of A's and B's, the object is to see the number of runs that occur. The module lets you select the total number of A's and B's, the number of A's, and the number of random samples. The distribution of the number of runs is drawn as well as numerical measures for the mean and standard deviation. |
Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for College Algebra and Precalculus in Excel
Most of the following graphical explorations require the use of macros to operate. In order to use these spreadsheets, Excel must be set to accept macros. To change the security setting on macros:
- When you open the spreadsheet, a new bar appears near the top of the window that says "Security Warning: Macros have been disabled ".
- Click on Options.
- Click on "Enable this Content" and then click OK.
The following are the DIGMath explorations that are currently completed and ready for use in Excel 2007 and later. (Many others are under development.) If you have any suggestions for improvements or for new topics, please pass them on also.
DIGMath Spreadsheets for College Algebra and Precalculus |
---|
Linear Functions This DIGMath spreadsheet allows you to investigate visually three different aspects of linear functions. (1) You can enter the slope and vertical intercept and watch the effects of changing either of them via a slider on the resulting graph. (2) You can enter a point and the slope and watch the effects of changing either of them on the graph via the point-slope formula. (3) You can enter two points and change either of them to see the effects. |
Linear Regression: Fitting a Linear Function to Data This DIGMath module performs a linear regression analysis on any set of up to 50 (x, y) data points. It shows graphically the points and the associated regression line and also displays the equation of the regression line, the value for the correlation coefficient r, and the value for the Sum of the Squares that measures how close the line comes to all the data points. |
Regression Simulation The user has the choice of the sample size (n> 2) and the number of samples. The simulation generates repeated random samples, calculates the equation of and plots the corresponding sample regression line, and also draws the population regression line. The students quickly see that, with small sample sizes, the likelihood of the sample regression line being close to the population regression line may be very small with widely varying slopes for many of the sample lines. As the sample size increases, the sample regression lines become ever more closely matched to the population regression line. |
Fitting a Median-Median Line to Data This DIGMath module fits a median-median line to any set of up to 50 (x, y) data points. It shows graphically the points and the associated median-median line and also displays the equation of the median-median line and the value for the Sum of the Squares that measures how close the line comes to all the data points. |
Median-Median Line Simulation The user has the choice of the sample size (n > 2) and the number of samples. The simulation generates repeated random samples, calculates the equation of and plots the corresponding sample median-median line, and also draws the population median-median line. The students quickly see that, with small sample sizes, the likelihood of the sample median-median line being close to the population median-median line may be very small with widely varying slopes for many of the sample lines. As the sample size increases, the sample median-median lines slowly become more closely matched to the population median-median line. |
Comparing Lines that Fit Data This DIGMath program lets you compare how well the least-squares line, the median-median line (that is built into many calculators), and the quartile-quartile line fit sets of data. You can choose the number of random data points from an underlying population and the spreadsheet generates a random sample and displays the three lines, along with the data points, so that you can compare how well the three lines fit the data and how they compare to one another, particularly as the sample size increases. |
Exponential Functions This DIGMath spreadsheet allows you to investigate visually two different aspects of exponential functions. (1) You can enter the growth/decay factor b in y = b^{x }and watch the effects on the resulting graph of changing it via a slider. (2) You can enter two points and change either of them to see the effects. |
Exponential Regression: Fitting an Exponential Function to Data This DIGMath module performs an exponential regression analysis on any set of up to 50 (x, y) data points. It shows graphically the points and the associated exponential regression function and also displays the equation of the exponential regression function, the value for the associated correlation coefficient r based on the transformed (x, log y) data, and the value for the Sum of the Squares that measures how close the exponential function comes to all the data points. |
Drug Level Models This DIGMath module lets you investigate two different models for the level of a medication in the bloodstream. The first model is for the drug level after a single dose of the medication; the second model is for the repeated (say daily) dose of a medication. In both cases, the key parameters are the amount of the medication that is taken (either once or repeatedly) and the percentage of the drug that is washed out of the blood each time period. |
Doubling Time and Half-Life This DIGMath spreadsheet is intended to let you investigate visually two important applications of exponential functions. First, you can explore the relationship between the growth factor b and the doubling time of an exponential growth process. Second, you can investigate the relationship between the decay factor b and the half-life of an exponential decay process. |
Amortization: Financing a Home or a Car This DIGMath module is intended to let you investigate the mathematics involved in the amortization process -- taking out a loan to finance a home or a car. You have a choice of financing a home or a car on different pages of the spreadsheet. For each, you enter the amount of the loan, the length of the loan, and the annual interest rate. The spreadsheet displays the graph of the monthly balance of the loan and two different views of the breakdown of how the monthly payment is split between paying off the principal and paying for the interest on the loan. It also lets you trace across the graphs to see the amounts in any month. |
Effects of Compound Interest This DIGMath spreadsheet lets you see the effects of compounding with different frequencies -- yearly, quarterly, monthly, daily, by the hour, and by the minute -- on the balance in an account. You can enter your choice of interest rate and initial balance and see both graphically and numerically the growth in the balance over time with the different compounding periods. |
Haldane Functions in Genetics This DIGMath module draws the graph of the Haldane function that is used in genetics to relate the recombination fraction C_{AB} between loci A and B in a gene and the distance X_{AB} between the loci. A slider lets you change the value for the distance x_{AB} between loci and see the effect on the corresponding point on the graph of the Haldane function that involves an exponential function. |
Power Functions This DIGMath spreadsheet allows you to investigate visually the behavior of power functions. You can enter the power pand watch the effect on the graph of changing it via a slider. |
Power Regression: Fitting a Power Function to Data This DIGMath module performs a power regression analysis on any set of up to 50 (x, y) data points. It shows graphically the points and the associated power regression function and also displays the equation of the power regression function, the value for the associated correlation coefficient r based on the transformed (log x, log y) data, and the value for the Sum of the Squares that measures how close the power function comes to all the data points. |
Sum of the Squares This DIGMath module allow you to investigate dynamically how the sum of the squares measures how well a line fits a set of data. You can enter a set of data and select the number of data points you want to use. You also enter the values you want for the slope and the vertical intercept of a line. The display shows the data points with the line based on those parameters and also shows the value for the sum of the squares associated with that linear fit. |
DataFit: Fitting Linear, Exponential, and Power Functions to Data This DIGMath spreadsheet is provided as a visual and computational tool for investigating
the issue of fitting linear, exponential, and power functions to data and the underlying
transformations used to create the nonlinear functions. You can enter a set of data
and the spreadsheet displays six graphs: (1) For a linear fit: the regression line superimposed over the original (x, y) data; (2) For an exponential fit: the regression line superimposed over the transformed (x, log y) data values; (3) The exponential function superimposed over the original (x, y) data; (4) For a power fit: the regression line superimposed over the transformed (log x, log y) data values; (5) The power function superimposed over the original (x, y) data; (6) All three functions superimposed over the original (x, y) data. The spreadsheet also shows the values for the correlation coefficients associated with all three linear fits and the values for the sums of the squares associated with each of the three fits to the original data. On a separate page, the spreadsheet also shows the residual plots associated with each of the three function fits. |
Logarithmic Growth This DIGMath spreadsheet lets you investigate how fast (or actually how slow) logarithmic growth is. In particular, it lets you see, both graphically and numerically, what the cost is in terms of how much the variable t must increase in order for the logarithmic function f(t) = log t to increase by 1 unit for different values of t. |
The Logistic Model This DIGMath module allows you to investigate visually two different aspects of the discrete logistic model based on the logistic difference equation P_{n+1}= aP_{n }- bP_{n}^{2}. (1) You can enter, via sliders, values for the two parameters a and b, as well as the initial population value P_{0}and watch dynamically the effects on the resulting graph of the population, and also see the effects of changing any of these values. (2) You can also investigate visually the effects on a population of changes in the initial growth rate a and the maximum sustainable population (the limit to growth), along with the initial population value P_{0}, using sliders, and watching the dynamic effects on the graph of changing any of them. |
Doubling Times of Various Functions This DIGMath module lets you investigate the notion of the doubling time associated with a variety of different functions, including linear, power and logarithmic. For an exponential function f(t) = Ab^{t} , the doubling time depends only on the growth rate b, but not on the point t or the value of the coefficient A. The module lets you see what happens with the other families of function to see which, if any, of the parameters or values of the independent variable contribute to the value for the doubling time. |
The Surge Function This DIGMath module lets you investigate the properties of the surge function, which has the equation y = A t ^{p} b^{t}, where p > 0 and b < 1. It is used to model phenomena where there is an initial growth spurt in a quantity followed by a slow decay toward zero. You can experiment with different values for the parameters, using sliders, to see the effects on the behavior of the function. |
Moving Along Lines One of the most common mathematical concepts that arises in economics is the idea of moving along a line, typically involving the Supply and Demand lines (or curves). This DIGMath spreadsheet lets you explore this concept in which you have a pair of intersecting lines and use a slider to move one of the two lines along the other line while keeping the slope the same. The spreadsheet shows the new and the old lines and the changes in the point of intersection. |
Quadratic Functions This DIGMath spreadsheet allows you to investigate visually two different aspects of quadratic functions. (1) You can enter, via sliders, values for the three coefficients in a quadratic function and watch dynamically the effects on the resulting graph of changing any of them via sliders. (2) You can also investigate visually the fact that a quadratic is determined by three points by entering the coordinates of three points, using sliders, and watching the dynamic effects on the graph of changing any of them. |
Cubic Functions This DIGMath spreadsheet allows you to investigate visually two different aspects of cubic functions. (1) You can enter, via sliders, values for the four coefficients in a cubic function and watch dynamically the effects on the resulting graph of changing the values of any of them via sliders. (2) You can also investigate visually the fact that a cubic is determined by four points by entering the coordinates of four points, using sliders, and watching the dynamic effects on the graph of changing any of them. |
Quartic Functions This DIGMath spreadsheet allows you to investigate visually two different aspects of quartic functions. (1) You can enter, via sliders, values for the five coefficients in a cubic function and watch dynamically the effects on the resulting graph of changing the values of any of them via sliders. (2) You can also investigate visually the fact that a quartic is determined by five points by entering the coordinates of five points, using sliders, and watching the dynamic effects on the graph of changing any of them. |
Polynomial Graphs This DIGMath spreadsheet lets you investigate the graph of any polynomial up to eighth degree by entering the values for the coefficients and the interval over which you want to see the graph. You can also control a point on the graph by means of a slider to see the coordinates of that point and so locate real roots, turning points, and inflection points. |
End Behavior: A Polynomial vs. Its Power Function This DIGMath module lets you investigate the end behavior of any polynomial up to eighth degree. You must enter the values for the coefficients. The spreadsheet then displays the graph of the polynomial as well as the graph of the power function corresponding to the leading term of the polynomial. A slider lets you expand the interval for the display, so that you can see how different the two graphs are when the interval is small and the turning points and inflection points of the polynomial are clearly in view. As the interval expands, the polynomial looks more and more like the power function. |
Polynomial Regression: Fitting a Polynomial to Data This DIGMath module performs a polynomial regression analysis (linear, quadratic, ..., up to sixth degree) on any set of up to 50 (x, y) data points, which goes beyond what is possible with graphing calculators. It shows graphically the points and the associated polynomial regression function and also displays the equation of the regression polynomial, the value for the associated coefficient of multiple determination R^{2} based on multivariate linear regression of y on x, x^{2}, x^{3}, ..., x^{6} (depending on the choice of degree) and its significance in terms of what percentage of the variation in the data is explained by the regression polynomial, and the value for the Sum of the Squares that measures how close the power function comes to all the data points. |
Finding the Complex Zeros of Cubic Polynomials This DIGMath spreadsheet lets you locate all three zeros, particularly any pairs of complex conjugate zeros, of cubic polynomials using a graphical exploration. The spreadsheet also displays the factorization and the values of the three zeros, either real or complex. |
Finding the Complex Zeros of Quartic Polynomials This DIGMath module lets you approximate all four zeros, particularly any pairs of complex conjugate zeros, of quartic polynomials of the form y = x^{4} + ax^{3} + bx^{2} + cx + d using a graphical exploration. As you vary the coefficients in an approximation to a possible quadratic factor, you see how well the resulting approximate factorization fits the original quartic both graphically and in terms of the Sum of the Squares. The spreadsheet also displays the factorization and the values of the four zeros, either real or complex. |
Bairstow's Method for Complex Roots This DIGMath program lets you investigate Bairstow's Method for approximating the complex roots of a polynomial by creating a sequence of quadratic functions that converges to an irreducible quadratic factor of the polynomial. Once you know a quadratic factor, you can find the complex roots by applying the quadratic formula. The spreadsheet lets you use any polynomial up to 8^{th} degree and any choice of initial estimate for the quadratic factor. The spreadsheet draws the first five quadratic approximations to illustrate the convergence both graphically and numerically. |
Components of the Lagrange Interpolating Polynomial This DIGMath spreadsheet lets you investigate the Lagrange Interpolating Polynomial and how it is formed by a set of components. You can work with a linear function based on two interpolating points, a quadratic function based on three interpolating points, or a cubic function based on four interpolating points of your choice. The spreadsheet displays the resulting Lagrange interpolating polynomial, as well as the components of that polynomial -- the two linear functions that combine to form the linear Lagrange polynomial, the three quadratic functions that combine to form the quadratic Lagrange polynomial, and the four cubic functions that combine to form the cubic Lagrange polynomial. |
Difference Tables and the Newton Interpolating Polynomial This DIGMath spreadsheet lets you investigate the Newton Interpolating Polynomial and how it is based on a table of successive differences formed from a set of data. You can enter your data values with equally spaced x-values and the spreadsheet displays the corresponding table of differences, as well as the graph of the resulting Newton Interpolating Polynomial and the formula for that polynomial. |
A Bouncing Ball This DIGMath module lets you investigate the mathematics behind a bouncing ball. You can work in either the English or the metric system. You input the initial height from which a ball is dropped and the percentage of the velocity that is lost on each bounce. The spreadsheet draws the graphs of the height of the ball as a function of time and the velocity of the ball as a function of time. The investigations also include the fact that the shape of each portion of the height function is a polynomial. |
Graph of a Function This DIGMath spreadsheet allows you to investigate the graph of any desired function of the form y = f(x) on any desired interval a to b (or equivalently, xMin to xMax). |
Shifting and Stretching This DIGMath spreadsheet allows you to investigate visually the four different aspects of shifting and stretching/squeezing a function. The function used in the dynamic presentation is a zig-zag function (basically a saw-tooth wave that serves as a precursor to the sine function). (1) The first investigation involves experimenting with the effects of changing the parameters a and c in the zig-zag function y - c = zig (x - a). You can enter, via sliders, values for these parameters and watch dynamically the effects on the resulting graph of changing their values via sliders to see the horizontal and vertical shifts. (2) The second investigation involves experimenting with the effects of changing the parameters k and m in the zig-zag function k * y = zig (m * x). You can enter, via sliders, values for these parameters and watch dynamically the effects on the resulting graph of changing their values via sliders to see the horizontal and vertical stretches and squeezes that occur. |
Operations on Functions This DIGMath module lets you visualize the operations of adding or subtracting two functions, using a zig-zag function. |
Correlation Coefficient and the Sum of the Squares This DIGMath spreadsheet lets you investigate how the correlation coefficient and the sum of the squares capture the trend in a set of data. You use a slider to vary a parameter that represents by how much a set of data is "squeezed" or "stretched" vertically to see the effects on the correlation coefficient and on the sum of the squares. |
Newton's Laws of Heating and Cooling This DIGMath module lets you explore both Newton 's Law of Heating and Newton 's Law of Cooling. Using sliders, you can enter the temperature of the medium, the heating or cooling constant (essentially, the rate at which the object heats up or cools), and the initial temperature of the object. The program draws the graph of the temperature function and allows the user to trace along the curve to see the temperature value at different times. |
Normal Distribution Function This DIGMath module allows you to investigate the behavior of the normal distribution function based on its two parameters: the mean m (which produces horizontal shifts) and the standard deviation s (which primarily produces vertical stretches and squeezes). You can change either of them using sliders to see the effect on the normal distribution curve. |
Multivariate Linear Regression This DIGMath spreadsheet lets you perform multivariate linear regression when the dependent variable Y is a function of two independent variables X1 and X2 or a function of three independent variables X1, X2, and X3. You enter the number of data points (up to a maximum of 50) and then the values for the dependent and independent variables in the appropriate columns. The spreadsheet responds with the equation of the associated linear regression equation, the value for the sum of the squares, and the value for the coefficient of determination, R^{2}; note that this value tells you the percentage of the variation that is explained by the linear function. |
Visualizing Cosine and Sine This DIGMath spreadsheet is intended to introduce, visually and dynamically, the graphs of the cosine and sine functions based on the movement of the minute hand of a clock over a 60 minute period. (1) The cosine function is introduced as the vertical distance, at time t, of the end of the minute hand above/below the horizontal axis. Two graphs are shown, one being that of the clock as time passes and the other being that of the associated vertical distances as time passes. You control the time t via a slider to see how the curve generated is related to the time on the clock. (2) Similarly, the sine function is introduced as the horizontal distance, at time t, from the vertical axis to the end of the minute hand. |
Sinusoidal Functions This DIGMath spreadsheet allows you to investigate dynamically the effects of the four parameters A, B, C, and D on a sinusoidal function. (1) For the sine curve f(x) = A + B sin (C(x - D)), you can vary the values of the midline, the amplitude, the frequency, and the phase shift via sliders and see the effects on the corresponding graph. (2) You can conduct the same kind of experiments on the cosine function f(x) = A + B cos (C(x - D)). |
Fitting Sinusoidal Functions to Data This DIGMath spreadsheet lets you investigate dynamically the problem of fitting a sinusoidal function to a set of data. You can opt to use either a sine or a cosine function. You enter the desired set of periodic data values and then enter values for the four parameters -- the midline, the amplitude, the period, and the phase shift. The spreadsheet displays the corresponding sinusoidal function superimposed over the data, so you can visually assess how well the function fits the data. It also gives the value for the sum of the squares associated with the function, so you can assess numerically how well the function fits the data. You can then adjust any of the four parameters that are reasonable to see if you can improve on the fit. |
Approximating Sinusoidal Functions This DIGMath spreadsheet lets you investigate dynamically the idea of approximating a sinusoidal function with a polynomial. You can choose to work with either the sine or the cosine function and can use an approximating polynomial up to sixth degree in the form y = a + (1/b)x + (1/c)x^{2}+ (1/d)x^{3} + (1/e)x^{4} + (1/f)x^{5} + (1/g)x^{6}, where the seven parameters are all integers. You use sliders to change each of the parameter values and the associated graph shows how well the corresponding polynomial fits the sinusoidal curve. The spreadsheet also shows the value for the sum of the squares to provide a numerical measure for the goodness of the fit. This investigation is intended as a precursor to the notion of Taylor polynomial approximations. |
Approximating the Exponential Function This DIGMath spreadsheet lets you investigate dynamically the idea of approximating the exponential function f(x) = b^{x}^{ }= e^{x}^{ }with base e = 2.71828... with a polynomial. You can use an approximating polynomial up to fifth degree in the form y = a + (1/b)x +(1/c) x^{2}+ (1/d) x^{3}+ (1/e) x^{4}+ (1/f) x^{5}, where the six parameters a, b, c, d, e, and f are all integers. You use sliders to change each of the parameter values and the associated graph shows how well the corresponding polynomial fits the exponential curve. The spreadsheet also shows the value for the sum of the squares to provide a numerical measure for the goodness of the fit. This investigation is intended as a precursor to the notion of Taylor polynomial approximations. |
Approximating the Natural Logarithmic Function This DIGMath spreadsheet lets you investigate dynamically the idea of approximating the natural logarithmic function f(x) = ln x with base e = 2.71828... with a polynomial. You can use an approximating polynomial up to fifth degree in the form y = a + (1/b)(x - 1) + (1/c) (x-1)^{2}+ (1/d) (x-1)^{3}+ (1/e) (x-1)^{4}+ (1/f) (x-1)^{5}, where the six parameters a, b, c, d, e, and fare all integers. You use sliders to change each of the parameter values and the associated graph shows how well the corresponding polynomial fits the exponential curve. The spreadsheet also shows the value for the sum of the squares to provide a numerical measure for the goodness of the fit. This investigation is intended as a precursor to the notion of Taylor polynomial approximations. |
Approximating the Sine Function with Lagrange Interpolation This DIGMath module lets you investigate dynamically the way that the Lagrange Interpolating Polynomial is used to approximate values of the sine function on the interval [0, p/4] using either a quadratic polynomial (based on three interpolating points) or a cubic polynomial (based on four interpolating points). |
Approximating the Cosine Function with Lagrange Interpolation This DIGMath module lets you investigate dynamically the way that the Lagrange Interpolating Polynomial is used to approximate values of the cosine function on the interval [0, p/4] using either a quadratic polynomial (based on three interpolating points) or a cubic polynomial (based on four interpolating points). |
Approximating the Exponential Function with Lagrange Interpolation This DIGMath spreadsheet lets you investigate dynamically the way that the Lagrange Interpolating Polynomial is used to approximate values of the exponential function. One page lets you work with a quadratic polynomial based on three points on the exponential curve and another page lets you use a cubic polynomial based on four points. |
Approximating the Sine Function with Newton Interpolation This DIGMath module lets you investigate dynamically the way that the Newton Interpolating Polynomial is used to approximate values of the sine function on the interval [0, p/4]using either a quadratic polynomial (based on three uniformly spaced interpolating points) or a cubic polynomial (based on four uniformly spaced interpolating points). |
Approximating the Cosine Function with Newton Interpolation This DIGMath module lets you investigate dynamically the way that the Newton Interpolating Polynomial is used to approximate values of the cosine function on the interval [0, p/4]using either a quadratic polynomial (based on three uniformly spaced interpolating points) or a cubic polynomial (based on four uniformly spaced interpolating points). |
Approximating the Exponential Function with Newton Interpolation This DIGMath spreadsheet lets you investigate dynamically the way that the Newton Interpolating Polynomial is used to approximate values of the exponential function. One page lets you work with a quadratic polynomial based on three uniformly spaced points on the exponential curve and another page lets you use a cubic polynomial based on four uniformly spaced points. The spreadsheet calculates and draws the graph of the interpolating function as it passes through the interpolating points and seeks to match the exponential curve. It also draws the graph of the error function -- the difference between the polynomial and the exponential function. |
Chebyshev Nodes This DIGMath module lets you investigate the so-called Chebyshev nodes that are often the best points to use to construct an interpolating polynomial based on a set of points. The Chebyshev nodes have the property that they provide the minimum value of the maximum error in the approximation at the interpolating points. The spreadsheet lets you enter your choice of either three or four interpolating points on the interval [-1, 1] and compares, both numerically and graphically, the maximum error to the corresponding maximum error using the Chebyshev nodes. |
The Tangent Function This DIGMath module lets you investigate the definition of the tangent function as the ratio of the sine and the cosine. You can enter any desired interval in radians (or in degrees on a separate sheet of the spreadsheet). The spreadsheet draws two charts, one for the graphs of the sine and cosine functions, and the other for the graph of the tangent function. It also provides numerical results, showing the values of the sine, the cosine, and the tangent at any desired tracing point, to demonstrate that the tangent function is indeed the ratio of the sine and cosine at each point. |
DeMoivre's Theorem This DIGMath module lets you explore DeMoivre's Theorem. You enter the values for any desired complex number and use a slider to select the power to which z = a + bi is to be raised. You can investigate the results both graphically and numerically in three situations: using the trigonometric form for the complex number and its powers, using the rectangular form for both, and using non-integer powers. |
Tangentoidal Functions This DIGMath module lets you investigate the behavior of the so-called tangentoidal functions that are defined as f(x) = sin x /[a + cos x]. You can enter any desired value for the parameter a and any desired interval in radians. The spreadsheet draws the graph of the tangentoidal function. It also raises questions about the behavior of these functions in terms of the location and existence of vertical asymptotes and how that is related to the value of a. |
Systems of Linear Equations This DIGMath modules provides a tool for solving systems of linear equations using matrix methods. You have the choice of a 2 x 2 system, a 3 x 3 system, or a 4 x 4 system. In each case, you enter the components of the matrix of coefficients A and the vector (matrix) of constants B in AX = B and the program responds with the corresponding solution vector X. |
Homogeneous Linear Systems This DIGMath spreadsheet lets you investigate the solutions of homogeneous systems of linear equations AX = 0 from a graphical perspective. You can use sliders to change the coefficients and watch the effects on the corresponding lines to see the conditions under which the lines have a unique point of intersection, are parallel so there is no solution, or overlap completely so that there are infinitely many solutions. |
Matrix Powers This DIGMath module lets you investigate the successive powers of a 2 by 2 matrix A applied to a vector X_{0}. The results are displayed both graphically and numerically. |
Rotation Matrices This DIGMath module lets you investigate the effects of successively applying a rotation matrix A to any desired initial vector X_{0} using any desired angle. The results are displayed both graphically and numerically. |
Markov Chains This DIGMath module lets you investigate the effects of successive terms in a Markov chain by applying a transition matrix A to any desired initial vector X_{0}. The results are displayed both graphically and numerically. |
Finding Eigenvectors Graphically This DIGMath program lets you investigate graphically the notion of the eigenvectors and eigenvalues of the 2 x 2 matrix A. You can enter the four entries in the matrix and the components of an initial vector X using sliders. The spreadsheet draws the graph of the vector X and the resultant vector AX. You can estimate the eigenvectors by adjusting the components of X until X and AX are essentially pointing in the same direction. The program also displays the coordinates and shows the actual eigenvalues, either real or complex. |
Eigenvalues and Eigenvectors This DIGMath modules finds the eigenvalues and eigenvectors of any two by two matrix that you enter, whether there are two distinct real eigenvalues, a double real eigenvalue, or a pair of complex conjugate eigenvalues. It also displays the characteristic equation, the value of the discriminant, and graphs of the real eigenvectors. |
The Ellipse This DIGMath spreadsheet lets you investigate the properties of the ellipse. One sheet is based on the equation of the ellipse and you can select and vary the values for the center x = c of the ellipse and the parameters a and b in the ellipse and see the effects on the resulting graphs instantly. The second sheet is based on the definition of the ellipse as the set of points such that the sum of the distances to two fixed points, the foci, is a constant. You can enter and vary the locations of the two foci that lie on the x-axis and the value for the sum of the two distances and see the effects on the ellipse so determined, as well as its equation. |
The Hyperbola This DIGMath spreadsheet lets you investigate the properties of the hyperbola. One sheet is based on the equation of the hyperbola where the foci are located on the horizontal axis and you can select and vary the values for the center x = x_{0} of the hyperbola and the parameter a in its equation and see the effects on the resulting graph instantly. A second sheet is based on equation of the hyperbola where the foci are located on the vertical axis and you can select and vary the values for the center y = y_{0} of the hyperbola and the parameter a in its equation and see the effects on the resulting graph instantly. The third sheet is based on the definition of the hyperbola as the set of points such that the difference in the distances to two fixed points, the foci, is a constant. You can enter and vary the location of the foci that lie on the x-axis symmetrically and the value for the difference of the two distances and see the effects on the hyperbola so determined, as well as its equation. |
The Parabola This DIGMath spreadsheet lets you investigate the geometric definition of the parabola. One sheet is based on the equation of the parabola where the focus is located on the vertical axis and you can select and vary the value for the focus c and the width of the display window and see the effects on the resulting graph instantly. It also shows the directrix and displays the distances from a tracing point both to the focus and to the directrix. A second sheet is based on equation of the parabola where the focus lies on the horizontal axis and you can select and vary the values for the value for the focus c and the height of the display window and see the effects on the resulting graph instantly. It also shows the distances from a moving point to the focus and the directrix. |
Rational Functions This DIGMath spreadsheet lets you investigate the properties of rational functions. On different sheets, you have the choice of a variety of different forms for a rational function, including (1) the product of two linear terms divided by a quadratic term, (2) the product of three linear terms divided by a quadratic term, and (3) the product of one linear and one quadratic term divided by a quadratic term. In each case, you enter the values of the parameters in each factor and the spreadsheet displays the corresponding graph instantly, as well as the equation of that rational function. |
Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for Calculus in Excel
Most of the following graphical explorations require the use of macros to operate. In order to use these spreadsheets, Excel must be set to accept macros. To change the security setting on macros:
- When you open the spreadsheet, a new bar appears near the top of the window that says "Security Warning: Active content has been disabled".
- Click on Options.
- Click on "Enable this Content" and then click OK.
The following are the DIGMath explorations that are currently completed and ready for use in Excel 2007. (Many others are under development.) If you have any suggestions for improvements or for new topics, please pass them on also.
DIGMath Spreadsheets for Calculus |
---|
Graph of a Function This DIGMath spreadsheet allows you to investigate the graph of any desired function of the form y = f(x) on any desired interval a to b (or equivalently, xMin to xMax). |
Graphs of Two Functions This DIGMath utility allows you to investigate the graphs of any two functions of the form y = f(x) and y = g(x) on any desired interval a to b. It is probably most useful as a tool for estimating the point(s) of intersection of the two functions by numerically zooming in on the graphs. |
Delta-Epsilon Definition of the Limit This DIGMath module allows you to explore the delta-epsilon definition of the limit of a function at a point. For your choice of any point x = a on any function's graph, you can select the value of e and see graphically the notion that you want to construct a box centered at the presumed limit point that contains the portion of the curve from x = a - d to x = a + d, for some d > 0. |
The Newton Difference-Quotient This DIGMath module lets you investigate the Newton Difference-Quotient, which is the basis for the definition of the derivative of a function at a point. You can enter any desired function on any interval, adjust the size of the step-size using a slider, and select the point on the curve. As the step-size decreases toward zero, you can see, both visually and numerically, how the difference-quotient approaches the value for the derivative of the function at the point, which is equivalent to the slope of the tangent line at that point. |
Tangent Line to a Curve This DIGMath spreadsheet allows you to investigate the tangent line to the graph of any desired function of the form y = f(x) on any desired interval a to b. You control the point of tangency using a slider and watch the effects on the resulting tangent line to the curve as the point changes. The length of the tangent line also changes to reflect the size of the slope or, equivalently, the value of the derivative of the function at the point. |
The Angle of Inclination of the Tangent Line This DIGMath module lets you investigate the angle of inclination of the tangent line to a curve as a function of the point x as you use a slider to move along the curve. |
Tangent Parabola to a Curve This DIGMath spreadsheet allows you to investigate the idea that, at each point on a smooth curve, there is a parabola (the second order Taylor polynomial approximation, actually) that is tangent to the graph of any desired function of the form y = f(x) and has the same curvature as the graph on any desired interval a to b. You control the point of tangency using a slider and watch the effects on the resulting tangent parabola as the point changes. |
Secant Lines This DIGMath module lets you investigate the convergence, as h approaches 0, of a sequence of secant lines to any desired curve at any desired point. Graphically, it is clear that the successive secant lines converge to the tangent line and numerically, the slopes of the successive secant lines converge to the slope of the tangent line at the point, which is the value of the derivative at that point. |
The Bisection Method This DIGMath module illustrates the convergence of the Bisection Method for finding the real zeros of any function y = f(x). To use it, you enter the desired function and an initial interval from a to b over which the function has at least one zero and the program performs successive iterations of the method, displaying the results both graphically and in a table. |
The Secant Method This DIGMath module illustrates the convergence of the Secant Method for finding the real zeros of any function y = f(x). To use it, you enter the desired function and an initial estimate x_{0} of any real zero and the program performs successive iterations of the method, displaying the results both graphically and in a table. |
The Regula Falsi (or False Position) Method This DIGMath module illustrates the convergence of the Regula Falsi Method for finding the real zeros of any function y = f(x). To use it, you enter the desired function and an initial interval that brackets a real zero x_{0} and the program performs successive iterations of the method, displaying the results both graphically and in a table. |
The Secant Parabola Method for Root Finding This DIGMath module illustrates the convergence of the Secant Parabola Method for finding the real zeros of any function y = f(x). It is based on the idea of using a parabola determined by three points to find the next approximation to a real zero x_{0} of the function. The next approximation is determined by one of the two real roots of the quadratic polynomial based on the quadratic formula. The program performs successive iterations of the method, displaying the results both graphically and in a table. |
A Function and its Derivatives This DIGMath spreadsheet allows you to investigate the behavior of any desired function of the form y = f(x) and its first and second derivatives on any desired interval a to b. Using a slider, you can control the position of a point on the curve of the function and see the tangent line to the curve at that point. A vertical line is also drawn through that point and connects to the other two curves, so you can see the corresponding slope of the tangent line on the graph of the derivative and the corresponding point on the graph of the second derivative. |
Mean Value Theorem This DIGMath spreadsheet allows you to investigate the Mean Value Theorem of any desired smooth function of the form y = f(x) on any desired interval a to b. There are two components to the investigation. First, you can control the point of tangency using a slider and watch the effects on the resulting tangent line both visually and numerically as the point changes in order to locate all the points c where the tangent line is parallel to the secant line connecting the endpoints of the curve on the desired interval. Second, using a slider, you can slide a line that is parallel to the secant line until it is tangent to the curve and then find the point of tangency. |
Derivative of the Exponential Function This DIGMath spreadsheet allows you to investigate the derivative of exponential functions of the form y = b^{x}and discover the base e. The spreadsheet shows the graph of the exponential function and its derivative. For some values of b, the derivative is below the function; for other values of b, the derivative is above the function. The challenge is to find the value for b as accurately as possible for which the derivative is exactly the same as the function itself. You control the value of b using a slider to produce the dynamic effects |
Derivative of the Natural Logarithm This DIGMath spreadsheet allows you to investigate the derivative of the natural logarithm function y = ln x. There are two components to this investigation. First, you can control the location of four points on the curve of the logarithmic function using sliders and see the corresponding four tangent lines. An associated chart shows the slopes of those four tangent lines, which fall into the pattern of a decaying power function y = x^{p} with p < 0. The spreadsheet uses Excel’s power function fit routine to calculate, graph, and display the equation of that power function. The second component generates sets of 20 random points on the natural logarithm curve, calculates the slope of the tangent line at each of these points, displays the results, and fits a power function to the 20 points. |
Exponential Rate of Change This DIGMath module lets you investigate the rate of change of exponential functions based on the base b. You can compare the rate of change of three exponential growth functions both graphically and numerically by looking at the slope of the tangent line to the three curves at different points of tangency as you use a slider. |
Quadratic Rate of Change This DIGMath module lets you investigate the rate of change of quadratic functions y = ax + bx + c based on the parameters a, b, and c. You can compare the rate of change of three quadratic functions both graphically and numerically by looking at the slope of the tangent line to the three curves at different points of tangency as you use a slider. There are three cases, one where you can select and change the values of a and b using sliders while c takes on three fixed values, a second where you can select and changes the values of a and c while b takes on three fixed values, and a third where you can select and change the values of b and c while a takes on three fixed values. |
Derivative of the Sine and Cosine This DIGMath spreadsheet allows you to investigate the derivative of both the sine and the cosine functions . The spreadsheet shows the graph of the either function and its derivative based on the slope of the tangent line. A slider allows the user to control a moving point along both curves drawn to see the way that the slope of the tangent line in the derivative plot relates to points on the graph of the original function. |
Discovering the Chain Rule This DIGMath module allows the user to discover the chain rule by examining the graphs of y = sin x, y = sin 2x, y = sin 3x, and y = sin x^{2}, along with the associated graph of its derivative. The graphs clearly indicate that the derivative of each sine function has the form of a cosine function, but with different amplitudes; for the last of the four functions, the amplitude is not constant, but rather increases in a linear pattern that is enveloped by the function 2x. |
Newton's Method This DIGMath module lets you investigate Newton's Method for finding the roots of a function f, both numerically and graphically. For any desired function, any desired starting value, and any desired number of iterations, you can see the set of iterated approximations in a table and the graph of the process, either in a fixed window of your choice (although the sequence of approximations may leave the window) or in a variable window that follows the sequence of iterations. |
The Differential This DIGMath spreadsheet lets you investigate the differential dy associated with a change dx in the independent variable for any desired function y = f(x). In particular, you can compare, both graphically and numerically, the change in the function along the tangent line to the curve at any given point and the actual change along the curve for any value of Dx at any desired point. |
Visualizing the Product Rule This DIGMath module helps you understand the product rule through a visual image. You can enter any two functions f(x) and g(x). The spreadsheet draws the graph of the two and the graph of the product and, as you trace along the curves, it shows the various values, including the slope of the point on the product curve. It also shows the graph of the product of the two derivatives, y = f(x) g(x), as well as the graph of the product rule function, y = f(x) g'(x) + f'(x) g(x). |
Visualizing the Quotient Rule This DIGMath spreadsheet helps you understand the quotient rule for the derivative of the quotient of two functions through a visual image. You can enter any two functions f(x) and g(x). The spreadsheet draws the graph of the two and the graph of the quotient f(x) / g(x); as you trace along the curves, it shows the various values, including the slope of the point on the quotient curve. It also shows the graph of the quotient of the two derivatives, y = f '(x)/ g'(x), as well as the graph of the quotient rule function, y = [f(x) g'(x) - f'(x) g(x)]/g^{2}(x). |
Projectile Motion This DIGMath spreadsheet allows you to investigate the path of a projectile launched from ground level with initial velocity and initial angle of inclination a . You control the values for the initial velocity and the angle via sliders and the spreadsheet draws the path of the projectile, allows you to trace along the path via another slider, and displays the time t, the coordinates of the tracing point, and the vertical velocity at each point. One page uses the English system of measurements in feet and seconds and another pages does the comparable displays in the metric system with centimeters and seconds. Among the suggested investigations is one involving finding the angle a for which the range of the projectile is maximum. |
Visualizing l'Hopital's Rule: 0/0 at x = a This DIGMath module lets you investigate l'Hopital's Rule both graphically and numerically for the limit of the ratio of two functions that leads to the indeterminate form 0/0. You can provide any two functions f and g you want that are both zero at a point x = a. The spreadsheet creates the graphs of both f/g and f'/g' and allows you to trace along both curves. It also provides the numerical values as you trace, particularly as you approach the limiting point a. It also shows the graphs of the two functions f and g together, as well as the graphs of the two derivative functions f' and g'. |
Visualizing l'Hopital's Rule: ∞/∞ at x = a This DIGMath module lets you investigate l'Hopital's Rule both graphically and numerically for the limit of the ratio of two functions that leads to the indeterminate form ∞/∞ as x approaches a finite point x = a. You can provide any two functions f and g you want that both become infinite as x approaches a point x = a. The spreadsheet creates the graphs of both f/g and f'/g' and allows you to trace along both curves. It also provides the numerical values as you trace, particularly as you approach the limiting point a. It also shows the graphs of the two functions f and g together, as well as the graphs of the two derivative functions f' and g'. |
Visualizing l'Hopital's Rule: 0/0 as x approaches ∞ This DIGMath module lets you investigate l'Hopital's Rule both graphically and numerically for the limit of the ratio of two functions that leads to the indeterminate form 0/0 as x approaches infinity. You can provide any two functions f and g you want that both approach zero as x becomes infinite. The spreadsheet creates the graphs of both f/g and f'/g' and allows you to trace along both curves. It also provides the numerical values as you trace, particularly as x increases toward infinity. It also shows the graphs of the two functions f and g together, as well as the graphs of the two derivative functions f' and g'. |
Visualizing l'Hopital's Rule: ∞/∞ as x approaches ∞ This DIGMath module lets you investigate l'Hopital's Rule both graphically and numerically for the limit of the ratio of two functions that leads to the indeterminate form ∞/∞ as x approaches infinity. You can provide any two functions f and g you want that both become infinite as x approaches infinity. The spreadsheet creates the graphs of both f/g and f'/g' and allows you to trace along both curves. It also provides the numerical values as you trace, particularly as x increases toward infinity. It also shows the graphs of the two functions f and g together, as well as the graphs of the two derivative functions f' and g'. |
The Fencing Problem This DIGMath program lets you investigate graphically the standard optimization problem of finding the dimensions of the largest rectangular pen(s) that a farmer can construct with a given amount of fencing (the perimeter). There are several scenarios: a single rectangle, a single rectangle using an existing wall or fence or river for one side, two rectangular pens, and three rectangular pens. Using a slider, you can see the effect on the total area of the pen(s) based on the perimeter and compare the solution observed graphically and numerically with the analytic solution. |
The Optimal Sum or Product of Numbers Problem This DIGMath module lets you investigate graphically the standard optimization problems of finding either two numbers with a given sum whose product is maximum or two numbers with a given product whose sum is minimal. Using a slider in each case, you can see the effect both graphically and numerically on the quantity being optimized and compare the solution observed with the analytic solution. |
The Optimal Sum of Squares of Two Numbers Problem This DIGMath module lets you investigate graphically the standard optimization problems of finding two numbers such that the sum of their squares is either a maximum or a minimum. Using a slider, you can see the effect both graphically and numerically on the sum of the squares of the two numbers with a sum that you select and you can then compare the solution observed with the analytic solution. |
The Largest Rectangle that Fits in a Circle Problem This DIGMath module lets you investigate graphically the standard optimization problems of finding the largest rectangle that fits into the unit circle. It draws the graph of the area function for the rectangle as a function of its horizontal length. Using a slider, you can see the effect both graphically and numerically on the area of the rectangle and you can then compare the solution observed with the analytic solution. |
The Wire Into a Square Plus a Circle Problem This DIGMath program lets you investigate graphically the standard calculus problem of cutting a length of wire into two pieces to form a square and a circle that encompass the greatest area. Using a slider, you can see the effect on the total area based on the length of wire used to form the square and compare the solution observed graphically and numerically with the analytic solution. |
The Wire Into a Square Plus an Equilateral Triangle Problem This DIGMath program lets you investigate graphically the standard calculus problem of cutting a length of wire into two pieces to form a square and a an equilateral triangle that encompass either the minimum area or the maximum area. Using sliders, you can see the effect on the total area based on the length of wire used to form the square and the triangle and compare the solution you observe graphically and numerically with the analytic solution. |
The Distance from a Point to a Parabola Problem This DIGMath spreadsheet lets you investigate graphically the standard calculus problem of finding the point on the parabola y = x^{2} that is closest to a given point P(a, b). You use sliders to enter the coordinates of P, and the spreadsheet shows the graph of the situation along with the graph of the distance function as a function of x = a. Using a slider, you can see the effect on both the overall situation and the distance function as the point changes and then you can compare the solution observed graphically and numerically with the analytic solution. |
The Distance from a Point to a Circle Problem This DIGMath spreadsheet lets you investigate graphically the standard calculus problem of finding the point on the circle x^{2} + y^{2} = r^{2} that is closest to a given point P(a, b). You use sliders to enter the coordinates of P and the value of the radius r, and the spreadsheet shows the graph of the situation along with the graph of the distance function as a function of x as well as the graph of the derivative function. Using a slider, you can see the effect on both the overall situation, the distance function and the derivative as the point changes and then you can compare the solution observed graphically and numerically with the analytic solution. |
The Run and Swim Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the optimal path for a person to run along a shore and then swim out to a particular point. Using a slider, you can see the effect on the total time based on the point where the person takes to the water and compare the solution observed graphically with the analytic solution. |
The Two Poles Staked to the Ground Problem This DIGMath spreadsheet lets you investigate the standard optimization problem in which there are two vertical poles and a guy wire that stakes both of them to the ground at some point between the two poles. The problem is to find the point so that the length of wire used is a minimum, based on the height of the two poles and the distance between them. You enter these three values using sliders and then trace both the graph of the total length of wire function and the derivative function, using a slider, to determine where the minimum occurs. You can then compare the solution you observe graphically and vertically with the analytic solution |
The Ladder Around a Corner Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the longest ladder that can be carried horizontally around a corner from one corridor to another corridor. Using a slider, you can see the effect on the length of the ladder based on the widths of the two corridors and compare the solution observed graphically and numerically with the analytic solution. |
The Printed Page Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the dimensions of the smallest sheet of paper that will contain a given area of printed material. Using a slider, you can see the effect on the total area of the page based on the side and top/bottom margins and the area of the printed material and compare the solution observed graphically and numerically with the analytic solution. |
The Norman Window Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the dimensions of the largest Norman Window (a rectangle surmounted by a semicircle) that can be constructed with a given perimeter. Using a slider, you can see the effect on the total area of the window based on the perimeter and the radius of the semicircle and compare the solution observed graphically and numerically with the analytic solution. |
The Open Box Problem This DIGMath program lets you investigate graphically the standard optimization problem of finding the dimensions of the largest (meaning greatest volume) open box that can be constructed by snipping off the four corners of a sheet of cardboard. The program has two pages: the first is the usual problem where the cardboard sheet is square and the second is the more sophisticated problem when the cardboard is rectangular. Using sliders, you can see the effect on the total volume of the box based on the lengths of the sides of the cardboard and the size of the corner being snipped away. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Open Box with a Given Amount of Material Problem This DIGMath program lets you investigate graphically the standard optimization problem of finding the dimensions of the largest (meaning greatest volume) open box with a square base that can be constructed using a given amount of cardboard for the base and four sides. Using sliders, you can see the effect on the total volume of the box and the associated derivative function based on the lengths of the sides and the height. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Cheapest Tin Can Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the dimensions of the cheapest (meaning, least surface area) open cylindrical tin can that can be constructed having a given volume. Using a slider, you can see the effect on the surface area of the tin can based on the volume and the radius of the tin can and the associated derivative function. You can compare the solution observed graphically and numerically with the analytic solution. |
The Cost of a Tin Can Problem This DIGMath module lets you investigate graphically the standard optimization problem of finding the dimensions of the cheapest cylindrical tin can that can be constructed having a given volume where there are costs associated with the metal used for the sides and for the top and bottom. Using a slider, you can see the effect on the total cost of the tin can based on the volume and the radius of the tin can and compare the solution observed graphically and numerically with the analytic solution. |
The Cylinder Inscribed in a Cone Problem This DIGMath spreadsheet lets you investigate graphically the standard optimization problem of finding the dimensions of the largest (meaning greatest volume) cylinder that can be inscribed in a right circular cone. The program lets you select the radius and height of the cone, using sliders. Then as you use a slider to select the radius of the cylinder, you can see the effect on the volume of the cylinder that is inscribed in the cone, as well as the value of the height of the cylinder. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Maximum Viewing Angle Problem This DIGMath spreadsheet lets you investigate graphically the standard optimization problem of finding the distance from a wall to stand to have the maximum viewing angle with which to view a painting hanging on the wall. Using sliders, you can select the height of the painting as well as the height from eye level to the bottom of the painting. You can then see the effect on the viewing angle a as you change the distance x from the wall. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Blowing Up a Balloon Related Rate Problem This DIGMath module lets you investigate graphically the standard related rate problem of finding the rate at which the radius of a balloon changes, at a particular instant, when air is blown into the balloon at a fixed rate. Using sliders, you can see how the volume of the balloon depends on the radius, how the volume changes over time, and the rate at which the radius changes as air is blown into the balloon, and you can also compare the solution observed graphically and numerically with the analytic solution. |
The Two Cars Approaching an Intersection Related Rate Problem This DIGMath spreadsheet lets you investigate graphically the standard related rate problem of finding the rate at which the distance between two cars approaching an intersection at right angles at different speeds, at a particular instant. Using sliders, you can see how the distances of the two cars from the intersection changes with respect to time, how the distance between the two cars changes over time, and how the rate of change of the distance changes over time. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Plane vs. the Radar Station Related Rates Problem This DIGMath module lets you investigate graphically the standard related rate problem of finding the rate at which the distance from a plane to a radar station changes at a particular instant when the plane flies at a fixed altitude with a fixed speed. Using sliders, you can see how the distance from the plane to the radar dish changes with respect to time, how the distance changes with respect to the horizontal distance, and how the rate of change of the distance changes over time. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Slipping Ladder Related Rate Problem This DIGMath module lets you investigate graphically the standard related rate problem of finding the rate at which the height of a ladder leaning against a wall decreases, at a particular instant, when the base of the ladder slips away from the wall at a given rate. Using sliders, you can see how the height of the ladder changes as a function of the distance the base is from the wall, how the height of the ladder changes with respect to time, and how the rate of change of the height changes over time. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Conical Pile of Sand Related Rate Problem This DIGMath program lets you investigate graphically the standard related rate problem of finding the rate at which the height of a conical pile of sand grows, at a particular instant, as additional sand is added to the pile. Using sliders, you can see the rate at which the height changes as the sand is added to the pile and compare the solution observed graphically and numerically with the analytic solution. |
The Filling a Conical Cup Related Rate Problem This DIGMath module lets you investigate graphically the standard related rate problem of finding the rate at which the height of liquid in a cone-shaped cup increase, at a particular instant, when the liquid is poured into the cup at a given rate. Using sliders, you can see how the height of the liquid changes as a function of the radius of the liquid at the surface, how the height of the liquid changes with respect to time, and how the rate of change of the height changes over time. You can also compare the solution observed graphically and numerically with the analytic solution. |
The Length of Shadow Related Rate Problem This DIGMath program lets you investigate graphically the standard related rate problem of finding the rate at which the shadow of a person walking away from a lamppost changes, at a particular instant. There are two scenarios. One is where the quantity of interest is the length of the shadow; the other is the rate at which the tip of the shadow is moving away from the light. Using sliders, you can see the rate at which the length of the shadow changes or the rate at which the tip of the shadow moves as the person's distance from the lamppost changes based on the person's height, the height of the light, and the rate at which the person walks. You can then compare the solution observed graphically and numerically with the analytic solution. |
The Third Derivative This DIGMath module lets you investigate the properties of the third derivative of any function and how it relates to the function, to the first derivative, and to the second derivative. |
Inverse Functions This DIGMath module lets you explore graphically the inverse of a function f. For any choice of a function that is strictly increasing or decreasing on an interval [a, b[, the program draws the graph of both the function and the inverse to demonstrate the symmetric relationship between the two. |
Cubic Splines This DIGMath spreadsheet lets you investigate the notion of cubic splines, a way to construct a smooth curve determined by a set of points in such a way that the curve is made up of a series of smoothly connected cubic curves. The spreadsheet has two components. In the first, the data points are grouped three at a time subject to the condition that the slope at the third point must be equal to the slope of the following cubic at the first point. In the second, the points are grouped two at a time subject to the two conditions that the slope and the value of the second derivative must agree at each of the overlapping points. |
Antiderivatives of a Function This DIGMath spreadsheet allows you to investigate two different aspects of the antiderivative of a function. First, you can enter any function on any interval and the minimum and maximum "starting" values for the antiderivative of the function. The spreadsheet draws three graphs; two correspond to the minimum and maximum starting values and the third is controlled by a slider that lets you vary the "starting" value, so that you can see a spectrum of different antiderivative functions. The second aspect of the antiderivative on a separate page draws the graph of the function along with one antiderivative and, with the use of a slider, allows you to see the correspondence of points on the two curves. |
The Second Fundamental Theorem This DIGMath module lets you investigate the Second Fundamental Theorem of Calculus, which says that the derivative of a definite integral with a variable limit of integration is equal to the function evaluated at that upper limit of integration. You can enter any desired function of x on any interval from a to b and the spreadsheet shows the graph of the function. You can then select any point between a and b with a slider and the spreadsheet sweeps out the area under the curve in one chart and also the graph of the area function in a second chart. |
Numerical Integration This DIGMath spreadsheet allows you to investigate four different methods to approximate the value of a definite integral -- using left and right-hand Riemann Sums, using the Trapezoid Rule, the MidPoint Rule, and Simpson's Rule for any function of the form y = f(x) on any desired interval [a, b]. You control the number of subdivisions for each method using a slider and the spreadsheet draws the graph of the function, draws the approximating subdivisions, and displays the associated approximation to the definite integral. |
Monte Carlo Method for Definite Integrals This DIGMath spreadsheet allows you to investigate visually and numerically the use of Monte Carlo simulations for estimating the value of the definite integral of any function of the form y = f(x) that is non-negative on any desired interval [a, b]. You control the number of random points, between 500 and 2500, via a slider and the spreadsheet draws the graph of the function, plots the random points, and displays the number and percentage of them that fall under the curve, and uses that percentage to estimate the area of the region. |
Mean Value Theorem for Integrals This DIGMath spreadsheet allows you to investigate the Mean Value Theorem for Integrals of any desired smooth function of the form y = f(x) on any desired interval a to b. First, you slide a horizontal line up and down until the area of the rectangle roughly matches the area of the region under the curve. Second, using a slider, you can slide a point along the curve to find the coordinates of the points where the horizontal line crosses the curve and so determine the values of c for which the theorem holds. |
Integrating the Acceleration Function This DIGMath module allows you to investigate visually the process of starting with the function representing the acceleration of a body as a function of time and then integrating the acceleration once to produce the velocity function and then integrating the velocity to produce the position function. |
Arc Length This DIGMath spreadsheet allows you to investigate the arc length of any curve y = f(x) on any desired interval a to b. You have the choice of the desired number of subdivisions, n = 4, 8, 16, ..., 128 and the program draws all of the associated piece-wise linear approximations to the arc length to illustrate the convergence graphically to the curve. It also displays the corresponding numerical values in a table to illustrate the convergence numerically. |
The Logistic Model This DIGMath module allows you to investigate visually two different aspects of the continuous logistic model based on the logistic differential equation P' = aP - bP^{2}. (1) You can enter, via sliders, values for the two parameters a and b, as well as the initial population value P_{0} and watch dynamically the effects on the resulting graph of the population, and also see the effects of changing any of these values. (2) You can also investigate visually the effects on the population of changes in the initial growth rate a and the maximum sustainable population (the limit to growth) L, along with the initial population value P_{0}, using sliders, and watching the dynamic effects on the graph of changing any of them. |
Comparing the Discrete and Continuous Logistic Growth Models This DIGMath spreadsheet lets you investigate the differences between the solutions of the discrete and the continuous logistic growth models. The discrete logistic model based on the logistic difference equation P_{n+1} = aP_{n} - bP_{n}^{2} and the continuous model is based on the differential equation P' = aP - bP^{2}. You can enter, via sliders, values for the two parameters a and b, as well as the initial population value P_{0 }and watch dynamically the effects on the resulting graph of the two population models, and also see the effects of changing any of these values. The spreadsheet also shows the graph of the difference between the two model functions, which gives a different, and often more insightful, view of how the two models compare. |
The Slope, or Tangent, Field of a Differential Equation This DIGMath module allows you to investigate the slope field (also called the tangent field) associated with a differential equation of the form y' = f(x, y). You can enter your choice of function, the window with x from xMin to xMax and y from yMin to yMax over which the tangent lines are to extend. The program then draws the associated slope field and, as you vary the coordinates of the initial point (x_{0}, y_{0}), it also draws the graph of the solution, which you can see following the path determined by the tangent line segments. |
Euler's Method for Numerical Solutions to Differential Equations y' = f(x, y) This DIGMath spreadsheet lets you investigate Euler's Method for generating numerical approximations to the solution of the differential equation y' = f(x, y), for any desired function of x and y, with any desired initial condition. The spreadsheet calculates and displays the approximation solutions corresponding to n = 4, 8, 16, ..., 128 steps across any desired interval, so you can observe the convergence of the successive approximations toward a smooth curve. |
Euler's Method for Numerical Solutions to Differential Equations y' = f(x) This DIGMath spreadsheet lets you investigate Euler's Method for generating numerical approximations to the solution of the differential equation y' = f(x), for any desired function of x (but not y) with any desired initial condition. The spreadsheet calculates and displays the approximation solutions corresponding to n = 4, 8, 16, ..., 128 steps across any desired interval, so you can observe the convergence of the successive approximations toward a smooth curve. |
Integration via Trig Substitutions This DIGMath spreadsheets lets you investigate the process involved in integration via trig substitutions. You can consider either substitutions of the form x = a/b sin θ or x = a/b tan θ. In either case, you can enter the values of the parameters a and b corresponding, respectively, to the coefficients of a^{2} - b^{2}x^{2} or a^{2} + b^{2}x^{2}. The program draws the graph of the original function on any desired interval of x-values, the graph of the area function on the same interval, and the graph of the transformed function in terms of the angle q on the equivalent interval of q -values. You can trace along all three curves simultaneously to see that the area under the transformed graph is always precisely the same as the area under the original graph. |
Integration by Parts This DIGMath spreadsheets lets you investigate graphically the process involved in integration by parts. You can consider three different forms for the integrand: x^{p} e ^{cx} , x^{p} sin (cx), and x^{p} cos (cx). In each case, you can enter the values of the parameters p and c. The program draws (1) the graph of the original function on any desired interval of x-values, (2) the graph of the area function on the same interval, (3) the graph of the function y = uv, (4) the graph of the integral of v du, and (5) the graph of the difference between uv and the integral of v du. You can trace along all five curves simultaneously to see that the area under the final graph is always precisely the same as the area under the original graph. |
Integration via the z-Substitution This DIGMath module lets you investigate graphically the process involved in integration by using the z-substitution z = tan (x/2), which is used to integrate rational functions of sine and cosine. For any choice of the three parameters a, b and c in the function 1/(a + b sin x + c cos x), the spreadsheet shows the result of the substitution and displays the graphs of the original function with the associated area highlighted on any desired interval, the graph of the area function, and the graph of the transformed function in terms of z with the area highlighted on the resulting transformed interval. In this way, it is evident that, as you trace along the various curves, the area swept out under the original and the transformed curves are identical. |
Partial Fraction Decompositions This DIGMath spreadsheet lets you investigate graphically the partial fraction decomposition of a rational function. There are three cases considered: (a) rational functions where the denominator consists of the product of two different linear terms; (2) rational functions where the denominator consists of the product of a linear function and an irreducible quadratic term; and (3) rational functions where the denominator consists of the product of a repeated (double) linear factor and a different linear factor. |
Universal Law of Gravitation This DIGMath spreadsheet lets you investigate the Universal Law of Gravitation that says that the gravitational force on an object is proportional to the product of the masses and inversely proportional to the square of the distance between them. You can select the relative masses of the two objects -- say, planets -- and select the proportion of the distance between them for a spacecraft travelling from one to the other. |
Series vs. Sequences This DIGMath module lets you investigate the meaning of a sequence compared to that of a series. You an enter the expression for any desired sequence, a_{k}, in terms of k. You can select the number of points you want displayed. The spreadsheet then draws that number of the points in one chart and simultaneously draws the associated graph showing the sum of the values of those terms from the sequence. |
A Bouncing Ball This DIGMath module lets you investigate the mathematics behind a bouncing ball. You can work in either the English or the metric system. You input the initial height from which a ball is dropped and the percentage of the velocity that is lost on each bounce. The spreadsheet draws the graphs of the height of the ball as a function of time, the velocity of the ball as a function of time, and the function giving the total distance traversed by the ball from the instant it is dropped to any time thereafter. |
Modeling a Spring This DIGMath module lets you investigate the behavior of a bob attached to a vertical spring. There are two options -- no damping where the motion depends only on the mass of the bob, the the initial displacement, and the spring constants or damping where the motion also depends on the viscous resistance coefficient. You can experiment with the effects of the coefficients in the case of simple harmonic motion (no damping) or the special cases of underdamping and overdamping when the resistance force is included. |
Taylor Approximations to the Exponential Function This DIGMath spreadsheet lets you investigate ideas on building polynomial approximations to the exponential function on any desired interval. Individual pages let you build linear, quadratic, cubic, quartic, and quintic polynomials by entering values for the coefficients via sliders and judging how well the resulting function fits the exponential curve graphically and numerically by the values of the greatest deviation and the sum of the squares of the deviations. |
Taylor Approximations to the Sine Function This DIGMath spreadsheet lets you investigate ideas on building polynomial approximations to the sine function on any desired interval. Individual pages let you build linear, quadratic, cubic, quartic, and quintic polynomials by entering values for the coefficients via sliders and judging how well the resulting function fits the sine curve graphically and numerically by the values of the greatest deviation and the sum of the squares of the deviations. |
Taylor Approximations to the Cosine Function This DIGMath spreadsheet lets you investigate ideas on building polynomial approximations to the cosine function on any desired interval. Individual pages let you build linear, quadratic, cubic, quartic, quintic, and 6th degree polynomials by entering values for the coefficients via sliders and judging how well the resulting function fits the cosine curve graphically and numerically by the values of the greatest deviation and the sum of the squares of the deviations. |
Taylor Approximations to the Natural Logarithm Function This DIGMath spreadsheet lets you investigate ideas on building polynomial approximations to the natural logarithm function on any desired interval within (0, 2). Individual pages let you build linear, quadratic, cubic, quartic, and quintic polynomials by entering values for the coefficients via sliders and judging how well the resulting function fits the natural logarithm curve graphically and numerically by the values of the greatest deviation and the sum of the squares of the deviations. |
Taylor Polynomial Approximations This DIGMath spreadsheet allows you to investigate the Taylor polynomial approximations to the four most common transcendental functions: the exponential function, the sine function, the cosine function, and the natural logarithm function. In each case, you can enter any desired interval and select which polynomial approximations you want to see displayed along with the function. For instance, with the exponential function, you can select any or all of the linear through the fifth degree polynomials; with the sine function, you can select any or all of the polynomials of odd degree up to the seventh degree. |
Taylor Polynomials for Any Function This DIGMath spreadsheet allows you to investigate the Taylor polynomial approximations to any desired functions. You need to enter the formula for the function, the center point for the polynomials, and the desired interval. You can select which polynomial approximations (linear, quadratic, ..., sixth degree) you want to see displayed along with the function. You can also trace along the curves and see the various numerical approximations for each of the active curves. |
Taylor Polynomials vs. the Center Point This DIGMath module lets you investigate the effects of changing the center point x_{0} at which Taylor polynomial approximations are based on the quadratic polynomial so created. The spreadsheet lets you explore the effects on both the cosine function (when the center is other than x = 0) or the natural logarithm function (when the center is other than x = 1). |
The Indeterminate Form 0/0 and Taylor Approximations This DIGMath module lets you investigate the indeterminate form 0/0 that arises in the limit as x approaches a of the ratio f(x)/g(x). l'Hopital's Rule is a way to find the value of this limit, but to understand where the limiting value comes from, it is better to look at the ratio of the corresponding Taylor approximations to f and g. You enter the two functions, the limit point a, the two Taylor polynomials and the spreadsheet produces a number of graphs, most importantly that of f/g and the ratio of the two Taylor approximations. |
Power Series Approximations This DIGMath spreadsheet allows you to investigate the successive polynomial approximations to a power series Σ a_{k} (x - c)_{k} based on the coefficients of the series and the center point. You can enter any desired interval and select which polynomial approximations you want to see displayed from the constant up through the quintic (fifth degree). |
Hyperbolic Functions This DIGMath module lets you investigate the hyperbolic functions y = sinh x and y = cosh x graphically and numerically based on their definitions in terms of the exponential functions y = e^{x }and y = e^{-x}. |
Fourier Series Approximations This DIGMath spreadsheet allows you to investigate the successive Fourier approximations to three common periodic functions -- the square wave, the triangle wave, and the sawtooth wave. In each case, you can select which of the first four Fourier approximations you want to see displayed and can turn them on or off via sliders to observe how the successive approximations relate to one another and how they begin to converge to the shape of the desired target wave. |
Graphs in Polar Coordinates This DIGMath spreadsheet draws the graph of any function r = f(Q) in polar coordinates on any interval of angles in radians from Q = a to Q = b. You can use a slider to trace out a moving point along the curve. |
Intersection of Polar Curves This DIGMath spreadsheet lets you locate the points of intersection of two curves in polar coordinates. You enter both desired functions in terms of Q and an interval of Q-values from a to b. You can select a moving point along each curve using a slider to find the points where the curves apparently intersect and see whether or not the two curves have the same pairs of coordinates. |
Slopes of Polar Curves This DIGMath spreadsheet lets you experiment with the slope of a curve in polar coordinates at any point along the curve. You enter any desired polar function in terms of Q on any desired interval and use a slider to move a tracing point along the curve. The program calculates and draws the associated tangent line. |
Taylor Approximations to Polar Curves This DIGMath spreadsheet lets you investigate how well Taylor polynomial approximations in terms of the variable Q approximate a polar curve r = f(Q), also in terms of Q. |
Graphs of Parametric Functions This DIGMath module lets you explore the graphs of parametric functions of the form x = f(t) and y = g(t) on any desired interval. You can trace along the curve using a moving point and see the coordinates of that point. |
Slope of a Parametric Curve This DIGMath spreadsheet lets you investigate the slope of the tangent line at any point along a parametric curve of the form x = f(t), y = g(t). |
Tangent and Normal Vectors to a Parametric Curve This DIGMath spreadsheet lets you investigate the unit tangent and normal vectors at any point along a parametric curve of the form x = f(t), y = g(t). |
Length of the Tangent Vector to a Parametric Curve This DIGMath spreadsheet lets you investigate the length of the tangent vector at any point along a parametric curve of the form x = f(t), y = g(t). |
Taylor Polynomial Approximations to Parametric Functions This DIGMath spreadsheet allows you to investigate Taylor polynomial approximations to a function given in parametric form: x = f(t) and y = g(t) on any desired interval. You have to enter the two functions f and g in terms of the parameter t, as well as the expressions for the desired Taylor approximations x = F(t) and y = G(t) of any degree you like to each. The spreadsheet then draws the graphs of the two curves, so you can compare how well the approximation matches and use a slider to trace around the original parametric curve. The spreadsheet also displays the coordinates of the points on both curves as you trace around. |
Linear Functions in Bi-angular Coordinates This DIGMath spreadsheet lets you investigate the graphs of linear functions in bi-angular coordinates, which are based on locating points in the plane in terms of two angles, θ and φ, at two points, the poles. The linear function takes the form φ =mθ + b and some very surprising shapes result, particularly as you use the sliders to vary the parameters. |
Functions in Bi-angular Coordinates This DIGMath spreadsheet lets you investigate the graphs of any function φ = f(θ) in bi-angular coordinates, which are based on locating points in the plane in terms of two angles, θ and φ, at two points, the poles. |
Curvature Function This DIGMath module lets you investigate the curvature function associated with a function of the form y = f(x) on any desired interval. You can trace along the curves of the function and the curvature function to see the coordinates of the point and the value of the curvature at that point. |
Osculating Circle This DIGMath spreadsheet lets you explore the notion of the osculating circle -- the circle that is tangent to a function y = f(x) at any given point and whose radius is equal to the radius of curvature of the function at that point. |
Surface Plot This DIGMath module lets you produce the graph (a surface plot) of a function of two variables, z = f(x, y) defined over any rectangular domain, x between xMin and xMax and y between yMin and yMax. You are able to rotate and make other changes to the view from within Excel. |
Contour Plots This DIGMath module produces the contour plot of a function of two variables, z = f(x, y) defined over any rectangular domain with x between xMin and xMax and y between yMin and yMax. You are able to rotate and make other changes to the view from within Excel. |
Contour Plot of the Area Function for a Rectangle This DIGMath module produces the contour plot of the area function A = x y for a rectangle, which is a function of two variables. It draws three contours automatically and lets you select a fourth contour value via a slider, so you can see the effects of changing that value, as well as tracing along all four contours. |
Contour Plot of the Area Function for an Ellipse This DIGMath module produces the contour plot of the area function A = π a b for an ellipse, which is a function of two variables -- the semi-major and the semi-minor axes a and b. It draws three contours automatically and lets you select a fourth contour value for A via a slider, so you can see the effects of changing that value, as well as tracing along all four contours. |
Contour Plot of the Volume Function for a Right-Circular Cylinder This DIGMath spreadsheet produces the contour plot of the volume function V = π r^{2} h for a right-circular cylinder of radius r and height h, which is a function of two variables. It draws three contours automatically and lets you select a fourth contour value for V via a slider, so you can see the effects of changing that value, as well as tracing along all four contours. You can investigate either the case where r is in terms of h or h is in terms of r. |
Contour Plot of the Volume Function for a Right-Circular Cone This DIGMath spreadsheet produces the contour plot of the volume function V = 1/3 π r^{2} h for a right-circular cone having base radius r and height h, which is a function of two variables. It draws three contours automatically and lets you select a fourth contour value for V via a slider, so you can see the effects of changing that value, as well as tracing along all four contours. You can investigate either the case where r is in terms of h or h is in terms of r. |
Curves in Space This DIGMath spreadsheet creates a representation of a curve in space based on the three parametric equations x = f(t), y = g(t), and z = h(t) on any desired interval for t from t = a to t = b. |
Curves in Space with Tangent and Normal Vectors This DIGMath spreadsheet creates a representation of a curve in space based on the three parametric equations x = f(t), y = g(t), and z = h(t) on any desired interval for t from t = a to t = b. It also shows, both graphically and numerically, the unit tangent vector and the unit normal vector to the curve at any desired point as you trace along the curve. |
Dynamic Investigatory Graphical Displays of Math: DIGMath Graphical Investigations for Numerical Analysis in Excel
Most of the following graphical explorations require the use of macros to operate. In order to use these spreadsheets, Excel must be set to accept macros. To change the security setting on macros:
- When you open the spreadsheet, a new bar appears near the top of the window that says "Security Warning: Active content has been disabled".
- Click on Options.
- Click on "Enable this Content" and then click OK.
The following are the DIGMath explorations that are currently completed and ready for use. (Many others are under development.) If you have any suggestions for improvements or for new topics, please pass them on also.
DIGMath Spreadsheets for Numerical Analysis | Category | Filter |
---|---|---|
The Bisection Method This DIGMath module illustrates the convergence of the Bisection Method for finding the real zeros of any function y = f(x). To use it, you enter the desired function and an initial interval from a to b over which the function has at least one zero and the program performs successive iterations of the method, displaying the results both graphically and in a table. | Root Finding Methods | Root Finding Methods |
The Secant Method This DIGMath module illustrates the convergence of the Secant Method for finding the real zeros of any function y = f(x). To use it, you enter the desired function and an initial estimate x0 of any real zero and the program performs successive iterations of the method, displaying the results both graphically and in a table. | Root Finding Methods | Root Finding Methods |
Newton's Method This DIGMath module lets you investigate Newton's Method for finding the roots of a function f, both numerically and graphically. For any desired function, any desired starting value, and any desired number of iterations, you can see the set of iterated approximations in a table and the graph of the process, either in a fixed window of your choice (although the sequence of approximations may leave the window) or in a variable window that follows the sequence of iterations. | Root Finding Methods | Root Finding Methods |
Bairstow's Method This DIGMath spreadsheet lets you investigate Bairstow's Method for approximating the complex roots of a polynomial by creating a sequence of quadratic functions that converges to an irreducible quadratic factor of the polynomial. You can use any polynomial up to 8th degree and any choice of initial estimate for the quadratic factor. The spreadsheet draws the first five quadratic approximations to illustrate the convergence both graphically and numerically. | Root Finding Methods | Root Finding Methods |
Taylor Polynomial Approximations This DIGMath spreadsheet allows you to investigate the Taylor polynomial approximations to the four most common transcendental function: the exponential function, the sine function, the cosine function, and the natural logarithm function. In each case, you can enter any desired interval and select which polynomial approximations you want to see displayed along with the function. For instance, with the exponential function, you can select any or all of the linear through the fifth degree polynomials; with the sine function, you can select any or all of the polynomials of odd degree up to the seventh degree. | Approximating a Function | Approximating a Function |
Power Series Approximations This DIGMath spreadsheet allows you to investigate the successive polynomial approximations to a power series Σ a_{k} (x - c)^{k} based on the coefficients of the series and the center point. You can enter any desired interval and select which polynomial approximations you want to see displayed from the constant up through the quintic (fifth degree). | Approximating a Function | Approximating a Function |
Fourier Series Approximations This DIGMath spreadsheet allows you to investigate the successive Fourier approximations to three common periodic functions -- the square wave, the triangle wave, and the sawtooth wave. In each case, you can select which of the first four Fourier approximations you want to see displayed and can turn them on or off via sliders to observe how the successive approximations relate to one another and how they begin to converge to the shape of the desired target wave. | Approximating a Function | Approximating a Function |
Lagrange Interpolation Formula This DIGMath module lets you investigate the Lagrange Interpolating Polynomial based on any set of up to 8 data points. The spreadsheet draws the graph of the Lagrange polynomial as it passes through the interpolating points. It also displays the equation of the polynomial using the Lagrange formula for the linear, quadratic, and cubic cases. | Approximating a Function | Approximating a Function |
Building Lagrange Interpolation Polynomials This DIGMath spreadsheet lets you investigate the way that the Lagrange Interpolating Polynomial is created as a combination of the individual component polynomials. You can look at the way that the linear, the quadratic, and the cubic Lagrange polynomials are built based on the sum of two linear, three quadratic, or four cubic polynomials, respectively. In each case, the individual components are drawn along with the Lagrange polynomial based on the data points entered and you can then examine the relationships between the roots of the polynomial components, the interpolating points, and the associated function values. | Approximating a Function | Approximating a Function |
Newton Interpolation Formula This DIGMath module lets you investigate the Newton Forward Interpolating Polynomial based on any set of up to 8 uniformly spaced data points. The spreadsheet draws the graph of each of the successive linear, quadratic, ... Newton polynomials as they pass through the various interpolating points. | Approximating a Function | Approximating a Function |
Approximating the Sine using Lagrange Interpolation This DIGMath spreadsheet lets you investigate how the sine function can be approximated on the interval [0, π/4] using Lagrange Interpolating Polynomials based on either three or four interpolating points given either in radians or degrees. The spreadsheet draws the graph of sine and the interpolating polynomial as well as the graph of the error function P(x) - sin x so you can see how well or poorly the polynomial fits the function as you change the interpolating points. | Approximating a Function | Approximating a Function |
Approximating the Sine using Newton Interpolation This DIGMath spreadsheet lets you investigate how the sine function can be approximated on the interval [0, π/4] using Newton Interpolating Polynomials based on either three or four uniformly spaced interpolating points given either in radians or degrees. The spreadsheet draws the graph of sine and the interpolating polynomial as well as the graph of the error function P(x) - sin x so you can see how well or poorly the polynomial fits the function as you change the interpolating points. | Approximating a Function | Approximating a Function |
Approximating the Cosine using Lagrange Interpolation This DIGMath spreadsheet lets you investigate how the cosine function can be approximated on the interval [0, π/4] using Lagrange Interpolating Polynomials based on either three or four interpolating points given either in radians or degrees. The spreadsheet draws the graph of cosine and the interpolating polynomial as well as the graph of the error function P(x) - cos x so you can see how well or poorly the polynomial fits the function as you change the interpolating points. | Approximating a Function | Approximating a Function |
Approximating the Cosine using Newton Interpolation This DIGMath spreadsheet lets you investigate how the cosine function can be approximated on the interval [0, π/4] using Newton Interpolating Polynomials based on either three or four uniformly spaced interpolating points given either in radians or degrees. The spreadsheet draws the graph of sine and the interpolating polynomial as well as the graph of the error function P(x) - cos x so you can see how well or poorly the polynomial fits the function as you change the interpolating points. | Approximating a Function | Approximating a Function |
Approximating the Exponential Function using Lagrange Interpolation This DIGMath spreadsheet lets you investigate how the exponential function y = e^{x} can be approximated on the interval [0, 1] using Lagrange Interpolating Polynomials based on either three or four interpolating points. The spreadsheet draws the graph of exponential function and the interpolating polynomial as well as the graph of the error function P(x) - e^{x} so you can see how well or poorly the polynomial fits the function as you change the interpolating points. | Approximating a Function | Approximating a Function |
Chebyshev Nodes This DIGMath module lets you investigate the so-called Chebyshev nodes that are often the best points to use to construct an interpolating polynomial based on a set of points. The Chebyshev nodes have the property that they provide the minimum value of the maximum error in the approximation at the interpolating points. The spreadsheet lets you enter your choice of either three or four interpolating points on the interval [-1, 1] and compares, both numerically and graphically, the maximum error to the corresponding maximum error using the Chebyshev nodes. | Approximating a Function | Approximating a Function |
Cubic Splines This DIGMath spreadsheet lets you investigate the notion of cubic splines, a way to construct a smooth curve determined by a set of points in such a way that the curve is made up of a series of smoothly connected cubic curves. The spreadsheet has two components. In the first, the data points are grouped three at a time subject to the condition that the slope at the third point must be equal to the slope of the following cubic at the first point. In the second, the points are grouped two at a time subject to the two conditions that the slope and the value of the second derivative must agree at each of the overlapping points. | Approximating a Function | Approximating a Function |
Tangent Line to a Curve This DIGMath spreadsheet allows you to investigate how the value of the derivative of a function at a point can be approximated by using the slope of the tangent line to the graph of any desired function of the form y = f(x) on any desired interval a to b. You control the point of tangency using a slider and watch the effects on the resulting tangent line to the curve, and therefore the derivative, as the point changes. The length of the tangent line also changes to reflect the size of the slope or, equivalently, the value of the derivative of the function at the point. | Approximating the Derivative | Approximating the Derivative |
Newton Difference Quotients This DIGMath module lets you investigate the notion of the Newton difference quotient as an approximation to the slope of the tangent line to a curve at a point. You can use any function, any interval, any desired step-size, and any point of tangency. The spreadsheet displays graphically the graph, the associated secant line and the triangle based on the point of tangency. If also displays numerically slope of the secant line compared to the slope of the tangent line, so you can see what happens to the agreement as the step-size is decreased or as the point of tangency moves along the curve. | Approximating the Derivative | Approximating the Derivative |
Numerical Integration Methods This DIGMath spreadsheet allows you to investigate four different methods to approximate the value of a definite integral -- using left and right-hand Riemann Sums, using the Trapezoid Rule, the MidPoint Rule, and Simpson's Rule for any function of the form y = f(x) on any desired interval [a, b]. You control the number of subdivisions for each method using a slider and the spreadsheet draws the graph of the function, draws the approximating subdivisions, and displays the associated approximation to the definite integral. | Numerical Integration | Numerical Integration |
Monte Carlo Method for Definite Integrals This DIGMath spreadsheet allows you to investigate visually and numerically the use of Monte Carlo simulations for estimating the value of the definite integral of any function of the form y = f(x) that is non-negative on any desired interval [a, b]. You control the number of random points, between 500 and 2500, via a slider and the spreadsheet draws the graph of the function, plots the random points, and displays the number and percentage of them that fall under the curve, and uses that percentage to estimate the area of the region. | Numerical Integration | Numerical Integration |
Euler's Method for Numerical Solutions to Differential Equations y' = f(x, y) This DIGMath spreadsheet lets you investigate Euler's Method for generating numerical approximations to the solution of the differential equation y' = f(x, y), for any desired function of x and y, with any desired initial condition. The spreadsheet calculates and displays the approximation solutions corresponding to n = 4, 8, 16, ..., 128 steps across any desired interval, so you can observe the convergence of the successive approximations toward a smooth curve. | Approximating Solutions of Differential Equations | Approximating Solutions of Differential Equations |
Euler's Method for Numerical Solutions to Differential Equations y' = f(x) This DIGMath spreadsheet lets you investigate Euler's Method for generating numerical approximations to the solution of the differential equation y' = f(x), for any desired function of x (but not y) with any desired initial condition. The spreadsheet calculates and displays the approximation solutions corresponding to n = 4, 8, 16, ..., 128 steps across any desired interval, so you can observe the convergence of the successive approximations toward a smooth curve. | Approximating Solutions of Differential Equations | Approximating Solutions of Differential Equations |
Second Order Homogeneous Differential Equations with Constant Coefficients This DIGMath module lets you investigate the behavior of the solutions of the second order homogeneous differential equation ay" + by' + cy = 0 for your choice of the coefficients a, b, and c and initial conditions y_{0} and y'_{0}. | Approximating Solutions of Differential Equations | Approximating Solutions of Differential Equations |