x y

1 5
2 9
3 10
4 10.5
5 11
Use a spreadsheet calculator to determine the equation of the line of best fit for the data in this table. Round to the nearest hundredth, if needed.

(1 point)
Responses

y=5.05x+1.35
y equals 5.05 x plus 1.35

y=x+5
y equals x plus 5

y=1.35x+5.05
y equals 1.35 x plus 5.05

y=5x+11

1 answer

To determine the equation of the line of best fit (linear regression) for the provided data points, we can use the linear regression formula.

The formula for a linear regression line is:

y=mx+b

Where:

  • m is the slope of the line,
  • b is the y-intercept.

Using a spreadsheet calculator, we can find the slope m and the y-intercept b by inputting the data:

  1. For the provided data points:

    • (1, 5)
    • (2, 9)
    • (3, 10)
    • (4, 10.5)
    • (5, 11)
  2. After calculating using the linear regression tools in the spreadsheet, we may find:

  • Slope m1.35
  • Y-intercept b5.05

Thus, the equation of the line of best fit would be:

y=1.35x+5.05

Looking at your response options, the correct one is:

y = 1.35x + 5.05