5. The apartment complex was completed at the time of the 2007 recession; So, there were not many ready buyers and the maker was forced to sell the complex at an auction, 9 months after opening. This is in contrast to how real estate general works, which are usually seller and broker specified. Whereas in this case the prices are completely buyer-specified and hence customer-oriented. 6. Some of the units in the complex were furnished (had furniture) by the maker and some were not. Given the information above, the current owner of the apartment complex is unsure of how the floor level of the unit (floor numbers), proximity to the elevator, advantage of a beach view, etc. affect the prices of the units sold at auction. Your task is to investigate these relationships using the given data which contains the following. 1. Sale price. Measured in hundreds of dollars. 2. Floor level. The floor location of the unit; the levels range from one to eight. 3. Distance (Elevator proximity). This is simply the number of apartment units from the elevator. Two more points were added to the apartments in building Beta to account for the walking distance in the connecting area between the two buildings. Thus, the distance of unit 107 from the elevator would be Four, and the distance between unit 115 and the elevator would be ten. The distance is also given on the figure. 4. View of the beach. This simply marks whether it is possible to see the beach view or not and specified with a dummy variable, 1 if the unit has a beach view and 0 otherwise. 5. End variable. This variable to denote the units present in the center of the complex is also specified with a dummy variable, 1 for units whose view of the sea is partially blocked and 0 otherwise 6. Furniture. 1 means the unit has some furniture and 0 if otherwise. Here are the things that are required in this project. 1. Do a primitive analysis of the Sale price data. Do not use any other variables as of yet. Analyze only Sale price. Summarize the data using various measures and develop a frequency distribution. Which measure of central tendency would you use? (1-2 paragraphs) 2. What factors influence the sale price? Do not use regression yet. Use any of the other methods discussed in the course to answer this question. For example, you may develop a few charts or use pivot tables (various configurations) to analyze the influence of other variables. Summarize your observations (1-2 paragraphs). Build a (multi variable) regression model that predicts the sale price of an apartment unit. Present the regression output in your report. 4. Prepare a professional summary report (2-3 paragraphs) that presents the results of your regression analysis. Be sure to interpret some of the coefficients. 5. Prepare a technical summary of your regression analysis (2-3 paragraphs) Note: For questions 2 and 4, your analysis will fetch more points if you DO NOT use technical terms and present it in a way that can be comprehended by a person who has not taken MGMT 350