Ajustes de Ecuaciones

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 49

DATOS Xi Yi X^2 X*Y

1 1 0.5 1 0.5 8.5765 0.1687


2 2 2.5 4 5 0.8622 0.5625
3 3 2 9 6 2.0408 0.3473
4 4 4 16 16 0.3265 0.3265
5 5 3.5 25 17.5 0.0051 0.5896
6 6 6 36 36 6.6122 0.7972
7 7 5.5 49 38.5 4.2908 0.1993
Σ 28 24 140 119.5 22.7143 2.9911

N= 7

https://www.generadordegraficos.com
Y AJUSTADO
Σx 28
= = = 4
0.91071429 n 7
1.75
2.58928571 Σy 24
= = = 3.42857142857
3.42857143 n 7
4.26785714
5.10714286
5.94642857 7 *
a1 = =
24.0000 7 *

a0= = 3.4286 - 0.83928571429 * 4

ECUACIÓN: Y = a0 + a1 * X Y= 0.07142857143 + 0.839285714286

0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286
0.07142857143 + 0.839285714286

= 22.7143
22.7143
SY= = 2.1314
7 - 2
119.5 - 28 * 24
2 = 0.83928571
140 - ( 28 )

= 0.071428571429

0.839285714286 * x

0.839285714286 * 1 = 0.91071429
0.839285714286 * 2 = 1.75
0.839285714286 * 3 = 2.58928571
0.839285714286 * 4 = 3.42857143
0.839285714286 * 5 = 4.26785714
0.839285714286 * 6 = 5.10714286
0.839285714286 * 7 = 5.94642857
SR

DATOS Xi Yi X^2 X*Y

1 2.5 15 6.25 37.5 1511.2656 0.9511


2 4 24 16 96 892.5156 2.7284
3 6 32 36 192 478.5156 42.9527
4 8 56 64 448 4.5156 20.6491
5 9 49 81 441 23.7656 79.3326
6 9.5 76 90.25 722 489.5156 221.0457
7 12.5 90 156.25 1125 1305.0156 90.5266
8 15.5 89 240.25 1379.5 1233.7656 117.4732
Σ 67 431 690 4441 5938.8750 575.6596

N= 8

C)
EDAD DE UN ARBOL DE 18 PULGADAS

X=DIAMETRO 18
Y=EDAD ?

Y= A0 + A1 * X

SUSTITUYENDO VALORES

Y= -0.152279 + 6.4510 * (18)

Y= 115.96 ==> 116 AÑOS


SR

Y AJUSTADO
Σx 67
0.9511 15.9753
= n
=
8
=

2.7284 25.6518
42.9527 38.5538 Σy 431
= = =
20.6491 51.4559 n 8
79.3326 57.9069
221.0457 61.1324
90.5266 80.4855
a1 = =
117.4732 99.8385
575.6596 431.000000

a0= = 53.875 -

ECUACIÓN: Y = a0 + a1 * X Y=

= 5938.8750

5938.8750
SY= =
8 - 2
8.3750

53.8750

8 * 4441 - 67 * 431
= 2 = 6.4510
8 * 690 - ( 67 )

6.45101842871 * 8 = -0.1523

-0.1522793404 + 6.45101842871 * x

-0.1522793404 + 6.45101842871 * 2.5 = 15.9753


-0.1522793404 + 6.45101842871 * 4 = 25.6518
-0.1522793404 + 6.45101842871 * 6 = 38.5538
-0.1522793404 + 6.45101842871 * 8 = 51.4559
-0.1522793404 + 6.45101842871 * 9 = 57.9069
-0.1522793404 + 6.45101842871 * 9.5 = 61.1324
-0.1522793404 + 6.45101842871 * 12.5 = 80.4855
-0.1522793404 + 6.45101842871 * 15.5 = 99.8385

desviacion estandar de y en base a x


para ver la precisión de la curva

31.4613
DATOS Xi Yi X^2 X*Y

1 1984 344.3 3936256 683091.2 303.9211 0.2669


