Spreadsheet: 107737d1304888796-many-multiple-regressions-residuals-ef775192-variance-of-residuals
Sheet: Ex 2

 | Other data | X1 | X2 | X3 | X4 | X5 | Y | Var(resid)
 | 32904 | -0.01408171069162923 | 0.01979660873718277 | 0.04022623433827184 | 0.01012834102663338 | 0.01858106602676144 | -0.005183233216535042
 | 32932 | -0.02740725165016138 | 0.0162721035221766 | 0.01851948112927377 | 0.01000475933161834 | 0.008454623381961159 | -0.01940065429034871
 | 32962 | 0.07027350889405512 | -0.04007484387604602 | 0.01278176046512184 | 0.05768237126286343 | 0.01294448166459078 | 0.05665181598514968
 | 32993 | 0.004184508168385021 | 0.02657383987844088 | 0.03945198220022608 | -0.002430064248943604 | 0.04366753408876515 | 0.03499613868229886
 | 33024 | 0.04241571823443328 | -0.001563697480767762 | -0.01947198444374255 | 0.01647087274847315 | 0.007310695654229364 | 0.07204676232355317
 | 33053 | 0.03853699227945162 | 0.003578417740978838 | 0.01171166462315089 | 0.05427425525345025 | 0.02113362820759183 | 0.04204236468773213
 | 33085 | 0.008648537293486526 | -0.005593344685828765 | -0.004027066615658178 | 0.03043982519885906 | 0.01452329286375877 | 0.02098903334711709
 | 33116 | -0.1489255487038164 | 0.01855512720818564 | 0.008623054070531683 | 0.01497837299703941 | -0.02664481132267299 | -0.1414201295536606
 | 33144 | -0.163475859415531 | 0.02925857008178319 | 0.006028788445925665 | 0.01519622723420197 | -0.04478914065117645 | -0.1072322205070415
 | 33177 | 0.04722322972493945 | -0.00855960717165287 | -0.02032665163902238 | -0.004970277069590384 | 0.01693574666224767 | 0.04891211326285735
 | 33207 | -0.02671428086156134 | -0.02246228459460721 | 0.01328398458394645 | 0.00927441561930933 | -0.004592539864903218 | -0.03303043509394809
 | 33238 | -0.0183301745905554 | 0.01204259171761265 | 0.003186283118334945 | 0.00372814000516809 | -0.01406595242871354 | 0.01278311952249372
 | 33269 | -0.005247128552479965 | -0.03382722610143486 | 0.02084960876547231 | -0.00403468880379568 | 0.008890346761769578 | -0.0311557594545284
 | 33297 | 0.1228524860561643 | 0.01540379381795316 | 0.005603019254286495 | -0.04561059463293499 | 0.04888679944333334 | 0.124225216852758 | 0.000118201728275797
 | 33326 | 0.01960552084100169 | 0.02869690925980225 | 0.00916130839385322 | -0.01031392336913443 | 0.005769421507494286 | 0.03937019402864588 | 0.0001265993540391885
 | 33358 | -0.01528765248257016 | 0.01470155544420147 | 0.001960100521492939 | -0.02456464411845022 | -0.04701016765466633 | -0.01412334271072569 | 0.0001351971164039921
 | 33389 | 0.02036778427122512 | -0.02721900888405168 | 0.01909370237554807 | 0.002633131227396564 | -0.01093929027383887 | -0.006233949064700203 | 0.000132565482647948
 | 33417 | -0.04079772547020216 | 0.01339934508075769 | -0.005748928903013786 | 0.007295277871488415 | 0.0005336925262246842 | -0.01482815767067699 | 0.0001090376603291027
 | 33450 | 0.005525209454719775 | -0.02243671441426271 | 0.01232496507925941 | 0.01396378048917596 | 0.00332355474276697 | -0.0003055985189395331 | 0.0001013879326145793
 | 33480 | 0.008964002893038765 | -0.01323950534747307 | 0.01001558553497192 | 0.009165163639424505 | 0.005800741990714916 | 0.001237775756519536 | 8.754242124200774e-05
 | 33511 | -0.03503746974328155 | 0.002424099103587814 | 0.01531396954282273 | 0.02378195974622978 | -0.0279996821394182 | -0.008100915095037926 | 8.754710847432924e-05
 | 33542 | -0.01925156282570413 | -0.00796537609590164 | -0.003862108557288906 | 0.005811034407839564 | -0.02004825058769605 | -0.03612516992863595 | 5.478606176394906e-05
 | 33571 | -0.02898055723778646 | -0.004168223307393474 | -0.00793896046831662 | 0.001357816632021839 | -0.01041508799024109 | -0.007133756813713742 | 7.28385505555679e-05
 | 33603 | -0.01584130674526253 | -0.00568180564599512 | 0.01753792405617828 | 0.00583263323041646 | -0.03247977615195146 | -0.0262214829452674 | 7.546226452406944e-05
 | 33634 | 0.07125986615665632 | -0.02553835513734569 | -0.02504455805989769 | 0.000761529312434478 | 0.05612607879446486 | 0.1031043772130209 | 0.0001014145391615869
 | 33662 | 0.02830348201594794 | -0.01024030791918208 | 0.0004111259940904471 | -0.0005253205298339503 | 0.004303602171909254 | 0.02179974490547603 | 9.644337224414988e-05
 | 33694 | -0.03590970311316894 | 0.02804388375252922 | 0.008979601287415147 | 0.01674775634690695 | -0.02252214693856683 | -0.007170693589000629 | 9.506105665475106e-05
 | 33724 | 0.01133595156136447 | -0.010163860824164 | 0.006069354294523249 | 0.01930376019348758 | 0.02225619427948322 | 0.04235664167176201 | 0.0001091472929878711
 | 33753 | -0.001831076188057753 | 0.005631867862168847 | 0.02485573812824939 | 0.023129046190043 | -0.01104960133256046 | 0.004863621771453445 | 0.000109589316429135
 | 33785 | -0.04713255299601762 | 0.00620404304630736 | -0.03367328089594829 | 0.01831978642669955 | -0.02374805471693172 | -0.03087262613564113 | 9.734294613573072e-05
 | 33816 | -0.07755990421081235 | 0.01438475616764186 | -0.01068371521852265 | 0.03404163716476932 | -0.04062107615940577 | -0.04729871652973352 | 9.749553791318677e-05
 | 33847 | -0.05362958174253311 | 0.01452101700683878 | 0.005179369133410945 | 0.01609293132051823 | -0.02418086669084674 | -0.01855065157859708 | 8.773919459271738e-05
 | 33877 | -0.03425700956402576 | 0.0002771278243497502 | 0.02011213440699264 | 0.0321000865704465 | -0.007787458483623586 | -0.03435166168359898 | 0.0001370047083217316
 | 33907 | 0.01434015155840531 | -0.01333066738076032 | 0.0384607024893089 | -0.02664440162530933 | 0.01651519643071703 | -0.008520567314711283 | 0.0001397598263467047
 | 33938 | 0.02187767796304313 | -0.01654045389930939 | 0.00385808792997842 | 0.003971031473238872 | 0.03346771727444826 | 0.05201389762457477 | 0.0001046807199120315
 | 33969 | 0.01303658210578348 | -0.008904181741919339 | 0.003741819925664544 | 0.004172502286212357 | -0.003898615411197215 | 0.0241078861891836 | 9.836019605561562e-05
 | 33998 | 0.0254009658170814 | -0.007294250515673197 | 0.00311427298876709 | -0.008979185614063679 | 0.05662680040664739 | 0.0444583270241535 | 0.000104949928527972
 | 34026 | 0.07458748359067151 | -0.02874751872855941 | -0.01514045915787739 | -0.006001491533054085 | 0.02870102733496689 | 0.0768304056273082 | 0.0001046926571574245
 | 34059 | -0.007234562218180519 | 0.03483136716671924 | 0.01354131336577351 | -0.003127855109298909 | -0.0313080823952419 | 0.02361295296280116 | 0.0001099430093017274
 | 34089 | -0.02008053913250668 | 0.04935255841601535 | 0.05654210138770155 | -0.001724227913947687 | 0.0001522312169880621 | -0.006307628958110005 | 0.0001109082668573895
 | 34120 | 0.004863798659010079 | 0.011452149239074 | 0.00820202279896708 | -0.0005626408254596777 | 0.00973258869669084 | 0.02893122999514486 | 0.0001112191911201575
 | 34150 | 0.03166600678093982 | -0.03456735288076324 | -0.003418451274552734 | -0.0071701687730732 | -0.00751919527840296 | 0.01502168782970209 | 9.776097164795419e-05
 | 34180 | 0.05200998821014304 | -2.946899625232147e-05 | 0.007317725874865982 | -0.01736106319764372 | 0.00463271379524214 | 0.02663479829997003 | 0.0001557031742330971
 | 34212 | 0.05611000138244865 | 0.03311257827275776 | 0.03902099345532385 | 0.004582974588501806 | 0.03419608194418684 | 0.08089887897466981 | 0.0001156812661954157
 | 34242 | -0.03478254223900854 | 0.007017821976528619 | 0.003009984543147902 | 0.005943385693155504 | -0.03502732990684719 | -0.02356459982036661 | 0.0001048790772408159
 | 34271 | 0.04806763764358096 | -0.003500354489010808 | 0.0005108008477278589 | 0.004225749784821854 | -0.03097062907861619 | 0.04771391867057544 | 0.0001059997629987766
 | 34303 | -0.02140238336552227 | 0.02357551355910591 | 0.000234956854761343 | 0.002360714987794249 | -0.02404920444314871 | 0.03195806404246587 | 8.504525729969291e-05
 | 34334 | 0.0697973806988082 | -0.004058157849822858 | 0.03097714496223104 | -0.0113765802773499 | 0.02384797974788053 | 0.06923910084590384 | 9.434019416340429e-05
 | 34365 | 0.04882378577329001 | 0.04399471675128361 | 0.007025519124291071 | 0.005396953177289693 | 0.06649975191746313 | 0.1433324869026943 | 9.548664042734957e-05
 | 34393 | -0.03658612622237773 | 0.03037092466081185 | 0.01191678227601506 | 0.001250731688228377 | 0.0111489748690134 | 0.003533420717960185 | 0.0001000752212757492
 | 34424 | -0.02755959896104809 | 0.01615248885240796 | 0.01509686240841402 | -0.006209485057512714 | 0.02631941619082565 | -0.02996792361588356 | 0.0001393410309037191
 | 34453 | 0.03753084427293527 | -0.005776131413638565 | 0.0240763804761143 | -0.01566660437035818 | 0.01154384215869068 | 0.02281427492683119 | 0.00014858068887648
 | 34485 | -0.05944335900108948 | 0.04520304092353014 | 0.01656249284553378 | 0.004470191217677603 | -0.01254714120343042 | -0.003912356506374365 | 0.0001537624870174257
 | 34515 | -0.05471036798699896 | 0.01333551239359338 | -0.000331722641931452 | 0.004509206212919378 | -0.01557896365215132 | -0.02664600954592183 | 0.0001538583225920241
 | 34544 | 0.04855453628643713 | -0.03464081187101299 | 0.00396956440287892 | 0.0158240787496889 | -0.004633913196043192 | 0.02626461652344818 | 0.000165543953949744
 | 34577 | 0.006814091218810419 | 0.01114538913556737 | -0.007748502521547346 | 0.003720971640884498 | -0.009959725076794875 | 0.02201647773584727 | 0.0001602112651618415
 | 34607 | -0.05742948536512874 | 0.0230580752677718 | -0.002657144870399974 | -0.001364030575352594 | 0.01019050652469222 | -0.03439619158218639 | 0.0001354920166811744
 | 34638 | -0.002963057732863592 | -0.02171526313994796 | -0.005439157922293499 | -0.003171036020006705 | -0.01993467710948936 | -0.04118203466006138 | 8.143865178044514e-05
 | 34668 | -0.001268377715004636 | -0.0006943057242518209 | 0.0148143686598322 | -0.01194231709912587 | -0.003271886820968749 | 0.005500157353645916 | 0.0001112795444936372
 | 34698 | -0.007364069578874218 | 0.002800654519552255 | -0.005654589134447267 | 0.008987364247748727 | -0.01011339406663361 | 0.003198413693212696 | 9.084314077919222e-05
 | 34730 | -0.02834634469818273 | 0.007165608446396701 | 0.01779715298298402 | 0.02097990497435129 | 0.01117003842554589 | -0.02128162355930484 | 8.460310960326572e-05
 | 34758 | -0.003167856992577914 | 0.001943187468542345 | -0.01307204637934907 | 0.003231599538277958 | -0.0152309785083986 | 0.03401976146838423 | 0.0001181383202241702
 | 34789 | -0.02521159076025152 | -0.0189443169231817 | 0.01258872617491022 | -0.005745899076339524 | -0.007446862763575281 | -0.05754971864394774 | 0.0001008167298128399
 | 34817 | 0.04601842343522648 | -0.02350230450126486 | 0.004882308748297343 | -0.007491476585464847 | 0.01378255319573538 | 0.03227170963294669 | 0.0001114601856669326
 | 34850 | 0.03328963074360115 | -0.0004788701556252342 | 0.003007927659381147 | -0.01344837514233012 | 0.01250486021554803 | 0.04986449481369336 | 0.0001048075275988618
 | 34880 | -0.004981988888359491 | 0.0006323106477589845 | -0.01002828352969248 | -0.0002111168951721347 | -0.02291996224882004 | -0.002998915823569911 | 0.0001012958563513526
 | 34911 | 0.0441963714584946 | -0.02808155261742178 | -0.003576743978682323 | 0.00195370397545467 | 0.005281369787063596 | 0.02921991925736277 | 0.000102343548907286
 | 34942 | -0.009352536922456191 | 0.02355714329199715 | -0.008959744592115664 | 0.008846445327539861 | -0.00106148951213593 | 0.03365699462693581 | 7.957940059585955e-05
 | 34971 | -0.02291997874944459 | 0.01740972875449624 | -0.01137604423076718 | 0.02964899477888424 | -0.0106387808765976 | 0.03947802041221073 | 0.0001162745051494639
 | 35003 | -0.02231191113093461 | -0.007693417912543347 | 0.009175146009114874 | 0.02814063931430638 | -0.02799741115295758 | -0.02730801276121773 | 8.91249348088227e-05
 | 35033 | 0.01077134152756874 | -0.02467789803836438 | 0.005700416268383756 | 0.004963415355719021 | -0.01351642870577447 | -0.02081203328247851 | 8.939017416991991e-05
 | 35062 | 0.01877588101329571 | -0.00897567187304059 | 0.01366132444750516 | 0.0009765452548156622 | -0.01050909036812992 | -0.01246162405123537 | 9.711787182116978e-05
 | 35095 | 0.06475806961162714 | -0.00285031357042477 | -0.000305870797189689 | 0.009490146481370726 | 0.0001698985720613305 | 0.08184422327628747 | 6.1023376977394e-05
 | 35124 | -0.0005180727857072632 | 0.0385070076232555 | 0.007261398602649542 | 0.03039499272872309 | 0.01422911907662316 | 0.07485181236851246 | 5.521305033140174e-05
 | 35153 | 0.009113040396180796 | 0.01659487769088444 | 0.0001837597100029231 | 0.01924870791083077 | -0.006778684386379878 | 0.03137219431005217 | 6.31851713643277e-05
 | 35185 | 0.02604708987763595 | -0.004804503129949487 | -0.0006603940135090636 | -0.01939543530613987 | -0.01653850230599564 | 0.02709229848737053 | 6.754513110130764e-05
 | 35216 | 0.01486626611894375 | 0.01566790473992703 | -0.004654018841959196 | 0.01461746451529877 | 0.003471190727529907 | 0.05010523328905633 | 7.28854375673672e-05
 | 35244 | 0.01001377881375583 | 0.0004358120244726225 | -0.01657570820999931 | 0.01192802773077474 | -0.004259312302213148 | 0.01180843419924244 | 0.0001188276538576041
 | 35277 | -0.05228215994042085 | 0.01177959726109958 | -0.002495625179497023 | -0.002721448852537146 | -0.03154279905595396 | -0.05123441234012345 | 0.0001113781606024675
 | 35307 | 0.01464662867016036 | 0.001029481752755187 | 0.006852427619162568 | 0.01021225265754438 | -0.009139964430342996 | 0.01029769372167672 | 0.0001172914030499201
 | 35338 | 0.03902687856790327 | -0.0262421698478931 | -0.002516477961960539 | 0.02222092245044006 | 0.00782780792794642 | 0.03766552734231493 | 0.0001172645546512225
 | 35369 | -0.002107586537890772 | 0.01742979518472944 | -0.002466760022116781 | 0.03432127383110031 | -0.006368279239510026 | 0.01719526332056663 | 0.0001567812702203631
 | 35398 | 0.05711822080622059 | -0.00992641923542438 | 0.01488418489747392 | 0.01181212157986512 | 0.01036477270541291 | 0.05930479767248608 | 9.744051506472717e-05
 | 35430 | 0.02027192047606731 | 0.002574252655039962 | 0.01312882152035022 | 0.01437422339514535 | 0.000988782656828554 | 0.03291506013446178 | 6.220904579425397e-05
 | 35461 | 0.08676362781072379 | 0.007934817545611123 | 0.04151839035070315 | -0.007641488951005873 | 0.04747899634947549 | 0.1135725154380847 | 8.068871172214034e-05
 | 35489 | 0.05275130615837036 | -0.008983821503588507 | 0.002185468543442273 | -0.01257333784574952 | -0.006247094914947446 | 0.05985485980466348 | 6.776116773817917e-05
 | 35520 | 0.01330835284301471 | 0.01033445746625884 | -0.008443254592220333 | -0.0005756109977431492 | 0.00298530412406087 | 0.03389426450319275 | 6.95434898321148e-05
 | 35550 | 0.01652480876451838 | -0.003251500797813991 | 0.02985017497487335 | 0.02273572646048566 | 0.002022242653453892 | 0.04793091381194296 | 6.95590461099212e-05
 | 35580 | 0.0255295712719226 | 0.02412464961001461 | -0.006837640067425634 | 0.01935716679599116 | -0.0192766088083952 | 0.03948363087314143 | 7.096478026178508e-05
 | 35611 | 0.06065649719869814 | -0.002841999074015195 | -0.03641608940868414 | 0.006985540938851079 | -0.01111597497113485 | 0.07839293970634673 | 8.49496047885076e-05
 | 35642 | 0.09605799712271203 | -0.04167768084282409 | 0.04144776006790866 | 0.03025629857330508 | 0.009785751489074984 | 0.06801485076975028 | 8.988845678760562e-05
 | 35671 | -0.07806602072116256 | 0.04532093043337765 | -0.007347767554349786 | -0.03518354426170989 | 0.02177490952928204 | -0.03343241848910243 | 8.353694849985099e-05
 | 35703 | 0.08067099053673915 | -0.03314414549613855 | 0.03810276410727138 | 0.02502722603848497 | 0.03436075477232889 | 0.06708258930310791 | 8.706629180394086e-05
 | 35734 | -0.08971465866227447 | 0.04220033553902221 | 0.01089758379888064 | -0.02101009266144313 | -0.01231701579112573 | -0.07579623457608561 | 9.561923433330887e-05
 | 35762 | 0.0237760090146432 | -0.02776597289414479 | -0.009421332922630995 | -0.000890632555911236 | -0.01242089236026848 | 0.003264344422087336 | 9.964199499580594e-05
 | 35795 | 0.04273349948108679 | -0.02651364836413102 | 0.03041187010465516 | 0.0133764488174884 | -0.005635934132500083 | 0.01756823176754285 | 0.0001010997389464604
 | 35825 | 0.04869770121870202 | 0.02743618645881216 | 0.01573641443158906 | 0.01012267439429823 | 0.007840855375383995 | 0.09408305890294247 | 0.0001068407227146945
 | 35853 | 0.074830786484061 | 0.002757950195876074 | 0.004507994909723756 | 0.02743149888859286 | -0.00270511146948603 | 0.09187954740561134 | 0.0001073129469093389
 | 35885 | 0.1185904265259036 | 0.005861670429898297 | 0.05033533154848921 | 0.009245126284169958 | 0.05139302060356693 | 0.1645513888451798 | 0.0001051002612001926
 | 35915 | 0.08670475491563646 | -0.01436961800525478 | -0.03737067260688778 | -0.0491993907104178 | 0.08276662127977788 | 0.1410692880671335 | 9.95300437737458e-05
 | 35944 | 0.06308325648364184 | -0.01523694955762155 | -0.007237726181930658 | 0.004716857907326316 | 0.01797488674243029 | 0.06549534197147601 | 0.0001065525321431186
 | 35976 | 0.02032896169807659 | -0.0387038434369512 | -0.01906423948171584 | 0.004504332374674395 | -0.01457174651326981 | -0.04214778625256885 | 4.260834924725238e-05
 | 36007 | 0.04197033462699511 | -0.02530560138417465 | 0.01136199212101149 | 0.0561866819712007 | 0.02616785064368034 | 0.0428616422211596 | 4.872834257868755e-05
 | 36038 | -0.1856409683265096 | 0.05690836382266232 | 0.002637262784436101 | -0.011305442173111 | -0.05800733708666672 | -0.1341961027107313 | 0.000175542659701873
 | 36068 | -0.08488453413502005 | 0.006398155940436898 | -0.03757306975774351 | -0.006657200399994442 | -0.04376185717737972 | -0.0955637759282723 | 0.0001732302962955966
 | 36098 | 0.06400403781031502 | -0.03321200503013511 | 0.0002703828122617782 | -0.007342507370164952 | 0.03971376548159194 | 0.03684059252807755 | 0.000164379393843263
 | 36129 | 0.1098130705024344 | -0.03425733932881529 | 0.001454076601446128 | 0.03626395625573971 | 0.07495744145155732 | 0.1069090162189918 | 0.0001815097917855033
 | 36160 | 0.04097371791571685 | -0.02939728075194639 | -0.0004509502538383118 | 0.03397295114725569 | -0.01454288782161404 | -0.003459457885405482 | 8.474225196973662e-05
 | 36189 | 0.05948394875820416 | -0.03202721049802452 | -0.01778597502316942 | 0.05068544884932474 | 0.02924427489460087 | 0.07309578132093397 | 0.0001075457158730213
 | 36217 | 0.01359743363884911 | 0.02880197081259571 | -0.005380030582196695 | 0.01027251896410238 | 0.01339016873631335 | 0.04612247380548697 | 0.0001504134387772899
 | 36250 | 0.02786225214881469 | -0.04211547860724232 | 0.02124648637771861 | -0.03829895203018326 | 0.0003688905439493372 | -0.02046665580634761 | 0.0001597202508173025
 | 36280 | 0.02801047061761386 | 0.0009798266035944067 | 0.01862495322182749 | -0.04691379244379663 | 0.01824270098550283 | 0.01055185053757431 | 0.0001932844668128281
 | 36311 | -0.01785885777437501 | 0.03949846895318238 | -0.01183943146044118 | 0.008284167116623475 | 0.0008323318292509335 | 0.0573534166047198 | 0.0001790369627560251
 | 36341 | 0.03097113051779403 | -0.002865936991274076 | 0.008840980116255386 | 0.01546417740425228 | 0.02540668844509295 | 0.08012545768662648 | 0.0002204304378530788
 | 36371 | -0.01754853282554846 | 0.01976475822945504 | 0.01660108926149743 | 0.03198534483783934 | 0.01084302303251408 | 0.05698247500389349 | 0.0002354526251210239
 | 36403 | 0.04380051818403579 | 0.01901163299325267 | -0.00676252167691424 | 0.03114604109231734 | 0.04089821317988415 | 0.1654739705574969 | 0.0004307801149811634
 | 36433 | -0.0008649821937860148 | 0.004004789769281013 | -0.002121419536310454 | 0.0124551373896546 | -0.006858929326606015 | -0.001850114028093482 | 0.0004232913633573422
 | 36462 | 0.003473994040416001 | 0.01273473740254582 | -0.02228448705764264 | 0.001564888398014089 | -0.0111165019597895 | 0.04033448417883208 | 0.0004349987306526322
 | 36494 | 0.05428693037640384 | -0.01207100242524205 | -0.01780113644727804 | 0.05295207671446507 | 0.005964554955981194 | 0.109383038820656 | 0.0005067527031012094
 | 36525 | 0.1082199589858338 | -0.04719191305813264 | -0.001051332591804094 | 0.02202505700348731 | 0.02991708767734988 | 0.03321527171363655 | 0.000546942322067985