Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the dataset duke_forest_for_homework.xlsx, we have the following seven columns/variables for a dataset gathered from Zillow in November of 2020 for listed homes in the

In the dataset "duke_forest_for_homework.xlsx", we have the following seven columns/variables for a dataset gathered from Zillow in November of 2020 for listed homes in the Duke Forest neighborhood of Durham, North Carolina:

Column name

Description

Price ($1000s)

Price of the house (in $1000s)

Bath

Number of bathrooms

Area

Area of the house (in square feet)

Lot

House lot size (in acres)

Central_cooling

1 if the house has central cooling and 0 if not

Bed

Number of bedrooms

Heat_pump

1 if the house has a heat pump and 0 if not

  1. You are interested in buying a house in the Duke Forest neighborhood and one of your friends tells you that the only thing that matters for a house price is the lot size. Run a regression with price as the response/dependent (Y) variable and lot size as the only independent/predictor (X) variable. Please paste the output here:
  2. According to the coefficients from this regression, what is the equation you would use to predict the price of a home?
  3. How much of the variation in home price is explained by the variation in lot size, and which value from the output did you use to determine that?
  4. If a house lot size decreases by 0.5 acres, what will be the change in home price according to this regression?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel G Short, George Kanaan, Maureen Sterling

6th Canadian edition

73208140, 1259105695, 978-1259105692

More Books

Students also viewed these Accounting questions

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago