1. The file stockton4.dat contains data on 1500 houses sold in Stockton, CA during XXXXXXXXXXVariable descriptions are in the file stockton4.def. (20 points total)a. Estimate a linear regression...

1 answer below »






1. The file stockton4.dat contains data on 1500 houses sold in Stockton, CA during 1996-1998. Variable descriptions are in the file stockton4.def. (20 points total) a. Estimate a linear regression SPRICE= with dependent variable SPRICE and independent variable the indicator LGRLOT which identifies house on larger lots. Please provide the estimated regression model and interpret the results, the estimated intercept and estimated coefficient of the indicator variable LGRLOT. (10 points) b. Please estimate the log-linear model for all the house in the sample and please provide the estimated regression model and interpret the estimated intercept and slope. (10 points) e age SPRICE + + = 2 1 ) ln( q q Data spricelivareabedsbathslgelotagepool 13800017321970 1057002142.50180 220007210490 25500030331230 20300021421180 1291781632020 1400001732000 1186001432040 1250001432030 1450001732.5010 1570001732.5030 1600001942.5040 1510001732.5000 1660001942000 1245001432010 1450001432030 1440001642000 1750001842030 1250001432000 1725002242.5020 3300003543.5000 2339002442000 1999502133000 1590001942070 1800002643050 1550002342.5060 1290001632060 1499002743060 2350003353.51241 13700017320290 21900021320230 21000021330220 1900002222.50220 24700025430240 1250001632030 1990002643040 1325001742040 1610002142.5020 1663002142.5040 1465002343010 1800002643030 1420001932040 1499501842040 1280001332040 1270001332040 1280001532050 1340001432040 1340001532060 1365001532060 1300001332040 1865002153060 1685002153060 1699501832020 1799002043000 1465002042030 10450016320160 1540002142.5000 11000012320140 10000010220130 15500016320130 1619001932.50120 16900017320140 13400017220130 1450001932.5080 1325001832.50120 1310001932.50100 1470002153090 1900002142.5090 1475002132.5080 1750002242080 1880002733080 1720002743070 1630001832080 2099002743080 1630001932080 1790002733081 1490001832080 1210001842030 1349001842050 1600001832080 1640002542010 1485001842.5030 1000001632060 1070001632060 1110001632060 1000001632040 1480001632060 1275001843060 1365002042.5070 1600002543020 1525002142.5030 1320001632030 1265001632030 1497501832070 1650002442.5070 1375002042.5070 1450001942080 1360001832070 1565002442.5060 1400002142.5030 1800002853.5040 1445001632030 1050001632040 1010001632040 1070001632060 1750001842.5000 1310002032.5000 1449001632050 1900002043000 1565002042030 2190002532.51410 14200020321320 16500016320381 19500022430311 2610003143070 1127002242.50180 10900016320180 11350019430191 1189502242.50120 11200015320190 10250017320190 9872516320190 11500016320200 11400017320200 12100016320200 11200018420200 1090002242.50190 1239002242.50201 910001532090 1070002242.50170 9190017320160 10450018420190 11000014320200 9790018320200 10300017320190 9350014320190 11000016320200 1400002242.50200 1050002242.50190 1265002242.50200 1180002242.50190 10950015320170 12650018420170 1360002142.50171 1530002142.50181 11500018420180 11800015320180 12250016320170 15250024530180 1135002142.50180 1250002142.50190 11750017320190 1430002242.50171 11000017320190 10490015320220 10500015320210 10500016320210 14250019420220 11495015320200 9000014320190 1010001532.50170 14500019320150 11990017220141 14250019320120 13800018320180 12000018320160 1470002042.50180 14550022420170 13495020430170 12200018320180 11400016320181 13970022430160 12990019320170 1650002642.50180 11400015320180 1419502542.50160 11610018420180 11250020420200 10350016420200 11500014320211 14400021430201 10850016320210 10300016320210 10250015320210 11695016320220 12650018420220 12100016320210 11500016320200 9600015320190 1356252142.50200 13995021430200 10900016320190 11300018320210 1430002342.50201 12750018420210 11900022430180 13900018420200 1390002142.50201 12350017320180 8500013320220 11500016320220 13050022430220 10200013420210 12495016320230 11700018420220 10595016320240 8000014320220 10300015320180 11515014320220 1465002142.50190 1355002242.50180 11500016320180 12600022430170 11850017320190 11690018420190 10900018420180 11850017320190 14000028430160 13200020320130 11000018320110 7750012320130 10400013320160 10000014320180 11000017320480 8700021320410 12000016320390 1155001832.50380 9995014320380 11350015320350 11000016320410 11750016420350 11500022330260 16650026530260 1299501732.5060 1275002042.50410 11000014320430 7300023320440 11000012220480 13030015320470 1210001421.50490 10995012310490 1260002331.50480 20500029430460 14500025430501 8300012210510 7600011320470 7900011310470 12950017320470 9995016320470 14000024530280 11950019320290 10600015320260 9570014320280 9700014320250 1625002753.50291 9500016420300 9790019420290 9650015320290 945001331.50470 12300017320491 8800016320490 12200017320250 11700020430260 10500014320241 11867516320250 9990015320260 1190001942.51240 10500015320250 8850016420250 11000015320210 12450018420240 10700014320190 10750015320200 9900017320180 11895015320100 1340001832.50100 1450002242080 9550017420250 11995015420270 12000017320260 9700012320370 10500012320360 11700015320300 12000014320320 9650014320320 9000014320310 11550015420330 10800014320370 10500012320340 10500012320330 16450020531381 11900010320371 9700013320390 8150012320430 11950013320350 14500018320350 14650016320340 13500016320381 12900014320340 2300002532.50330 23000026420290 28500025420391 35750032540181 13900017320370 14200014320410 15500019320410 33500023320400 13300018320390 10500015320400 11650016320380 1425001832.50380 2090002342.50311 15900015320370 11490015420420 18067524430400 17750029421480 10900018420390 11300013320430 6500004643.51141 25500032440100 3750004844.51340 12600012310420 8200012320370 11995014320280 1535001631.50430 1030001732.50460 13500020320470 1340001531.50410 1335631431.50420 12975920330431 10400011320440 11950013320430 12400015320430 12500016320420 13200015320420 14500020430420 6900012210480 1050001421.50480 1720002242.50120 12700018320130 1675002542.50140 15250017330101 1250001632090 13995018320100 1479002342.5091 13100017320100 1550002142.5090 12250015320100 970001732080 1169002142.5080 1359002353090 1249501842080 1235751532090 1420002353070 1350001832090 1175001532080 1315002142.5090 12500018320110 1550002142.50120 12100015320110 12400015320110 12500018420100 1490002242.50100 11700015320110 1370002142.5090 10195013320120 10800015320130 16600025430150 17900025430160 1615002342.50140 12450016320130 13100018420150 13250017320150 9986215320140 13390018320170 11250016320160 14300023530140 11800015320140 1330001942.50160 11900017320180 10700016320160 13050021430170 14900025430180 12700019430170 1150001842.50160 12500025430150 1420002232.50190 12450020430190 11200015320190 9800016320190 10000015320180 1100002042.50181 10200016320190 10852315320150 11250025430160 9500015320180 9775015320170 1255002242.50150 10300014320150 1350002342.50160 10100017320150 1259502232.50170 10350014320170 1350002242.50130 16900027530120 10850014320110 12050017320110 14800025430120 16400027531121 1255002242.50120 1285002242.50140 8500015320190 10600015320130 10000019420120 1370002242.50140 1400002042.50140 12750014420141 10300015320130 11400019430130 1225002242.50130 10800017420150 10000015320130 1345002242.50101 9900023540170 12295013321100 1235002042.5080 11850017320100 10990018420180 9350014320141 1300002242.50110 1190002242.50110 14700026430100 15500026430100 1250002132.50120 12600015320120 10500016420130 1325002142.50111 16950027430120 11700016320110 16350027530110 1260002343090 1540002232.50110 10400016320100 16500027530100 6690012320380 7000011311410 8500017320420 8450010320400 8620018430350 5900011420370 7000014320310 7200012320340 7500010310370 7750013420330 7200011320340 8100011320340 9400014320351 8550013320330 9328012320260 8351114320250 14750020430270 9995014320280 9700015320291 8400015320270 7900014320270 9375015320240 9500012320280 9750012320270 8695014320270 8525012320300 9250016320280 8750012320290 9250014320300 8990013320331 8700011320330 7440016320310 9000017320300 7400013320310 7130001432.50290 10900012320300 9400014320270 8650013320290 8200014320280 9425016320260 10200015320310 8560016420310 8870012320320 9450017320330 8250015320310 8000012320350 9500014320340 9900015320320 9000012320320 9500013320340 8200012320320 9300014320330 8100013320330 9500014320260 1250001952.50280 8295015320270 12800030430261 8200012320290 9100016320290 7683816320300 9100014320410 5550015420370 6600010310410 7995011320430 7795013310420 8300015320310 9550014320320 10700021430300 9000015320300 7900014320370 7850011320400 8795012320410 8250012320400 9400012320231 790001742.50260 8500010310240 8040012320190 1270002242.50170 13000026530160 11600018420170 11500015320180 11900018420170 13500016320180 10000015320170 11100015320170 10600019430170 11350017520180 10800016320181 10900018420190 10800017320150 10400016320130 12300015320150 10180015320160 10550015320160 11000017320140 16700022430151 10100016320170 10300016420160 14790027540180 9600015320170 11800015320160 12900022430120 10200015320120 10500015320150 12500015320150 19800027421510 12400023430190 10300015320200 12000022430190 10100017320190 9900018420180 12600022430180 10675018420180 13700018420181 10200015320190 10000015320190 11450022330180 10000015320180 880002242.50191 10150015320180 10450015320170 8850017320170 11500017320180 13000022430170 8495016320170 12500013320120 10500013320120 10800013320120 12995013320120 950001632090 1250001732080 12800016320100 14995022420100 12850018320110 12700018420970 1350001842090 12500016320100 1440002243080 1195001532050 1360001832080 1230001532080 1400001832090 1370002243070 1240001532080 1200001532080 1215001532080 1265001832080 1199501532080 1180001432000 1180001432000 1465001832040 1215001432000 1245001432000 1325001532010 7762514320300 7750011320290 7700012320290 7110015420280 7700012320290 6500012320290 7700012320290 6990013320280 7995010320270 5500014320320 6800014320320 8500013320280 12000015320290 650001952.50370 885001031.50370 910001441.50380 810001131.50400 850001131.50380 9950012320380 799001131.50370 910001031.50390 690001341.50380 935001541.50380 6900015520390 600001451.50380 949501331.50390 913651441.50380 10562613320340 9750015320351 9150011320370 10700018320310 10995016420321 8100012320320 10100015320320 9370018320340 9500014320330 8800014320340 11500018420330 720001331.50310 8495014320340 7790020420290 8140012320290 4000010310280 9500014320290 10750015420410 9450020420410 900001231.50410 1099501831.50410 9750015320370 9950014320380 7500014320360 875001231.50360 8700011320380 1199501942.50410 600001531.50410 7400010310430 7512814310420 9970014320420 7600011310420 699509210440 7700011320440 5100012320430 6500010310420 772509310430 8000013320440 10200014320250 5890016210570 7100011310430 9500014420420 8500011310420 7500011310440 8300015310420 9800011310430 9150011310440 8750014310440 8500011310450 11495016320450 7900010310460 10600011310450 10100019320450 609009310250 7900011310240 6200011310230 7500010310230 720009310250 75000931.50230 9000014320130 10200015220160 8650014320160 9700015320150 9550017320210 10900015320190 8990015320200 12500019430200 9750018320200 1170002042.50200 10350015320200 9990014320220 9990015320220 7500015320210 9000018420220 9650016320220 12250017420220 9600014320230 8990014320230 10200015420230 9700013320250 8750013220240 9250014320210 10950016420200 10000015420210 9984015320210 9200014320241 1040002052.50230 1050002052.50240 11800016320250 9800016320220 9500016420220 11000016320230 12395017320221 11200014320230 9400015320230 11900015320201 10700018420220 8600018320210 9300017420210 11200017420240 9800020430220 1419792042.50200 12900021430211 1320002042.50190 1070001932.50190 9490017420200 11500019320180 11200018420200 10550019420210 8900016320180 12750015320200 1115001842.50200 12850019430210 11990016320200 11290014320200 12500016320210 11500017320210 8200020321520 42500036431160 3250002942.51200 28000020321480 19000023320240 23500024420250 13250012311480 25000028530341 2500003432.51401 28600028431410 13000020430400 16800017320410 21000019420410 28500030321321 19500022320400 2790002742.51161 19000017320410 2500003044.50320 1785001832.50330 20500018320401 11000017221440 3810003043.51181 1950002332.51350 26000023320361 26000026331411 3700010120480 1450001521.50450 13200017220370 18800018320390 1670002032.50351 12900014320400 2580002832.51130 2750002632.51181 5500003642.5180 9800010310360 10740013310360 12900012320330 12100015320330 9200013320340 1100001432.50340 11200011320330 1100003642170 23500017321311 5300003533190 25500026331240 2400002233.51191 20995020321190 3200003033.51170 21200033331170 36000046531151 24100031431180 2470002432.51180 6450004044141 27000028331161 3100004444.5190 3910003753180 3340003242.51151 3350003032.51120 4250004242.5180 4500003443150 5250003754.5141 5250004053.5140 5000004243.5120 16000018320310 850008211510 12400023440350 1265001331.51380 14150015221490 17900023331160 2790002942.51181 32500029431180 7995011320140 8250014320170 8300014320180 7490014320180 8000014320180 915001642.50160 8000011320150 8500014320170 8888814320170 8300014320170 7000013320160 6800015420170 8400015420170 7390013320200 8495014320190 8600013320200 8200011320200 7150011320190 7400011320200 8000014320180 7995011320180 8800015320180 8450012320180 8700011320170 8800014320160 9550011320180 8150014320170 8500014320180 9500014320190 1015001232040 8700015320170 9000015420170 7350013320180 7400013320170 5000014420200 8622513320180 4800013420190 6950013420200 7100013320190 7500013220180 6750014220160 7500011220160 6365010220170 7300014220170 7200013220180 8500015220180 8100014220180 660009220180 8900016220180 665009220190 640009220180 8300014220180 8500014220190 7800014220190 7550013220180 649009220180 7300011220170 7500014220170 690001121.50200 958001942.50230 8150012320230 7750013320190 8400013320190 7950015420190 6995013320190 750001942.50240 8000015320240 8800015420230 6640012420260 7650015420270 8910015320280 8800012320140 6995010320150 8500012320140 720001131.50140 9095013320140 7750011320150 11400018320140 8495011320130 10350018320130 8300011320120 7500010220140 7500014220130 7550014220130 8600014220120 6900011220140 6600010220140 970001532090 1150002143070 1169501832080 1436002653090 1320002653080 999001532080 1410002243091 1020001842.5080 1220002653080 1340002143070 1280001842.5080 950001632.5070 1110001632.5070 1150001632.5080 1189001942.5060 1200001932.5060 1420002553050 1085491632060 1125991542.5040 19700017320210 2500002032.51200 13400010321520 48500041431231 13995013211390 16250012311680 27800028421180 11200013221500 19000017321520 3250002942.5191 3200002322.51110 7945011320210 7000011320200 7300010320210 5500010320210 7800012320210 7550012320210 7950012320200 7300013320200 6460011320190 8900017420200 7200011320210 7350013320190 7200011320220 725001831.50240 7800014320220 8000014320220 8150017320230 5250014320240 715001031.50220 7000012320210 6225011320180 6995010320190 5000013320180 6500010320170 7700011320200 7200011320170 7490011320190 7900011420180 5600013420190 6700011320180 7700013320180 6990011420190 6300011320180 7650011420190 8980012320190 7050011320170 8500015320190 7490011420190 7000015320180 7600011320180 6900011320180 6500011320170 4600011320170 720009320170 550008210180 7195010320170 5160011320160 6700011420160 7700011420170 6990011320170 5500010320150 7795011420170 7350011320180 6880011320160 5150010320160 7790013320160 7600011320171 6290012210170 7500013320160 8200013420161 10100018330190 5990011320180 6500011320200 7800013320190 6300012320180 6250013320180 8700012320200 8250011320190 6175212320200 8300013420200 7350011320150 7500011320150 7100011320150 6700011320150 8100015320160 7100011320160 8995011320160 745009320160 7500012320210 6795012320190 7200011320200 8700012320210 6000011320200 5000013420210 7900013420210 945001332000 7205010320120 8850014320110 9800011320130 9100010320130 8400015320140 8550011320130 9700010320130 8800014320100 1015001732.5090 690001232090 9400012320101 850001232090 900001632.5080 935001022070 1120001642.5060 960001232070 850001032060 1050001232070 1100001642080 970001232080 1020001432080 912001032080 1154501632.5060 895001632.5060 950001432070 1000001632.5070 1263001732.5170 1300002243080 1485002243080 1050001132000 1450002442.5051 1170001832080 1249501832070 32000025431260 16100014321220 2285002041.51650 17900026330310 16000021321490 13880013320170 2850002333191 17500019420150 23500020430160 2020002743.5060 18000019420120 15680016320160 15500018320170 17600018320151 2175001942090 20100024430101 2100001932.50100 2000002042.50120 19000026430111 8500011220150 11500011210390 1690009311971 1070001332060 1079901542000 17250018321200 16500016421100 1850002242.51130 15150014321150 19700021321110 22900018321120 8100012320180 9000014320180 7726513320170 7900013320160 7500014320160 8600014320160 9600014320160 8350012320150 8500012320160 7500012320150 8800013320110 899001332090 8350012420130 5300011320110 1040001542090 775001542090 890001232090 897001332070 870001332070 850001332080 1070001632.5090 1079001632.5080 1050001632.5080 1420001842.5081 925001132080 1135001842.5070 990011332060 1157001642090 1069501232000 1060001542070 830001532070 1280002042.5080 1240001532081 920001532070 1025001532080 1050001542080 1149501742081 1290002443090 1100001842.5080 860001332090 1099001732.5071 1380001842.5090 1060001632.5080 960001332070 972501332090 1000001432080 800001232090 1060002142.5060 1250001842.5080 1120001832.5070 1145001732.5060 1590002243070 1090001632080 1185001442070 1360001842.5080 1179501842.5070 1130001442070 870001742.5070 1275001943080 1100001632070 8995010210230 1420002143030 1000001432.50130 8400011320120 890001432.50100 1030001432.50100 1012002142.50110 1051131332.5090 8900013320100 900001432.5090 850001032080 1235001432080 1390002442.5080 997501532080 1320002042.5090 1220001842090 1579502042.5070 1105001532070 1165001532090 1219501532090 1170001532090 950002042.5080 1500002443080 1070001532080 1090001832080 1480002243080 920001332060 885001132060 950001332070 990001032060 1170001642060 990001032040 1229601442061 905001132050 1050001032030 1020001542.5070 940001432.5060 920001332070 980001332030 995501632040 1100001742.5040 1095001332040 1097221832070 1650002653080 1250002342.5070 1750002653080 1450001942.5050 1369001942.5061 980001332050 1100001642.5050 1177511642040 1130001332020 1130001642.5040 899501032030 1050001542130 1285001732.5020 1069501132030 1055001542000 1135001532000 1450001743000 22500024420320 16200023330360 13495015320380 13200015320400 7250011310420 9250013310410 14650020320390 10790013320410 21250025430320 12300019330380 2500002452.51380 15200019430380 10700014320390 11800015320390 18100018320431 12700016320430 12200015320420 12150018320440 9700014310430 7950010310450 8000010310450 7500012310450 8910011310430 7290013310430 8350011310410 8955013420420 8350011310420 7850011310440 8800011310450 7400011310440 8450011310440 7290011310440 10200012320460 4995010310470 8250011310460 670009210460 8200012310470 13100015320360 14500018420340 19100022530390 1420002132.50411 13200017320380 14625016320310 12800020420460 9500013310450 7505012310450 8150015310450 5790010310460 8600015420480 8700011310440 8600020320440 10750020420270 9500018320450 7000012310460 7995011210470 539509210460 825009210480 9900018320460 840009210470 10500012210470 9695011210460 1370002031.50450 16000018320460 20000024320390 13800016320430 1150001431.50480 13600018320450 13600015320470 10495014310470 13092519320380 2340003342.50171 1199502042.50200 12195019320150 13400022530210 11700016320211 10750016320220 10300016320130 7700018320210 10500018320221 1725003053.50210 17350019320200 16950022530190 16600018320210 2450002352.50210 3750004042.50171 13350013320210 14200016320200 1799502242.50210 13750017320220 18300024530240 14400014320210 2050002652.50190 3370003042.50171 1610002142.50220 14400016320190 2975003642.50170 3050002942.50190 25300024320160 3850004043.50160 18500016320190 11900014320190 11800015320190 1595001942.50170 2600003063.50180 16850015220180 15790019430190 12150014320170 13000014320180 3950004956.5070 2595002342.50290 2200002342.50280 17300021430290 1495001932.50170 20850021320220 2980003543.50170 15300018320220 13100016320230 18900017320260 12600021320280 19500020420280 19500026230200 13825020320250 17750018230260 31500034330160 3625003143.50170 28200021320220 28500030530240 23280021320240 1699002332.50240 35000030430250 2750002342.50220 14350017320240 14300023530230 8695013320220 9400013320230 9300013320220 14000020530220 9991013320190 12900017420230 10750016320230 16100020420220 17000019420240 13700016320250 13000017320231 8000014320250 8250014420260 1040001842.50210 10550014320210 10400013320220 6390010210230 575009210270 685001331.50250 560009210250 17800023330260 2300002442.50250 13400018320250 13150017320270 13290014320270 14500019320300 11900015320290 12650015320320 14900018420261 1260001636.50250 17100020320191 9895011320130 10000012320120 1600002242.50100 12490015320140 11800013320140 11500012320130 12390015320130 10900012320130 9250012320110 10500012320120 10700012320130 9600012320130 8250010220120 10050012320110 11500012320130 18500014321320 13750019321410 2000001932.5110 10900010211500 13300017320370 8700010310390 8750010310370 9450011320370 900001131.50360 8450011320360 9500014320210 10500012320230 10800014320330 10995019330320 10500017420330 8700013320300 7350011320290 8500014320311 12395020430320 9500014320310 7490010310350 749009210330 10700016220370 9750015320380 10500014320380 10000014420350 850001521.50360 9800016320340 9450014320380 8400014320380 9495013320360 12500015320370 11402515320390 8995015320390 6600015320400 960001231.50400 6990016320380 949501331.50370 13400030430420 15650018320370 830001532.50180 10700015320410 7800010310400 9640011320400 10000011320390 1170002432.50400 8500012320380 8360013320350 9000012320370 9275013310380 10000017420370 7400013320360 9100013320350 9200013320340 8400012320340 7450010310350 690009310400 9500014320410 7800010310410 9060014320410 11600011311480 1780002032.51250 9700012320260 11500011211310 9950010210570 9600012310500 2755002833140 16000015321240 9200011320130 8695013320110 9500011320130 799151432090 10100016320320 9700015320340 9100018320330 8200016221220 8500018320200 8300014320200 10750016420200 12500019430180 8490017420170 9150014320170 915001932.50200 8950017320190 7290012320350 8100012320350 6000011320150 699501131.50330 865001132090 9500015320410 13500015210470 1650002232.50440 12900014320480 12000016220460 13000016320350 12000016320440 19100025430440 23000028430370 7000010310511 11000018320420 7650010310500 8000021330440 8700016420200 15800025330210 11500021420190 12995018420180 1426502142.50200 11300015320190 11000018330200 1230002032.50160 1286002032.50170 1799501932.50190 11750014320180 11000014320150 12000018320190 12500020420190 23000031430190 1700002142.50200 14900025530210 1870002032.50400 18663516320350 38500043331380
Answered Same DayMar 20, 2023

Answer To: 1. The file stockton4.dat contains data on 1500 houses sold in Stockton, CA during...

Komalavalli answered on Mar 20 2023
7 Votes
a)
Estimated model 1:
y = 115220.01 + 133797.35 x + e
y – SPRICE
x – LGELOT
The average price o
f house in Stockton for smaller plots is $115220.01. The average price of house in Stockton for larger lots is $249017.37.
b)
Estimated model 2:
y = 11.75 -0.005 x + e
y – SPRICE
x – age
The...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here