Correlación
-
Upload
pamee-garcia -
Category
Documents
-
view
29 -
download
2
Transcript of Correlación
CorrelaciónReactores
temperatura y absorción
Queremos saber existe una correlación entre la absorción y la temperatura en un reactor.Tenemos dos reactores. A continuación se muestran los datos:
datos reactortemperatura absorcion
x y
1 1 50.01 64.3
2 1 58.62 71.2
3 1 58.97 72.4
4 1 59.21 72.9
5 2 60.34 67
6 2 61.36 69.8
7 2 62.11 77.1
8 2 62.3 74.1
9 1 63.13 76.4
10 2 64.11 78.5
11 2 64.86 75.8
12 2 65.76 79.9
13 2 66.91 78.3
14 2 67.29 73.3
15 1 68.5 82.7
16 2 68.57 78.7
17 1 68.64 82
18 2 68.93 81.8
19 2 69.66 81.5
20 2 70.51 78.5
21 2 70.93 79.9
22 1 71.55 84.5
23 1 73.68 87.3
24 1 74.44 86.8
datos reactor x y x2 y2 xy1 1 50.01 64.3 2501.0001 4134.49 3215.6432 1 58.62 71.2 3436.3044 5069.44 4173.744
3 1 58.97 72.4 3477.4609 5241.76 4269.428
4 1 59.21 72.9 3505.8241 5314.41 4316.409
5 2 60.34 67 3640.9156 4489 4042.786 2 61.36 69.8 3765.0496 4872.04 4282.9287 2 62.11 77.1 3857.6521 5944.41 4788.6818 2 62.3 74.1 3881.29 5490.81 4616.43
9 1 63.13 76.4 3985.3969 5836.96 4823.13210 2 64.11 78.5 4110.0921 6162.25 5032.635
11 2 64.86 75.8 4206.8196 5745.64 4916.388
12 2 65.76 79.9 4324.3776 6384.01 5254.22413 2 66.91 78.3 4476.9481 6130.89 5239.05314 2 67.29 73.3 4527.9441 5372.89 4932.35715 1 68.5 82.7 4692.25 6839.29 5664.9516 2 68.57 78.7 4701.8449 6193.69 5396.45917 1 68.64 82 4711.4496 6724 5628.4818 2 68.93 81.8 4751.3449 6691.24 5638.47419 2 69.66 81.5 4852.5156 6642.25 5677.2920 2 70.51 78.5 4971.6601 6162.25 5535.03521 2 70.93 79.9 5031.0649 6384.01 5667.30722 1 71.55 84.5 5119.4025 7140.25 6045.97523 1 73.68 87.3 5428.7424 7621.29 6432.26424 1 74.44 86.8 5541.3136 7534.24 6461.392
1570.39 1854.7 103498.664 144121.51 122051.458
SCx = 743.465696SCY = 791.839583SCXY = 693.027458
r = 0.90323627r2 = 0.81583577
ao= 290582.436 17843.1767 16.2853533a1 = 16632.659 17843.1767 0.93215795
40 45 50 55 60 65 70 75 800
10
20
30
40
50
60
70
80
90
100
f(x) = 0.932157949206432 x + 16.2853532560713R² = 0.815835767623909
x Linear (x) Linear (x)
Podemos observar que el valor de R cuadrada es de 0.8158 , esto quiero decir que la correlación no es muy fuerte
Ahora los analizaremos por separado.
REACTOR 1
datos x y x2 y2 xy1 50.01 64.3 2501.0001 4134.49 3215.6432 58.62 71.2 3436.3044 5069.44 4173.7443 58.97 72.4 3477.4609 5241.76 4269.4284 59.21 72.9 3505.8241 5314.41 4316.409
5 63.13 76.4 3985.3969 5836.96 4823.1326 68.5 82.7 4692.25 6839.29 5664.957 68.64 82 4711.4496 6724 5628.488 71.55 84.5 5119.4025 7140.25 6045.9759 73.68 87.3 5428.7424 7621.29 6432.264
10 74.44 86.8 5541.3136 7534.24 6461.392
646.75 780.542399.144
5 61456.13 51031.417
SCx = 570.58825SCY = 538.105SCXY = 552.5795
r= 0.77775014r2 = 0.60489528
ao= 87963.3375 5705.8825 15.4162546a1 = 5525.795 5705.8825 0.96843827
45 50 55 60 65 70 75 800
10
20
30
40
50
60
70
80
90
100
f(x) = 0.968438274009323 x + 15.4162546284471R² = 0.994488319627089
reactor 1
En el reactor 1 existe una fuerte correlación, ya que se aproxima al 1.
Reactor 2
datos x y x2 y2 xy1 60.34 67 3640.9156 4489 4042.78
2 61.36 69.8 3765.0496 4872.04 4282.928
3 62.11 77.1 3857.6521 5944.41 4788.681
4 62.3 74.1 3881.29 5490.81 4616.435 64.11 78.5 4110.0921 6162.25 5032.6356 64.86 75.8 4206.8196 5745.64 4916.388
7 65.76 79.9 4324.3776 6384.01 5254.2248 66.91 78.3 4476.9481 6130.89 5239.053
9 67.29 73.3 4527.9441 5372.89 4932.357
10 68.57 78.7 4701.8449 6193.69 5396.45911 68.93 81.8 4751.3449 6691.24 5638.47412 69.66 81.5 4852.5156 6642.25 5677.2913 70.51 78.5 4971.6601 6162.25 5535.03514 70.93 79.9 5031.0649 6384.01 5667.307
923.64 1074.2 61099.5192 82665.38 71020.041
Reactor 2
SCx = 163.029943SCY = 243.548571SCXY = 150.463286
r= 0.75509929r2 = 0.57017493
ao= 15.4162546a1 = 0.96843827
58 60 62 64 66 68 70 720
10
20
30
40
50
60
70
80
90
f(x) = 0.922918103738349 x + 15.8397087616508R² = 0.570174932741894
reactor 2
El valor de R cuadrada nos muestra que no existe correlación en este reactor.