6. From the following table giving the quantity demanded of a commodity (Y), its price (X1), and the consumers income (X2) from 1986 to 2005, a) estimate the regression equation of Y on X1 and X2, b) test at the 5 % level for the statistical significance of the slope parameters, c) find the unadjusted and the adjusted coefficients of determination and d) test at the 5 % level for the overall statistical significance of the regression. Show all your results to three decimal places.
7. If the regression of Y on X1 and X2 is run in double log form for the data of Problem 5, the results are as follows;
In Yt= -0.533 - 0.389 ln X1t + 0.769 ln X2t
R2= 0.95054 F= 183,582
Compare the above results with those of the above problem. Which are better? Why?
8. Starting with the data for problem 6 and the data on the price of a related commodity for years 1981 to 2000 given below, we estimated the regression for the quantity demanded of a commodity which now relabel Q^x, on the price of the commodity which we now label Px consumers income which we now label Y and the price of the related commodity Pz, and we obtained the following results (Please refer to the attachment for the data).
a) Explain why you think we have chosen to include the price commodity Z in the above regression.
b) Evaluate the above regression results.
c) What type of commodity is Z? Can you be sure?
[Please refer to the attachment for details]
This solution is comprised of detailed step-by-step calculations and analysis of the given problems related to Statistics and provides students with a clear perspective of the underlying concepts.