Compute the matrix of correlation coefficients

Assignment Help Econometrics
Reference no: EM131603948

Assignment

Determinants of Residential Property value in Las Vegas (Use the data File: Home)

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)

PRICE = Sale price of a residential property
SQFT = Square feet, measured in 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.

Part I: Characteristics of residential properties

1. Construct a table (Table 1) 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 (Table 2) for the variables PRICE, SQFT, BED, BATH, AGE, POOL. Analyze the direction and strength of the relationship of the right-hand side variables (SQFT, BED, BATH, AGE, AGE, POOL) 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 (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 value of home with and without swimming pool

Is there a difference in values between residential properties with and without swimming pool or spas? Compute the average difference in values of the two types of properties. Explain your findings. Are your findings consistent with intuition? Explain (Use Table 3 to report your findings).

Table 3: Descriptive Statistics (Average Values)

Variables

Home with Pool

Home without Pool

Difference

PRICE

 

 

 

SQFT

 

 

 

BED

 

 

 

BATH

 

 

 

AGE

 

 

 

Guid

I. Introduction

Section 1 of the study should be the Introduction which describe the purpose of the study, motivation in selecting the topic and the conclusion that announces the organization of the rest of the paper.

II. Descriptive Statistics

Section 2 should analyze the descriptive statistics of the variables used and interpret your findings. It is in three parts (a) create a table of descriptive statistics, (b) Construct a matrix of correlation coefficients and (c) construct scatter plots of selected variables and interpret your findings.

III. Comparing Values of homes with and without swimming pool

Describe and contrast values of homes in Las Vegas. Use the provided descriptive table 3 to report the summary statistics (mean) and interpret your findings.

V. Conclusion

The conclusion should emphasize: The purpose of the study, key findings of the study, and extension for future research.

Attachment:- Housing.rar

Reference no: EM131603948

Questions Cloud

About the firm future earnings and dividends : How do investors use the annual report to form expectations about the firm’s future earnings and dividends, and the riskiness of cash flows.
Does f have local maxima or minima : The function f is defined for all x. Use the graph of f' to decide: Over what intervals is f increasing? Decreasing?
Define theory that best aligns with the use of a life review : Choice of a theory that best aligns with the use of a life review and why. Explain how life review can be a useful intervention when working with elderly client
At certain interest rate the present value : At a certain interest rate the present value of the following two payment patterns are equal:
Compute the matrix of correlation coefficients : Compute the matrix of correlation coefficients (Table 2) for the variables PRICE, SQFT, BED, BATH, AGE, POOL.
Find the x-values of any critical points : Use a graph to estimate the x-values of any critical points and inflection points of f(x) = e-x2.
Gracie has a very active and unsociable temperament : Gracie has a very active and unsociable temperament. For this reason, it is probably most difficult for Gracie's parents to be authoritarian.
Small oil services firm in the houston area : Hugo Enterprises (HE) is a small oil services firm in the Houston area.
Define the negative impact of the divorce on children : What is one thing divorcing parents can do to limit the negative impact of the divorce on their children. Expect the children to be happy and stay

Reviews

Write a Review

Econometrics Questions & Answers

  Design a simple econometric research project

Design a simple econometric research project

  Multiplicative decomposition method

Multiplicative decomposition method

  Market for cigarettes

The Australian government administers two programs that affect the market for cigarettes.

  Solve the forecast model

Solve the forecast model

  What are the marginal abatement cost functions

What are the marginal abatement cost functions for each of the two areas? Calculate the loss in the two areas due to over-control (for the rural area) and under-control (for the urban area).

  Write the t statistic for testing the null hypothesis

Explain why this model violates the assumption of no perfect collinearity.  Write the t statistic for testing the null hypothesis

  What is economics system

What is economics system? What are the types of economics system? Briefly explain each type of economics system by giving examples of nations that are close to each type

  Multiple choice questions related to market concentration

Determine when a competitively produced product generates negative externalities in production, the industry will,

  Calculating number of units produced by firm

Assume a company has the following production function: Q = 100 K.5 L1 . Currently, the company hires 1,000 workers and employs 100 units of capital.

  Question about mobile commerce

M-commerce also known as mobile commerce is being lumped in with several strategic internet plans. Explain some of the industries that are likely to use mobile commerce and how it is working for them.

  Calculating the average days past due and average flow time

Auto Data manufactures custom engineering testing machine. The following 5-orders are currently in the design department:

  Mechanism of an english auction and second price auction

Briefly discuss the difference between mechanism of an oral or English auction and a Vickrey or second price auction.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd