Research ProjectResearch Project Overview: Students will work in groups of 2 (or occasionally 3) on research projects investigating economic relationships. The output of your project should be...

1 answer below »









Research Project











Research Project Overview: Students will work in groups of 2 (or occasionally 3) on research projects investigating economic relationships. The output of your project should be presentation with approximately 15 slides, including all tables and figures. You will present your project proposal in class with a short 10 minutes “PechaKucha” style presentation. This means that each slide will only have an image (graphs/figures/tables are acceptable, but no words/titles). A good project will ask an interesting question and use data and regression techniques in appropriate ways to formulate an answer. Specifically, your goals are to:

















1) Formulate an empirical economic question that can be addressed using data and techniques covered in this course;








2) Select appropriate data;








3) Formulate and estimate an econometric model that addresses your research question;








4) Interpret your results and discuss how potential violations of the OLS assumptions could affect your results;





Research Project Research Project Overview: Students will work in groups of 2 (or occasionally 3) on research projects investigating economic relationships. The output of your project should be presentation with approximately 15 slides, including all tables and figures. You will present your project proposal in class with a short 10 minutes “PechaKucha” style presentation. This means that each slide will only have an image (graphs/figures/tables are acceptable, but no words/titles). A good project will ask an interesting question and use data and regression techniques in appropriate ways to formulate an answer. Specifically, your goals are to: 1) Formulate an empirical economic question that can be addressed using data and techniques covered in this course; 2) Select appropriate data; 3) Formulate and estimate an econometric model that addresses your research question; 4) Interpret your results and discuss how potential violations of the OLS assumptions could affect your results; 5) Draw conclusions about your question based on your evidence. Choosing a research question: You should start with a “topic” that interests you (eg. an economic issue or problem encountered in a course you have taken). Then hone the broader topic into a specific research question. Posing your question clearly and specifically (what is Y and what is X, what variables would my data need to have to address this question?) will help you define a manageable project. I do not mean that it needs to be an easy question. I understand (and expect) that you may have outstanding identification issues at the end of the semester. A good project will discuss these concerns. One possible approach is to select a published piece of empirical research and “redo” the analysis using different or more recent data, or by altering the econometric model. An advantage to this approach is that you can directly compare your findings with the earlier study. Structure: In general, your presentation should include the following sections: i. Introduction, stating the importance of the question ii. Brief review of literature (how does your project fit in?) iii. Description of the data and sources. Include a table (and/or figure) giving summary statistics and a scatter plot if relevant. iv. Presentation of the economic and econometric models v. Presentation and interpretation of the estimated model results. Include regression table(s) vi. Results of hypothesis testing and other econometric analyses vii. Interpretation of results and their economic significance and their relevance, if any, to policy. Discussion of remaining omitted variable bias viii. Conclusion Component weight Points awarded Data 2013 CONTROLAGE1METRO3LMEDFMRIPOVBEDRMSBUILTSTATUSTYPEVALUENUNITSROOMSPERZINC2ZADEQZSMHCSTRUCTURETYPEOWNRENTUTILITYOTHERCOSTCOST06COST12COST08REGIONCOSTMEDASSISTEDAge Group '100144130103'-9'1'863003100-642004'3'149000017-6-6'-6'-61'1'33.333333333108.333333333398.18448265290.34821913990.068437542988.648883-9NA '100260380142'-9'2'646001149-641980'3'146000017-6-6'-6'-61'1'135.91666667116.666666673309.72250755086.03948463865.368669232925.260516-9NA '100298130103'-9'3'612921094-652005'3'1570000111-6-6'-6'-61'1'16.666666667158.333333333963.1941946164.28262224651.71226423486.7956394-9NA '100303110149'-9'1'60991988-631980'3'17000016-6-6'-6'-61'1'40100605.21683085875.52593606689.771681543546.71174519-9NA '100303330145'-9'2'779541573-641980'3'144000019-6-6'-6'-61'1'41.6666666671003065.88674634764.97255053597.374379232698.1404936-9NA '100306530103'-9'1'725311285-652009'3'160000111-6-6'-6'-61'1'00398.75728358630.45080234471.232869893348.61006731-9NA '100356320148'-9'2'603001173-631980'3'11000016-6-6'-6'-61'1'10.1666666670.083333333376.709547264115.3251337288.788811649368.351677884-9NA '100477230103'-9'1'651001020-632004'3'112000018-6-6'-6'-61'1'83.33333333366.666666667947.514567161410.90160471092.46573982847.22013461-9NA '100553230103'-9'2'620661249-642007'3'195000018-6-6'-6'-61'1'100108.333333336521.990323410190.4710377669.5204435727.9927323-9NA '100591130103'-9'5'55846949-632007'3'117000015-6-6'-6'-61'1'9.166666666701138.97897021795.443941344.32646473996.8951907-9NA '100656720145'-9'2'59900876-621980'3'115000015-6-6'-6'-61'1'70155.51222.3932091801.62700581403.582174741097.0251683-9NA '100696130103'-9'4'64077805-622008'3'114000014-6-6'-6'-61'1'1992551384.43366171925.05187211553.543363111267.4234904-9NA '100696130203'-9'4'640771041-632007'3'120000015-6-6'-6'-61'1'10029.1666666671458.35761192230.66934111699.942899611291.2002244-9NA '100707130133'-9'2'863241983-642007'3'137000017-6-6'-6'-61'1'49.579.1666666672587.66991544016.44661443034.602697712278.4287484-9NA '100871130103'-9'1'586001689-652003'3'1280000110-6-6'-6'-61'1'2201802260.86732343342.10374432599.086726242026.8469808-9NA '100898740148'-9'2'918002299-641985'3'155000017-6-6'-6'-61'1'66.66666666741.6666666673763.60843285887.46568814427.96797413303.925617-9NA '101295230103'-9'1'631001861-642008'3'114000017-6-6'-6'-61'1'58.33333333377.51066.2669951606.88520551235.37669644949.25682371-9NA '101319530103'-9'2'600601282-632006'3'116000018-6-6'-6'-61'1'150146.666666671360.01942291977.86880621553.287653131226.2935128-9NA '101336130103'-9'2'740081243-632006'3'118000017-6-6'-6'-61'1'58.33333333386.751341.35518412036.43574041558.78194321190.9135353-9NA '101434140145'-9'2'646001183-621980'3'110000026-6-6'-6'-62'1'0205869.595472641255.7513372990.388116493786.01677884-9NA '101502230133'-9'2'648101094-632000'3'121000016-6-6'-6'-61'1'75.416666667551526.06715922336.99447491779.731711321350.5519022-9NA '101512180149'-9'2'617001236-621985'3'1170000684-6-6'-6'-65'1'001129.81230351786.27727331335.1597983987.72852403-9NA '101596130133'-9'1'73600815-612003'3'12700004803-6-6'-6'-65'1'001794.40777612837.02861052120.547914521568.7453029-9NA '101743700141'-9'5'61917828-621985'3'19000014-6-6'-6'-61'1'077.5675.635925371023.1762035784.349304841600.41510096-9NA '102502330103'-9'2'648101094-632006'3'125000016-6-6'-6'-61'1'108.3333333362.51832.32201492797.71167642134.303624621623.3752804-9NA '102828730140'-9'2'82300736-611985'3'1100001244-6-6'-6'-65'1'0685751.45954726790.07513372763.538811652743.10167788-9NA '103751590145'-9'2'856001598-631985'3'125000016-6-6'-6'-61'1'75116.666666671853.15534832818.54500972155.136957931644.2086138-9NA '105267550147'-9'3'686581427-631985'3'122000017-6-6'-6'-61'1'60.08333333335.8333333331558.02670652407.56960861823.770522941374.1535801-9NA '106497310144'-9'3'641651619-631985'3'125000016-6-6'-6'-61'1'173751909.48868162874.87834312211.470291241700.5419471-9NA '107497580141'-9'2'626001577-631985'3'133000016-6-6'-6'-61'1'53.33333333366.6666666672313.16505973587.47941292711.780784442037.3553702-9NA '129453930113'-9'5'46720859-631980'3'12000016-6-6'-6'-61'1'56.6666666677.6666666667197.25242786274.48360078221.410956633180.5366891-9NA '129515900145'-9'1'490001122-621975'3'126000024-6-6'-6'-62'1'33.333333333192.51953.78156222957.78681012267.842436231736.4769583-9NA '129901930113'-9'3'613291214-641990'3'240000111-6-6'-6'-66'1'81.6666666670.0833333333347.58818905502.05053489395.90524663314.15671154-9NA '146502230133'-9'2'648101094-631970'3'116000015-6-6'-6'-61'1'33.333333333102.51199.18608961817.03547291392.454319721065.4601795-9NA '147502830133'-9'2'64810819-621975'3'111000015-6-6'-6'-61'1'8525841.05501991265.826471973.926928142749.11845673-9NA '148150830142'-9'2'736001436-641960'3'115000019-6-6'-6'-61'1'141.6666666733.751172.30987561751.54367251353.498841421046.9418349-9NA '151502030133'-9'2'64810819-621950'3'111000015-6-6'-6'-61'1'530766.05501991190.826471898.926928142674.11845673-9NA '155502030133'-9'2'64810819-621930'3'19000014-6-6'-6'-61'1'61.2541.666666667701.052592041048.5928702809.765971512625.83176763-9NA '162502030133'-9'1'64400821-621970'3'115000014-6-6'-6'-61'1'157430.833333331584.72654232163.96033921765.915508121459.3585016-9NA '162502530133'-9'1'64400495-601995'3'11000001123-6-6'-6'-65'1'025689.595472641075.7513372810.388116492606.01677884-9NA '163549290148'-9'1'736001231-631920'3'126000036-6-6'-6'-62'1'11.66666666787.51827.11489552831.12014352141.175769521609.8102917-9NA '165583530133'-9'2'792001394-631950'3'120000016-6-6'-6'-61'1'7562.51466.69094532239.00267451708.27623311299.5335577-9NA '167502900146'-9'1'644001095-631940'3'110000026-6-6'-6'-62'1'52.08333333325741.678805971127.8346706862.471449822658.10011218-9NA '168549200142'-9'1'736001231-631960'3'163000015-6-6'-6'-61'1'60.833333333112.54360.28481096793.06675795121.278467223833.73904-9NA '171583230133'-9'1'792001812-661975'3'1250000112-6-6'-6'-61'1'65751801.48868162766.87834312103.470291211592.5419471-9NA '172926180148'-9'1'644001095-631940'3'139000016-6-6'-6'-61'1'133.333333332002925.25567664431.26354853396.346987622599.2987708-9NA '173583030133'-9'1'792001394-631950'3'11000015-6-6'-6'-61'1'50100216.45954726255.07513372228.538811651208.10167788-9NA '174596470143'-9'1'736001436-641940'3'110000017-6-6'-6'-61'1'14521.25830.845472641217.0013372951.638116492747.26677884-9NA '175336630133'-9'2'740081243-631975'3'16000016-6-6'-6'-61'1'29.58333333342470.34061692702.03413567542.816203232420.19340064-9NA '175596830133'-9'1'736001231-631970'3'113000019-6-6'-6'-61'1'70.83333333341.666666667976.474114431478.47673841133.50455142867.8218125-9NA '176502130133'-9'1'64400821-621950'3'110000025-6-6'-6'-62'1'52.08333333321.25737.928805971124.0846706858.721449822654.35011218-9NA '177281980145'-9'2'946551792-631919'3'1252000016-6-6'-6'-61'1'10091.66666666716939.47257726670.60036519983.447202114833.289494-9NA '177336930133'-9'2'740081243-631919'3'138000017-6-6'-6'-61'1'37.51002662.9627964130.35508153121.974842722345.3637596-9NA '177589150141'-9'2'71022796-621980'3'115000016-6-6'-6'-61'1'62.545.8333333331105.22654231684.46033921286.41550812979.8585016-9NA '178502430133'-9'2'64810819-621960'3'16000015-6-6'-6'-61'1'22.2542463.00728358694.70080234535.482869892412.86006731-9NA '178638330141'-9'2'61228835-621975'3'12000014-6-6'-6'-61'1'66.757.5207.16909453284.40026745231.32762333190.45335577-9NA '179778520142'-9'2'892001901-631940'3'156000016-6-6'-6'-61'1'86.251883995.98464686158.45748854672.423452443527.9439615-9NA '179890590141'-9'3'732471680-661960'3'1170000110-6-6'-6'-61'1'8042.51252.31230351908.77727331457.65979841110.228524-9NA '180687150143'-9'1'490001122-621940'3'145000014-6-6'-6'-61'1'14.58333333370.8333333333076.09629354813.79768423619.663190932699.9921715-9NA '181294950149'-9'2'1073002374-641970'3'130000017-6-6'-6'-61'1'18.916666667752087.70308463246.17067842450.081016131836.9670032-9NA '181502430133'-9'2'648101094-631950'3'16000016-6-6'-6'-61'1'22.2566.666666667487.67395025719.36746901560.149536562437.52673397-9NA '181583530133'-9'2'792001394-631950'3'17000016-6-6'-6'-61'1'70.83333333386.583333333622.63349751892.94260273707.188348211564.12841186-9NA '181778710145'-9'1'892002332-641970'3'158000018-6-6'-6'-61'1'296.751054256.40374136496.1077564957.001075743771.6473173-9NA '182502750146'-9'2'648101201-641950'3'18000018-6-6'-6'-61'1'12529.166666667685.84304478994.76773645782.477159862618.98008974-9NA '182638560147'-9'1'674961183-631919'3'113000016-6-6'-6'-61'1'50183.166666671097.14078111599.14340511254.17121813988.48847916-9NA '182941870143'-9'1'723002009-631950'3'147000016-6-6'-6'-61'1'72.41666666791.253287.26538815102.19795173854.990814242894.4455272-9NA '183321180149'-9'1'56800915-621950'3'17000015-6-6'-6'-61'1'138250853.216830851123.5259361937.771681543794.71174519-9NA '183850750140'-9'1'1013002574-641960'3'135000016-6-6'-6'-61'1'40.583333333902456.66748763808.21301362879.441741142164.1420593-9NA '184206130133'-9'2'863242237-661919'3'1180000112-6-6'-6'-61'1'71.8333333331001368.10518412063.18574041585.53194311217.6635353-9NA '184258520141'-9'2'792001394-631970'3'17000016-6-6'-6'-61'1'68.3333333330533.55016418803.8592694618.105014881475.04507852-9NA '184336730133'-9'2'740081243-631919'3'127000016-6-6'-6'-61'1'75131.666666672001.07444283043.69527722327.214581221775.4119695-9NA '184336830133'-9'2'740081445-641960'3'119000019-6-6'-6'-61'1'43.91666666760.8333333331367.4813982101.17754071596.987421321208.6818798-9NA '184389020140'-9'1'67496887-621940'3'113000015-6-6'-6'-61'1'140183.166666671187.14078111689.14340511344.171218131078.4884792-9NA '184493420144'-9'2'841001621-621970'3'34000015-6-6'-6'-66'1'01645.16666671911.00485572065.46720161959.321913341877.5733782-9NA '184494040140'-9'2'612281105-631920'3'17000015-6-6'-6'-61'1'138250853.216830851123.5259361937.771681543794.71174519-9NA '184657960148'-9'1'702001142-641950'3'113000016-6-6'-6'-61'1'73.3333333338.3333333333945.64078111447.64340511102.67121812836.98847916-9NA '185141710148'-9'2'65100969-631940'3'111000017-6-6'-6'-61'1'33.66666666750814.721686571239.4931376947.593594811722.78512339-9NA '185596530133'-9'1'73600966-621940'3'14000034-6-6'-6'-62'1'08.75274.58818905429.05053489322.90524662241.15671154-9NA '185638200147'-9'1'67496887-621950'3'113000014-6-6'-6'-61'1'50.83333333383.333333333998.14078111500.14340511155.17121813889.48847916-9NA '185791440146'-9'2'953541469-621950'3'1300000124-6-6'-6'-63'1'0752068.78641793227.25401172431.164349511818.0503365-9NA '185963610149'-9'2'841002268-631950'3'184000015-6-6'-6'-61'1'102.83333333162.55847.93530359091.64456616862.593511945145.8742756-9NA '186005590144'-9'2'490001539-631960'3'118000015-6-6'-6'-61'1'70451311.27185072006.3524071528.698609731160.8302019-9NA '186558700145'-9'2'675001183-631975'3'123000015-6-6'-6'-61'1'56.66666666760.9166666671646.15292042534.3114091923.976001331453.9219247-9NA '186597170144'-9'2'65100969-631950'3'14000016-6-6'-6'-61'1'113.333333330379.17152239533.63386823427.488579931345.74004487-9NA '187052770143'-9'1'762911259-631950'3'137000016-6-6'-6'-61'1'33.333333333752567.33658213996.11328113014.269364412258.0954151-9NA '187168570149'-9'1'632001200-631970'3'18000016-6-6'-6'-61'1'12854713.676378111022.6010698810.310493193646.81342307-9NA '187206630133'-9'1'895261623-631960'3'160000045-6-6'-6'-62'1'8568.754141.32283586458.25802344866.078698913639.8506731-9NA '187295920143'-9'1'631001064-621970'3'13000014-6-6'-6'-61'1'13941.666666667380.04530846495.89206784416.283101614354.97170032-9NA '187379770141'-9'1'630001895-631919'3'11000000655-6-6'-6'-65'1'068.756714.704726410576.2633727922.631164915878.9177884-9NA '187442920145'-9'4'59508791-621975'3'119000014-6-6'-6'-61'1'172.582.8333333331518.06473132251.76087411747.570754741359.2652131-9NA '187508940141'-9'3'697751037-631960'3'19000017-6-6'-6'-61'1'174.1666666768.75841.052592041188.5928702949.765971512765.83176763-9NA '188015720147'-9'2'63400741-621960'3'1250000725-6-6'-6'-65'1'4362.51766.98868162732.37834312068.970291221558.0419471-9NA '188029700148'-9'1'665001079-641940'3'12000017-6-6'-6'-61'1'50137.91909453215.15026745162.07762332121.20335577-9NA '188216330143'-9'1'566131164-631975'3'114000015-6-6'-6'-61'1'126.6666666791.6666666671148.7669951689.38520551317.876696431031.7568237-9NA '188267900144'-9'2'867001627-631950'3'122000016-6-6'-6'-61'1'81.666666667551598.77670652448.31960861864.520522941414.9035801-9NA '188281190148'-9'2'946551792-631919'3'135000018-6-6'-6'-61'1'52.587.52466.08415423817.62968032888.858407712173.558726-9NA '188295380149'-9'2'63100864-611950'3'15000045-6-6'-6'-62'1'40.83333333312.5385.63106965578.70900195446.027391584343.84172275-9NA '188389900149'-9'2'675001183-631930'3'189000018-6-6'-6'-61'1'107.666666671256147.56637319584.3535687222.620903435403.7159984-9NA '188532370142'-9'1'61700973-611975'3'170000503-6-6'-6'-65'1'9336.666666667594.88349751865.19260273679.438348213536.37841186-9NA '188596130133'-9'1'736001436-641919'3'118000018-6-6'-6'-61'1'3045.4166666671271.68851741966.76907371489.115276421121.2468686-9NA '188616150140'-9'2'62258973-631960'3'16000016-6-6'-6'-61'1'117.580596.25728358827.95080234668.732869892546.11006731-9NA '188654570146'-9'2'695001710-641950'3'117000019-6-6'-6'-61'1'164.66666667501344.47897022000.943941549.826464741202.3951907-9NA '188687780149'-9'2'49000876-611970'3'170000563-6-6'-6'-65'1'93411.66666667969.883497511240.19260271054.43834823911.37841186-9NA '188816230141'-9'3'68658974-621995'3'24000015-6-6'-6'-66'1'0484.75750.58818905905.05053489798.90524664717.15671154-9NA '188846960144'-9'1'61900831-631930'3'19000016-6-6'-6'-61'1'58.33333333344.666666667701.135925371048.6762035809.849304842625.91510096-9NA '188878320143'-9'1'727001110-631930'3'118000016-6-6'-6'-61'1'3045.4166666671271.68851741966.76907371489.115276421121.2468686-9NA '189007100145'-9'1'609911171-641930'3'110000016-6-6'-6'-61'1'42150856.595472641242.7513372977.388116493773.01677884-9NA '189104900148'-9'4'50723683-621930'3'14000014-6-6'-6'-61'1'98.50364.33818905518.80053489412.65524663330.90671154-9NA '189119570146'-9'4'640771041-631919'3'14000017-6-6'-6'-61'1'8511.25362.08818905516.55053489410.40524661328.65671154-9NA '189120930144'-9'4'50723683-621960'3'116000015-6-6'-6'-61'1'100183.333333331346.68608961964.53547291539.954319731212.9601795-9NA '189176990143'-9'2'687001025-631975'3'18000015-6-6'-6'-61'1'1000631.67637811940.60106979728.310493193564.81342307-9NA '189268600140'-9'1'762911259-631930'3'14000016-6-6'-6'-61'1'62.16666666712.5340.50485572494.96720156388.821913261307.0733782-9NA '189269510140'-9'2'867001104-621975'3'1550000104-6-6'-6'-63'1'76.66666666724.8333333333756.77509955880.63235484421.134640743297.0922836-9NA '189294510143'-9'2'1073002374-641950'3'130000017-6-6'-6'-61'1'6087.52141.28641793299.75401172503.664349531890.5503365-9NA '189302570146'-9'2'704251377-641940'3'120000017-6-6'-6'-61'1'75.58333333333.3333333331438.10761192210.41934111679.692899641270.9502244-9NA '189365020146'-9'2'712001073-631950'3'128000016-6-6'-6'-61'1'50851995.86732343077.10374432334.086726221761.8469808-9NA '189388940145'-9'4'49074644-621950'3'116000014-6-6'-6'-61'1'0183.333333331246.68608961864.53547291439.954319731112.9601795-9NA '189472560148'-9'2'707241007-611970'3'28000013-6-6'-6'-66'1'12.520564.17637811873.10106979660.810493194497.31342307-9NA '189492530145'-9'1'60700601-611930'3'110000014-6-6'-6'-61'1'263.4166666722.5950.51213931336.66800391071.30478323866.93344551-9NA '189502230133'-9'2'64810819-621920'3'17000014-6-6'-6'-61'1'52.541.666666667559.38349751829.69260273643.938348212500.87841186-9NA '189543140143'-9'1'55926767-621950'3'126000014-6-6'-6'-61'1'0701797.94822892801.95347682112.009102931580.643625-9NA '189596530133'-9'1'73600966-621920'3'118000016-6-6'-6'-61'1'37193.916666671427.18851742122.26907371644.615276421276.7468686-9NA '189712570148'-9'1'629241039-631919'3'11000017-6-6'-6'-61'1'054.166666667120.62621393159.24180039132.705478323112.26834455-9NA '189719330147'-9'4'632211135-651940'3'110000017-6-6'-6'-61'1'57.33333333336.25758.178805971144.3346706878.971449822674.60011218-9NA '189813140149'-9'1'62900778-621950'3'18000014-6-6'-6'-61'1'12641.666666667699.343044781008.2677365795.977159864632.48008974-9NA '189924570149'-9'1'52400762-621950'3'18000015-6-6'-6'-61'1'14.58333333317.5563.75971144872.68440312660.393826533496.89675641-9NA '189961980147'-9'5'619171214-651919'3'15000018-6-6'-6'-61'1'36.33333333341.666666667410.29773632603.37566862470.694058251368.50838942-9NA '191206830133'-9'2'863241721-631950'3'122000017-6-6'-6'-61'1'60551577.11003982426.65294191842.853856311393.2369135-9NA '191502630133'-9'2'648101201-641960'3'19000017-6-6'-6'-61'1'116.6666666722.5737.302592041084.8428702846.015971512662.08176763-9NA '192583530133'-9'2'792001119-621980'3'113000014-6-6'-6'-61'1'508.1666666733.3333333331405.47411441907.47673841562.504551411296.8218125-9NA '193206430133'-9'2'863241335-621985'3'120000015-6-6'-6'-61'1'22133.333333331484.52427862256.83600781726.109566311317.366891-9NA '193206830133'-9'3'954812075-641919'3'170000019-6-6'-6'-61'1'38.33333333366.6666666674757.16830857460.25936065602.716815414172.1174519-9NA '193336330133'-9'1'73600815-611950'3'13000013-6-6'-6'-61'1'2733.333333333259.71197512375.5587345295.949768282234.63836699-9NA '193336530133'-9'2'740081243-631975'3'114000015-6-6'-6'-61'1'24.166666667651019.60032841560.21853881188.71002982902.59015705-9NA '193489530133'-9'2'792001496-641940'3'119000017-6-6'-6'-61'1'5373.51389.2313982122.92754071618.737421311230.4318798-9NA '193583030133'-9'2'792001496-642000'3'17000018-6-6'-6'-61'1'114.33333333158.33333333737.883497511008.1926027822.438348211679.37841186-9NA '194336830133'-9'3'753251279-631995'3'16000016-6-6'-6'-61'1'45195638.75728358870.45080234711.232869892588.61006731-9NA '195273330133'-9'2'953721125-611985'3'125200002863-6-6'-6'-65'1'01643.833333318391.63924428122.76703221435.613869116285.45616-9NA '195452230133'-9'1'630001243-611960'3'137000044-6-6'-6'-62'1'183.33333333126.833333332769.16991544197.94661443216.102697712459.9287484-9NA '197381130133'-9'3'937951876-631980'3'155000017-6-6'-6'-61'1'196.6666666781.253933.19176626057.04902144597.551307413473.5089503-9NA '197381430133'-9'2'953721125-611980'3'13000013-6-6'-6'-61'1'270.33333333250719.71197512835.5587345755.949768281694.63836699-9NA '197791130133'-9'2'908311433-621960'3'122000044-6-6'-6'-62'1'015172979.11003983828.65294193244.853856312795.2369135-9NA '197796430133'-9'2'863241721-631950'3'150000016-6-6'-6'-61'1'16.6666666671003439.64402995370.42335284043.607249113021.7505609-9NA '198381930133'-9'2'953721877-632012'3'1252000018-6-6'-6'-61'1'5012516922.8059126653.93369819966.780536114816.622827-9NA '198452830133'-9'1'630001243-611960'3'120000023-6-6'-6'-62'1'0501379.19094532151.50267451620.77623311212.0335577-9NA '198502630133'-9'2'648101201-641960'3'112000017-6-6'-6'-61'1'83.33333333350930.84790051394.2349381075.79907312830.55346795-9NA '199067760145'-9'5'591561262-641940'3'115000019-6-6'-6'-61'1'070.8333333331067.72654231646.96033921248.91550814942.3585016-9NA '199122980142'-9'5'55846949-631950'3'112000015-6-6'-6'-61'1'151.3333333350998.84790051462.2349381143.79907313898.55346795-9NA '199135800244'-9'3'59541904-621975'3'21000014-6-6'-6'-66'1'0325391.45954726430.07513372403.538811653383.10167788-9NA '199158750349'-9'3'61329773-621940'3'110000014-6-6'-6'-61'1'37.536.666666667738.76213931124.9180039859.554783163655.18344551-9NA '199178758181'-9'5'55846949-632012'3'26000015-6-6'-6'-66'1'8115494.75728358726.45080234567.232869893444.61006731-9NA '199234720142'-9'5'502221034-641940'3'150000016-6-6'-6'-61'1'142.52503715.47736325646.25668624319.440582533297.5838942-9NA '199250840249'-9'4'49074873-631950'3'111000015-6-6'-6'-61'1'96.666666667100927.721686571352.49313761060.59359483835.78512339-9NA '199260950441'-9'2'60060956-621960'3'117000013-6-6'-6'-61'1'01001229.81230351886.27727331435.15979831087.728524-9NA '199281860242'-9'2'775661012-621940'3'130000016-6-6'-6'-61'1'166.666666672502410.45308463568.92067842772.831016112159.7170032-9NA '199288950343'-9'2'48714830-631940'3'110000018-6-6'-6'-61'1'10050814.595472641200.7513372935.388116493731.01677884-9NA '199298920449'-9'3'61292951-631960'3'114000017-6-6'-6'-61'1'5954.1666666671043.60032841584.21853881212.71002982926.59015705-9NA '199381230133'-9'2'953721390-621960'3'19000015-6-6'-6'-61'1'33.333333333218.33333333849.802592041197.3428702958.515971511774.58176763-9NA '199381980449'-9'3'937951380-621975'3'19000015-6-6'-6'-61'1'33.333333333368.33333333999.802592041347.34287021108.51597151924.58176763-9NA '199398980441'-9'4'595471004-631920'3'115000016-6-6'-6'-61'1'80501126.8932091706.12700581308.082174731001.5251683-9NA '199410920346'-9'2'63068844-611960'3'28000013-6-6'-6'-66'1'0174.33333333706.009711441014.9344031802.643826534639.14675641-9NA '199421680241'-9'3'737381204-631950'3'155000015-6-6'-6'-61'1'166.6666666766.6666666673888.60843286012.46568814552.96797413428.925617-9NA '199431850447'-9'5'57596883-631919'3'113000018-6-6'-6'-61'1'032.25896.224114431398.22673841053.25455142787.5718125-9NA '199456810144'-9'5'55846949-631950'3'113000017-6-6'-6'-61'1'158.3333333331.251053.55744781555.56007171210.58788483944.90514583-9NA '199456810441'-9'5'55846949-631970'3'113000016-6-6'-6'-61'1'031.25895.224114431397.22673841052.25455143786.5718125-9NA '199494970342'-9'5'58768642-621919'3'16000014-6-6'-6'-61'1'46.66666666733.333333333478.75728358710.45080234551.232869892428.61006731-9NA '199502730133'-9'1'644001095-631930'3'11000015-6-6'-6'-61'1'400106.45954726145.07513372118.53881165298.101677884-9NA '199517920445'-9'2'63068844-611970'3'38000013-6-6'-6'-66'1'0366.66666667898.343044781207.2677365994.977159864831.48008974-9NA '199548970144'-9'5'626111153-631970'3'117000016-6-6'-6'-61'1'23.333333333401193.14563681849.61060661398.493131411051.0618574-9NA '199557890449'-9'3'613291032-631975'3'17000015-6-6'-6'-61'1'5550570.21683085840.52593606654.771681543511.71174519-9NA '199577810441'-9'2'600601528-641975'3'116000017-6-6'-6'-61'1'53.33333333341.6666666671158.35275621776.20213961351.620986431024.6268461-9NA '199597550241'-9'2'65100969-631930'3'117000016-6-6'-6'-61'1'31.66666666741.251202.72897021859.193941408.076464711060.6451907-9NA '199604947389'-9'5'46720859-632005'3'115000015-6-6'-6'-61'1'50166.666666671213.55987561792.79367251394.748841431088.1918349-9NA '199604948189'-9'5'46720859-631980'3'115000015-6-6'-6'-61'1'0166.666666671163.55987561742.79367251344.748841431038.1918349-9NA '199623750249'-9'5'44607666-621919'3'14000014-6-6'-6'-61'1'16410439.83818905594.30053489488.15524663406.40671154-9NA '199657730113'-9'5'591561102-631985'3'216000015-6-6'-6'-66'1'62.16666666758.3333333331183.85275621801.70213961377.120986441050.1268461-9NA '199667758085'-9'5'57596664-621990'3'24000014-6-6'-6'-66'1'045.833333333311.67152239466.13386823359.988579932278.24004487-9NA '199667830348'-9'5'57596883-631970'3'150000017-6-6'-6'-61'1'32503404.97736325335.75668624008.940582522987.0838942-9NA '199697808188'-9'5'587681104-661995'3'1120000110-6-6'-6'-61'1'79.16666666727.5904.181233831367.56827131049.13240652803.88680128-9NA '199700840346'-9'3'595411208-631975'3'114000015-6-6'-6'-61'1'3133.333333333994.766995031535.38520551163.87669643877.75682371-9NA '199714870140'-9'3'737381204-631919'3'16000016-6-6'-6'-61'1'102.0833333329.166666667530.00728358761.70080234602.482869891479.86006731-9NA '199731970442'-9'3'595411208-631975'3'115000015-6-6'-6'-61'1'3586.6666666671118.55987561697.79367251299.74884143993.19183493-9NA '199777970346'-9'5'55846706-621960'3'27000015-6-6'-6'-66'1'00465.21683085735.52593606549.771681543406.71174519-9NA '199793890243'-9'5'57596883-631970'3'116000015-6-6'-6'-61'1'58.33333333342.51164.18608961782.03547291357.454319721030.4601795-9NA '199807870140'-9'5'59156794-621920'3'150000017-6-6'-6'-61'1'0183.333333333506.31069655437.09001954110.273915843088.4172275-9NA '199819850247'-9'4'50723907-631950'3'15000016-6-6'-6'-61'1'22.083333333108.33333333462.71440299655.79233528523.110724913420.92505609-9NA '199842890441'-9'5'591561433-661930'3'110000019-6-6'-6'-61'1'025689.595472641075.7513372810.388116494606.01677884-9NA '199851680347'-9'5'57596883-631920'3'114000016-6-6'-6'-61'1'054.166666667984.600328361525.21853881153.71002982867.59015705-9NA '199860910440'-9'4'58019853-631950'3'11000016-6-6'-6'-61'1'51.6666666670118.12621393156.74180039130.205478322109.76834455-9NA '199871940346'-9'3'67676936-611970'3'13000013-6-6'-6'-61'1'27.558.333333333285.21197512401.0587345321.449768284260.13836699-9NA '199894850346'-9'4'59547760-621940'3'17000014-6-6'-6'-61'1'43.7520528.96683085799.27593606613.521681543470.46174519-9NA '199910720147'-9'5'57596991-641960'3'118000017-6-6'-6'-61'1'43.333333333133.333333331372.93851742068.01907371590.365276421222.4968686-9NA '199918890449'-9'5'55846706-621960'3'120000014-6-6'-6'-61'1'66.666666667501445.85761192218.16934111687.442899631278.7002244-9NA '199927980140'-9'1'613001134-631970'3'120000016-6-6'-6'-61'1'66.6666666671051500.85761192273.16934111742.442899631333.7002244-9NA '199937930442'-9'2'684941177-631940'3'16000016-6-6'-6'-61'1'74.16666666750522.92395025754.61746901595.399536561472.77673397-9NA '199954330133'-9'1'630002179-651960'3'1380000110-6-6'-6'-61'1'263.4166666787.52876.37946274343.77174823335.391509312558.7804263-9NA '199965710346'-9'3'70310893-621960'3'118000015-6-6'-6'-61'1'16.66666666716.6666666671229.60518411924.68574041447.03194311079.1635353-9NA '199975709084'-9'5'46720859-631990'3'226000016-6-6'-6'-66'1'22.9166666672251975.86489552979.87014352289.925769531758.5602917-9NA '199975880844'-9'4'49074644-621980'3'226000015-6-6'-6'-66'1'22.9166666672251975.86489552979.87014352289.925769531758.5602917-9NA '199992890142'-9'5'55846706-621919'3'112000015-6-6'-6'-61'1'050847.514567161310.9016047992.465739793747.22013461-9NA '199992978381'-9'4'50723907-631980'3'127000017-6-6'-6'-61'1'57.501851.90777612894.52861052178.047914531626.2453029-9NA '199993930141'-9'4'52006878-631970'3'15000016-6-6'-6'-61'1'5760449.29773632642.37566862509.694058252407.50838942-9NA '199996910441'-9'3'676761987-641920'3'130000016-6-6'-6'-61'1'52.558.3333333332104.61975123263.0873452466.997682841853.8836699-9NA '200013430103'-9'1'643621209-642007'3'129000017-6-6'-6'-61'1'33.08333333368.752029.1602043149.01221132379.458871221786.781992-9NA '200037930103'-9'2'707242101-642005'3'121000016-6-6'-6'-61'1'61.666666667183.333333331640.65049252451.57780821894.315044641465.1352356-9NA '200103730143'-9'2'68700740-621985'3'123000016-6-6'-6'-61'1'323.91666667133.333333331985.81958712873.97807562263.642667921793.5885913-9NA '200150730248'-9'2'73600966-621980'3'18000064-6-6'-6'-63'1'221247.666666671000.34304481309.26773651096.97715992933.48008974-9NA '200169530103'-9'2'695001430-632006'3'125000018-6-6'-6'-61'1'43.3333333331551859.82201492825.21167642161.803624641650.8752804-9NA '200202130103'-9'2'62258973-632004'3'118000017-6-6'-6'-61'1'106.416666672301532.68851742227.76907371750.115276421382.2468686-9NA '200302130103'-9'2'743161523-642003'3'120000017-6-6'-6'-61'1'130.833333331001560.02427862332.33600781801.609566341392.866891-9NA '200321330103'-9'3'595411208-632005'3'18000015-6-6'-6'-61'1'17.5100649.17637811958.10106979745.810493193582.31342307-9NA '200431230103'-9'5'619171257-642004'3'116000018-6-6'-6'-61'1'23.166666667451131.51942291749.36880621324.78765311997.79351282-9NA '200510130103'-9'1'762911443-642007'3'134000019-6-6'-6'-61'1'164.1666666773.3333333332497.1246073810.05454662907.819596112212.9570481-9NA '200529130103'-9'2'600601282-632005'3'116000017-6-6'-6'-61'1'120208.333333331391.68608962009.53547291584.954319731257.9601795-9NA '200538330103'-9'5'55846949-632007'3'122000016-6-6'-6'-61'1'052.51514.61003982364.15294191780.353856331330.7369135-9NA '200553380149'-9'1'733001570-631980'3'123000016-6-6'-6'-61'1'63.333333333133.333333331725.23625372613.39474232003.059334631533.005258-9NA '200596730133'-9'1'73600966-622009'3'18000002985-6-6'-6'-65'1'711575.33333336963.097114410052.3440317929.438265326294.4675641-9NA '200635230103'-9'5'50296780-622004'3'110000014-6-6'-6'-61'1'033.333333333697.928805971084.0846706818.721449824614.35011218-9NA '200733770144'-9'2'600601282-631980'3'115000065-6-6'-6'-63'1'61.66666666741.6666666671100.22654231679.46033921281.41550813974.8585016-9NA '200749130103'-9'1'70200828-622005'3'1660000745-6-6'-6'-65'1'711575.33333336032.66345278581.29215916829.894902225481.0440737-9NA '200793160149'-9'5'57596883-631980'3'116000015-6-6'-6'-61'1'108.33333333401211.68608961829.53547291404.954319721077.9601795-9NA '200799330103'-9'1'56613868-622005'3'1900002435-6-6'-6'-65'1'1107201428.13592541775.67620351536.849304831352.915101-9NA '200851510244'-9'5'57596883-631990'3'150000017-6-6'-6'-61'1'86.6666666671423551.64402995482.42335284155.607249123133.7505609-9NA '200908130403'-9'5'50222671-622008'3'125000014-6-6'-6'-61'1'59.1666666673252045.65534833011.04500972347.636957931836.7086138-9NA '200970530103'-9'4'595471181-642008'3'125200001967-6-6'-6'-65'1'144.8333333310016992.63924426723.76703220036.613869314886.45616-9NA '201261430103'-9'1'622001567-652006'3'143000019-6-6'-6'-61'1'143.51403141.26053234801.73075013660.668900942781.872149-9NA '201295130103'-9'2'630681057-622007'3'120000014-6-6'-6'-61'1'7.5501386.69094532159.00267451628.27623341219.5335577-9NA '201410130103'-9'2'630681057-622005'3'110000014-6-6'-6'-61'1'117.533.333333333815.428805971201.5846706936.221449824731.85011218-9NA '201502730133'-9'2'648101094-632004'3'116000015-6-6'-6'-61'1'083.3333333331146.68608961764.53547291339.954319721012.9601795-9NA '201618900147'-9'2'63100864-611985'3'130000123-6-6'-6'-63'1'60223482.37864179598.22540117518.616434954457.30503365-9NA '201894530147'-9'2'600601282-631985'3'125000046-6-6'-6'-62'1'81.083333333491791.57201492756.96167642093.553624631582.6252804-9NA '202502530233'-9'2'648101094-632005'3'163000017-6-6'-6'-61'1'240.3333333383.3333333334510.61814436943.40009125271.611800623984.0723734-9NA '203447580149'-9'3'595411208-631985'3'1150000105-6-6'-6'-63'1'016.6666666671013.55987561592.79367251194.74884143888.19183493-9NA '203502330133'-9'2'648101201-642005'3'19000016-6-6'-6'-61'1'96.66666666722.5717.302592041064.8428702826.015971512642.08176763-9NA '206248720145'-9'3'595411436-641985'3'116000017-6-6'-6'-61'1'274.2542.51380.10275621997.95213961573.370986431246.3768461-9NA '207196590141'-9'3'595411389-651985'3'175000019-6-6'-6'-61'1'52.916666667116.666666675154.04937818050.21836266059.99420734527.2091747-9NA '229102970141'-9'2'620661249-641975'3'115000017-6-6'-6'-61'1'115.83333333120.833333331233.55987561812.79367251414.748841431108.1918349-9NA '229684970147'-9'4'621401113-631919'3'115000015-6-6'-6'-61'1'0501046.8932091626.12700581228.08217471921.52516826-9NA '241502930133'-9'1'644001196-641930'3'15000017-6-6'-6'-61'1'17.66666666712.5362.46440299555.54233528422.860724912320.67505609-9NA '245502030133'-9'1'644001095-631960'3'12000015-6-6'-6'-61'1'18.91666666750201.83576119279.06693411225.994289962185.12002244-9NA '250502730133'-9'2'64810819-621920'3'125000014-6-6'-6'-61'1'041.6666666671703.15534832668.54500972005.136957921494.2086138-9NA '255583530133'-9'2'792001394-631940'3'110000016-6-6'-6'-61'1'4025729.595472641115.7513372850.388116491646.01677884-9NA '256583030133'-9'2'792001119-621960'3'9160000425-6-6'-6'-64'1'673801510.35275622128.20213961703.620986411376.6268461-9NA '257502530133'-9'2'648101094-631940'3'11000016-6-6'-6'-61'1'62.08333333325153.5428806192.15846706165.622144982145.18501122-9NA '259583230133'-9'2'792001119-621970'3'1170000424-6-6'-6'-64'1'67251221.81230351878.27727331427.15979811079.728524-9NA '269502930133'-9'2'648101094-631950'3'116000016-6-6'-6'-61'1'5066.6666666671180.01942291797.86880621373.287653121046.2935128-9NA '270583370146'-9'1'79200929-611920'3'122000023-6-6'-6'-62'1'001462.11003982311.65294191727.853856311278.2369135-9NA '271502630133'-9'1'64400821-621950'3'12000015-6-6'-6'-61'1'0.83333333336.5140.25242786217.48360078164.410956632123.5366891-9NA '271583230133'-9'1'792001603-651920'3'16000018-6-6'-6'-61'1'7079.916666667548.67395025780.36746901621.149536561498.52673397-9NA '271583730133'-9'1'792001394-631920'3'16000016-6-6'-6'-61'1'7079.916666667548.67395025780.36746901621.149536561498.52673397-9NA '272336630133'-9'2'74008971-621995'3'118000014-6-6'-6'-61'1'25501271.27185071966.3524071488.698609721120.8302019-9NA '273502530133'-9'1'644001095-631920'3'12000016-6-6'-6'-61'1'150187.5470.41909453547.65026745494.57762332453.70335577-9NA '275336430133'-9'2'74008971-621970'3'125000045-6-6'-6'-62'1'121.66666667137.51920.65534832886.04500972222.636957921711.7086138-9NA '277037110149'-9'1'619001421-621920'3'117000016-6-6'-6'-61'1'188.3333333362.51380.64563682037.11060661585.993131441238.5618574-9NA '278258590141'-9'1'792001812-661919'3'12520000112-6-6'-6'-61'1'70.41666666797.516915.72257726646.85036519959.697202114809.539494-9NA '278502100149'-9'2'648101094-631920'3'11000016-6-6'-6'-61'1'1250191.45954726230.07513372203.538811652183.10167788-9NA '278583230133'-9'1'792001394-631920'3'18000016-6-6'-6'-61'1'242.8333333366.666666667841.176378111150.1010698937.810493191774.31342307-9NA '278597190141'-9'2'775661469-651919'3'117000019-6-6'-6'-61'1'76.666666667541260.47897021916.943941465.826464711118.3951907-9NA '279206180143'-9'1'891001550-631919'3'11000045-6-6'-6'-62'1'41.9166666670108.37621393146.99180039120.455478321100.01834455-9NA '279572770149'-9'1'65100772-621919'3'12000015-6-6'-6'-61'1'23.33333333334.25190.50242786267.73360078214.660956631173.7866891-9NA '279880180341'-9'1'891001550-631919'3'11000045-6-6'-6'-62'1'41.9166666670108.37621393146.99180039120.455478321100.01834455-9NA '280482500149'-9'1'856001740-641950'3'129000017-6-6'-6'-61'1'33.33333333366.6666666672027.32687063147.1788782377.625537831784.9486586-9NA '281502730133'-9'1'64400629-611920'3'1100002643-6-6'-6'-65'1'0485.08333333551.5428806590.15846706563.622144982543.18501122-9NA '281596530133'-9'1'73600966-621920'3'115000024-6-6'-6'-62'1'41.66666666728.3333333331066.8932091646.12700581248.08217472941.52516826-9NA '282379420147'-9'1'630001191-601960'3'1190000401-6-6'-6'-64'1'05551817.7313982551.42754072047.237421311658.9318798-9NA '282583730133'-9'2'792001496-641930'3'114000017-6-6'-6'-61'1'33.33333333366.6666666671030.43366171571.05187211199.54336311913.42349038-9NA '282939970145'-9'1'692001405-661919'3'11000019-6-6'-6'-61'1'288.4166666791.666666667446.5428806485.15846706458.622144982438.18501122-9NA '283005100144'-9'2'49000876-611970'3'1700003003-6-6'-6'-65'1'020485.21683085755.52593606569.771681543426.71174519-9NA '283515760145'-9'2'49000876-611970'3'1700004413-6-6'-6'-65'1'9620581.21683085851.52593606665.771681543522.71174519-9NA '283583130133'-9'2'792001119-621960'3'130000014-6-6'-6'-61'1'51.6666666671402185.45308463343.92067842547.831016111934.7170032-9NA '283730170144'-9'1'622001363-631960'3'143000016-6-6'-6'-61'1'118.3333333383.3333333333059.4271994719.89741683578.835567642700.0388157-9NA '284502130133'-9'1'64400629-611920'3'12000013-6-6'-6'-61'1'86.6666666677.5227.08576119304.31693411251.244289962210.37002244-9NA '284548910142'-9'1'622001363-631970'3'143000016-6-6'-6'-61'1'144.16666667133.333333333135.26053234795.73075013654.668900942775.872149-9NA '284809550145'-9'1'63226874-621920'3'130000018-6-6'-6'-61'1'130802203.78641793362.25401172566.164349541953.0503365-9NA '284895390147'-9'1'702001142-641919'3'119000017-6-6'-6'-61'1'116.2574.5833333331453.56473132187.26087411683.070754721294.7652131-9NA '285050330144'-9'1'1073001191-611960'3'12500001334-6-6'-6'-65'1'01579.53240.98868164206.37834313542.970291233032.0419471-9NA '285220510147'-9'2'600601282-631975'3'110000045-6-6'-6'-62'1'45100809.595472641195.7513372930.388116493726.01677884-9NA '285468820143'-9'1'679001008-631930'3'16000015-6-6'-6'-61'1'228.33333333100727.09061692958.78413567799.566203232676.94340064-9NA '285502430133'-9'2'648101094-631985'3'118000015-6-6'-6'-61'1'098.51294.77185071989.8524071512.198609721144.3302019-9NA '285806520145'-9'2'1073002374-641950'3'113000017-6-6'-6'-61'1'26.66666666765955.64078111457.64340511112.67121813846.98847916-9NA '286099560247'-9'3'612921073-641930'3'928000018-6-6'-6'-61'1'0751935.86732343017.10374432274.086726221701.8469808-9NA '286294950143'-9'2'1073002174-651960'3'19000018-6-6'-6'-61'1'11.2522.5631.88592537979.42620351740.599304843556.66510096-9NA '286295990146'-9'1'631001568-631975'3'18000016-6-6'-6'-61'1'264.33333333222.51018.50971141327.43440311115.14382654951.64675641-9NA '286468840140'-9'1'679001008-631950'3'16000017-6-6'-6'-61'1'66.66666666766.666666667532.09061692763.78413567604.566203232481.94340064-9NA '286502730133'-9'1'644001196-641920'3'11000017-6-6'-6'-61'1'00.166666666766.62621393105.2418003978.705478316258.268344551-9NA '286721560148'-9'3'612921073-641920'3'128000018-6-6'-6'-61'1'066.6666666671927.53399013008.77041092265.753392821693.5136474-9NA '286795100145'-9'2'909001878-631930'3'198000027-6-6'-6'-62'1'133.3333333327.0833333336673.452298510457.7797727857.220208315854.3810993-9NA '287141900142'-9'2'651001032-641975'3'118000017-6-6'-6'-61'1'42.333333333451283.60518411978.68574041501.03194311133.1635353-9NA '287155110142'-9'3'61292718-621919'3'148000016-6-6'-6'-61'1'0503.916666673693.97493535547.52308544273.779625823292.7972051-9NA '287294710140'-9'2'1073001890-631995'3'19000016-6-6'-6'-61'1'50100748.135925371095.6762035856.849304843672.91510096-9NA '287303350148'-9'1'62924778-621940'3'16000014-6-6'-6'-61'1'7.7515421.50728358653.20080234493.982869893371.36006731-9NA '287321320146'-9'2'568001221-631970'3'135000016-6-6'-6'-61'1'134.7551.4166666672512.25082093863.7963472935.025074432219.7253926-9NA '287468610146'-9'1'67900782-621940'3'13000014-6-6'-6'-61'1'86.66666666780366.04530846481.89206784402.283101612340.97170032-9NA '287584980149'-9'2'62258729-621960'3'111000016-6-6'-6'-61'1'14.16666666775820.221686571244.9931376953.093594812728.28512339-9NA '287880970147'-9'2'891001550-631960'3'179000016-6-6'-6'-61'1'23.3333333331255398.63756728449.26889756352.899453614738.3658862-9NA '287939320148'-9'2'692001227-641960'3'122000017-6-6'-6'-61'1'88.33333333370.51620.94337312470.48627521886.687189621437.0702468-9NA '287963150143'-9'2'841002268-631970'3'127000056-6-6'-6'-63'1'357.41666667503.916666672655.74110953698.36194392981.881247942430.0786362-9NA '288220980347'-9'1'646001907-641975'3'13000017-6-6'-6'-61'1'2.50201.87864179317.72540117238.116434953176.80503365-9NA '288339730141'-9'1'715991276-631919'3'140000036-6-6'-6'-62'1'041.6666666672700.04855724244.67201563183.219132612365.733782-9NA '288489530133'-9'2'792001394-631930'3'115000016-6-6'-6'-61'1'33.33333333366.6666666671096.8932091676.12700581278.08217471971.52516826-9NA '288506740143'-9'2'775661435-641970'3'118000018-6-6'-6'-61'1'142.3333333345.8333333331384.43851742079.51907371601.865276411233.9968686-9NA '288686510147'-9'2'612281105-631960'3'114000017-6-6'-6'-61'1'8636.251052.68366171593.30187211221.79336313935.67349038-9NA '288958800141'-9'1'72900750-621920'3'16000015-6-6'-6'-61'1'33.166666667100531.92395025763.61746901604.399536562481.77673397-9NA '289092730149'-9'2'734371325-641975'3'125000019-6-6'-6'-61'1'100501811.48868162776.87834312113.470291211602.5419471-9NA '289101320140'-9'4'63221987-631940'3'17000015-6-6'-6'-61'1'6566.666666667596.88349751867.19260273681.438348212538.37841186-9NA '289160540245'-9'5'58768849-631919'3'128000016-6-6'-6'-61'1'081.251942.11732343023.35374432280.336726221708.0969808-9NA '289253640140'-9'1'66000797-621960'3'13000014-6-6'-6'-61'1'95.3333333336.75301.46197512417.3087345337.699768282276.38836699-9NA '289338370148'-9'4'58019853-631950'3'18000016-6-6'-6'-61'1'172.2541.666666667745.593044781054.5177365842.227159862678.73008974-9NA '289409940140'-9'4'49074873-631975'3'113000018-6-6'-6'-61'1'120651048.97411441550.97673841206.00455143940.3218125-9NA '289421930142'-9'5'57596664-621940'3'15000016-6-6'-6'-61'1'52.5116.66666667501.46440299694.54233528561.860724912459.67505609-9NA '289467720141'-9'4'63221552-611919'3'17000013-6-6'-6'-61'1'46.66666666758.333333333570.21683085840.52593606654.771681542511.71174519-9NA '289483540149'-9'2'705361183-631950'3'175000015-6-6'-6'-61'1'501505184.46604488080.63502926090.410873714557.6258413-9NA '289519920148'-9'2'66663652-611970'3'136000013-6-6'-6'-61'1'63.58333333391.6666666672547.79370153937.9548142982.647219442246.9104038-9NA '289559410148'-9'1'72900750-621950'3'16000014-6-6'-6'-61'1'13213.75544.50728358776.20080234616.982869892494.36006731-9NA '289565960143'-9'1'76291994-621930'3'121000014-6-6'-6'-61'1'66.66666666753.751516.06715922326.99447491769.731711311340.5519022-9NA '289619170149'-9'1'621001041-631970'3'115000016-6-6'-6'-61'1'6083.3333333331140.22654231719.46033921321.415508131014.8585016-9NA '289629110142'-9'1'76291793-611940'3'140000033-6-6'-6'-62'1'083.3333333332741.71522394286.33868233224.885799312407.4004487-9NA '289653170143'-9'4'52006634-621930'3'115000015-6-6'-6'-61'1'6591.6666666671153.55987561732.79367251334.748841421028.1918349-9NA '289801990144'-9'3'67535808-621919'3'116000014-6-6'-6'-61'1'16039.751263.10275621880.95213961456.370986421129.3768461-9NA '289839330143'-9'1'62300819-621970'3'9220000104-6-6'-6'-63'1'02551717.11003982566.65294191982.853856331533.2369135-9NA '289871360140'-9'1'586001469-631975'3'13000016-6-6'-6'-61'1'5530284.37864179400.22540117320.616434954259.30503365-9NA '289906920141'-9'4'50723683-621920'3'13000015-6-6'-6'-61'1'613.75264.12864179379.97540117300.366434953239.05503365-9NA '289949700147'-9'1'55926767-621960'3'15000015-6-6'-6'-61'1'70109511.29773632704.37566862571.694058253469.50838942-9NA '289956780147'-9'5'58768642-621940'3'12000014-6-6'-6'-61'1'4063235.91909453313.15026745260.07762332219.20335577-9NA '289962190145'-9'2'666001083-631950'3'117000016-6-6'-6'-61'1'501251304.81230351961.27727331510.15979811162.728524-9NA '290583430133'-9'2'792001394-631950'3'110000016-6-6'-6'-61'1'8425773.595472641159.7513372894.388116491690.01677884-9NA '292489130133'-9'2'792001603-651975'3'119000018-6-6'-6'-61'1'50116.666666671429.39806472163.09420741658.90408811270.5985465-9NA '294583930133'-9'1'792001119-621920'3'113000014-6-6'-6'-61'1'17.66666666758.333333333939.974114431441.97673841097.00455141831.3218125-9NA '295381330133'-9'3'937951876-631985'3'130000016-6-6'-6'-61'1'54.16666666783.3333333332131.28641793289.75401172493.664349511880.5503365-9NA '295583430133'-9'1'792001394-631920'3'113000016-6-6'-6'-61'1'17.66666666758.333333333939.974114431441.97673841097.00455141831.3218125-9NA '296381830133'-9'2'953721877-631985'3'130000016-6-6'-6'-61'1'1252002318.78641793477.25401172681.164349512068.0503365-9NA '296502130133'-9'3'675351093-631990'3'113000015-6-6'-6'-61'1'62.531.25957.724114431459.72673841114
Answered 2 days AfterMar 26, 2023

