We're Open
+44 7340 9595 39
+44 20 3239 6980

Finance 6279: Real Estate

  100% Pass and No Plagiarism Guaranteed

Finance 6279: Real Estate

 

  1. PS2_data_2016.xlsx is an Excel file that contains housing transaction records of a

town for 76 quarters (19 years). Each observation corresponds to a transaction,

and one house can appear in multiple observations. The dataset has 22 variables,

and brief variable description is provided in the worksheet “Info.” The data also

contains 76 dummy variables (d_q1 through d_q76) indicating the quarter of

sales for each house.

  1. Calculate mean, median, standard deviation, minimum, maximum,

percentiles at 1%, 5%, 10%, 25%, 75%, 90%, 95%, 99% of “Living Area” and

“Price”.

  1. Calculate the percentage of “YES” response for all the dummy variables.
  2. Estimate a hedonic regression of log house price on all the variables in the

dataset using the data in “Hedonic Data” worksheet.

  1. Using estimated coefficients on quarterly dummy variables, construct a

house price index (with 1st quarter as base quarter) and draw a graph

(quarter on the horizontal axis and index on the vertical axis).

  1. “Repeat Sales Data 3” worksheet only includes transaction information for

houses sold more than once. Compare characteristics of the whole dataset

and the repeat sample

  1. Estimate a repeat sales regression of log house price using the data in

“Repeat Sales Data 3” worksheet. Assume all the housing characteristics

didn’t change between sales.

  1. Repeat the part (d) using regression results from the part (f).
  2. Estimate a repeat sales regression of log house price using the data in

“Repeat Sales Data 3” worksheet again. However, do NOT assume all the

housing characteristics didn’t change between sales, but include all the (first

order differenced) housing characteristics in the regression.

  1. Repeat the part (d) using regression results from the part (h).
  2. Compare three housing price indices ((d), (g), (i)) and explain why the

constructed indices are not the same.


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: Finance 6279: Real Estate
  • Price: £ 120
  • Post Date: 2021-05-26T04:26:26+00:00
  • Category: Research Paper Queries
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Finance 6279: Real Estate Finance 6279: Real Estate
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Very professional and effective assignment writing service.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I was worried about the plagiarism ration in my dissertation. But thanks to my dedicated writer, I received 0% plagiarism in all the chapters. I owe my writer a million thanks..!