Based on the data shown below, calculate the regression line (each value to two decimal places)
Be careful: Some programs may give the equation in the form y=b+mx
y= ⋅x+
x |
y |
2 |
20.81 |
3 |
19.5 |
4 |
18.29 |
5 |
16.78 |
6 |
16.37 |
7 |
17.96 |
8 |
15.05 |
9 |
14.74 |
10 |
14.73 |
11 |
15.72 |
12 |
15.21 |
13 |
12 |
We can use here Excel for regression equation
Step 1) Enter data in Excel .
Step 2) Data >>Data analysis >>Regression >>Select y and x values separately >>Ok
y=-0.60x+20.93
Get Answers For Free
Most questions answered within 1 hours.