2 1986 347 3944196 689142 217.0711 0.0022
3 1988 351.3 3952144 698384.4 108.8544 0.9789
4 1990 354 3960100 704460 59.8044 0.1813
5 1992 356.3 3968064 709749.6 29.5211 0.2893
6 1994 358.9 3976036 715646.6 8.0278 1.4436
7 1996 362.7 3984016 723949.2 0.9344 0.4424
8 1998 366.5 3992004 732267 22.7211 0.0166
9 2000 369.4 4000000 738800 58.7778 0.2425
10 2002 372 4008004 744744 105.4044 1.3365
11 2004 377.5 4016016 756510 248.5878 1.1671
12 2006 380.9 4024036 764085.4 367.3611 1.4803
Σ 23940 4340.8 47760872 8660829.4 1530.9867 7.8476

N= 12
C) ESTIMACION DE CO2 EN 2005 EN COMPARACIÓN CON NIVEL REAL DE 379.7
Y= -2893.7439 + 1.6118 * X

X= AÑO
Y= NIVEL DE CO2

Y= -2893.7439 + 1.6118 * (2005)

Y= 378.0515

LA ESTIMACIÓN CONSIDERANDO UN AJUSTE EN LA RECTA DE REGRESIÓN ES DE 378.0515

SI LO COMPARAMOS CON EL REAL HAY UNA DIFERENCIA DE 1.6485


Y AJUSTADO
Σx 23940
343.78333333329
= n
=
12
= 1995.0000

347.046969696934
350.310606060579 Σy 4340.8
= = = 361.7333
353.574242424223 n 12
356.837878787867
360.101515151511
363.365151515155 12
a1 = =
366.628787878799 12
369.892424242444
373.156060606088
376.419696969732 a0= = 361.73333333 - 1.6318 *
379.683333333376
4340.800000
ECUACIÓN: Y = a0 + a1 * X Y= -2893.7439394 +

-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +
-2893.7439394 +

= 1530.9867
1530.9867
SY= = 12.3733
12 - 2
* 8660829.4 - 23940 * 4340.8
2 = 1.6318
* 47760872 - ( 23940 )

1995 = -2893.7439

1.63181818182209 * x

1.63181818182209 * 1984 = 343.7833


1.63181818182209 * 1986 = 347.0470
1.63181818182209 * 1988 = 350.3106
1.63181818182209 * 1990 = 353.5742
1.63181818182209 * 1992 = 356.8379
1.63181818182209 * 1994 = 360.1015
1.63181818182209 * 1996 = 363.3652
1.63181818182209 * 1998 = 366.6288
1.63181818182209 * 2000 = 369.8924
1.63181818182209 * 2002 = 373.1561
1.63181818182209 * 2004 = 376.4197
1.63181818182209 * 2006 = 379.6833
DATOS Xi Yi X^2 X^3 X^4 X*Y X^2 Y

1 0 2.1 0 0 0 0 0
2 1 7.7 1 1 1 7.7 7.7
3 2 13.6 4 8 16 27.2 54.4
4 3 27.2 9 27 81 81.6 244.8
5 4 40.9 16 64 256 163.6 654.4
6 5 61.1 25 125 625 305.5 1527.5
Σ 15 152.6 55 225 979 585.6 2488.8

N= 6
SR

Y AJUSTADO
=
544.4444 4.4100 0.0000
314.4711 59.2900 0.0000
140.0278 184.9600 0.0000
=
3.1211 739.8400 0.0000
239.2178 1672.8100 0.0000
1272.1111 3733.2100 0.0000
2513.3933 6394.5200 0.000000
Σx 15
= = 2.5000
n 6 N= 6
M=2 M=2 IWAL 3X3
Σy 152.6
= = 25.4333
n 6
n a0 + ( Σx ) a1 + ( Σx^2 ) a2 =
6 a0 + ( 15 ) a1 + ( 55 ) a2 =

Σx a0 + ( Σx^2 ) a1 + ( Σx^3 ) a2 =
15 a0 + ( 55 ) a1 + ( 225 ) a2 =

Σx^2 a0 + ( Σx^3 ) a1 + ( Σx^4 ) a2 =


55 a0 + ( 225 ) a1 + ( 979 ) a2 =
MDETERM

