you develop a regression model that predicts or explains the selling price of a house by as many as five other variables

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Objective of the Assignment

Your assignment is to learn statistical data analysis and draw conclusions from results. To this end, you develop a regression model that predicts or explains the selling price of a house by as many as five other variables. You will be collecting real estate listing information and then applying multiple regression to fit and validate the model you developed to your real estate data.

Data collection (Note: Data collection should be only Pertaining to a city in British Columbia Province)

First, take a look at www.mls.ca and decide upon a city that you would like to focus on (e.g. Vancouver). Go to www.mls.ca and click onto “Residential Properties”. It should

be a city that has at least a population size of 200,000 people. Next, decide what area or suburb you will be focusing (e.g. Kitsilano). Do a search “by map” to locate a suburb in the city of your choice. Zoom into your suburb/area until there is between 250 and 500 property listings and the property listings are shown on the right side of the webpage. Refine your search by selecting (1) Building Type = House, and (2) Style = Detached. Write down the boundaries of your data collection (e.g., Kitsilano: West of Burrard St. and North of 29th). Save your search by clicking on to the “save search” button at the top left hand corner of the webpage. This will allow you to retrieve your search listings at a later time.

Randomly select (as best as possible) 60 listings from the total number of property listings. The 60 listings will constitute your sample. MLS search listings are displayed from the lowest to highest in prices on the right side of the webpage. Try to randomly select homes across the spectrum of prices that are displayed in your search listing. For example, suppose you have a total of 250 listings of homes in your selected area. Note on the right side of the webpage, the cheapest 12 of the 250 listings are shown and with each sequential page the prices increase. Thus, for this example, there are approximately 250/12 = 21 pages of listings for the 250 houses. Therefore, try to select approximately 3 listings from each of the 21 pages (rather than selecting all prices in one page) so that the data collected is a better representation of the prices in the area. Collect the

 

following information (5 variables) from each of the 60 real estate property listings: Y = listing price

X1 = interior floor space (square footage of the house)

X2 = land size (square footage). This is usually represented by length of the front of the lot (in ft) X the depth of the lot (in ft). sizes range but a common lot size in Vancouver is 33 X 120. You will need to convert this to feet squared (area) before entering it into your spreadsheet (i.e., 3960)

X3 = number of bedrooms X4 = number of bathrooms

X5 = age of the building (often listed as “Built in” year date. Thus, you will need to calculate it.)

Key all data into an excel spreadsheet.

Note: some listings will not have all the data. If you are collecting data in a geographical area that does not provide the information above, please move onto another area. You will find that suburban areas around the Lower Mainland provide the above information quite readily.

Also Note: you can use your mls search and reuse it later by emailing yourself the browser URL. Simply copy and paste the URL from the mls webpage into an email and mail it to yourself so you can continue your data collection at another time.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme