Baixe o app para aproveitar ainda mais
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
Exemplo xi yi xi*yi xi² yi² 0 2160 0 0 4665600 50 2880 144000 2500 8294400 100 3360 336000 10000 11289600 150 3720 558000 22500 13838400 200 4020 804000 40000 16160400 500 16140 1842000 75000 54248400 1140000 1158792.4749496779 0.9837827088 9.12 b 2316 a y=a+bx y = 2316 + 9,12x xi yi Y = 2316 + 9,12x ei=yi-Yi 0 2160 2316 -156 50 2880 2772 108 100 3360 3228 132 150 3720 3684 36 200 4020 4140 -120 Yi Yi-ý (Yi-ý)² yi yi-ý (yi-ý)² 2316 -912 831744 2160 -1068 1140624 2772 -456 207936 2880 -348 121104 ý 3228 0 0 3360 132 17424 3228 3684 456 207936 3720 492 242064 4140 912 831744 4020 792 627264 2079360 2148480 0.9678284182 1 xi yi xi*yi xi² yi² 250 160 40000 62500 25600 241 170 40970 58081 28900 340 166 56440 115600 27556 215 170 36550 46225 28900 222 170 37740 49284 28900 218 173 37714 47524 29929 200 180 36000 40000 32400 199 181 36019 39601 32761 197 195 38415 38809 38025 2082 1565 359848 497624 272971 -19698 32881.674044975269 -0.599057091 -0.1368943374 b 205.56 a Y=a+bx Y = 205,55-0,1369x xi yi Y = 205,55-0,1369x ei=yi-Yi 250 160 239.78 -79.78 241 170 238.55 -68.55 340 166 252.10 -86.10 215 170 234.99 -64.99 222 170 235.95 -65.95 218 173 235.40 -62.40 200 180 232.94 -52.94 199 181 232.80 -51.80 197 195 232.53 -37.53 Yi Yi-ý (Yi-ý)² yi yi-ý (yi-ý)² 239.78 65.89 4341.7303278642 160 -13.89 192.90 238.55 64.66 4180.8843961664 170 -3.89 15.12 ý 252.10 78.21 6117.1635760344 166 -7.89 62.23 173.89 234.99 61.10 3733.2718255138 170 -3.89 15.12 235.95 62.06 3851.2904742988 170 -3.89 15.12 235.40 61.51 3783.6263657063 173 -0.89 0.79 232.94 59.05 3486.5589406483 180 6.11 37.35 232.80 58.91 3470.4112559444 181 7.11 50.57 232.53 58.64 3438.2283268945 195 21.11 445.68 36403.17 834.89 43.60 2 xi yi xi*yi xi² yi² 2 80 160 4 6400 3 92 276 9 8464 6 95 570 36 9025 7 96 672 49 9216 8 100 800 64 10000 8 105 840 64 11025 9 110 990 81 12100 10 115 1150 100 13225 11 105 1155 121 11025 13 120 1560 169 14400 16 125 2000 256 15625 93 1143 10173 953 120505 5604 5919.49 0.95 3.0556 b 78.075 a Y=a+bx Y = 78,075 + 3,0556x xi yi Y = 78,075 + 3,0556x ei=yi-Yi 2 80 84.19 -4.19 3 92 87.24 4.76 6 95 96.41 -1.41 7 96 99.46 -3.46 8 100 102.52 -2.52 8 105 102.52 2.48 9 110 105.58 4.42 10 115 108.63 6.37 11 105 111.69 -6.69 13 120 117.80 2.20 16 125 126.97 -1.97 Yi Yi-ý (Yi-ý)² yi yi-ý (yi-ý)² 84.19 -19.72 388.98 80 -23.91 571.64 87.24 -16.67 277.79 92 -11.91 141.83 ý 96.41 -7.50 56.25 95 -8.91 79.37 103.91 99.46 -4.44 19.75 96 -7.91 62.55 102.52 -1.39 1.93 100 -3.91 15.28 102.52 -1.39 1.93 105 1.09 1.19 105.58 1.67 2.78 110 6.09 37.10 108.63 4.72 22.30 115 11.09 123.01 111.69 7.78 60.50 105 1.09 1.19 117.80 13.89 192.91 120 16.09 258.92 126.97 23.06 531.58 125 21.09 444.83 1556.70 1736.91 0.90 3 xi yi xi*yi xi² yi² 230 5.2 1196 52900 27.04 90 1.8 162 8100 3.24 130 3.4 442 16900 11.56 450 5.8 2610 202500 33.64 200 3.0 600 40000 9 340 6.0 2040 115600 36 300 7.0 2100 90000 49 490 9.2 4508 240100 84.64 180 5.2 936 32400 27.04 2410 46.6 14594 798500 281.16 19039.999999999985 22241.41 0.86 0.0138 b 1.4789 a Y=a+bx Y = 1,4789 + 0,0138x xi yi Y = 1,4789 + 0,0138x ei=yi-Yi 230 5.2 4.66 0.54 90 1.8 2.72 -0.92 130 3.4 3.27 0.13 450 5.8 7.69 -1.89 200 3.0 4.24 -1.24 340 6.0 6.18 -0.18 300 7.0 5.62 1.38 490 9.2 8.25 0.95 180 5.2 3.97 1.23 Yi Yi-ý (Yi-ý)² yi yi-ý (yi-ý)² 4.66 -0.52 0.27 5.2 0.02 0.0005 2.72 -2.46 6.03 1.8 -3.38 11.41 ý 3.27 -1.90 3.62 3.4 -1.78 3.16 5.18 7.69 2.52 6.34 5.8 0.62 0.39 4.24 -0.94 0.88 3.0 -2.18 4.74 6.18 1.00 1.00 6.0 0.82 0.68 5.62 0.45 0.20 7.0 1.82 3.32 8.25 3.07 9.42 9.2 4.02 16.18 3.97 -1.21 1.47 5.2 0.02 0.0005 29.22 39.88 0.73 4 xi yi xi*yi xi² yi² 42 27 1134 1764 729 50 24 1200 2500 576 42 30 1260 1764 900 50 20 1000 2500 400 40 34 1360 1600 1156 35 40 1400 1225 1600 48 28 1344 2304 784 35 38 1330 1225 1444 342 241 10028 14882 7589 -2198 2346.07 -0.94 -1.0507 b 75.041 a Y=a+bx Y = 75,041-1,0507x xi yi Y = 75,041-1,0507x ei=yi-Yi 42 27 30.91 -3.91 50 24 22.51 1.49 42 30 30.91 -0.91 50 20 22.51 -2.51 40 34 33.01 0.99 35 40 38.27 1.73 48 28 24.61 3.39 35 38 38.27 -0.27 Yi Yi-ý (Yi-ý)² yi yi-ý (yi-ý)² 30.91 0.79 0.62 27 -3.13 9.77 22.51 -7.62 58.02 24 -6.13 37.52 ý 30.91 0.79 0.62 30 -0.13 0.02 30.13 22.51 -7.62 58.02 20 -10.13 102.52 33.01 2.89 8.35 34 3.88 15.02 38.27 8.14 66.30 40 9.88 97.52 24.61 -5.52 30.43 28 -2.13 4.52 38.27 8.14 66.30 38 7.88 62.02 288.67 328.88 0.88
Compartilhar