#### Question Details

Your submission should consist ofÂ onlyÂ those answers exhibits that are specifically asked for in aÂ single word or pdf document. Please ensure that each exhibit is well edited and appropriately formatted. You may assume that fractional answers are acceptable throughout.

ProblemThis assignment is an analysis of house prices in Springfield. You will find data in the file __House Prices (Excel file)Â (Links to an external site.)__ on 128 recent sales of single-family houses in Springfield has the following variables:

**Price: Â ** Â Â Â Â Â Â Â Price at which house was eventually sold

**SqFt: Â ** Â Â Â Â Â Â Â Floor area in square feet

**Bedrooms: Â ** Â Â Â Number of bedrooms

**Bathrooms:** Â Â Â Â Number of bathrooms

**Offers: Â ** Â Â Â Â Â Â Number of offers made on the house prior to the accepted offer

**Brick:** Â Â Â Â Â Â Â Â Whether the construction is primarily brick or not (yes or no)

**Neighborhood:** Â One of the three neighborhoods in Springfield (east, west or north)

Use StatTools to conduct the statistical analysis asked below. For questions that ask for a price (or change in price), use zero decimal places in your final numerical answer.

Â Part A - Linear RegressionCreate a regression model for Price using SqFt, Bedrooms, Bathrooms and Offers as the independent (explanatory) variables.Â Let us call this **Model A**.Â Include the StatTools regression output as

**Exhibit**.

*A*- Write out the estimated regression equation.
- The coefficient of SqFt is 309.20.Â Provide an economic interpretation of this number.
- Suppose a homeowner adds an extension to her house in the form of a 400 sq ft. bedroom.Â What is the increase in the predicted selling price of her house?
- Estimate the price of a 1720 sq ft. house that has 3 bedrooms, 2 bathrooms and has had 1 offer made on it.
- Consider house number 39 in the data set.Â It has 1720sq ft., 3 bedrooms, 2 bathrooms and has had 1 offer made on it.Â Suppose the list price is $656,500.
- According to Model
*A*, is this house over-priced or under-priced? - By how much?

- According to Model

Create a regression model for Price using the quantitative as well as qualitative (categorical) variables in the spreadsheet.

Use â€œNorthâ€ as the base (or reference) category for the Neighborhood variable, and â€œNo Brickâ€ as the base category for exterior construction material variable, Brick.

Let us refer to this model as **Model B**.Â Include the StatTools regression output as

**Exhibit**.

*B*- According to Model
*B*estimated above, by how much does the average price in the East exceed the average price of a similar house in the North? - According to Model
*B*, by how much does the average price in the West exceed the average price of a similar house in the East? - Let us define the â€œbrick premiumâ€ as the average amount by which the price of a brick house exceeds the price of a similar house made without brick. According to Model
*B*, what is the brick premium in Springfield?Â Â Â Â Â Â

In Model *B* the *brick premium* was defined to be â€œthe average amount by which the price of a brick house exceeds the price of similar house made without brick.â€

Next, suppose it is conjectured that the *brick premium varies by neighborhood*.Â To account for this conjecture, we augment Model *B* with interaction terms as follows:

**Price = a + b_{1}SqFt + b_{2}Bedrooms + b_{3}Bathrooms + b_{4}Offers + b_{5}BrickYes + b_{6}East + b_{7}WestÂ **

**+**

*b*_{8}BrickYes*East +*b*_{9}BrickYes*WestLet us call this model **Model C**.

- Simplify the equation for Model
*C*for the various segments as asked below. In this part, we are looking for*algebraic*answers, not numerical answers. For simplicity, let=*S**a*+*b*_{1}SqFt +*b*_{2}Bedrooms +*b*_{3}Bathrooms +*b*_{4}Offers.- What is the price of a non-Brick house in the North?
- What is the price of a Brick house in the North?
- What is the brick premium in the North
- What is the price of a non-Brick house in the East?
- What is the price of a Brick house in the East?
- What is the brick premium in the East?
- What is the price of a non-Brick house in the West?
- What is the price of a Brick house in the West?
- What is the brick premium in the West?

- Provide an economic interpretation of
*b*_{8}. - Provide an economic interpretation of
*b*_{9}. - Run Model
*C*using StatTools. Include the regression output as**Exhibit C**. - Use this output, what is the brick premium in the North, East and West?

Run the following regression as **Model D**:

**Â Log(Price) = a + b_{1}SqFt + b_{2}Bedrooms + b_{3}Bathrooms + b_{4}Offers + b_{5}BrickYes + b_{6}East +Â **

*b*_{7}WestRecall that for our purposes, â€œLogâ€ refers to natural logarithms.

- Include the StatTools output as
**Exhibit D**. - Estimate the price of a 1720 sq ft. brick house in the North that has 3 bedrooms, 2 bathrooms and has had 1 offer made on it.
- From the output, it is seen that
*b*_{7}= _______________.Â Provide an economic interpretation.Â - Suppose a homeowner adds an extension to her house in the form of a 400 sq ft. bedroom.Â According to Model
*D*, what is the increase in the predicted selling price of her house?

Be careful with the units.

**Solution details:**

Answered

QUALITY

Approved

ANSWER RATING

This question was answered on: * Sep 05, 2019 *

* * Solution~000200201856.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

##### Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

#### About this Question

STATUSAnswered

QUALITYApproved

DATE ANSWEREDSep 05, 2019

EXPERTTutor

ANSWER RATING

#### GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

- As a reference for in-depth understanding of the subject.
- As a source of ideas / reasoning for your own research (if properly referenced)
- For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).

#### NEW ASSIGNMENT HELP?

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions.
New orders are original solutions *and precise to your writing instruction requirements. Place a New Order using the button below.*

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.