||


AlgebraLAB
AlgebraLAB



About Us
About Us
external image spacer.gif
Activities
Activities
external image spacer.gif
Career Profiles
Career Profiles
external image spacer.gif
Connections
Connections
external image spacer.gif
Site Directions
Site Directions
external image spacer.gif
Glossary
Glossary
external image spacer.gif
Lessons
Lessons
external image spacer.gif
Reading Comprehension Passages
Reading Comprehension Passages
external image spacer.gif
Practice Exercises
Practice Exercises
external image spacer.gif
Search AlgebraLAB
Search AlgebraLAB
external image spacer.gif
StudyAids: Recipes
StudyAids: Recipes
external image spacer.gif
Word Problems
Word Problems
external image spacer.gif







EXCEL Modeling: Quadratic Functions


Often while studying quadratic functions it is useful to model how the graphs of these functions change as their amplitude (a), vertical displacement (k), and horizontal displacement (h).

external image 9328c7f1-2e05-4103-9f65-fcd02736d137.gif

The first EXCEL sheet shown above can be modified manually by entering values into the highlighted yellow column. Those changes are automatically updated on the blue graph and reflected in the rebuilt equation shown below. This spreadsheet's operation does not require the enabling of macros.external image 2d04cf79-5b93-4422-8ba7-0ac3300055b2.gif
To run the second EXCEL sheet you have to enable the use of macros to operate the sliders. The range for each slider has been optimized for supporting the spreadsheet's programming.

external image 89aa9359-8306-48e9-8ed2-5e220fe3b0e9.gif

Information about graphing quadratic functions can be located in the following lessons:# Graphs of Quadratic Functions
  1. Translations of Parabolas


C Colwell
B Richey

**Show Related AlgebraLab Documents**

AlgebraLAB
Project Manager
Copyright © 2003-2011
Mainland High School
All rights reserved.