Preview

Econometrics. a Regression Analysis

Satisfactory Essays
Open Document
Open Document
2927 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Econometrics. a Regression Analysis
Question 1:
Run the regression Report your answer in the format of equation 5.8 (Chapter 5, p. 152) in the textbook including and the standard error of the regression (SER). Interpret the estimated slope parameter for LOT. In the interpretation, please note that PRICE is measured in thousands of dollars and LOT is measured in acres.

Model 1: OLS estimates using the 832 observations 1-832
Dependent variable: price

VARIABLE COEFFICIENT STDERROR T STAT P-VALUE

const 119.575 1.54566 77.362 <0.00001 *** lot 1.38850 0.209083 6.641 <0.00001 ***

Mean of dependent variable = 122.076 Standard deviation of dep. var. = 44.3478 Sum of squared residuals = 1.55189e+006 Standard error of residuals = 43.2406 Unadjusted R-squared = 0.05045 Adjusted R-squared = 0.04931 Degrees of freedom = 830 Log-likelihood = -4313.52 Akaike information criterion (AIC) = 8631.03 Schwarz Bayesian criterion (BIC) = 8640.48 Hannan-Quinn criterion (HQC) = 8634.66

PRICEi=119.575+1.3885LOTi, 1.54566 (0.209083)
R2=0.05045, SER=43.2406

Slope coefficient = 1.3885

* After analyzing the slope coefficient, one can assume that a one unit (one acre) change in lot would lead to an overall predicted change in price of $1388.50.

Question 2:
Now run the regression
Report your answer using the format of equation 5.8 (Chapter 5) in the textbook, including and SER. Interpret the estimated slope parameter for LOT. Also report the ANOVA table provided by GRETL (for use in answering question (9) below). In the interpretation, please note that PRICE is measured in thousands of dollars and LOT is measured in acres

Model 2: OLS estimates using the 832 observations 1-832
Dependent variable: price

VARIABLE COEFFICIENT STDERROR T STAT P-VALUE

