Excel 3.docx - Jing Kui Dr Vivek Shah QMST 2333 Excel Analysis#3 Gulf Real Estate Properties Inc has two different type of condominium sales Gulf view

Excel 3.docx - Jing Kui Dr Vivek Shah QMST 2333 Excel...

This preview shows page 1 out of 1 page.

Jing Kui Dr. Vivek Shah QMST 2333 Excel Analysis #3 Gulf Real Estate Properties Inc. has two different type of condominium sales - Gulf view and No Gulf view. There are 42 condominiums on the Gulf view list and 20 condominiums on the No Gulf view list. Each report lists their condominiums list price, sale price and days to sell. From the Histogram chart, we can see there are about 15 Golf view condominiums took 102 days to get sold. And about 24% of the condominium sold less than 58 days, 21% of them took 147 days to get sold and only 7% took more than 200 days to get sold. On the other side for No Gulf view condominiums, it seems even quicker to get them sold. The data shows that 9 out of 20 condominium took only 121 days to get sold and about 90% of them could be sold within 193 days; only 2 condominium sold more than 266 days. From the descriptive statistic chart, we figure out that the mean sales price of Gulf view house is $454,688, the highest sales price is
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

Unformatted text preview: $975,000 and the lowest sales price is $165,000, the average dates that it takes to sell is 103 days. Let us see the other side for No Golf view houses, the average sales price for No Gulf view condominium is $ 203,520, the highest sales price is $ 292,500 and the lowest selling price is $135,500; the average days to sell is 130 days. The fastest day the one get sold it only took 48 days and the longest one took 338 days. Gulf Real Estate just signed contracts for two new listings: a Gulf view condominium with a list price of $589,000, from the data analysis, I estimate the final selling price would be $570,000 and around 93 days required to sell it. For the Non Golf view condominium with a list price of $285,000 I estimate the final selling price is $275000 and could require 135 days to sell the units....
View Full Document

  • Summer '08
  • Mendez

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors