Copy the database below into an excel sheet.
Run QX on the four regressors: PX, M, PY and lagged Qx.
Write down the estimated linear demand equation with t-statistics under the estimated coefficients as done above. In addition, write down the R-square and explain what it means. Explain the statistical significance of the t-statistics for each regressor. Significance of T-statistics is usually given by the P-values in the regression output. We will not use it in here because we have a small sample which will bias the P-values. There are three levels of significance: 1%, 5% and 10% represented by ***, ** and *, respectively. Do not use the computed P-values of this small sample regression. Instead, use the following conventional t-statistics significance ranges used for large data:1.63 <t < 1.96 (10%); 1.96 < t < 2.54 (5%); and t > 2.54 (1%). This means in your regression output, look at the t-statistics column for each regressor. Then place the value of that computed t-statistic in one of the above ranges. The P-values given in the regression output are sensitive to sample size and are not accurate.
Check the signs of the estimated coefficients. Do the signs follow the theory as expected? Examine the sign for each regressor and point out what they mean.
Calculate the short-run and long-run price and income elasticities of demand for good X using the averages for the quantity, price and income? Based on the income elasticity, what type is good X?
Short Run P elasticity for a linear Eq. = [slope of price]*(Average Price/Average quantity)
Long Run P elasticity for a linear Eq. = (SR P elasticity) /(1- slope of lagged Q)
or = [slope of price / (1- slope of the lagged variable)]*(Average Price/Average quantity).
They are the same.
Average = sum/n, skipping first row.
The short-run and long run income elasticities are calculated the same way. Here the slope is for income and the average for income (see page 31 or the solved regression on pp 32-33). What type of good is X with respect to income elasticities?
Short Run Income elasticity for a linear Eq. = [slope of Income]*(Average Income/Average quantity)
Long Run Income elasticity for a linear Eq. = (SR Income elasticity)/(1- slope of lagged Q)
Calculate the short-run and long-run cross price elasticities with respect to Py (see p. 28 and p. 30 in the notes). What type of goods are X and Y with respect to these elasticities?
Can you think of another independent variable that you may add to the above equation? What will the sign of this variable be? Specify the name of this variable. Do not include Weather in this equation.
Is this a supply or demand equation? Why? Forget about signs. Look for other clues in the equation.
SEE DATA BELOW:
Copy the data from Word to excel.
After transferring the data set from Word to excel, make sure you follow these steps;
Highlight all the cells in excel.
Right click on any cell in the data sheet in excel.
Click on FORMAT CELLS.
Under CATEGORY, click on NUMBER.
Then click OK.
Spring 2010: Regression Assignment Data Sheet (linear case only))
When you copy in Excel 2007: COPY, PASTE SPECIAL then TEXT.