# CH5-4 PRACTICE.xlsx - Run the polynomial regression model...

• Homework Help
• 98

This preview shows page 1 - 10 out of 98 pages.

The preview shows page 8 - 10 out of 98 pages.
Run the polynomial regression model belowE(PRICE) =+AGE +SQFT +SQFT²β₁β₂β₃b+ bx+ bx+ bx ²₂ ₂₃ ₃₄ ₃Print the regression output below:Print the var/cov matrix below:b1b2b3b4b1b2b3b4Find the predicted price given the following values for the control variables:AGE =10SQFT =2000x*_ijIntercept1AGE10SQFT2000SQFTsq4000000Build an interval estimate for the mean price of house where AGE = 10 and SQFT = 2000y =y* =β₄
(L, U) =x11x210x32000x44000000x4 = x3^2vb1x1^2vb2x2^2vb3x3^2vb4x4^2cb1b22*x1x2cb1b32*x1x3cb1b42*x1x4cb2b32*x2x3cb2b42*x2x4cb3b42*x3x4var(y*) =se(y*) =t_0.025,df =MOE =L =U =Find the marginal effect of SQFT when SQFT = 2000Intercept0AGE0SQFT1SQFTsq4000Build a 95% interval estimate for the marginal effect of SQFT when SQFT = 2000.(L, U) =var(b+ 2bx) =₄ ₃2000x10x20y* ± t/2,dfαse(b+ bx+ bx+ bx ²)₂ ₂₃ ₃₄ ₃var(y*) = var(b+ bx+ bx+ bx²) =₂ ₂₃ ₃₄ ₃SQFT = x∂y/∂x=b+ 2bx₄ ₃∂y/∂x=b+ 2bx₄ ₃b+ 2bx± t₄ ₃/2,dfαse(b+ 2bx )₄ ₃var(b) + (2x)²var(b) + 2(2x)cov(b ,b )x* =
x31x44000 x_4 = 2x_3vb1x1^2vb2x2^2vb3x3^2vb4x4^2cb1b22*x1x2cb1b32*x1x3cb1b42*x1x4cb2b32*x2x3cb2b42*x2x4cb3b42*x3x4var(y*) =se(y*) =t_0.025,df =MOE =L =U =
PRICEAGESQFTSQFTsq899503991784088913895010168428358568700020180032400001650001319003610000210000202000400000010800040105011025008900045105711172497900069549101161245004713501822500135000132134455395610550012131317239691336503716712792241835001812001440000101000451314172659615150010187735231298850038113212814241980002219848312041350001015252325625795002912081459264135050351450210250017500092000400000071000181267160528976000121088118374499250351159134328198500412551575025117500301386192099697000631400196000012500012144220793641150002314772181529145000615662452356820004516002560000160000719853940225850001410221044484102950711001210000155000321200144000088000401008101606410050041368187142410600010150022500001435001315402371600205000341800324000015500027200040000001100003792485377699000811481317904150000112150462250017400059185034225001070003013611852321122500114602131600103000131120125440033000439008100001070004113061705636
14000091650272250097000371414199939612795016147421726766600020756571536133900516802822400162500121820331240020250012217347219291060003413751890625140000111458212576413500011532234702412000040120014400001200006012501562500132000182056422713610990017154023716001085003112501562500970001213011692601134000415372362369139000361876351937616290012218047524004400045600360000870002214312047761141500101500225000011095012148021904006695048909826281160000818233323329120000151932373262495000451099120780190000111180139240016000013187034969009700011135018225001280001213611852321115000351197143280911300071000100000067000221000100000010700071140129960012200040126315951691600003016752805625135000616852839225105000551869349316120850012205042025008500015125015625001250001136018496001155002014001960000178000151700289000099950601100121000015250015136418604961820001121334549689109500101395194602512000031400196000012000013149022201001780001315802496400
8000071109122988175000301137129276913500001370187690012900015153623592968500031993986049113750301084117505617800021184534040252050001520004000000625003082067240064000012321517824103900012061454436775005012551575025135000771718295152414900048170128934011875001119503802500680002020004000000166000120414165681970003186474649697000010531108809223000141900361000095000401000100000023950061900361000012217001360184960015250013159125312811119507617403027600620004011201254400127000612951677025116000201382190992423975021180032400001375001015372362369128409516472712609109950641124126337613750021765311522552000878807744001123500131017161001500001018773523129980004098196236185500401040108160010350031300169000014300012168528392251540001517122930944776004098196236110500011130016900001169500124415475361210009141520022251659951219863944196165000120584235364101500496092160014450041525232562515950038154523870251280003018903572100
170000302000400000089000011201254400116000912441547536115000513001690000138500151814329059611800035110012100001032004012711615441151500491394194323612500010156024336001500001217803168400252500601800324000012100029103210650241030004012001440000139500121865347822512350071059112148112250035140019600001067502906820836112000121438206784414590013165027225001002502936876096979701111261267876134000121486220819676000689809604008100081100121000010700033127816332841220003714772181529136000121870349690051095401003100600915000035160025600006695034960921600127500314081982464124000914332053489136500501525232562512750061400196000012250035145021025001347001515002250000129000715422377764175000151900361000022500091998399200411800091466214915616620016153723623691100001610401081600104000381148131790413250001249156000115100013191136519211089508125115650011150003514832199289176000420204080400112000701270161290011200040101410281961520007020504202500
160000821804752400960003511001210000800000133817902442600001319003610000720002411071225449795005012001440000101500171394194323613747553161025921001420004817002890000220000419503802500110000211410198810014350081500225000013500013157424774761850002320004000000118000213091713481135000101504226201698000409058190251030002111171247689130000014192013561113000301825333062510750029110212144041140001214582125764980004011001210000151000221400196000014750017170028900001470007202040804008095028976952576102000351050110250011500040111812499241090005012281507984149000321403196840912500020170529070251500006219443779136118950614001960000169000211817330148915850013200040000001360003611691366561175250172150462250010650031103210650249550040110012100008200051142130416411500001363185776971000209058190256800046104810983049995063135018225001097000148221963241540001188535532258000043130016900001465008183533672251400001416002560000145000713601849600
6620043775600625100300101235152522512800014148021904008950053941885481126500411001210000102000111125126562598000371175138062510000027120014400001058001813001690000116000111433205348912495013144220793641105002515002250000890007016662775556159000141750306250014900021864347449615800091708291726470000421437

Course Hero member to access this document

Course Hero member to access this document

End of preview. Want to read all 98 pages?