Σy n Σx Σx^2 A0
152.6 Σx Σx^2 Σx^3 A1
Σx^2 Σx^3 Σx^4 A2
Σxy
585.6
CONSTANTES
Σx^2y 6 15 55 152.6
2488.8 15 55 225 585.6
55 225 979 2488.8

152.6 15 55
A0= 585.6 55 225 =
2488.8 225 979
MDETERM 3920.00000000001

6 152.6 55
A1= 15 585.6 225 =
55 2488.8 979
MDETERM 3920.00000000001

6 15 152.6
A2= 15 55 585.6 =
55 225 2488.8
MDETERM 3920.00000000001
152.6
= 585.6
2488.8

MATRIZ INVERSA
0.8214 -0.5893 0.0893 A0= 2.47857143
-0.5893 0.7268 -0.1339 A1= 2.35928571
0.0893 -0.1339 0.0268 A2= 1.86071429

9716 = 2.47857142857

3920

9248.4 = 2.35928571429

3920

7294 = 1.86071428571

3920
DATOS Xi Yi X^2 X^3 X^4 X^5 X^6

1 0 2.1 0 0 0
2 1 7.7 1 1 1
3 2 13.6 4 8 16
4 3 27.2 9 27 81
5 4 40.9 16 64 256
6 5 61.1 25 125 625
Σ 15 152.6 55 225 979 0 0

N= 6
SR

X*Y X^2 Y X^3Y Y AJUSTADO

0 0 0 544.4444 4.4100 0.0000


7.7 7.7 7.7 314.4711 59.2900 0.0000
27.2 54.4 108.8 140.0278 184.9600 0.0000
81.6 244.8 734.4 3.1211 739.8400 0.0000
163.6 654.4 2617.6 239.2178 1672.8100 0.0000
305.5 1527.5 7637.5 1272.1111 3733.2100 0.0000
585.6 2488.8 11106 2513.3933 6394.5200 0.000000
Σx 15
= = = 2.5000
n 6

Σy 152.6
= = = 25.4333
n 6
( n ) a0
N= 6 ( 6 ) a0
M=3 M=3 IWAL 4X4
( Σx ) a0
( 15 ) a0
M= GRADO
( Σx^2 ) a0
( 55 ) a0

( Σx^3 ) a0
( 225 ) a0
+ ( Σx ) a1 + ( Σx^2 ) a2 + ( Σx^3 ) a3 = Σy
+ ( 15 ) a1 + ( 55 ) a2 + ( 225 ) a3 = 152.6

+ ( Σx^2 ) a1 + ( Σx^3 ) a2 + ( Σx^4 ) a3 = Σxy


+ ( 55 ) a1 + ( 225 ) a2 + ( 979 ) a3 = 585.6

+ ( Σx^3 ) a1 + ( Σx^4 ) a2 + ( Σx^5 ) a3 = Σx^2y


+ ( 225 ) a1 + ( 979 ) a2 + ( 0 ) a3 = 2488.8

+ ( Σx^4 ) a1 + ( Σx^5 ) a2 + ( Σx^6 ) a3 = Σx^3y


+ ( 979 ) a1 + ( 0 ) a2 + ( 0 ) a3 = 11106
MDETERM

n Σx Σx^2 A0 152.6
Σx Σx^2 Σx^3 A1 = 585.6
Σx^2 Σx^3 Σx^4 A2 2488.8

CONSTANTES MATRIZ INVERSA


6 15 55 152.6 0.8214
15 55 225 585.6 -0.5893
55 225 979 2488.8 0.0893

152.6 15 55
A0= 585.6 55 225 = 9716 =
2488.8 225 979
MDETERM 3920.00000000001 3920

6 152.6 55
A1= 15 585.6 225 = 9248.4 =
55 2488.8 979
MDETERM 3920.00000000001 3920

6 15 152.6
A2= 15 55 585.6 = 7294 =
55 225 2488.8
MDETERM 3920.00000000001 3920
MATRIZ INVERSA
-0.5893 0.0893 A0= 2.47857143
0.7268 -0.1339 A1= 2.35928571
-0.1339 0.0268 A2= 1.86071429

2.47857142857

2.35928571429

1.86071428571
DATOS Xi Yi X^2 X^3 X^4 X^5 X^6

