Question

In: Statistics and Probability

We have consumption (Y) of ten people and their savings(X) data is given below. Pleaseestimate the...

We have consumption (Y) of ten people and their savings(X) data is given below. Pleaseestimate the regression model ( ) for the variables by using normal equations and showing all calculation steps clearly in the Ms World file. (25p). Also interpret the coefficients (10p)

X 10 30 15 20 12 10 18 22 25 26

Y 24 72 36 48 28.8 24 43.2 52.8 60 62.4

Solutions

Expert Solution

Here the given data is

X Y
10 24
30 72
15 36
20 48
12 28.8
10 24
18 43.2
22 52.8
25 60
26 62.4
Sum 188 451.2
Average 18.8 45.12

Obtaining the equation

From the given data obtaining the means

= 188 / 10

= 18.8

= 451.2 /10

= 45.12

Calculating the , and  

X Y
10    24    -8.8 -21.12    185.856 77.44 446.0544
30 72 11.2 26.88 301.056 125.44    722.5344
15 36 -3.8 -9.12 34.656 14.44 83.1744
20 48 1.2 2.88 3.456 1.44 8.2944
12 28.8 -6.8 -16.32 110.976 46.24 266.3424
10 24 -8.8 -21.12 185.856 77.44 446.0544
18 43.2 -0.8 -1.92 1.536 0.64 3.6864
22 52.8 3.2 7.68 24.576 10.24 58.9824
25 60 6.2 14.88 92.256 38.44 221.4144
26 62.4 7.2 17.28 124.416 51.84 298.5984
Sum 188 451.2 0 1064.64 443.6 2555.136

Therefore the = 443.6   , = 2555.136 and   = 1064.64

Obtaining the coefficients

= 2.4

Now obtaining

= 45.12 - 2.4 * 18.8

= 0

The regression equation is

Substituting the values

Y = 0 + 2.4 X

Consumption =  0+ 2.4 *savings

Interpretation

SInce the is zero ,the regression line passes through origin .i.e the expected value of consumption (Y) is zero if all savings(X) are zero.

Since , it is positive , hence there is positive correlation between consumption (Y) and savings(X) . i.e for every additional unit in savings(X) there is 2.4 unit increase in consumption (Y).(and vice -versa)


Related Solutions

We have consumption (Y) of ten people and their savings(X) data is given below. estimate the...
We have consumption (Y) of ten people and their savings(X) data is given below. estimate the regression model (?̂? = ? − ??? ) for the variables by using normal equations and showing all the calculation steps clearly in the.. Ms World file.. Also interpret the coefficients X Y 13 39 17 51 19 57 22 66 21.6 64.8 22.4 67.2 18 54 20.8 62.4 22 66 24.2 72.6
for the quantitative variables x and y are given in the table below. These data are...
for the quantitative variables x and y are given in the table below. These data are plotted in the scatter plot shown next to the table. In the scatter plot, sketch an approximation of the least-squares regression line for the data. x y 7.4 6.6 4.0 5.0 2.0 3.9 3.1 5.0 9.4 8.4 4.7 5.9 6.6 6.2 8.5 6.9 7.9 7.3 1.6 3.7 4.4 4.6 2.8 3.9 2.7 3.1 5.7 6.3 5.9 7.3 9.7 8.3 6.9 6.3 8.8 8.4 x...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y 2 70 0 70 4 130 a.) By hand, determine the simple regression equation relating Y and X. b.) Calculate the R-Square measure and interpret the result. c.) Calculate the adjusted R-Square. d.) Test to see whether X and Y are significantly related using a test on the population correlation. Test this at the 0.05 level. e.) Test to see whether X and Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X         Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X         Y 2          70 0          70 4          130 Test to see whether X and Y are significantly related using a t-test on the slope of X. Test this at the 0.05 level. Test to see whether X and Y are significantly related using an F-test on the slope of X. Test this at the 0.05 level.
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y 2 70 0 70 4 130 a.) By hand, determine the simple regression equation relating Y and X. b.) Calculate the R-Square measure and interpret the result. c.) Calculate the adjusted R-Square. d.) Test to see whether X and Y are significantly related using a test on the population correlation. Test this at the 0.05 level. e.) Test to see whether X and Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X         Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X         Y 2          70 0          70 4          130 By hand, determine the simple regression equation relating Y and X. Calculate the R-Square measure and interpret the result. Calculate the adjusted R-Square. Test to see whether X and Y are significantly related using a test on the population correlation. Test this at the 0.05 level. Test to see whether X and Y are significantly related using a...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y...
Suppose we have the following data on variable X (independent) and variable Y (dependent): X Y 2 70 0 70 4 130 (SOLVE ALL BY HAND, NOT BY USING EXCEL) By hand, determine the simple regression equation relating Y and X. Calculate the R-Square measure and interpret the result. Calculate the adjusted R-Square. Test to see whether X and Y are significantly related using a test on the population correlation. Test this at the 0.05 level. Test to see whether...
For the X,Y data below, compute:
For the X,Y data below, compute: X Y 2 5 4 6 4 7 5 11 6 12 (a) the correlation coefficient and determine if it is significantly different from zero. (b) find the regression line. c) interpret the coefficient of the regression line d) at 5% test if the Y is related to X e) find the coefficient of determination and interpret this coefficient. f) predict the value of average Y if the average of X is13 g) at...
Given below is a bivariate distribution for the random variables x and y. f(x, y) x...
Given below is a bivariate distribution for the random variables x and y. f(x, y) x y 0.3 50 80 0.2 30 50 0.5 40 60 (a) Compute the expected value and the variance for x and y. E(x) = E(y) = Var(x) = Var(y) = (b) Develop a probability distribution for x + y. x + y f(x + y) 130 80 100 (c) Using the result of part (b), compute E(x + y) and Var(x + y). E(x...
Suppose we have the following data on a dependent variable (Y) and an explanatory variable (X):...
Suppose we have the following data on a dependent variable (Y) and an explanatory variable (X): X          Y 0          140 1          140 4             0 0          180 3           80 2          120 4             0 1          200 2          120             3            40 Calculate the simple linear regression equation by hand. Show all your work. Using your result, predict the value of Y when X = 3.5. (15 points) Calculate the R2and the adjusted R2measures (by hand) and provide an interpretation of what they tell us. (12 points) Test (by hand) to see whether this is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT