Question

A drug was given to Sports Science students of approximately the same weight.   At the end of 20 days, their increase in weight and their average daily food intake were recorded. The data were as follows:

Intake, x       26        10        27        16        19        23        18        24

(g per day)

Gain, y          47        29        43        32        41        50        48        41

(g per day)

The coefficient of determination has a value of

		0.85 and measures the proportion of variation in the independent variable (x) explained by its linear relationship with the dependent variable (y)
		0.52 and measures the proportion of variation in the dependent variable (y) explained by its linear relationship with the independent variable (x)
		0.72 and measures the "goodness-of-fit" of the regression line to the points in the scatter plot
		0.85 and measures the proportion of variation in the dependent variable (y) explained by its linear relationship with the independent variable (x)

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

0.52 and measures the proportion of variation in the dependent variable (y) explained by its linear relationship with the independent variable (x)

B E F G H I K L M N O P Q R SUMMARY OUTPUT Chart Title Regression Statistics Multiple R 0 .724073 R Square 0.524282 Adjusted R Squai 0.444995 Standard Error 5.588285 Observations 8 y=0.947x+ 22.06 R?=0.524 ANOVA Axis Title Series1 Regression Residual Total NIIN SS 1 206.5014 6 187.3736 7 393.875 Linear (Series1) Intercept X Variable 1 Coefficientsandard Err 22.06362 7.765385 0.947798 0.368581 5 10 15 20 25 30 Axis Title