1 0 2.1 0 0 0
2 1 7.7 1 1 1
3 2 13.6 4 8 16
4 3 27.2 9 27 81
5 4 40.9 16 64 256
6 5 61.1 25 125 625
Σ 15 152.6 55 225 979 0 0

N= 6
SR

X*Y X^2 Y X^3Y Y AJUSTADO

0 0 0 544.4444 4.4100 0.0000


7.7 7.7 7.7 314.4711 59.2900 0.0000
27.2 54.4 108.8 140.0278 184.9600 0.0000
81.6 244.8 734.4 3.1211 739.8400 0.0000
163.6 654.4 2617.6 239.2178 1672.8100 0.0000
305.5 1527.5 7637.5 1272.1111 3733.2100 0.0000
585.6 2488.8 11106 2513.3933 6394.5200 0.000000
Σx 15
= = = 2.5000
n 6

Σy 152.6
= = = 25.4333
n 6
( n ) a0
N= 6 ( 6 ) a0
M=4 M=4 IWAL 5x5
( Σx ) a0
( 15 ) a0
M= GRADO
( Σx^2 ) a0
( 55 ) a0

( Σx^3 ) a0
( 225 ) a0

( Σx^4 ) a0
( 979 ) a0
+ ( Σx ) a1 + ( Σx^2 ) a2 + ( Σx^3 ) a3 + ( Σx^4 ) a4 =
+ ( 15 ) a1 + ( 55 ) a2 + ( 225 ) a3 + ( ) a4 =

+ ( Σx^2 ) a1 + ( Σx^3 ) a2 + ( Σx^4 ) a3 + ( Σx^5 ) a4 =


+ ( 55 ) a1 + ( 225 ) a2 + ( 979 ) a3 + ( ) a4 =

+ ( Σx^3 ) a1 + ( Σx^4 ) a2 + ( Σx^5 ) a3 + ( Σx^6 ) a4 =


+ ( 225 ) a1 + ( 979 ) a2 + ( 0 ) a3 + ( ) a4 =

+ ( Σx^4 ) a1 + ( Σx^5 ) a2 + ( Σx^6 ) a3 + ( Σx^7 ) a4 =


+ ( 979 ) a1 + ( 0 ) a2 + ( 0 ) a3 + ( ) a4 =

+ ( Σx^5 ) a1 + ( Σx^6 ) a2 + ( Σx^7 ) a3 + ( Σx^8 ) a4 =


+ ( 0 ) a1 + ( 0 ) a2 + ( 0 ) a3 + ( ) a4 =
MDETERM

Σy n Σx Σx^2 A0
152.6 Σx Σx^2 Σx^3 A1
Σx^2 Σx^3 Σx^4 A2
Σxy
585.6
CONSTANTES
Σx^2y 6 15 55 152.6
2488.8 15 55 225 585.6
55 225 979 2488.8
Σx^3y
11106 152.6 15 55
A0= 585.6 55 225 =
Σx^3y 2488.8 225 979
0 MDETERM 3920.00000000001

6 152.6 55
A1= 15 585.6 225 =
55 2488.8 979
MDETERM 3920.00000000001

6 15 152.6
A2= 15 55 585.6 =
55 225 2488.8
MDETERM 3920.00000000001
152.6
= 585.6
2488.8

MATRIZ INVERSA
0.8214 -0.5893 0.0893 A0= 2.47857143
-0.5893 0.7268 -0.1339 A1= 2.35928571
0.0893 -0.1339 0.0268 A2= 1.86071429

9716 = 2.47857142857

3920

9248.4 = 2.35928571429

3920

7294 = 1.86071428571

3920
DATOS Xi Yi X^2 X^3 X^4 X^5

1 -2.54 5.26 6.45 -16.39 41.62 -105.72


