Im very lost Where did I go wrong I solved for the following

I\'m very lost. Where did I go wrong? I solved for the following for the problem listed below:

b=For every square foot, the predicted price of a home increases by 92.61, holding number of bedrooms and bathrooms constant.

c = 18,155,14.98 or

Predicted price = 1,26715.08 + 92.61 sqft + 11,947.04 beds + 91,777.89 baths

Predicted price = 1,26715.09 + 92.61 (1,923) + 11,947.06 (3) + 91,777.89 (2)

Predicted price = 18,155,014.98

A realtor in Arlington, Massachusetts, is analyzing the relationship between the sale price of a home (Price), its square footage (Sqft), the number of bedrooms (Beds), and the number of bathrooms (Baths). She collects data on 36 recent sales in Arlington in the first quarter of 2009 for the analysis.

My Answers are listed below but I\'m very lost.

She estimates the model as Price = ?0 + ?1Sqft + ?2Beds + ?3Baths + ? and obtains the following output.


Predict the price of a 1,957 square-foot home with four bedrooms and three bathroom(s). (Round your intermediate calculations and final answer to 2 decimal places.)

My Excel regression Summary output is listed below:

Price Sqft Beds Baths Col
672000 2214 4 2 1
632308 1923 3 2 1
831833 2800 4 3 1
689000 2200 3 2.5 1
685000 2716 3 3.5 1
645000 2524 3 2 1
625000 2732 4 2.5 0
620000 2436 4 3.5 1
718056 2567 3 2.5 1
585000 1947 3 1.5 1
583000 2224 3 2.5 1
379333 2175 3 1 0
546000 1792 3 2 0
780000 2149 4 2.5 0
732273 3964 4 3.5 0
344000 1301 3 1 1
511000 1752 3 1.5 1
714000 2418 4 3 1
693000 2369 4 3 0
648200 2400 4 3 0
639800 2310 4 3 0
451000 1685 3 2 0
628333 2167 4 2.5 1
431700 1896 2 1.5 0
414000 1182 2 1.5 0
602250 1728 4 2 0
478800 1660 4 2 0
380000 1344 4 2 0
475000 1590 3 2 0
375900 2275 5 1 0
372000 1005 2 1 0
459375 1590 3 2 0
356500 1431 2 2 1
412500 1703 3 2 0
412500 1831 3 2 0
307500 850 1 1 0

Solution

Regression Analysis

R

Regression Analysis

R

I\'m very lost. Where did I go wrong? I solved for the following for the problem listed below: b=For every square foot, the predicted price of a home increases
I\'m very lost. Where did I go wrong? I solved for the following for the problem listed below: b=For every square foot, the predicted price of a home increases

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site