Question

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).

x	y
4	46.84
5	40.02
6	38.5
7	34.88
8	35.16
9	32.54
10	28.52
11	24.6
12	21.98
13	20.66
14	17.54
15	13.82
16	11.7

y =________ x + __________

Box 1: Enter your answer as an integer or decimal number. Examples: 3, -4, 5.5172
Enter DNE for Does Not Exist, oo for Infinity

Box 2: Enter your answer as an integer or decimal number. Examples: 3, -4, 5.5172
Enter DNE for Does Not Exist, oo for Infinity

Answer 1

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,

y=-2.76x+55.83