Answer To: Research ProjectResearch Project Overview: Students will work in groups of 2 (or occasionally 3)...

Komalavalli answered on Mar 28 2023
38 Votes
Slide 1
US Housing Market Value 1919 -2013
Introduction
House price swings are gaining attention in academics and the general public, owing to their apparent expanding influence on consumer spending and financial markets.
Dropping house values may have a huge influence on financial markets, as proven by the subprime mortgage market crisis that began in the United States in August 2007 and expanded to financial markets throughout the world.
Policymakers are primarily concerned with the impact of chan
ges in house prices on the business cycle.
A significant increase in property prices could cause the economy to "overheat," whereas a drop in property prices could signal an overall economic slowdown.
Housing prices in the United States climbed dramatically before plummeting precipitously.
Because many jobs are linked to the value of property through household and public sector expenditure, particularly local government spending, recent swings in housing values and employment have had major macroeconomic and microeconomic effects.
Review of literature
Rapach & Strauss(2009) This study focuses on projecting real house prices across shorter time periods of four and eight quarters, in line with current concerns regarding short-term swings in real home prices.
It investigates the predictability of real house prices across US states from 1995 to January 2006, including a lengthy housing market slump.
The findings demonstrate a significant variance in house price predictability among states, which is connected to variations in median home price increase.
Cohen Coughlin & Lopez (2012) This paper attempts to describe the major developments in housing prices in recent years from both a national and an urban viewpoint.
Furthermore, an analysis of the economies of 18 other sophisticated foreign nations demonstrates that housing price booms and busts are not exclusive to the United States.
Usage in 1998: Q1 at the start of the boom and 2006: Q2 is like a breaking point bankruptcy boom, some housing price observations can be made.
In terms of the country, the S&P/Case-Shiller index more than doubled in nominal terms during the boom and then reduced by roughly a third
The index has gained little under 50% in total. However, the FHFA Purchase Index shows substantially smaller gains (83%) and relatively lower drops (18%) during booms.
Nonetheless, the index's total volatility is somewhat less than 50%, which is nearly the same as the S&P/Case-Shiller index.
Objective
The objective of the paper is to find the determinant of housing price utilizing the dataset from kaggle for the period 1919 to 2013.
Data source:
https://www.kaggle.com/datasets/rahulyadav0710/capstone-dataset-hads
Correlations
This correlation table shows that there is a negative correlation between structuretype and rooms, region and rooms, costmed and structure type, region. Overall there is a weak correlation between independent variables
Regression Model
Y = β0+β1x1+ β2x2+ β3xd3+ β4xd4+ β5xd5
Y:house value
x1: Year Built
x2: Number of Rooms
xd3: Structure Type dummy 1 - House, apartment, flat
2  -Mobile home with no permanent room added
3  -Mobile home with permanent room added
4  -HU, in nontransient hotel, motel, etc
5 -HU, in permanent transient hotel, motel, etc
6  -HU, in rooming house
7  -Boat or recreation vehicle
9  -HU, not specified above
xd4: Region dummy
1-Northeast,2-Midwest,3-South and 4-west
x5: Medium Mortgage
Regression output
House value regression model
Y = 71286.01-49.74x1-2531.60 x2-5173.43 xd3+2810.29xd4+ 162.99xd5
One year increase in the year built on an average decreases the value of house by $49.74.
One room increase in the house on an average decreases the value of house by $2531.60.
If the type of house is House, apartment, flat, then the value of house will decreases by $5173.43.
If the house is located in Northeast region the value of house on an average increases $2810.29.
One unit increase in medium mortgage cost on an average increases the value of house by $162.99.
References
Rapach, D. E., & Strauss, J. K. (2009). Differences in housing price forecastability across US states. International Journal of Forecasting, 25(2), 351-372.
Cohen, J. P., Coughlin, C. C., & Lopez, D. A. (2012). The boom and bust of US housing prices from various geographic perspectives. Federal Reserve Bank of St. Louis Review, 94(September/October 2012).
United States Housing Market & Prices | Redfin. (2023.). Retrieved March 28, 2023, from https://www.redfin.com/us-housing-market
Caporal, J. (2023, March 9). Average house price by state in 2022. The Motley Fool. Retrieved March 28, 2023, from https://www.fool.com/the-ascent/research/average-house-price-state/
ROOMSSTRUCTURETYPEREGIONCOSTMED
ROOMS 1
STRUCTURETYPE-0.271651
REGION-0.019570.0518661
COSTMED0.339258-0.08775-0.005831
Data 2013
    CONTROL    AGE1    METRO3    LMED    FMR    IPOV    BEDRMS    BUILT    STATUS    TYPE    VALUE    NUNITS    ROOMS    PER    ZINC2    ZADEQ    ZSMHC    STRUCTURETYPE    OWNRENT    UTILITY    OTHERCOST    COST06    COST12    COST08    REGION    COSTMED    ASSISTED    Age...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here