Annual high temperatures in a certain location have been tracked
for several years. Let XX represent the year and YY the high
temperature. Based on the data shown below, calculate the
regression line (each value to two decimal places).
y = x +
x | y |
---|---|
3 | 38.36 |
4 | 36.38 |
5 | 30.3 |
6 | 30.62 |
7 | 26.04 |
8 | 25.16 |
9 | 20.58 |
10 | 18.5 |
11 | 15.02 |
12 | 10.94 |
13 | 7.86 |
14 | 8.18 |
15 | 3.9 |
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
Therefore, regression equation is,
Get Answers For Free
Most questions answered within 1 hours.