Reference no: EM131093798
1. A developer who specializes in summer cottage property is considering purchasing a large tract of land adjoining a lake. The current owner of the tract has already subdivided the land into separate building lots and has prepared the lots by removing some of the trees. The Developer wants to forecast the value of each lot. From previous experience, she knows that the most important factors affecting the price of the lot are size (lot size), number of mature trees (Trees), and distance to the lake (Distance). From a nearby area, she gathers data for 60 recently sold lots. These data are stored in Devloper.xls.
(a) Perform a multiple regression in Excel and provide excel output for the regression model = βo + βo(Lot size) + βo(Trees) + βo(Distance) + ∈
(b) Write down the equation for regression line.
(c) What is the standard error of estimate? Interpret its value.
(d) What is the coefficient of determination? What does this statistic tell you?
(e) What is the coefficient of determination, adjusted for degrees of freedom? Why does this value differ from the coefficient of determination? What does this tell you about the model?
(f) Test the overall utility of the model. What does the p-value of the test statistic tell you?
(g) Interpret each of the coefficients.
(h) Test to determine whether each of the independent variables is linearly related to the price of the lot.
|
Use the hildreth-lu procedure to obtain
: a. Use the Hildreth-Lu procedure to obtain a point estimate of the autocorrelation parameter. Do a search at the values p = .1 .. 2 ..... 1.0 and select from these the value of p that. minimizes SSE.
|
|
Point estimate of the autocorrelation parameter
: Refer to McGill Company sales Problem 12.17 is Assume that regression model (12.1) is applicable and that the Cochrane-Orcutt procedure is to be employed.
|
|
Obtain the equation for the ad curve
: Economics 111 - Principles of Economics - Accelerated Treatment - Problem Set 8. Obtain the equation for the AD curve. (Hint: Set Y = C + I + G and solve to see how Y depends on P.) Solve for the equilibrium output and the equilibrium price level
|
|
Examples of radical expressions
: Provide two examples of radical expressions, that include variables. One example should have more than one term. The examples must be worked out fully, vertically.
|
|
What is the coefficient of determination adjusted for degree
: Perform a multiple regression in Excel and provide excel output for the regression model = βo + βo(Lot size) + βo(Trees) + βo(Distance) + ∈ Write down the equation for regression line. What is the standard error of estimate? Interpret its value. What..
|
|
Continues to eat at the same rate
: A certain animal in the zoo has consumed 39 pounds of food in six days. If it continues to eat at the same rate, in how many more days will its total consumption be 91 pounds?
|
|
Find the dot product
: Find the dot product
|
|
Simple linear regression model by ordinary least squares
: McGill Company sales. The data below show seasonally adjusted quarterly sales for the McGill Company (Y, in million dollars) and for the entire industry (X, in million dollars) for the most recent 20 quarters
|
|
What is the nominal interest rate on this loan
: Suppose you borrowed $200 one year ago and must now repay $210. The inflation rate over the year was 7 percent. What is the nominal interest rate on this loan
|