Question

We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:

Amount Spent on Travel	Age
850	39
997	43
993	50
649	59
1265	25
680	38

Find the correlation coefficient.

	a.	0.6476
	b.	0.4194
	c.	-0.6476
	d.	0.5806

We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:

Amount Spent on Travel	Age
850	39
997	43
993	50
649	59
1265	25
680	38

Find MSE (s-squared/ s^2).

	a.	111147.28
	b.	38461.01
	c.	196.11
	d.	667.33

We are interested in studying the linear relationship between someone's age and how much they spend on travel. The following data is provided:

Amount Spent on Travel	Age
850	39
997	43
993	50
649	59
1265	25
680	38

Find the standard error of b1, s-b1 (s sub b1).

	a.	2.88
	b.	5.67
	c.	8.29
	d.	7.59

Answer 1

Let's use excel:

Multiple regression using Excel.

Step 1) First enter the given data set in excel columns.

Step 2) Then click on Data >>> Data Analysis >>>Regression >>>>OK

Step 3) Input Y Range: Select the data of column "A"

Input X Range: Select the data of column "B"

Click on Labels

then Click on Output Range

Look the following Image

Then Click on OK, we get following result.

From the above output the regression equation is as follows:

Find the correlation coefficient.

The correct option is as c

Multiple R = 0.6476

The sign of the coefficient of x is negative so the sign of correlation coefficient is also negative.

So correct answer is c) -0.6476

Find MSE (s-squared/ s^2).

The MS Residual is the MSE = 38461.01

So correct choice is as b.  38461.01

Find the standard error of b1, s-b1 (s sub b1).

correct choice is as d. 7.59