12. The data set used in Exercise 11 is used again. This time it is used...

Transcribed Image Text:

12. The data set used in Exercise 11 is used again. This time it is used to estimate how the proportion of the household budget spent on transportation WTRANS depends on the log of total expenditure In(TOTEXP), AGE, and number of children NK. The output is reported in Table 3. (a) Write out the estimated equation in the standard reporting format with standard errors below the coefficient estimates. (b) Interpret the estimates b, b3, and b4. Do you think the results make sense from an economic or logical point of view? (c) Are there any variables that you might exclude from the equation? Why? (d) What proportion of variation in the budget proportion allocated to transport is explained by this equation? (e) Predict the proportion of a budget that will be spent on transportation, for both one- and two- children households, when total expenditure and age are set at their sample means, which are 98.7 and 36, respectively. Table 3 Dependent Variable: WTRANS Included observations: 1519 Variable Coefficient Std.Error t-Statistics Prob. C -0.0315 0.0322 -0.9776 0.3284 In(TOTEXP) 0.0414 0.0071 5.8561 0.0000 AGE -0.0001 0.0004 -0.1650 0.8690 NK -0.0130 0.0055 -2.3542 0.0187 R-square 0.0247 Mean dependent var 0.1323 S.D. Dependent var 0.1053 12. The data set used in Exercise 11 is used again. This time it is used to estimate how the proportion of the household budget spent on transportation WTRANS depends on the log of total expenditure In(TOTEXP), AGE, and number of children NK. The output is reported in Table 3. (a) Write out the estimated equation in the standard reporting format with standard errors below the coefficient estimates. (b) Interpret the estimates b, b3, and b4. Do you think the results make sense from an economic or logical point of view? (c) Are there any variables that you might exclude from the equation? Why? (d) What proportion of variation in the budget proportion allocated to transport is explained by this equation? (e) Predict the proportion of a budget that will be spent on transportation, for both one- and two- children households, when total expenditure and age are set at their sample means, which are 98.7 and 36, respectively. Table 3 Dependent Variable: WTRANS Included observations: 1519 Variable Coefficient Std.Error t-Statistics Prob. C -0.0315 0.0322 -0.9776 0.3284 In(TOTEXP) 0.0414 0.0071 5.8561 0.0000 AGE -0.0001 0.0004 -0.1650 0.8690 NK -0.0130 0.0055 -2.3542 0.0187 R-square 0.0247 Mean dependent var 0.1323 S.D. Dependent var 0.1053