Try It
Determine the Line of Best Fit
Problem #1
The table shows the number if farms operating in the United States from 1998 through 2006.
| Year (since 1998) | Number of Farms (in thousands) |
|---|---|
| 0 | 2192 |
| 1 | 2187 |
| 2 | 2167 |
| 3 | 2149 |
| 4 | 2135 |
| 5 | 2127 |
| 6 | 2113 |
| 7 | 2009 |
| 8 | 1089 |
Use Geogebra's spreadsheet to find the line of best fit.
Step 1: In the spreadsheet enter the Years in column A and the Number of Farms in column B.
Step 2: Highlight the range of cells from A1:B9.
Step 3: Click on the bar chart and choose Two Variable Regression Analysis.
Step 4: Below Regression Model, click on the down arrow and choose Linear.
Step 5: You should now have an equation of the form y = mx + b below the Regression Model.
y = ?
Answer: y = -17.9333x + 2201.5111
Problem #2
Mary decides to run a 5K road race every Saturday morning for the next two months. The table shows the number of miles she runs per week, along with her weekly 5K results.
| Miles Run (per week) | 5K Time (min) |
|---|---|
| 10 | 42 |
| 12.5 | 40 |
| 15 | 36 |
| 17.5 | 31 |
| 20 | 30 |
| 22.5 | 27 |
| 25 | 26 |
Use Geogebra's spreadsheet to find the line of best fit.
y = ?
Answer: y = -1.1429x + 53.1429
Problem #3
The table shows the average daily temperature of a small town in Alabama since January 1st.
| Days | Temperature (°F) |
|---|---|
| 0 | 62 |
| 2 | 60 |
| 4 | 67 |
| 6 | 63 |
| 8 | 81 |
Use Geogebra's spreadsheet to find the line of best fit.
y = ?
Answer: y = 2.05x + 58.4