Question

Compute the requested quantities from the data below.

1.83 16

2.19 12

2.27 9

2.57 14

2.63 15

2.65 18

2.66 14

2.77 13

2.83 13

2.87 14

2.9 21

2.94 19

3 8

3 14

3.04 12

3.06 15

3.07 11

3.09 10

3.11 9

3.11 15

3.15 13

3.16 14

3.2 14

3.21 13

3.24 9

3.25 19

3.3 10

3.3 13

3.31 11

3.33 10

3.35 11

3.36 11

3.37 14

3.39 17

3.41 14

3.42 10

3.45 14

3.46 13

3.47 14

3.49 11

a = [ Choose ]-0.02825617.18198-0.01485-0.16809-5.21470.168093.339081-0.02154-1.31150.0282542.7654

b = [ Choose ]-0.02825617.18198-0.01485-0.16809-5.21470.168093.339081-0.02154-1.31150.0282542.7654

r = [ Choose ]-0.02825617.18198-0.01485-0.16809-5.21470.168093.339081-0.02154-1.31150.0282542.7654

r squared = [ Choose ]-0.02825617.18198-0.01485-0.16809-5.21470.168093.339081-0.02154-1.31150.0282542.7654

Answer 1

there are two columns two variable and observations

if we assume first column as x and second column as y : then

a = constant is = 17.18198 and

b= slope = -1.3115

r = -0.16809

r squared = 0.028254

use Excel : output