2 8.10 5.61 65.66 532.03 4311.05 34932.46
3 10.57 5.86 111.68 1180.26 12473.01 131814.75
4 13.22 6.91 174.87 2312.54 30580.98 404402.85
5 15.88 8.13 252.30 4007.56 63656.02 1011112.30
6 18.92 9.45 357.78 6767.36 128004.54 2421205.93
7 21.23 8.39 450.88 9574.04 203295.26 4316771.54
8 29.20 9.89 852.41 24886.86 726596.70 21213717.20
9 31.77 11.86 1009.52 32075.59 1019137.76 32381063.91
10 34.84 13.50 1213.48 42271.48 1472526.98 51295477.19
11 36.66 15.66 1343.88 49265.38 1806019.59 66206871.97
12 39.25 17.16 1540.88 60485.57 2374300.44 93200789.38
13 42.39 18.20 1797.00 76176.49 3229197.79 136888923.53
14 44.20 19.54 1953.99 86374.33 3818091.05 168774896.83
15 47.09 20.44 2217.66 104433.88 4918000.19 231598465.06
Σ 390.79 175.84 13348.44 500326.98 19806232.98 809880339.17

N= 15

Y=2.382-0.506X
X^6 x^7 X^8 X^9

268.54 -682.08 1732.49 -4400.51


283057.74 2293616.86 18585177.42 150595692.60
1393018.32 14721417.59 155575941.13 1644126545.85
5347823.23 70719614.39 935196180.68 12367034293.27
16060507.71 255105104.54 4052089480.57 64363389309.40
45797110.08 866252337.26 16385162959.18 309925357372.96
91662326.96 1946357850.59 41328962599.48 877579191837.29
619355687.25 18082708645.01 527942761599.67 15413816867664.10
1028843543.58 32689445910.01 1038641764898.81 33000764796129.90
1786877948.08 62245893321.40 2168335693851.13 75533973895304.20
2427077719.67 88974242125.39 3261706742074.55 119570907457711.00
3658503786.17 143610907622.13 5637302567799.02 221286674996383.00
5802858357.34 245988968626.16 10427718369031.60 442041409381620.00
7460525539.68 329785070956.07 14577819276542.20 644397923300270.00
10906434916.45 513605833085.65 24186725891669.20 1139001295690487.00
33851021610.80 1438138519550.97 61889068641537.20 2691512796076220.00
X^10 X^11 X^12 X*Y

11177.31 -28390.36 72111.51 -13.36


