Question

In: Economics

Question 2: Consider the following data on 10 students: Observation Weekly Food Expenditure Weekly Income 1...

Question 2:

Consider the following data on 10 students:

Observation Weekly Food Expenditure Weekly Income

1

80

200

2

70

100

3

60

80

4

80

220

5

100

230

6

70

160

7

50

60

8

70

80

9

70

130

10

80

140

(a) Calculate the values of β0 ̂ and β1 ̂ for the simple linear regression model given by:

food =β̂0 +β̂1 incomei + ei

  1. (b) Interpret those values in the context of the variable definitions and units of measurement.

  2. (c) Using the results from part (a), calculate the error (ei) for each of the 10 observations.

(c) Calculate and interpret the standard error of tĥe regression (se).

(d) Calculate and interpret the standard error of the β1 ̂ estimate (s β̂1)

(e) Test the null hypothesis that income has no effect on food expenditures. What do you conclude?

Solutions

Expert Solution

2.

(a)

Let us denote the weekly food expenditure by Y and the weekly income by X.

Now, we know that the formula for the estimated coefficients in the two variable regression model are:

where and .

So,

  

and

The computations required for the formulae are given in the table below:

Yi Xi yi xi xi^2 xi*yi
80 200 7 60 3600 420
70 100 -3 -40 1600 120
60 80 -13 -60 3600 780
80 220 7 80 6400 560
100 230 27 90 8100 2430
70 160 -3 20 400 -60
50 60 -23 -80 6400 1840
70 80 -3 -60 3600 180
70 130 -3 -10 100 30
80 140 7 0 0 0

where yi and xi are calculated in the 3rd and 4th column, the xi values are sqaured in the 5th column and the xi and yi columns are multiplied in the 6th column.

Now, for the formula, we need:

and , which will be obtained by summing the values in the 6th column and 5th column respectively.

Substituting these values in the formula, we get:

So, the values of are 46.96 and 0.186 respectively.

(b)

So, the estimated regression is given by:

So, the interpretation for the intercept coefficient is:

When the weekly income of a student is 0, then on average, the weekly food expenditure is 46.96 units.

So, the interpretation for the slope coefficient is:

When the weekly income of a student increases by 1 unit, then on average, the weekly food expenditure increases by 0.186 unit.

(c)

The value of error(ei) is given by the difference between the actual Y value and the predicted Y value.

-------------------------------------------(i)

The predicted Y value is given by the estimated regression:

So, for the 1st student for whom X1 = 200, the predicted Y value will be:

  

Similarly, the predicted Y values for all students are calculated in the 7th column and the error terms for all students are calculated using formula from eq(i) in 8th column in the given table:

Yi Xi yi xi xi^2 xi*yi Yi^ ei^
80 200 7 60 3600 420 84.16 -4.16
70 100 -3 -40 1600 120 65.56 4.44
60 80 -13 -60 3600 780 61.84 -1.84
80 220 7 80 6400 560 87.88 -7.88
100 230 27 90 8100 2430 89.74 10.26
70 160 -3 20 400 -60 76.72 -6.72
50 60 -23 -80 6400 1840 58.12 -8.12
70 80 -3 -60 3600 180 61.84 8.16
70 130 -3 -10 100 30 71.14 -1.14
80 140 7 0 0 0 73 7

(c)

The formula for standard error of the two variable regression is given by:

So, for this formula we'll require square of the error terms obtained in the previous table. The computations will be done in the 9th column in the given table:

Yi Xi yi xi xi^2 xi*yi Yi^ ei^ (ei^)^2
80 200 7 60 3600 420 84.16 -4.16 17.3056
70 100 -3 -40 1600 120 65.56 4.44 19.7136
60 80 -13 -60 3600 780 61.84 -1.84 3.3856
80 220 7 80 6400 560 87.88 -7.88 62.0944
100 230 27 90 8100 2430 89.74 10.26 105.2676
70 160 -3 20 400 -60 76.72 -6.72 45.1584
50 60 -23 -80 6400 1840 58.12 -8.12 65.9344
70 80 -3 -60 3600 180 61.84 8.16 66.5856
70 130 -3 -10 100 30 71.14 -1.14 1.2996
80 140 7 0 0 0 73 7 49

By summing all the values in the 9th column, we obtain:

Substituting this value in the formula and the value of n= 10, we get:

Hence, the standard error of the regression is 7.38.

(d)

The formula for standard error of the β1 ̂ is given as:

So,

The standard error of the estimated β1 ̂ is 0.04.

(e)

In order to test whether income has no effect on food expenditures or not, we'll create the hypotheses as:


So, for testing the given null hypothesis, we'll use t-test where t value is calculated as:

where is the hypothesised value for . In this case, from the hypothesis we can see that it is equal to 0.

So,

Now, the critical t-value is calculated for a given degrees of freedom(df ) and the level of significance().

So, we'll assume .

df = n - 2 = 10 - 2 = 8

So, the critical value of t at level of significance and df is given by:

So, at 5% level of significance and 8 df, the critical t-value is:

