In 2011 home prices and mortgage rates dropped so low that in a number of cities...

50.1K

Verified Solution

Question

Statistics

In 2011 home prices and mortgage rates dropped so low that in anumber of cities the monthly cost of owning a home was lessexpensive than renting. The following data show the average askingrent for 10 markets and the monthly mortgage on the median pricedhome (including taxes and insurance) for 10 cities where theaverage monthly mortgage payment was less than the average askingrent (The Wall Street Journal, November 26–27, 2011).Click on the webfile logo to reference the data.

CityRent ($)Mortgage ($)
Atlanta840539
Chicago10621002
Detroit823626
Jacksonville, Fla.779711
LasVegas796655
Miami1071977
Minneapolis953776
Orlando,Fla.851695
Phoenix762651
St.Louis723654

Enter negative values as negative numbers.

a. Develop the estimated regression equationthat can be used to predict the monthly mortgage given the averageasking rent (to 2 decimals).
The regression equation is:
Mortgage ($) =  +  Rent ($)

b. Choose a residual plot against theindependent variable.

SelectScatter diagram 1Scatter diagram 2Scatter diagram 3None ofthese choicesItem 3

c. Do the assumptions about the error term andmodel form seem reasonable in light of the residual plot?
SelectRelationship is significant and should assume a linearrelationship, due to residual plot.Relationship is significant butshouldn't assume a linear relationship, due to residualplot.Relationship is not significant and should assume a linearrelationship, due to residual plot.Relationship is not significantand shouldn't assume a linear relationship.Item 4

  • Check My Work

Icon Key

Question 9 of 10

Exercise 12.49

Answer & Explanation Solved by verified expert
4.1 Ratings (474 Votes)
aExcel Data Data Analysis RegressionSUMMARY OUTPUTRegression StatisticsMultiple R0869565051R Square0756143377Adjusted R Square0725661299Standard    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students