1220276897.11 9887903697.31 80121683659.29 45.43
17375129336.56 183620366828.75 1940500036646.18 61.97
163541661494.21 2162674931599.47 28599213295471.40 91.31
1022348075790.44 16238976835855.30 257939908060726.00 129.14
5862238134709.55 110884234318031.00 2097375292125560.00 178.73
18634516559473.10 395685324623851.00 8401982183062860.00 178.09
450021797268321.00 13138836393045900.00 383601467331368000.00 288.75
1048533299867430.00 33315048536688000.00 1058519037156190000.00 376.70
2631225980642920.00 91658757035696200.00 3192932801338470000.00 470.27
4383349896492231.00 160689223855509000.00 5890706257319090000.00 574.04
8686387140308009.00 340975440805651000.00 13384649953385000000.00 673.68
18738577385096300.00 794347033931616000.00 33673165115395100000.00 771.64
28484965801565100.00 1259149428292390000.00 55659441328236600000.00 863.53
53637849016656400.00 2525913585892380000.00 118950322586844000000.00 962.42
118086611557746000.00 5219712519461930000.00 232204126464224000000.00 5652.34
X^2 Y X^3Y X^4Y X^5Y X^6Y
(
33.92 -86.16 218.85 -555.89 1411.96 (
368.15 2983.10 24172.07 195866.31 1587104.74
654.91 6921.06 73141.72 772961.72 8168659.42 (
1207.51 15968.06 211161.65 2792401.65 36926719.40 (
2051.21 32581.43 517523.48 8220342.97 130571927.72
3380.64 63944.75 1209514.92 22877974.79 432736893.19 (
3781.55 80297.51 1705037.34 36204762.94 768771936.18 (
8430.30 246131.02 7186041.34 209803663.07 6125427746.92
11968.91 380288.21 12082897.23 383909893.70 12197969052.63 (
16381.94 570664.97 19879114.17 692488942.13 24122852299.09 (
21043.85 771446.59 28280460.68 1036733408.23 38005610012.31
26444.52 1038053.30 40747744.11 1599511947.27 62787241978.17 (
32710.73 1386640.73 58781087.38 2491789075.01 105629430678.73 (
38171.27 1687322.61 74586408.69 3297017609.67 145741366417.67
45322.25 2134315.17 100509169.93 4733177830.37 222894810387.57 (
211951.66 8417472.35 345793693.58 14515496123.93 618883473225.72 (

(
(
n ) a0 + ( Σx ) a1 + ( Σx^2 ) a2 + (
15 ) a0 + ( 390.792 ) a1 + ( 13348.441374 ) a2 + (

Σx ) a0 + ( Σx^2 ) a1 + ( Σx^3 ) a2 + (
390.792 ) a0 + ( 13348.4 ) a1 + ( 500326.98172386 ) a2 + (

Σx^2 ) a0 + ( Σx^3 ) a1 + ( Σx^4 ) a2 + (


13348.441374 ) a0 + ( 500327 ) a1 + ( 19806232.98 ) a2 + (

Σx^3 ) a0 + ( Σx^4 ) a1 + ( Σx^5 ) a2 + (


500326.9817239 ) a0 + ( ### ) a1 + ( 809880339.17 ) a2 + (

Σx^4 ) a0 + ( Σx^5 ) a1 + ( Σx^6 ) a2 + (


19806232.98 ) a0 + ( ### ) a1 + ( 33851021610.80 ) a2 + (

Σx^5 ) a0 + ( Σx^6 ) a1 + ( Σx^7 ) a2 + (


809880339.17 ) a0 + ( ### ) a1 + ( 1438138519550.97 ) a2 + (

Σx^6 ) a0 + ( Σx^7 ) a1 + ( Σx^8 ) a2 + (


33851021610.80 ) a0 + ( ### ) a1 + ( 61889068641537.20 ) a2 + (
Σx^3 ) a3 + ( Σx^4 ) a4 + ( Σx^5 )
500326.98172386 ) a3 + ( 19806232.98 ) a4 + ( 809880339.17 )

Σx^4 ) a3 + ( Σx^5 ) a4 + ( Σx^6 )


19806232.98 ) a3 + ( 809880339.17 ) a4 + ( 33851021610.80 )

Σx^5 ) a3 + ( Σx^6 ) a4 + ( Σx^7 )


809880339.17 ) a3 + ( 33851021610.80 ) a4 + ( 1438138519550.97 )

Σx^6 ) a3 + ( Σx^7 ) a4 + ( Σx^8 )


33851021610.80 ) a3 + ( 1438138519550.97 ) a4 + ( 61889068641537.20 )

Σx^7 ) a3 + ( Σx^8 ) a4 + ( Σx^9 )


1438138519550.97 ) a3 + ( 61889068641537.20 ) a4 + ( 2691512796076220.00 )

Σx^8 ) a3 + ( Σx^9 ) a4 + ( Σx^10 )


61889068641537.20 ) a3 + ( 2691512796076220.00 ) a4 + ( 118086611557746000.00 )

Σx^9 ) a3 + ( Σx^10 ) a4 + ( Σx^11 )


2691512796076220.00 ) a3 + ( 118086611557746000.00 ) a4 + ( 5219712519461920000.00 )
a5 + ( Σx^6 ) a6 = Σy
a5 + ( 33851021610.80 ) a6 = 390.79

a5 + ( Σx^7 ) a6 = Σxy
a5 + ( 1438138519550.97 ) a6 = 5652.34

a5 + ( Σx^8 ) a6 = Σx^2y
a5 + ( 61889068641537.20 ) a6 = 211951.66

a5 + ( Σx^9 ) a6 = Σx^3y
a5 + ( 2691512796076220.00 ) a6 = 8417472.35

a5 + ( Σx^10 ) a6 = Σx^4y
a5 + ( 118086611557746000.00 ) a6 = 345793693.58

a5 + ( Σx^11 ) a6 = Σx^5y
a5 + ( 5219712519461920000.00 ) a6 = 14515496123.93

a5 + ( Σx^12 ) a6 = Σx^6y
a5 + ( 232204126464224000000.00 ) a6 = 618883473225.72
MDETERM

