Ajustes de Ecuaciones
Ajustes de Ecuaciones
Ajustes de Ecuaciones
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 *
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
N= 8
C)
EDAD DE UN ARBOL DE 18 PULGADAS
X=DIAMETRO 18
Y=EDAD ?
Y= A0 + A1 * X
SUSTITUYENDO VALORES
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
31.4613
DATOS Xi Yi X^2 X*Y
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= 378.0515
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 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 =
Σ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
Σ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
n Σx Σx^2 A0 152.6
Σx Σx^2 Σx^3 A1 = 585.6
Σx^2 Σx^3 Σx^4 A2 2488.8
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
Σ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 =
Σ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
N= 15
Y=2.382-0.506X
X^6 x^7 X^8 X^9
(
(
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 + (
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
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
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