Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets
Grade Levels
Product Rating
File Type

Compressed Zip File

Be sure that you have an application to open this file type before downloading and/or purchasing.

208 KB|4 pages
Product Description
This project incorporates spreadsheets with scatter plots and lines of best fit. It asked students to perform various regressions, such as linear, power, exponential, and logarithmic, The students are asked to generate an model to help park rangers determine the weight of black bears by using only one of three measures, neck girth, length, and chest girth. Calculating the bears weights allow the rangers to anesthetize them in order for them to care for the bears. The r values in this project suggest that one model is best but if students also examine the graph they will find that the model with the highest r value does not in fact fit the points the best because it suggest that the measurement could be infinite. This is a great group project, especially if using Google Docs spreadsheets to collaboratively work on the project. After the spreadsheets and regressions, students are asked to complete a written lab report modeled after the traditional high school science template.
Total Pages
4 pages
Answer Key
Teaching Duration
2 hours
Report this Resource
Digital Download

Holland Math

More products from Holland Math
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up