You are consulting for a large real estate firm. You have been asked to construct ...

     You are consulting for a large real estate firm. You have been   asked to construct a model that can predict listing prices based on square   footages for homes in the city you’ve been researching. You have data on   square footages and listing prices for 100 homes.   Price Sq. Ft.   19,500 1,116   19,900 1,550   21,500 1,493   24,900 1,862   27,900 1,488   28,000 2,208   29,000 1,100   34,900 1,150   38,800 1,592   39,900 2,144   39,900 936   40,000 1,441   42,000 912   43,900 1,788   49,900 1,728   52,000 2,560   52,000 1,360   52,000 1,032   52,500 1,080   55,000 2,624   55,000 1,056   59,900 1,200   60,000 1,645   69,000 1,008   69,900 1,632   72,100 1,032   74,500 1,119   74,900 1,675   74,900 1,800   79,900 3,016   79,900 2,624   79,900 3,046   79,900 864   80,000 1,440   84,900 924   89,900 1,453   89,900 936   90,000 1,374   98,000 1,344   109,900 1,240   115,000 1,334   119,900 1,440   119,900 1,202   120,000 1,224   124,000 1,767   124,900 2,182   124,999 1,352   127,990 1,404   129,000 1,476   137,500 2,044   138,900 1,472   139,900 1,704   139,900 1,239   139,900 1,786   140,000 2,750   140,000 1,504   140,000 1,928   143,500 1,755   145,000 2,870   145,900 1,682   149,900 2,184   149,900 1,516   153,990 2,259   154,900 1,889   159,900 2,128   162,900 2,436   164,900 2,178   168,500 2,160   169,900 1,522   169,990 1,858   170,000 1,751   175,000 1,629   175,000 2,872   177,000 2,502   177,500 2,134   179,900 3,562   179,900 2,680   182,900 2,119   182,900 1,806   183,000 2,635   184,900 2,000   186,000 3,382   187,900 2,240   189,000 3,250   189,900 1,632   194,500 4,266   197,500 2,733   200,000 1,745   209,900 2,959   212,000 2,141   215,000 2,894   215,000 3,508   219,900 1,764   229,900 1,914   239,800 2,882   255,900 2,255   259,000 3,468   265,000 2,268   275,000 4,016   275,000 4,460   434,000 5,500    

     Click on Data→Data   Analysis→Regression→OK.   Highlight your data (including your two   headings) and input the correct columns into Input Y Range and Input X Range,   respectively. Make sure to check the box entitled “Labels”. Paste these   regression analysis results here as part of your answer to this question.   This is needed to enable the instructor to check the accuracy of your   answers.   Check the coefficients in your summary   output. What is the regression equation relating square footage to listing   price?   Using the regression equation that you   designated in #3(a) above, what is the predicted sales price for a house of   2100 square feet?