1. Create a new variable price per sq ftprsq=priceCompute themean and medianof the price persqft
2. sq ft for various zip codes.Do you see any meaningful difference in the price per sq ft between the zip
3. codes?
4. Compute themean and medianof thesqftfor various zip codes. Do you see any meaningful
5. difference in thesqftbetween the zip codes?
6. Create a new variableageof the house whereage= 2020?yearCompute themean and medianof
7. theagefor various zip codes.Do you see any meaningful difference in theagebetween the zip codes?
8. Estimate the following regression models andexplain your findingsin as much detail as possible.
9. prsq=?0+?1(size) +?
10. prsq=?0+?1(size) +?2(lot) +?
11. prsq=?0+?1(size) +?2(lot) +?3(age) +?
12. prsq=?0+?1(size) +?2(lot) +?3(age) +?4(school) +?
13. price=?0+?1(size) +?2(lot) +?3(age) +?
14. price=?0+?1(size) +?2(lot) +?3(age) +?4(school) +?
15. price=?0+?1(size) +?2(lot) +?3(age) +?4(school) +?5(bed) +?6(bath) +?
16. Which model is the best for predicting the price per sq ft? Which model is the best for predicting the selling price of the house?

AutoSave O OFF ECON3110 EXAM - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri (Body) 12 AA ab Wrap Text v General Ex Delete Analyze Sensitivity Paste BI UV MVA Merge & Center $ ~ % " 508 Conditional Format Cell Sort & Find & Formatting as Table Styles Format Filter Select Data B2 X V fx 37214 N O P B C D E F G H K M STREET ZIP PRICE BED BATH SQF LOT YEAR PARK SCHOOL HOA 3141 MCGAVOCK PIKE 37214 384,900 2402 21,344 1958 IN 4 W 27214 500,000 3196 6,970 2019 3 3 1028 NAVE CT 2.7 180 WOODSON LN 37211 330,000 1200 10,454 1955 NNN 3103 MORNING STROLL 37206 575,000 2141 871 2017 2 2916 HIGH RIGGER DR 37217 289,900 1916 16,988 1977 2 2 1704 SHARPE AVE 37206 375,000 825 7,405 1950 3.5 2009 12TH AVEN 37208 355,000 1931 6,970 1928 W WW WWNHNAH 4 3 9 1115 KIRKLAND AVE 37216 699,000 2650 9,148 1936 10 5127 PRITCHETT DR 37220 705,000 2518 17,860 1957 4 11 402 PAGE DRIVE 943,000 17,242 NNNNNNNNNN 27205 2507 1945 5.3 12 2400 VALE LN 37214 280,000 4063 45,738 1050 4 13 836 BROOK HOLLOW 37205 657,170 1548 43,124 Tex1956 3.7 14 4353 GOINS RD 37211 419,500 w 1840 9,583 2021 3.3 37214 1248 955 2.7 923 SHAUNA DRIVE 327,000 22,216 16 115 CLAIBORNE 37210 389,000 1568 5,663 1900 2.6 A W N A W A D W W W W N W W N W W A W W A W W W N W A D UT U 17 1209 AINLAY DR 37217 260,000 768 15,682 1952 3.7 18 1308 LITTON AVE 37216 495,000 1930 1,930 2021 2.7 19 2641 SOLON DR 27206 360,000 1075 12,197 1986 2 20 910 MANILA AVE 27206 466,200 1488 8,712 1950 2.7 21 2024 GREENWOOD AVE 37206 455,000 1570 9,148 930 2 22 504 S LAKERIDGE 37214 380,000 2247 7,841 1996 3.3 23 556 TOBYLYNN DR 37211 360,000 1792 15,682 1972 5.3 W W N A W N W N N W HN HW HN 24 211 DESOTO DR 37210 418,000 1455 11,326 1956 3.7 25 1106 WADE AVE #4 37203 620,000 1941 871 2016 5.5 NNNNWHNANNE 1204 TIMBER VALLEY DR 37214 265,000 2742 6,970 1984 2.7 27 701 S 14TH DT 37026 590,000 2455 10,019 2019 2 28 501 27TH AVEN #2 37209 765,000 2338 43,996 2019 2.7 29 3209 PRIEST WOOD DR 37214 214,000 1161 5,663 1984 2.7 30 1002 LAW43NCE AVE 37204 1,400,000 3298 13,504 900 31 715 32ND AVEN 37209 519,900 2144 10,520 2021 2.7 32 22 Sheet1 + 125%