Construct a table that includes the summary statistics

Reference no: EM13919945

Determinants of Residential Property value in Las Vegas-

The Greater Las Vegas Association of Realtors® (GLVAR) is interested in analyzing the determinants of residential property values in the Las Vegas (NV) housing market. The data set is based on the residential properties of the city of Las Vegas. Residential property values (PRICE) are explained by a number of factors. The relationship between price and these factors is written as:

PRICE =f(SQFT, BED, BATH, AGE, POOL, FORECLOS, DOM)

PRICE                = Sale price of residential property
SQFT                  = Square feet, measuring the size of living space
BED                   = Number of bedrooms
BATH                 = Number of bathrooms
AGE                   = Year of the residential property
POOL                 = 1 if the property has a pool or a spa and 0 if not.
DOM                  = Days the property was on the market for sales
FORECLOS         = 1 if property is a foreclosed property and 0 if not

Part I: Characteristics of residential properties

1. Construct a table that includes the summary statistics (mean, standard deviation, minimum and maximum) of all the variables. Explain briefly your findings.

2. Compute the matrix of correlation coefficients for the variables PRICE, SQFT, BED, BATH, AGE, POOL, FORECLOS, and DOM. Analyze the direction and strength of the relationship of the right-hand side variables (SQFT, BED, BATH, AGE, POOL, FORECLOS, and DOM) on PRICE.

3. Show the scatter plots of the relationships between (i) PRICE and SQFT, (ii) PRICE and BED, (iii) PRICE and BATH, (iii) PRICE and AGE and (iv) PRICE and DOM (Use PRICE as the variable on the vertical axis in each plot). Explain your findings. Are the results of the plots consistent with the correlation results in (2)? Explain.

Part II: Comparing characteristics of foreclosed and non-foreclosed home

The variable FORECLOS accounts for the recent bad housing market conditions in Las Vegas. Is there a difference in values between foreclosed and non-foreclosed residential properties? Compute the average difference in values of the two types of properties. Explain your findings. Are your findings consistent with intuition? Explain.

Table: Descriptive Statistics (Average Values)

Variables Foreclosed Non-foreclosed Difference

PRICE

SQFT

BED

BATH

AGE

POOL

DOM

Part III: Policy recommendation

The Greater Las Vegas Association of Realtors (GLVAR) likes your study and requests that you draft a useful policy for the Association with regard to housing market in Las Vegas Metropolitan area. Your recommendation should be based essentially on the data and results of this project.

Attachment:- Housing 2013 Data.rar

Reference no: EM13919945

Questions Cloud

Address senior management concerns : In order to address senior management's concerns about how to lead and motivate this new workforce, you will draw upon Path-Goal Theory.

Research issues in biology. : Explain how the article relates to this course.Identify which biological concepts from the course and / or text are relevant to the topic covered in the article.

Standard deviation the error term in the model : The following data consists of 6 homes with variables Price = sale price in tens of thousands of dollars, Floor = floor size in thousands of square feet, and Lot= lot size.

What project management tools does your company use : What project management tools does your company use? With an example, describe how you, or someone in your company has used these tools.

Construct a table that includes the summary statistics : Characteristics of residential properties - Construct a table that includes the summary statistics (mean, standard deviation, minimum and maximum) of all the variables. Explain briefly your findings

What positions are there in a communication network : What positions are there in a communication network and how and to what extent do they effect/influence the workings of that network?

Identify corporate strategies that formulate by michael dell : Identify the corporate strategies that have been formulated by Michael Dell - the CEO of Dell Computer Corporation that led to the success of the company. Indicate any obstacles they had to overcome.

Buddhism-hinduism and judaism : Consider the three religions, Buddhism, Hinduism, and Judaism. In an essay of approximately 700 to 800 words in length, answer the questions listed above. Be sure to use appropriate APA format for citations and to include at least one reference fo..

An analogy to a cache system : Design a set of instructions you would use to add the value stored in memory location "20" by the value stored at memory location "29" ten (15) times. That is, if is the value at location 20, and is the value location 29 then you are being asked..

User Account

All Pages