const

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Xacc 280 Week 2 Mini Case

    • 502 Words
    • 3 Pages

    * The property, including the two plants, can be assumed as Plant & Equipment, and given the appraised value of $200,000.…

    • 502 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dallas Project

    • 563 Words
    • 2 Pages

    The developers spent $100 million on the land, $100 million on the recreation facilities, & $100 million on streets, parks, utilities, lots, & greenways. Based on these expenditures, I first allocated half of the $33 million purchase price ($16.5 million) to the recreation complex under the assumption that the $100 million recreation expenditures plus ½ of the $100 million land expenditures were related to the recreation complex. Next, I allocated $10,000 to each of the 500 finished lots ($5 million total), since that was the stated cost to complete each unfinished lot. This left $11.5 million of the $33 million purchase price to still be allocated ($33 - $16.5 - $5). I divided the remaining $11.5 million by the total number of lots to be sold (25,000, including finished & unfinished) to get a cost per lot of $460. I multiplied this amount by the number of lots that were sold each year, including to the finished lots that were sold in 1992. This allocation method resulted in a Net Present Value for the project, at 12%, of $124,290,018.…

    • 563 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Busn311 Unit 5

    • 1291 Words
    • 6 Pages

    Running head: UNIT 5 INDIVIDUAL PROJECT BUSN311 by Barbara Ryals Quantitative Methods and Analysis Irene Tsapara November 7, 2010 Benefits | Intrinsic | | | | | | | | | 1.4 | 5.5 | correl | | | | | | | | 5.4 | 5.5 | 0.209015 | | | | | | | | 6.2 | 5.2 | | | | | | | | | 2.3 | 5.3 | SUMMARY OUTPUT | | | | | | | 4.5 | 4.7 | | | | | | | | | 5.4 | 5.5 | Regression Statistics | | | | | | | 6.2 | 5.2 | Multiple R | 0.209015 | | | | | | | 2.3 | 5.3 | R Square | 0.043687 | | | | | | | 4.5 | 4.7 | Adjusted R Square | 0.009533 | | | | | | | 5.4 | 5.4 | Standard Error | 0.396714 | | Intrinsic is higher | | | | 6.2 | 6.2 | Observations | 30 | | |…

    • 1291 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    1. Calculate the mean, median, range, and standard deviation of home price and size. For the assignment document you will submit, you can cut and paste the answers from the Analysis ToolPak, or you can place your results in the same Excel sheet as the data, below the existing table. Be sure to label each of your data cells. (For example: Row 84 Column B should contain the calculated Mean of Home Selling Prices; Column A already contains the title, mean; Column C the Mean of Home Size in Square Feet; Row 85 Column B should contain the Home Median price, and so on. Highlight all your results in yellow.) Then cut and paste that spreadsheet into a Word document. Be sure to verbally summarize your data findings in four or five sentences that will help a home buyer make a purchasing decision in the Florida real estate market.…

    • 1273 Words
    • 18 Pages
    Good Essays
  • Satisfactory Essays

    Food for Thought

    • 587 Words
    • 3 Pages

    Baked Beans owns a manufacturing facility in Chino, California. The facility is comprised of land, two buildings, and machinery. There are no other significant assets located at this facility. The land could be rezoned into a residential subdivision for a nominal fee and management has determined that the fair value of the underlying land as residential property would be $30 million, after considering costs necessary to prepare it for use as residential lots (i.e., demolition costs of the building, net…

    • 587 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Predict the sales price of a 1134-square-foot home with a lot size of 15,400 square feet and 2 bedrooms.…

    • 465 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    ˆ  4.99  0.73LY  0.37LP  23.36D2002  36.25D2008  2.79(LY * D2002)…

    • 575 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    Now let’s get down to business and find out how the Gravity Equations work in different…

    • 2386 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    2. Using Excel or other calculation software, input the data you collected in criterion one to calculate an estimated regression. Then, from the calculation provided, interpret the coefficient of determination, indicating how it will influence your decision to open the pizza business. Explain any additional variables that may improve the coefficient of determination.…

    • 261 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Computer Exercises C1.2 Use the data in BWGHT.RAW to answer this question. . summ Variable | Obs Mean Std. Dev.…

    • 4874 Words
    • 20 Pages
    Good Essays
  • Good Essays

    Data in Housing Worksheet

    • 766 Words
    • 4 Pages

    d. Evaluate the model by testing the slope coefficient to see if there is a relationship at the 5%…

    • 766 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Real Estate Statistics

    • 451 Words
    • 2 Pages

    a. Let selling price be the dependent variable and size of the home the independent variable. Determine the regression equation. Estimate the selling price for a home with an area of 2,200 square feet. Determine the 95 percent confidence interval and the 95 percent prediction interval for the selling price of a home with 2,200 square feet.…

    • 451 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    In this part, the objective is to present and discuss aspects of the Labour Force Survey data. Histograms and a…

    • 1231 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Econometrics: Exercises

    • 1186 Words
    • 11 Pages

    Report your results in equation form along with the number of observations and R2. What…

    • 1186 Words
    • 11 Pages
    Good Essays
  • Good Essays

    Baron Coburg.

    • 468 Words
    • 2 Pages

    Frederick: At the end of the year Frederick's net income totaled 119 bushels--significantly less than Ivan's net income because of the land allotment differences. Frederick produced a net income of 11.9 bushels per acre, a favorable difference of 11% over Ivan's 10.7. His operating expenses per acre and total expenses per acre were $0.50 and $1.60, which is higher than Ivan's largely due to the fixed costs of the plow and ox. Frederick's gross margin per acre is 12.4 bushels compared to Ivan's 11.05 bushels, a difference of 12.2%. Frederick'sbalance sheet total of 143 bushels is also less when looking at the raw data. However, when the…

    • 468 Words
    • 2 Pages
    Good Essays