Download - CORRELACION.xlsx
7/23/2019 CORRELACION.xlsx
http://slidepdf.com/reader/full/correlacionxlsx 1/5
N° Xi Yi XiYi001 10 21 100 441 210
002 28 65 784 4,225 1,820
003 12 19 144 361 228
004 31 72 961 5,184 2,232005 30 75 900 5,625 2,250
006 19 39 361 1,521 741
007 24 67 576 4,489 1,608
008 5 11 25 121 55
009 9 12 81 144 108
010 15 24 225 576 360
011 20 35 400 1,225 700
012 10 15 100 225 150
013 15 22 225 484 330
014 5 12 25 144 60015 11 20 121 400 220
016 15 20 225 400 300
017 16 22 256 484 352
018 5 10 25 100 50
019 4 10 16 100 40
020 15 26 225 676 390
021 18 25 324 625 450
TOTAL 317 622 6,099 27,550 12,654
X2i Y 2i
7/23/2019 CORRELACION.xlsx
http://slidepdf.com/reader/full/correlacionxlsx 2/5
R= 622
15.0952381
0.94280618
7/23/2019 CORRELACION.xlsx
http://slidepdf.com/reader/full/correlacionxlsx 3/5
15.0952381
7/23/2019 CORRELACION.xlsx
http://slidepdf.com/reader/full/correlacionxlsx 4/5
CUADRO
X Y Z A B C
25 25 12 12 5 8
35 26 15 10 6 8
30 28 16 0 4 8
34 29 15 8 8 8
36 30 16 6 9 8
38 31 18 5 6 8
39 32 19 12 3 8
34 28 18 14 6 8
35 29 17 16 11 8
20 22 14 14 12 8
31 24 13 15 10 8
15 25 15 13 12 8
16 26 17 11 15 8
18 28 12 6 14 8
26 27 18 8 10 8
432 410 235 150 131 120
5
7/23/2019 CORRELACION.xlsx
http://slidepdf.com/reader/full/correlacionxlsx 5/5
°1
585,299,375 1,602,202.18
1,455,084,224 2,320,868.22
-481,890,304 #D!"0
470,546,279 2,650,223.33
35,411,904 3,123,685.28
-138,934,081 2,963,469.09
3,986,588,672 2,321,562.64
4,216,389,632 2,307,084.30
5,205,522,279 2,963,739.13
870,069,696 2,419,010.06
2,147,586,624 2,401,562.25
303,419,375 2,249,917.50
264,016,320 3,167,251.66
-374,394,880 3,008,700.20
509,701,815 2,890,814.11
19054416930 #D!"0
( )( 10)−Y6