Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Plan1 Lista de Exercícios 6 - Análise de Regressão Exercício 1 Ano/X Produção/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 1986 285 -4 14.4444444444 16 208.6419753086 -57.7777777778 0.9111111111 0.8301234568 3944196 2 1987 270 -3 -0.5555555556 9 0.3086419753 1.6666666667 -10.7055555556 114.6089197531 3948169 3 1988 294 -2 23.4444444444 4 549.6419753086 -46.8888888889 16.6777777778 278.1482716049 3952144 4 1989 279 -1 8.4444444444 1 71.3086419753 -8.4444444444 5.0611111111 25.614845679 3956121 5 1990 260 0 -10.5555555556 0 111.4197530864 0 -10.5555555556 111.4197530864 3960100 6 1991 262 1 -8.5555555556 1 73.1975308642 -8.5555555556 -5.1722222222 26.7518827161 3964081 7 1992 258 2 -12.5555555556 4 157.6419753086 -25.1111111111 -5.7888888889 33.5112345679 3968064 8 1993 272 3 1.4444444444 9 2.0864197531 4.3333333333 11.5944444444 134.4311419753 3972049 9 1994 255 4 -15.5555555556 16 241.975308642 -62.2222222222 -2.0222222222 4.089382716 3976036 SOMA/MEDIA: 1990 270.5555555556 0 0 60 1416.2222222222 -203 0 729.4055555556 35640960 Sx² 6.6666666667 Beta2-erro 1.3178315121 VarBeta2 1.7366798942 Sy² 157.3580246914 Beta1-erro 2622.4869164226 VarBeta1 6877437.626807825 COV(X,Y) -22.5555555556 Sigma² 104.2007936508 tbeta1 2.6705143294 B2 -3.3833333333 Sigma 10.2078789986 tbeta2 -2.5673489383 B1 7003.3888888889 r² 0.4849639102 F 6.5912805709 Valor de Previsão r 0.6963935024 Valor de X 1996 Previsão alpha 0.05 Ycalc 250.2555555556 Var: 115.7787648625 t-student 2.3646242509 IC - LimINFERIOR 224.8120706202 IC - LimSUPERIOR 275.6990404909 Desvio 25.4434849353 Lista de Exercícios 6 - Análise de Regressão Exercício 1 Ano/X* Prod./Y* x*i=X*i-X*m y*i=Y*i-Y*m x*i² y*i² x*i*y*i e*i e*i² X*i² 1 1986 5.6524891803 -4 0.053072067 16 0.0028166443 -0.2122882679 0.0032807429 0.0000107633 3944196 2 1987 5.598421959 -3 -0.0009951543 9 0.0000009903 0.0029854629 -0.0383386474 0.0014698519 3948169 3 1988 5.6835797673 -2 0.0841626541 4 0.0070833523 -0.1683253081 0.059266992 0.0035125763 3952144 4 1989 5.6312117818 -1 0.0317946685 1 0.0010109009 -0.0317946685 0.0193468375 0.0003743001 3956121 5 1990 5.560681631 0 -0.0387354823 0 0.0015004376 0 -0.0387354823 0.0015004376 3960100 6 1991 5.5683445038 1 -0.0310726095 1 0.0009655071 -0.0310726095 -0.0186247785 0.0003468824 3964081 7 1992 5.5529595849 2 -0.0464575284 4 0.0021583019 -0.0929150567 -0.0215618663 0.0004649141 3968064 8 1993 5.6058020663 3 0.006384953 9 0.0000407676 0.019154859 0.0437284461 0.001912177 3972049 9 1994 5.5412635452 4 -0.0581535681 16 0.0033818375 -0.2326142725 -0.008362244 0.0000699271 3976036 SOMA/MEDIA: 1990 5.5994171133 0 -0 60 0.0189587396 -0.7468698614 0 0.0096618298 35640960 Sx²* 6.6666666667 Beta2-erro 0.0047962857 VarBeta2 0.0000230044 Sy²* 0.0021065266 Beta1-erro 9.5446165984 VarBeta1 91.0997060113 COV(X*,Y*) -0.0829855402 Sigma² 0.0013802614 tbeta1 3.1819613222 B2* -0.012447831 Sigma 0.0371518694 tbeta2 -2.5953064047 B1* 30.3706008511 r² 0.4903759439 F 6.7356153343 B2 0.9876293228 r 0.7002684799 Valor de X 1996 B1 15480477829108.242 alpha 0.05 Ycalc 5.5247301271 Valor de Previsão t-student 2.3646242509 Previsão Var: 0.0015336252 IC - LimINFERIOR 5.4321278315 IC - LimSUPERIOR 5.6173324227 Exercício 2 IPOF/X IPAC/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 108.8 112.2 -21.5 -21.2 462.25 449.44 455.8 -0.2336262381 0.0545812191 11837.44 2 119.7 123.5 -10.6 -9.9 112.36 98.01 104.94 0.4369098547 0.1908902211 14328.09 3 128 131 -2.3 -2.4 5.29 5.76 5.52 -0.1570855976 0.024675885 16384 4 135.8 138.6 5.5 5.2 30.25 27.04 28.6 -0.1634909623 0.0267292948 18441.64 5 142.5 145.7 12.2 12.3 148.84 151.29 150.06 0.4028018653 0.1622493427 20306.25 6 147 149.4 16.7 16 278.89 256 267.2 -0.285508922 0.0815153446 21609 SOMA/MEDIA: 130.3 133.4 0 -0 1037.88 987.54 1012.12 -0 0.5406413073 102906.42 Sx² 172.98 Beta2-erro 0.0114117184 VarBeta2 0.0001302273 Sy² 164.59 Beta1-erro 1.4945025306 VarBeta1 2.2335378141 COV(X,Y) 168.6866666667 Sigma² 0.1351603268 tbeta1 4.2382151059 B2 0.975180175 Sigma 0.3676415738 tbeta2 85.4542798564 B1 6.3340232011 r² 0.9994525373 F 7302.4339457746 Valor de Previsão r 0.9997262312 Valor de X Previsão alpha 0.05 Ycalc 6.3340232011 Var: 0.172477665 t-student 2.776445105 IC - LimINFERIOR 5.1809535989 IC - LimSUPERIOR 275.6990404909 4.2382151058601432 Desvio 25.4434849353 85.45427985639239 Exercício 3 Trimestre/X Vendas/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 1 1206 -4.5 -56881.6 20.25 3235516418.56 255967.2 -7041.8909090909 49588227.57553704 1 2 2 11356 -3.5 -46731.6 12.25 2183842438.56 163560.6 -7967.3818181818 63479173.03669408 4 3 3 36888 -2.5 -21199.6 6.25 449423040.15999997 52999 6489.1272727273 42108772.761653 9 4 4 39636 -1.5 -18451.6 2.25 340461542.55999994 27677.4 -1838.3636363636 3379580.8595041176 16 5 5 53887 -0.5 -4200.6 0.25 17645040.35999999 2100.3 1337.1454545455 1787957.96661157 25 6 6 77806 0.5 19718.4 0.25 388815298.56000006 9859.2 14180.6545454545 201090963.33752054 36 7 7 91627 1.5 33539.4 2.25 1124891352.3600001 50309.1 16926.1636363636 286495015.44495815 49 8 8 80147 2.5 22059.4 6.25 486617128.3600001 55148.5 -5629.3272727273 31689325.543471213 64 9 9 86646 3.5 28558.4 12.25 815582210.5600001 99954.4 -10205.8181818182 104158724.76033077 81 10 10 101677 4.5 43589.4 20.25 1900035792.3600001 196152.3 -6250.3090909091 39066363.73190109 100 SOMA/MEDIA: 5.5 58087.6 0 0 82.5 10942830262.400002 913728.0000000001 -0 822844105.0181814 385 Sx² 8.25 Beta2-erro 1116.5722065553 VarBeta2 1246733.49245179 Sy² 1094283026.2400002 Beta1-erro 8944.2010505312 VarBeta1 79998732.4323232 COV(X,Y) 91372.8 Sigma² 102855513.12727268 tbeta1 -0.3161377952 B2 11075.4909090909 Sigma 10141.7707096578 tbeta2 9.9191891434 B1 -2827.6 r² 0.9248051843 F 98.3903132626 Valor de Previsão r 0.9616679179 Valor de X 12 alpha 0.05 Ycalc 130078.2909090909 t-student 2.3060041333 Previsão Previsão Média Previsão Pontual 4644.6681301285525 11154.750340832579 Var 21572942.039031867 Var 124428455.16630456 Intervalo de Confiança Lim Inferior 119367.6670032118 Lim Inferior 104355.3905172113 Lim Superior 140788.91481497 Lim Superior 155801.1913009706 Exercício 4 Volume/X Tempo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 20.39 10.8 -5.9477777778 -4.0666666667 35.3760604938 16.5377777778 24.1876296296 -0.8589803924 0.7378473145 415.7521 2 24.92 14.4 -1.4177777778 -0.4666666667 2.0100938272 0.2177777778 0.6616296296 0.2979527404 0.0887758355 621.0064 3 34.84 19.6 8.5022222222 4.7333333333 72.287782716 22.4044444444 40.2438518519 0.148013817 0.02190809 1213.8256 4 31.72 18 5.3822222222 3.1333333333 28.9683160494 9.8177777778 16.8642962963 0.2306558977 0.0532021432 1006.1584 5 13.59 8.4 -12.7477777778 -6.4666666667 162.5058382716 41.8177777778 82.4356296296 0.4083164503 0.1667223236 184.6881 6 30.87 15.2 4.5322222222 0.3333333333 20.5410382716 0.1111111111 1.5107407407 -2.1109319969 4.4560338957 952.9569 7 17.84 11 -8.4977777778 -3.8666666667 72.2122271605 14.9511111111 32.8580740741 0.7162559236 0.5130225481 318.2656 8 23.22 13.3 -3.1177777778 -1.5666666667 9.7205382716 2.4544444444 4.8845185185 0.1147769511 0.0131737485 539.1684 9 39.65 23.1 13.3122222222 8.2333333333 177.2152604938 67.7877777778 109.603962963 1.0539406092 1.1107908077 1572.1225 SOMA/MEDIA: 26.3377777778 14.8666666667 -0 0 580.8371555556 176.1 313.2503333333 0 7.1614767067 6823.944 Sx² 64.5374617284 Beta2-erro 0.0419686575 VarBeta2 0.0017613682 Sy² 19.5666666667 Beta1-erro 1.1556372955 VarBeta1 1.3354975587 COV(X,Y) 34.8055925926 Sigma² 1.023068101 tbeta1 0.5732620006 B2 0.5393083592 Sigma 1.0114682896 tbeta2 12.8502647382 B1 0.662482948 r² 0.9593328977 F 165.1293038416 r 0.9794554088 Valor de X alpha 0.05 Ycalc 0.662482948 t-student 2.3646242509 Previsão Previsão Média Previsão Pontual 0.45420851518746802 1.1087711559307247 Var 0.2063053753 Var 1.2293734762 Intervalo de Confiança Lim Inferior -0.411549522 Lim Inferior -1.9593442161 Lim Superior 1.736515418 Lim Superior 3.2843101121 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 168.9385232933 1 168.9385232933 165.1293038416 INDIVIDUAL 7.1614767067 7 1.023068101 TOTAL 176.1 8 5.5914478481776282 2.1009220368611805 0.10348117197761143 1.7151515151515153 Ex 6 Exercício 6 10 Volume/X Tempo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 1 30 -4.5 13 20.25 169 -58.5 0.5090909091 0.2591735537 1 2 2 28 -3.5 11 12.25 121 -38.5 1.2848484848 1.650835629 4 3 3 24 -2.5 7 6.25 49 -17.5 0.0606060606 0.0036730946 9 4 4 20 -1.5 3 2.25 9 -4.5 -1.1636363636 1.3540495868 16 5 5 18 -0.5 1 0.25 1 -0.5 -0.3878787879 0.1504499541 25 6 6 14 0.5 -3 0.25 9 -1.5 -1.6121212121 2.5989348026 36 7 7 13 1.5 -4 2.25 16 -6 0.1636363636 0.0267768595 49 8 8 10 2.5 -7 6.25 49 -17.5 -0.0606060606 0.0036730946 64 9 9 7 3.5 -10 12.25 100 -35 -0.2848484848 0.0811386593 81 10 10 6 4.5 -11 20.25 121 -49.5 1.4909090909 2.2228099174 100 SOMA/MEDIA: 5.5 17 0 0 82.5 644 -229 -0 8.3515151515 385 Sx² 8.25 Beta2-erro 0.1124891587 VarBeta2 0.0126538108 Sy² 64.4 Beta1-erro 0.6979768744 VarBeta1 0.4871717172 COV(X,Y) -22.9 Sigma² 1.0439393939 tbeta1 46.2288477612 B2 -2.7757575758 Sigma 1.0217335239 tbeta2 -24.6757785966 B1 32.2666666667 r² 0.9870318088 F 608.8940493469 N 10 r 0.9934947452 Valor de X 5 -0.99349474521556425 alpha 0.05 Ycalc 18.3878787879 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.1050718221 Var 1.1490112161 SE(Y) 0.3241478399 SE(Y) 1.0719194074 Lim Inferior 17.6403925293 Lim Inferior 15.9160282037 Lim Superior 19.1353650465 Lim Superior 20.859729372 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 635.6484848485 1 635.6484848485 608.8940493469 INDIVIDUAL 8.3515151515 8 1.0439393939 TOTAL 644 9 Ex7 Exercício 7 7 Pluv/X Colheita/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 17.8 520 -77.89 263.5714285714 6066.8521 69469.8979591837 -20529.5785714286 112.9535200368 12758.4976886952 316.84 2 158.58 190 62.89 -66.4285714286 3955.1521 4412.7551020408 -4177.6928571429 55.1834489559 3045.2130386666 25147.6164 3 118.65 208 22.96 -48.4285714286 527.1616 2345.3265306122 -1111.92 -4.0302253 16.2427159686 14077.8225 4 114.8 213 19.11 -43.4285714286 365.1921 1886.0408163265 -829.92 -6.4750699252 41.9265305363 13179.04 5 21.7 310 -73.99 53.5714285714 5474.5201 2869.8979591837 -3963.75 -89.5049490442 8011.1359034018 470.89 6 127.15 194 31.46 -62.4285714286 989.7316 3897.3265306122 -1964.0028571429 -1.5935553482 2.5394186478 16167.1225 7 111.15 160 15.46 -96.4285714286 239.0116 9298.4693877551 -1490.7857142857 -66.5331693751 4426.662627094 12354.3225 SOMA/MEDIA: 95.69 256.4285714286 -0 -0 17617.6212 94179.7142857143 -34067.65 -0 28302.2179230101 81713.6539 Sx² 2516.8030285714 Beta2-erro 0.5668283967 VarBeta2 0.3212944313 Sy² 13454.2448979592 Beta1-erro 61.24207466 VarBeta1 3750.5917086553 COV(X,Y) -4866.8071428571 Sigma² 5660.443584602 tbeta1 7.2085539724 B2 -1.9337258767 Sigma 75.2359195106 tbeta2 -3.4114837716 B1 441.4668005682 r² 0.6994871121 F 11.6382215242 N 7 r 0.8363534612 Valor de X 5 alpha 0.05 Ycalc 431.7981711848 t-student 2.5705818347 Ftab 6.6078909689 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 1135.7816403427 Var 6796.2252249447 SE(Y) 33.7013596216 SE(Y) 82.4392213994 Lim Inferior 345.1660683369 Lim Inferior 219.8814061888 Lim Superior 518.4302740326 Lim Superior 643.7149361807 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 65877.4963627042 1 65877.4963627042 11.6382215242 INDIVIDUAL 28302.2179230101 5 5660.443584602 TOTAL 94179.7142857143 6 Ex 8 Exercício 7 10 Prop/X Vendas/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 2 20 -9 -28.6 81 817.96 257.4 -7.5454545455 56.9338842975 4 2 4 28 -7 -20.6 49 424.36 144.2 -4.2242424242 17.8442240588 16 3 6 35 -5 -13.6 25 184.96 68 -1.903030303 3.6215243343 36 4 8 48 -3 -0.6 9 0.36 1.8 6.4181818182 41.1930578512 64 5 10 54 -1 5.4 1 29.16 -5.4 7.7393939394 59.8982185491 100 6 12 58 1 9.4 1 88.36 9.4 7.0606060606 49.8521579431 144 7 14 60 3 11.4 9 129.96 34.2 4.3818181818 19.2003305785 196 8 16 61 5 12.4 25 153.76 62 0.703030303 0.494251607 256 9 18 60 7 11.4 49 129.96 79.8 -4.9757575758 24.7581634527 324 10 20 62 9 13.4 81 179.56 120.6 -7.6545454545 58.5920661157 400 SOMA/MEDIA: 11 48.6 0 -0 330 2138.4 772 0 332.3878787879 1540 Sx² 33 Beta2-erro 0.3548302405 VarBeta2 0.1259044995 Sy² 213.84 Beta1-erro 4.4033274838 VarBeta1 19.3892929293 COV(X,Y) 77.2 Sigma² 41.5484848485 tbeta1 5.1930424778 B2 2.3393939394 Sigma 6.4458114189 tbeta2 6.5929948259 B1 22.8666666667 r² 0.8445623462 F 43.4675807746 N 10 r 0.9190007325 Valor de X 50 alpha 0.05 Ycalc 139.8363636364 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 45.1907221566 Var 86.7392070051 SE(Y) 6.7224044922 SE(Y) 9.3133885888 21.47671258068544 Lim Inferior 124.3344710917 Lim Inferior 118.3596510557 Lim Superior 155.3382561811 Lim Superior 161.313076217 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 1806.0121212121 1 1806.0121212121 43.4675807746 INDIVIDUAL 332.3878787879 8 41.5484848485 TOTAL 2138.4 9 Ex 9 Exercício 9 10 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 14.83 1242.5 1.061 -134.68 1.125721 18138.7024 -142.89548 -200.4266144769 40170.8277906609 219.9289 2 13.54 1247.4 -0.229 -129.78 0.052441 16842.8484 29.71962 -115.5896374032 13360.9642750034 183.3316 3 12.74 1262.1 -1.029 -115.08 1.058841 13243.4064 118.41732 -51.3163182877 2633.3645226092 162.3076 4 13.04 1292.3 -0.729 -84.88 0.531441 7204.6144 61.87752 -39.706312956 1576.5912885631 170.0416 5 12.73 1357.9 -1.039 -19.28 1.079521 371.7184 20.03192 45.1033482012 2034.3120189585 162.0529 6 13.4 1402.5 -0.369 25.32 0.136161 641.1024 -9.34308 48.185693442 2321.8610524868 179.56 7 13.46 1443.3 -0.309 66.12 0.095481 4371.8544 -20.43108 85.2676945083 7270.5797267684 181.1716 8 13.96 1464.7 0.191 87.52 0.036481 7659.7504 16.71632 75.6843700612 5728.1238715584 194.8816 9 14.67 1519.2 0.901 142.02 0.811801 20169.6804 127.96002 86.1880493462 7428.3798501062 215.2089 10 15.32 1539.9 1.551 162.72 2.405601 26477.7984 252.37872 66.6097275649 4436.8558062717 234.7024 SOMA/MEDIA: 13.769 1377.18 -0 -0 7.33349 115121.476 454.4318 0 86961.8602029866 1903.1871 Sx² 0.733349 Beta2-erro 38.5002956942 VarBeta2 1482.2727685418 Sy² 11512.1476 Beta1-erro 531.1348615719 VarBeta1 282104.2411769966 COV(X,Y) 45.44318 Sigma² 10870.2325253733 tbeta1 0.9864937312 B2 61.9666488943 Sigma 104.2604072761 tbeta2 1.6095109863 B1 523.9612113741 r² 0.2446078419 F 2.5905256149 N 10 r 0.4945784486 Valor de X alpha 0.05 Ycalc 523.9612113741 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 2169.8579131321 Var 13040.0904385054 SE(Y) 46.5817336853 SE(Y) 114.1932153786 263.33002665778912 Lim Inferior 416.5435409595 Lim Inferior 260.6311847163 Lim Superior 631.3788817888 Lim Superior 787.2912380319 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 28159.6157970135 1 28159.6157970135 2.5905256149 INDIVIDUAL 86961.8602029866 8 10870.2325253733 TOTAL 115121.476 9 Ex9 Exercício 9 - Exponencial 10 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² Tabela Auxiliar 1 2.6966521561 7.124880758 0.0761354634 -0.099881236 0.0057966088 0.0099762613 -0.0076045042 -0.14573194 0.0212377983 7.2719328513 14.83 1242.5 2 2.6056482675 7.1288166641 -0.0148684253 -0.0959453298 0.0002210701 0.0092055063 0.001426556 -0.0869911876 0.0075674667 6.7894028938 13.54 1247.4 3 2.5447466501 7.1405322793 -0.0757700426 -0.0842297147 0.0057410994 0.0070946448 0.0063820891 -0.0385990763 0.0014898887 6.4757355134 12.74 1262.1 4 2.5680215565 7.1641788555 -0.0524951363 -0.0605831384 0.0027557393 0.0036703167 0.0031803201 -0.028969238 0.0008392167 6.5947347146 13.04 1292.3 5 2.5439614126 7.2136946677 -0.0765552802 -0.0110673262 0.0058607109 0.0001224857 0.0008472623 0.0350362021 0.0012275355 6.4717396686 12.73 1357.9 6 2.595254707 7.2460116374 -0.0252619858 0.0212496435 0.0006381679 0.0004515473 -0.0005368082 0.036463051 0.0013295541 6.735346994 13.4 1402.5 7 2.5997223242 7.2746874374 -0.0207943686 0.0499254434 0.0004324058 0.0024925499 -0.0010381681 0.0624483388 0.003899795 6.758556163 13.46 1443.3 8 2.6361960973 7.2894057223 0.0156794046 0.0646437284 0.0002458437 0.0041788116 0.0010135752 0.0552011939 0.0030471718 6.9495298636 13.96 1464.7 9 2.6858045922 7.3259391595 0.0652878994 0.1011771656 0.0042625098 0.0102368188 0.0066056446 0.0618591393 0.0038265531 7.2135463072 14.67 1519.2 10 2.7291591643 7.3394727582 0.1086424715 0.1147107643 0.0118031866 0.0131585594 0.0124624609 0.0492835168 0.002428865 7.4483097442 15.32 1539.9 SOMA/MEDIA: 2.6205166928 7.2247619939 0 0 0.0377573423 0.060587502 0.0227384277 0 0.046893845 68.7088347138 Sx² 0.0037757342 Beta2-erro 0.3940145138 VarBeta2 0.1552474371 Sy² 0.0060587502 Beta1-erro 1.0328054267 VarBeta1 1.0666870493 COV(X,Y) 0.0022738428 Sigma² 0.0058617306 tbeta1 5.4672645359 B2 0.6022253232 Sigma 0.0765619398 tbeta2 1.528434365 B1 5.6466204817 r² 0.2260145495 F 2.3361116083 N 10 r 0.4754098752 Valor de X alpha 0.05 Ycalc 5.6466204817 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.001172024 Var 0.0070337546 SE(Y) 0.0342348362 SE(Y) 0.0838674826 0.19339876146367874 Lim Inferior 5.567674808 Lim Inferior 5.4532217202 Lim Superior 5.7255661554 Lim Superior 5.8400192432 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 0.013693657 1 0.013693657 2.3361116083 INDIVIDUAL 0.046893845 8 0.0058617306 TOTAL 0.060587502 9 Ex9_ Exercício 9 - Exponencial 10 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² Tabela Auxiliar 1 14.83 7.124880758 1.061 -0.099881236 1.125721 0.0099762613 -0.1059739914 -0.1456705801 0.0212199179 219.9289 14.83 1242.5 2 13.54 7.1288166641 -0.229 -0.0959453298 0.052441 0.0092055063 0.0219714805 -0.0860624271 0.0074067414 183.3316 13.54 1247.4 3 12.74 7.1405322793 -1.029 -0.0842297147 1.058841 0.0070946448 0.0866723764 -0.0398213875 0.0015857429 162.3076 12.74 1262.1 4 13.04 7.1641788555 -0.729 -0.0605831384 0.531441 0.0036703167 0.0441651079 -0.0291218454 0.0008480819 170.0416 13.04 1292.3 5 12.73 7.2136946677 -1.039 -0.0110673262 1.079521 0.0001224857 0.011498952 0.0337725688 0.0011405864 162.0529 12.73 1357.9 6 13.4 7.2460116374 -0.369 0.0212496435 0.136161 0.0004515473 -0.0078411184 0.0371744955 0.0013819431 179.56 13.4 1402.5 7 13.46 7.2746874374 -0.309 0.0499254434 0.095481 0.0024925499 -0.015426962 0.0632608886 0.00400194 181.1716 13.46 1443.3 8 13.96 7.2894057223 0.191 0.0646437284 0.036481 0.0041788116 0.0123469521 0.0564007833 0.0031810484 194.8816 13.96 1464.7 9 14.67 7.3259391595 0.901 0.1011771656 0.811801 0.0102368188 0.0911606262 0.0622929063 0.0038804062 215.2089 14.67 1519.2 10 15.32 7.3394727582 1.551 0.1147107643 2.405601 0.0131585594 0.1779163954 0.0477745976 0.0022824122 234.7024 15.32 1539.9 SOMA/MEDIA: 13.769 7.2247619939 -0 0 7.33349 0.060587502 0.3164898187 0 0.0469288203 1903.1871 Sx² 0.733349 Beta2-erro 0.0282826092 VarBeta2 0.000799906 Sy² 0.0060587502 Beta1-erro 0.3901756977 VarBeta1 0.1522370751 COV(X,Y) 0.0316489819 Sigma² 0.0058661025 tbeta1 16.9937192931 B2 0.0431567806 Sigma 0.076590486 tbeta2 1.5259122742 B1 6.6305362824 r² 0.2254372802 F 2.3284082685 N 10 r 0.4748023591 Valor de X alpha 0.05 Ycalc 6.6305362824 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.0011709601 Var 0.0070370627 SE(Y) 0.0342192949 SE(Y) 0.0838872021 0.19344423482752704 Lim Inferior 6.551626447 Lim Inferior 6.4370920476 Lim Superior 6.7094461178 Lim Superior 6.8239805172 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 0.0136586817 1 0.0136586817 2.3284082685 INDIVIDUAL 0.0469288203 8 0.0058661025 TOTAL 0.060587502 9 EX10 Exercício 10 10 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 15 6 -4.7 -1 22.09 1 4.7 -0.0547547082 0.0029980781 225 2 12 5.5 -7.7 -1.5 59.29 2.25 11.55 0.0485933504 0.0023613137 144 3 20 7 0.3 0 0.09 0 0 -0.0603348059 0.0036402888 400 4 18 6.5 -1.7 -0.5 2.89 0.25 0.85 -0.1581027668 0.0249964849 324 5 25 8 5.3 1 28.09 1 5.3 -0.0659149035 0.0043447745 625 6 32 9.5 12.3 2.5 151.29 6.25 30.75 0.0262729598 0.0006902684 1024 7 27 8.5 7.3 1.5 53.29 2.25 10.95 0.0318530574 0.0010146173 729 8 22 7.5 2.3 0.5 5.29 0.25 1.15 0.0374331551 0.0014012411 484 9 10 5 -9.7 -2 94.09 4 19.4 -0.0491746106 0.0024181423 100 10 16 6.5 -3.7 -0.5 13.69 0.25 1.85 0.2441292723 0.0595991016 256 SOMA/MEDIA: 19.7 7 0 0 430.1 17.5 86.5 -0 0.1034643106 4311 Sx² 43.01 Beta2-erro 0.0054835975 VarBeta2 0.0000300698 Sy² 1.75 Beta1-erro 0.1138556484 VarBeta1 0.0129631087 COV(X,Y) 8.65 Sigma² 0.0129330388 tbeta1 26.6830364438 B2 0.2011160195 Sigma 0.1137235192 tbeta2 36.6759266482 B1 3.0380144153 r² 0.9940877537 F 1345.1235955056 N 10 r 0.9970394945 Valor de X alpha 0.05 Ycalc 3.0380144153 t-student 2.3060041333 Ftab 5.3176550628 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.0024575774 Var 0.0153906162 SE(Y) 0.0495739587 SE(Y) 0.1240589223 0.28608038763543958 Lim Inferior 2.9236966617 Lim Inferior 2.7519340276 Lim Superior 3.1523321689 Lim Superior 3.3240948029 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 17.3965356894 1 17.3965356894 1345.1235955056 INDIVIDUAL 0.1034643106 8 0.0129330388 TOTAL 17.5 9 Ex11 Exercício 11 12 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 2.2 1.1 -15.2083333333 -6.5333333333 231.2934027778 42.6844444444 99.3611111111 -0.2591440798 0.0671556541 4.84 2 4.2 2.3 -13.2083333333 -5.3333333333 174.4600694444 28.4444444444 70.4444444444 0.1157570595 0.0133996968 17.64 3 6.7 3.5 -10.7083333333 -4.1333333333 114.6684027778 17.0844444444 44.2611111111 0.2843834835 0.0808739657 44.89 4 9.5 4.4 -7.9083333333 -3.2333333333 62.5417361111 10.4544444444 25.5702777778 0.0292450785 0.0008552746 90.25 5 12.4 5.6 -5.0083333333 -2.0333333333 25.0834027778 4.1344444444 10.1836111111 0.0328517304 0.0010792362 153.76 6 15.5 6.9 -1.9083333333 -0.7333333333 3.6417361111 0.5377777778 1.3994444444 0.0539484963 0.0029104403 240.25 7 18.5 8.0 1.0916666667 0.3666666667 1.1917361111 0.1344444444 0.4002777778 -0.0836997948 0.0070056557 342.25 8 22.0 9.4 4.5916666667 1.7666666667 21.0834027778 3.1211111111 8.1119444444 -0.1276228011 0.0162875794 484 9 25.3 10.7 7.8916666667 3.0666666667 62.2784027778 9.4044444444 24.2011111111 -0.1890359213 0.0357345796 640.09 10 27.9 11.8 10.4916666667 4.1666666667 110.0750694444 17.3611111111 43.7152777778 -0.1616644403 0.0261353913 778.41 11 30.9 13.2 13.4916666667 5.5666666667 182.0250694444 30.9877777778 75.1036111111 0.0006872686 0.0000004723 954.81 12 33.8 14.7 16.3916666667 7.0666666667 268.6867361111 49.9377777778 115.8344444444 0.3042939205 0.0925947901 1142.44 SOMA/MEDIA: 17.4083333333 7.6333333333 0 0 1257.0291666667 214.2866666667 518.5866666667 -0 0.3440327359 4893.63 Sx² 104.7524305556 Beta2-erro 0.0052315118 VarBeta2 0.0000273687 Sy² 17.8572222222 Beta1-erro 0.1056457788 VarBeta1 0.0111610306 COV(X,Y) 43.2155555556 Sigma² 0.0344032736 tbeta1 4.2740499234 B2 0.4125494304 Sigma 0.1854811947 tbeta2 78.8585495031 B1 0.451535333 r² 0.998394521 F 6218.6708297314 N 12 r 0.9991969381 Valor de X alpha 0.05 Ycalc 0.451535333 t-student 2.2281388424 Ftab 4.9646027011 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.0055708347 Var 0.0399741083 SE(Y) 0.0746380242 SE(Y) 0.1999352602 0.44548351912168471 Lim Inferior 0.2852314521 Lim Inferior 0.0060518139 Lim Superior 0.6178392139 Lim Superior 0.8970188521 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 213.9426339308 1 213.9426339308 6218.6708297314 INDIVIDUAL 0.3440327359 10 0.0344032736 TOTAL 214.2866666667 11 Ex12 Exercício 12 8 Renda/X Consumo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 1.0 86.9 -3.5 16.73125 12.25 279.9347265625 -58.559375 18.3641666667 337.2426173611 1 2 2.0 74.2 -2.5 4.03125 6.25 16.2509765625 -10.078125 5.1976190476 27.0152437642 4 3 3.0 67.6 -1.5 -2.63875 2.25 6.9630015625 3.958125 -1.9389285714 3.7594440051 9 4 4.0 33.7 -0.5 -36.50875 0.25 1332.8888265625 18.254375 -36.2754761905 1315.9101728458 16 5 5.0 88.7 0.5 18.52125 0.25 343.0367015625 9.260625 18.2879761905 334.4500731434 25 6 6.0 48.7 1.5 -21.47875 2.25 461.3367015625 -32.218125 -22.1785714286 491.8890306122 36 7 7.0 55.9 2.5 -14.27875 6.25 203.8827015625 -35.696875 -15.4451190476 238.5517023951 49 8 8.0 105.8 3.5 35.62125 12.25 1268.8734515625 124.674375 33.9883333333 1155.2068027778 64 SOMA/MEDIA: 4.5 70.19875 0 0 42 3913.1670875 19.595 0 3904.0250869048 204 Sx² 5.25 Beta2-erro 3.9360085167 VarBeta2 15.4921630433 Sy² 489.1458859375 Beta1-erro 19.8758687258 VarBeta1 395.0501576035 COV(X,Y) 2.449375 Sigma² 650.6708478175 tbeta1 3.4262293968 B2 0.466547619 Sigma 25.5082505832 tbeta2 0.1185331833 B1 68.0992857143 r² 0.0023362152 F 0.0140501155 N 8 r 0.0483344105 Valor de X 10 alpha 0.1 Ycalc 72.7647619048 t-student 1.9431802743 Ftab 3.7759495784 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 161.5513649115 Var 812.222212729 SE(Y) 12.7102857919 SE(Y) 28.4995124998 55.379690516642569 Lim Inferior 48.0663852733 Lim Inferior 17.3850713881 Lim Superior 97.4631385362 Lim Superior 128.1444524214 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 9.1420005952 1 9.1420005952 0.0140501155 INDIVIDUAL 3904.0250869048 6 650.6708478175 TOTAL 3913.1670875 7 Ex13 Exercício 13 8 Mes/X Saldo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 1.0 659.0 -3.5 -420 12.25 176400 1470 -82.4166666667 6792.5069444445 1 2 2.0 768.0 -2.5 -311 6.25 96721 777.5 -69.869047619 4881.6838151928 4 3 3.0 601.0 -1.5 -478 2.25 228484 717 -333.3214285714 111103.174744898 9 4 4.0 1,246.0 -0.5 167 0.25 27889 -83.5 215.2261904762 46322.3130668934 16 5 5.0 1,727.0 0.5 648 0.25 419904 324 599.7738095238 359728.6225907028 25 6 6.0 1,173.0 1.5 94 2.25 8836 141 -50.6785714286 2568.3176020408 36 7 7.0 1,424.0 2.5 345 6.25 119025 862.5 103.869047619 10788.779053288 49 8 8.0 1,034.0 3.5 -45 12.25 2025 -157.5 -382.5833333333 146370.0069444445 64 SOMA/MEDIA: 4.5 1079 0 0 42 1079284 4051 0 688555.4047619046 204 Sx² 5.25 Beta2-erro 52.2720070144 VarBeta2 2732.3627173091 Sy² 134910.5 Beta1-erro 263.9606964898 VarBeta1 69675.2492913832 COV(X,Y) 506.375 Sigma² 114759.2341269841 tbeta1 2.4434103042 B2 96.4523809524 Sigma 338.7613232454 tbeta2 1.8452014082 B1 644.9642857143 r² 0.362025746 F 3.4047682368 N 8 r 0.6016857535 Valor de X 12 alpha 0.08 Ycalc 1802.3928571429 t-student 2.1043061207 Ftab 4.4281042496 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 43119.0945874183 Var 157878.3287144024 SE(Y) 207.6513775235 SE(Y) 397.3390601418 836.12301624425345 Lim Inferior 1365.4307924511 Lim Inferior 966.2698408986 Lim Superior 2239.3549218346 Lim Superior 2638.5158733871 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 390728.5952380952 1 390728.5952380952 3.4047682368 INDIVIDUAL 688555.4047619046 6 114759.2341269841 TOTAL 1079284 7 Ex14 Exercício 14 5 Idade/X Custo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 6.0 9.7 -18 -8.62 324 74.3044 155.16 -1.2 1.44 36 2 15.0 16.5 -9 -1.82 81 3.3124 16.38 1.89 3.5721 225 3 24.0 19.3 0 0.98 0 0.9604 0 0.98 0.9604 576 4 33.0 19.2 9 0.88 81 0.7744 7.92 -2.83 8.0089 1089 5 42.0 26.9 18 8.58 324 73.6164 154.44 1.16 1.3456 1764 SOMA/MEDIA: 24 18.32 0 0 810 152.968 333.9 -0 15.327 3690 Sx² 162 Beta2-erro 0.0794191879 VarBeta2 0.0063074074 Sy² 30.5936 Beta1-erro 2.1575140015 VarBeta1 4.6548666667 COV(X,Y) 66.78 Sigma² 5.109 tbeta1 3.9057297708 B2 0.4122222222 Sigma 2.2603097133 tbeta2 5.1904613117 B1 8.4266666667 r² 0.8998025731 F 26.9408886279 N 5 r 0.9485792392 Valor de X 42 alpha 0.08 Ycalc 25.74 t-student 2.6054268229 Ftab 6.7882489297 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 0.959495122 Var 6.068495122 SE(Y) 0.9795382187 SE(Y) 2.4634315744 6.4182907005352376 Lim Inferior 23.1878848508 Lim Inferior 19.3217092995 Lim Superior 28.2921151492 Lim Superior 32.1582907005 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 137.641 1 137.641 26.9408886279 INDIVIDUAL 15.327 3 5.109 TOTAL 152.968 4 Ex15 Exercício 15 8 Idade/X Custo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 50.0 36.0 -185.625 -22 34456.640625 484 4083.75 -0.0895002831 0.0080103007 2500 2 240.0 48.0 4.375 -10 19.140625 100 -43.75 -10.5164090842 110.594860027 57600 3 150.0 50.0 -85.625 -8 7331.640625 64 685 2.1068635058 4.438873832 22500 4 350.0 70.0 114.375 12 13081.640625 144 1372.5 -1.5004089165 2.2512269166 122500 5 100.0 42.0 -135.625 -16 18394.140625 256 2170 0.0086816113 0.0000753704 10000 6 175.0 58.0 -60.625 0.0 3675.390625 0 0 7.155954453 51.2076841333 30625 7 485.0 91.0 249.375 33 62187.890625 1089 8229.375 3.5646821985 12.7069591763 235225 8 335.0 69.0 99.375 11 9875.390625 121 1093.125 -0.7298634848 0.5327007065 112225 SOMA/MEDIA: 235.625 58 0 0 149021.875 2258 17590 -0 181.7403904628 593175 Sx² 18627.734375 Beta2-erro 0.0142568996 VarBeta2 0.0002032592 Sy² 282.25 Beta1-erro 3.8821428994 VarBeta1 15.071033491 COV(X,Y) 2198.75 Sigma² 30.2900650771 tbeta1 7.7760358029 B2 0.1180363621 Sigma 5.5036410745 tbeta2 8.2792448112 B1 30.1876821775 r² 0.9195126703 F 68.545894644 N 8 r 0.9589122328 Valor de X 250 alpha 0.05 Ycalc 59.6967727053 t-student 2.4469118464 Ftab 5.9873775842 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 3.0395584662 Var 33.3296235433 SE(Y) 1.7434329543 SE(Y) 5.7731814057 14.126465973259 Lim Inferior 55.430745956 Lim Inferior 45.5703067321 Lim Superior 63.9627994547 Lim Superior 73.8232386786 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 2076.2596095372 1 2076.2596095372 68.545894644 INDIVIDUAL 181.7403904628 6 30.2900650771 TOTAL 2258 7 Ex16 Exercício 16 15 Idade/X Custo/Y xi=Xi-Xm yi=Yi-Ym xi² yi² xi*yi ei ei² Xi² 1 24.0 962.0 0.7333333333 0 0.5377777778 0 0 -15.9928109779 255.7700029747 576 2 30.0 1,181.0 6.7333333333 219 45.3377777778 47961 1474.6 72.1569173848 5206.6207264752 900 3 9.0 578.0 -14.2666666667 -384 203.5377777778 147456 5478.4 -72.8671318846 5309.6189090878 81 4 48.0 1,429.0 24.7333333333 467 611.7377777778 218089 11550.4666666667 -72.3938975272 5240.8763991735 2304 5 38.0 1,324.0 14.7333333333 362 217.0711111111 131044 5333.4666666667 40.689888535 1655.6670289933 1444 6 15.0 752.0 -8.2666666667 -210 68.3377777778 44100 1736 -29.7174035219 883.1240720845 225 7 5.0 542.0 -18.2666666667 -420 333.6711111111 176400 7672 -21.6336174597 468.0134043936 25 8 38.0 1,355.0 14.7333333333 393 217.0711111111 154449 5790.2 71.689888535 5139.4401181653 1444 9 15.0 788.0 -8.2666666667 -174 68.3377777778 30276 1438.4 6.2825964781 39.4710185064 225 10 24.0 998.0 0.7333333333 36 0.5377777778 1296 26.4 20.0071890221 400.2876125663 576 11 49.0 1,462.0 25.7333333333 500 662.2044444444 250000 12866.6666666667 -61.2022761334 3745.7186039069 2401 12 10.0 650.0 -13.2666666667 -312 176.0044444444 97344 4139.2 -22.6755104908 514.1787760193 100 13 17.0 862.0 -6.2666666667 -100 39.2711111111 10000 626.6666666667 36.6658392656 1344.3837690539 289 14 11.0 719.0 -12.2666666667 -243.0 150.4711111111 59049 2980.8 24.516110903 601.0396938062 121 15 16.0 828.0 -7.2666666667 -134 52.8044444444 17956 973.7333333333 24.4742178719 598.9873404394 256 SOMA/MEDIA: 23.2666666667 962 0 0 2846.9333333333 1385420 62087 -0 31403.1974756463 10967 Sx² 189.7955555556 Beta2-erro 0.9211420543 VarBeta2 0.8485026842 Sy² 92361.3333333333 Beta1-erro 24.9071996787 VarBeta1 620.3685958358 COV(X,Y) 4139.1333333333 Sigma² 2415.6305750497 tbeta1 18.2514184771 B2 21.8083786062 Sigma 49.1490648441 tbeta2 23.6753696181 B1 454.5917244286 r² 0.9773330849 F 560.5231265532 N 15 r 0.9886015805 Valor de X 55 alpha 0.05 Ycalc 1654.0525477707 t-student 2.1603686522 Ftab 4.6671927136 Previsão/Intervalor de Confiança Previsão Média Previsão Pontual Var 463.3694517068 Var 2879.0000267565 SE(Y) 21.5260180179 SE(Y) 53.6563139505 115.91741865390314 Lim Inferior 1607.5484132371 Lim Inferior 1538.1351291168 Lim Superior 1700.5566823043 Lim Superior 1769.9699664246 ANOVA FONTE DE VARIAÇÃO SOMA DOS QUADRADOS GRAUS DE LIBERDADE QUADRADO MEDIO FUNÇÃO F EXPLICADA 1354016.802524354 1 1354016.802524354 560.5231265532 INDIVIDUAL 31403.1974756463 13 2415.6305750497 TOTAL 1385420 14
Compartilhar