Regression Readout of the Data Analysis Toolpak - Excel: Videos & Practice Problems

Positive

Negative

0.857

-0.857

0.735

-0.735

0.857

0.735

0.926

0.850

5.61

2.37

37.67

6.14

$y=-1.77x+41.82$

$y=1.77x-41.82$

$y=1.77x+41.8$

$y=-1.77x-41.82$

(36.9, 46.7)

(1.15, 2.39)

(35.17, 48.47)

(1.31, 2.23)

$t$: 17.7

$P$-val: 17.7 × 10^-15

Yes

$t$: 17.7

$P$-val: 17.7 × 10^-15

Yes

$t$: 7.98

$P$-val: 4.43 × 10^-8

No

$t$: 7.98

$P$-val: 4.43 × 10^-8

Yes