How to respond to The Condo Sales Case on attached pages.How to perform a descriptive analysis of the data with correlations and build and test a regression model.

A common way to describe regression studies is to show the final regression equation (or at least the coefficients labeled by the variable values they multiply and R-square and discuss your interpretation - then in an appendix show the descriptive statistics and correlations, pointing out strong correlations - then show at least the initial regression with all the plots andmention potential problems - then briefly list. Show any transformations what you did to improve R-square leading to the final model - it is not necessary to show all the intermediate regressions unless they show something interesting.

Step-by-step in Excel would be extremely helpful!

Distance from Ground Fear clevalor -1 113 015 017 109 121 123 |125 101 103 JOS LOT |DOW III 114 016 018 120 122 124 Building ] Building ! Traffic flow Parking Figure C5.1 Layout of condominium complex he 3, and the distance between unit 113 and Your objective for this case is to build a re- the elevator would be 4. The variable levels are grewion model that accurately predicts the sale 1,1, . . .. 15. price of a condominium unit sold at suction. i Vine of ocean, The presence of chernce of an Prepare a professional document that pecornts the ocean view is recorded for each unit and specified results of your analyse Include graphs that dem- with a dummy variable (1 if the unit poucars ansirate how each of the independent variables in an ocean view and 0 if not). Note that units not your model allecis auction price. A layout of the possessing an ocean view face the parking lot. data file is described below. & End unit. We expect the partial reduction of view of end units on the ocean side (numbers riding in 11) to reduce their sale price. The ocean view of these Variable Type end units is partially blocked by building 2. This PRICE ON qualitative variable is also specified with a dummy FLOOR ON variable (1 if the unit has a unit number ending in DISTANCE ON i1 and O if not). VIEW OL . Fuminine. The presence of absence of furniture is ENDUNIT OL recorded for each unit and is represented with a single dummy variable (1 if the unit was furnished FURNISH and ( if not ). a Dou In CONDOThe Condo Sales Case This case involves an investigation of the factors that affect the sale price of oceanside condominium units. It represents an extension of an analysis of the same data by Herman Kelting. Although condo sale prices have increased dramatically over the past 20 years, the relationship between these factors and sale price remains about the same. Consequently. the data provide valuable insight into today's condominium sales market. The sales data were obtained for a new oceanside data that we, to a high device, seller and booker condominium complex consisting of two adjacent specified and connected eight-floor buildings. The complex 6. Many unsold units in the complex were furnished contains 200 units of equal size (approximately by the developer and rented prior to the suction. 500 square feet each). The locations of the build- Consequently, some of the units bid on and sold at ings relative to the ocean, the swimming pool, the auction had furniture; other did not parking lot, etc., are shown in the accompanying figure. There are several features of the complex This condominium complex is obviously that you should note: unique, For example, the single elevator located at one end al the complex produces a remarkshly L. The units facing south, called oncan wew, face the high level of both inconvenience and privacy for the beach and ocean. In addition, units in building ! people occupying units on the top floors in building have a good view of the pool. Units to the rear 2. Consequently, the developer is unsure of how the of the building, called bay-view, face the parking height of the unit (floor number), distance of the lot and an area of land that ultimately harder a unit from the elevator, presence or absence of an bay. The view from the upper Doors of these units ocean view, cic., affect the prices of the units sold at is primarily of wooded, sandy terrain. The bay is auction, To investigate these relationships, the fol. very diniant and barely visible. lowing data (saved in the data file) were moonded 1. The only elevator in the complex is located at for each of the 106 units sold at the auction the east end of building 1, as are the office and the game roam. People moving to of from the L. Sale price, Measured in hundreds of dollars higher floor units in building 2 would likely use (adjusted for inflation ). the elevator and move through the passages to 1. Flow height. The floor location of the unit; the their units. Thus, units on the higher floors and at variable levels are 1, 2, . . . . 8. a greater disiance from the elevator would be less 1. Distance from elevator. This distance, measured convenient; they would require greater effort in along the length of the complex, is expressed in moving baggage, groceries, and so on and would number of condominium units An additional two be farther away from the game room, the office, units of distance was added to the units in build. and the swimming pool. These units also possess ing 1 to account for the walking distance in the an advantage: there would be the least amount of connecting area between the two buildings Thus traffic through the hallways in the area and hence the distance of unit 105 from the elevator would they are the most private. 3. Lower-floor oceanside units are most suited to active people; they open onto the beach, ocean, and pool. They are within easy reach of the game room, and they are easily reached from the park- ing area. 4. Checking the layout of the condominium com- plex, you discover that some of the units in the center of the complex, units ending in numbers 11 and 14, have part of their view blocked. 5. The condominium complex was completed at the time of the 1975 recession; sales were slow and the developer was forced to sell most of the units at auction approximately 18 months af- ter opening. Comequently, the auction data are completely buyer specified and hence consumer oriented in contrast to most other real estate salesPICTION FLOOR DISTANCEINW IND FURNGH AUCTION 193 2 0 0 204 000 275 15 209 14 254 264 264 264 254 264 274 204 249 N I 264 209 250 204 274 199 109 274 269 193 304 190 261 154 261 199 181 294 204 271 159159 163 219 161 169 181 105 100 209 176 105 259 11 150 169 209 176 179 179 274 1BO 10906060 194 200 10 210 215 195 150 COOP 195 200 210 170 200 COPOOL CUOOH 205 215175 200 175 1090060 195 165 195 175 200 190 LEO 205 190 205 175 215 265 175 200 LEO 1090906060606056060 175 205 164 195 205 210 165 230 215 175 10600 200 105 175 185 200 COCOCOCOO 175 170 200193 195 205 180 195 180 175 205 165 175 205 190 203 105215 193 190 295 217 365 202 177 11 197 12 205 206 13 255 250 230 215 15 190