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

    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

    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
  • Good Essays

    (b) In addition to price fluctuations, you are also uncertain of how much of the material will be required for the project. Scope changes and site conditions will affect the amount of material actually needed. The most likely amount required is 36 tons. However, as little as 28 tons or as much as 56 tons might be required. What is the expected amount of the material needed for the project?…

    • 2102 Words
    • 7 Pages
    Good 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

    48 Kayla and Zhejia expect the price they charge per hour to increase by 6 each year. Variable costs are expected to increase by 3 per year. All payments for costs are made in the year incurred. Depreciation is 20,000 per year so no calculation is need for depreciation. Each owner will bill 30 hours per week for 48 weeks. There will be no other employees. Kayla and Zhejia plan to sell the business for 1.5 times what they paid for the building and the land at the end of the 15th year (750,000). Neither the land nor the building will appreciate in value during the 15 year period. The gain on the sale of the business will equal the sales price minus the book value of the land and the…

    • 1986 Words
    • 5 Pages
    Good 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
  • Good Essays

    Boyz-In-Hood Analysis

    • 310 Words
    • 2 Pages

    Off the top of my head, one movie that had a impact on me was Boyz-In-Da-Hood. The film was about a young man who had made an agreement with his mom...that if he kept getting in trouble he had to go live with his dad. Upon living with his father, he was exposed to things he didn't see living with his mother. His father was quite the intelligent man, and was able to keep him out of trouble. Some of the lessons his father taught him stuck with me to this day about how to be leader, He spoke on Gentrification in a clip in the film. Towards the end of the film, The young man was walking to the store with his friend and his friend was killed. At this point he was given a crucial fork in the road and had a very difficult decision to make. Rather…

    • 310 Words
    • 2 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

    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

    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

    ˆ  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
  • 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
  • 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
  • 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