Comparing Linear, Quadratic, Exponential Regressions w/Spreadsheets

Grade Levels
Product Rating
Not yet rated
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
0.2 MB   |   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
Answer Key
N/A
Teaching Duration
2 hours

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$2.00
Digital Download
ADD ONE TO CART
User Rating: 3.9/4.0
 (10 Followers)
$2.00
Digital Download
ADD ONE TO CART
Comparing Linear, Quadratic, Exponential Regressions w/Spr
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