The decision rule is that if the computed t value is greater than the critical t value at the given level of significance, we reject the null hypothesis.

Since, in this case, at 5% level of significance, the computed t-value(4.65) is greater than the critical t- value(2.306), we reject the null hypothesis and conclude that income has a significant effect on food expenditures.


Related Solutions

How much does household weekly income affect the household weekly expenditure on food? The following data...
How much does household weekly income affect the household weekly expenditure on food? The following data shows household weekly expenditure on food and the household weekly income (all in dollars). Use the data below to develop an estimated regression equation that could be used to predict food expenditure for a weekly income. Use Excel commands for your calculations. FOOD INCOME y x 91 292 148 479 107 428 146 766 243 1621 312 1661 243 1292 272 1683 349 1808...
hypothetically data on weekly family consumption expenditure Y and weekly family income X. Y = 70...
hypothetically data on weekly family consumption expenditure Y and weekly family income X. Y = 70 ,65, 90, 95, 110, 115, 120, 140, 155, 150. AND X = 80, 100, 120, 140, 160, 180, 200, 220, 240, 260. from the data given above ,you are required to obtain the estimates of the regression coefficients,their variances and standard errors, the correlation and coefficient of determination
Consider the following data to be used in a regression. xi yi 1 0 2 10...
Consider the following data to be used in a regression. xi yi 1 0 2 10 3 25 4 30 5 35 (a) Find the values of b0 and b1. (b) Find the Coefficient of Determination. (c) Find the estimated standard deviation of b1 and the corresponding t-statistic. At the 1% level of significance, can you reject the null hypothesis? Make sure you state the null and alternative hypotheses. (d) Find the F-statistic. Is the equation significant at the 1%...
Question 1 of 10 Express net income as a common-size percentage using the following data. Sales...
Question 1 of 10 Express net income as a common-size percentage using the following data. Sales - $45,000; cost of goods sold - $29,340; gross profit from sales - $15,660; operating expenses - $10,800; net income - $4,860. A. 100 percent B. 31 percent C. 12 percent D. 10.8 percent            Question 2 of 10 The excess of total assets over total liabilities is called working capital. A. True B. False Question 3 of 10 Any reputable company has a cash...
1.-The following data were used in a regression study. Observation 1 2 3 4 5 6...
1.-The following data were used in a regression study. Observation 1 2 3 4 5 6 7 8 9 xi 2 3 4 5 7 7 7 8 9 yi 4 5 4 7 4 6 9 6 11 (a)Develop an estimated regression equation for these data. (Round your numerical values to two decimal places.) ŷ =______ 2.-The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine....
The following data were used in a regression study. Observation 1 2 3 4 5 6...
The following data were used in a regression study. Observation 1 2 3 4 5 6 7 8 9 xi 2 3 4 5 7 7 7 8 9 yi 5 5 4 7 4 6 9 5 11 (a) Develop an estimated regression equation for these data. (Round your numerical values to two decimal places.) ŷ =   xi 1 2 3 4 5 yi 3 8 5 11 12 The estimated regression equation for these data is  ŷ = 1.50...
Problem 1: The following data is in the following of Table. Education Expenditure data, Assuming there...
Problem 1: The following data is in the following of Table. Education Expenditure data, Assuming there is unique variance in each region, using two stage approach weighted least square approach to estimate X1, X2 and X3 effect on Y. (sas programming) STATE Y X1 X2 X3 Region ME 189 2828 351 508 1 NH 169 3259 346 564 1 VT 230 3072 348 322 1 MA 168 3835 335 846 1 RI 180 3549 327 871 1 CT 193 4256...
Suppose a consumer organization was interested in studying weekly food & living expenses of college students...
Suppose a consumer organization was interested in studying weekly food & living expenses of college students living on college campuses in New York State. A survey of 40 students yielded the following (ordered array) to the nearest 10 cents. 38.3 50.0 54.5 60.0 39.4 50.5 55.6 61.2 40.0 51.2 56.3 62.3 41.2 51.7 57.0 63.8 43.7 51.8 57.0 64.0 45.0 52.0 57.4 64.5 47.5 53.8 58.5 65.0 48.2 53.8 58.5 65.0 48.5 54.0 59.4 66.2 50.0 54.0 60.0 67.0 I...
Question 1 The table below shows the income and expenditure relating to a product in 2019...
Question 1 The table below shows the income and expenditure relating to a product in 2019 and 2020. Complete the table with the correct value in every empty cell, and present a finished version in your answer book. Cost / Revenue Table 2019/2020 Year 2019 (£s) 2020 (£s) % Change Element Fixed Cost 2520 +5 Total Variable Cost Total Cost 6000 Total Revenue 6325 +8 Profit 411
Question #1 - Using the data on 4137 college students, the following equation was estimated by...
Question #1 - Using the data on 4137 college students, the following equation was estimated by OLS colgpai = β0 + β1 hsperci + ui , i = 1, 2, . . . , 4137 where colgpa is measured on a four-point scale and hsperc is the percentile in the high school graduating class (defined so that, for example, hsperc = 5 means the top 5 percent of the class). Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 2.9803872 0.0141800...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT