Whoops! Something went wrong.

Click here to refresh the page

Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets
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
  • Comments & Ratings
  • Product Q & A
Digital Download

Holland Math

Digital Download
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