Question

Data collected on the discharge of the Colorado River and speed are given in the table:

Discharge (ft3)	Speed
1.3	2.3
2.2	0.99
5.8	3.5
11	5
12	16
14	22
16	27
21	14
49	33

Find r², and interpret the results.

0.67; The least-squares regression line, given by ŷ = 3.95 + 0.82x, is a good fit for the data. 0.82; The least-squares regression line, given by ŷ = 3.95 + 0.82x, is not a good fit to the data. 0.82; The least-squares regression line, given by ŷ = 0.82 + 3.95x, is a good fit for the data. 0.67; The least-squares regression line, given by ŷ = 3.95 + 0.67x, is not a good fit for the data.

Answer 1

In Excel type all data, here speed (y) depends on the discharge of corolado river (x variable)

To run regression

Data-data analysis- regression - choose x and y array - ok

Then from the out put we get,

y^ = 3.9469 + 0.667 * x

y^ = 3.95 + 0.67 * x. ( On rounding)

And R^2 = 0.67

That means only 67% of variation in y is explained by the independent variable in the model

So this The least-squares regression line, given by ŷ = 3.95 + 0.67x, is not a good fit for the data.

Option 4