n Σx Σx^2 Σx^3
Σx Σx^2 Σx^3 Σx^4
Σx^2 Σx^3 Σx^4 Σx^5
Σx^3 Σx^4 Σx^5 Σx^6
Σx^4 Σx^5 Σx^6 Σx^7
Σx^5 Σx^6 Σx^7 Σx^8
Σx^6 Σx^7 Σx^8 Σx^9

15.00 390.79 13348.44 500326.98


390.79 13348.44 500326.98 19806232.98
13348.44 500326.98 19806232.98 809880339.17
500326.98 19806232.98 809880339.17 33851021610.80
19806232.98 809880339.17 33851021610.80 1438138519550.97
809880339.17 33851021610.80 1438138519550.97 61889068641537.20
33851021610.80 1438138519550.97 61889068641537.20 2691512796076220.00

CONSTANTES
15 390.792 13348.441374 390.792
390.792 13348.441374 500326.98172386 5652.34476
13348.441374 500326.98172386 19806232.975096 211951.657962262
Σx^5 390.792 13348.441374
A0= Σx^6 13348.441374 500326.98172386 =
Σx^7 500326.98172386 19806232.975096
MDETERM 27491160925.9431

15 Σx^5 13348.441374
A1= 390.792 Σx^6 500326.98172386 =
13348.441374 Σx^7 19806232.975096
MDETERM 27491160925.9431

15 390.792 390.792
A2= 390.792 13348.441374 5652.34476 =
13348.441374 500326.98172386 211951.657962262
MDETERM 27491160925.9431
CONSTANTINO
Σx^4 Σx^5 Σx^6 Σy
Σx^5 Σx^6 Σx^7 Σxy
Σx^6 Σx^7 Σx^8 Σx^2y
Σx^7 Σx^8 Σx^9 Σx^3y
Σx^8 Σx^9 Σx^10 Σx^4y
Σx^9 Σx^10 Σx^11 Σx^5y
Σx^10 Σx^11 Σx^12 Σx^6y

19806232.98 809880339.17 33851021610.80 175.84


809880339.17 33851021610.80 1438138519550.97 5652.34
33851021610.80 1438138519550.97 61889068641537.20 211951.66
1438138519550.97 61889068641537.20 2691512796076220.00 8417472.35
61889068641537.20 2691512796076220.00 118086611557746000.00 345793693.58
2691512796076220.00 118086611557746000.00 5219712519461920000.00 14515496123.93
118086611557746000.00 5219712519461920000.00 232204126464224000000.00 618883473225.72

MATRIZ INVERSA
0.5113 -0.0386 0.0006
-0.0386 0.0043 -0.0001
0.0006 -0.0001 0.0000
#VALUE! = #VALUE!

27491160925.9431

#VALUE! = #VALUE!

27491160925.9431

3911857968.51911 = 0.142295117294502

27491160925.9431
X X2 X3 X4
5.787416217895 0.87077958855 -0.3786578516 0.03520881296 -0.0013922257
0.87077958852 0.18793663391 -0.0672661819 0.00598775501 -0.0002313131
-0.3786578516 -0.0672661819 0.02764030462 -0.0025678968 0.00010182681
0.03520881296 0.00598775501 -0.0025678968 0.0002423965 -9.7166122E-06
-0.0013922257 -0.0002313131 0.00010182681 -9.7166122E-06 3.9259542E-07
2.5131452E-05 4.1112251E-06 -1.843739E-06 1.773885E-07 -7.212965E-09
-1.7034211E-07 -2.755021E-08 1.2531454E-08 -1.2136165E-09 4.9609581E-11

A0= 115.2512278759
A1= -8.28418813372
A2= 0.142295117295
X5 X6 MMULT
2.5131452E-05 -1.7034211E-07 A0= 2.3815421205
4.1112251E-06 -2.755021E-08 A1= -0.5057869671
-1.843739E-06 1.2531454E-08 A2= 0.2037503964
1.773885E-07 -1.2136165E-09 A3= -0.0164958143
-7.212965E-09 4.9609581E-11 A4= 0.0005770114
1.3322458E-10 -9.2047783E-13 A5= -9.044358E-06
-9.2047783E-13 6.3853078E-15 A6= 5.2221547E-08

You might also like