Sheet1RUMUS :cov(x,y) =1/10 (xi 4,7)(yi 4,3) corr(x, y) = cov(x, y) / (dev(x)dev(y)) DATADATA PERHITUNGAN RETURNCara mencari varians manual (unvr)DATAunvrtlkmbbnibbcaunvrtlkmbbnibbcanX-mXunvrtlkmbbnibbca31 des 2009110501895187748502009-20100.4932126697-0.15356200531.05114544490.329896907216068410031 des 2009110501895187748502010165001604385064502010-20110.1393939394-0.1190773067-0.0129870130.2403100775254756002010165001604385064502011188001413380080002011-20120.16223404260.2837933475-0.02631578950.1375316002011188001413380080002012218501814370091002012-20130.18993135010.18522601980.06756756760.054945054949060100201221850181437009100201326000215039509600551265600201326000215039509600Total9420088761717738000Total0.98477200170.19638005531.079410210.7626520397total126487000n-1 = 4Total9420088761717738000Mean (m)188401775.23435.47600Mean (m)0.24619300040.04909501380.26985255250.1906630099^231621750Mean (m)188401775.23435.476005623.3219719308HUBUNGAN ANTARA UNVR - BNII (X-Y)HUBUNGAN ANTARA TLKM - BBCA (X-Y)HUBUNGAN ANTARA UNVR - TLKM (X-Y)HUBUNGAN ANTARA BBNI - BBCA (X-Y)HUBUNGAN ANTARA TLKM - BBNI (X-Y)HUBUNGAN ANTARA UNVR - BBCA (X-Y)Sx0.1659711188Sx0.2183015897Sx0.1659711188Sx0.522510589Sx0.2183015897Sx5623.321972Sy0.522510589Sy0.1198562728Sy0.2183015897Sy0.1198562728Sy0.522510589Sy1955.441127cov(x,y)0.0648621461cov(x,y)-0.0168796702cov(x,y)-0.0148659016cov(x,y)0.0344848011cov(x,y)-0.0519540443cov(x,y)0.0102976195corr(x,y)0.7479347237corr(x,y)-0.6451285918corr(x,y)-0.4103002999corr(x,y)0.5506452037corr(x,y)-0.4554779594corr(x,y)0.0000000009Xi-mXYi-mY(Xi mX)(Yi mY)Xi-mXYi-mY(Xi mX)(Yi mY)Xi-mXYi-mY(Xi mX)(Yi mY)Xi-mXYi-mY(Xi mX)(Yi mY)Xi-mXYi-mY(Xi mX)(Yi mY)Xi-mXYi-mY(Xi mX)(Yi mY)0.24701966920.78129289240.1929947119-0.20265701910.1392338973-0.02821672660.2470196692-0.2026570191-0.05006026980.78129289240.13923389730.1087824543-0.20265701910.7812928924-0.15833448860.24701966920.13923389730.0343935113-0.106799061-0.28283956550.030207-0.16817232060.0496470676-0.0083492626-0.106799061-0.16817232060.0179606459-0.28283956550.0496470676-0.014042155-0.1681723206-0.28283956550.0475657861-0.1067990610.0496470676-0.0053022602-0.0839589579-0.2961683420.02486598530.2346983337-0.0531630099-0.0124772698-0.08395895790.2346983337-0.0197050275-0.296168342-0.05316300990.01574520050.2346983337-0.296168342-0.0695102163-0.0839589579-0.05316300990.0044635109-0.0562616503-0.20228498490.01138088710.136131006-0.135717955-0.0184754217-0.05626165030.136131006-0.0076589551-0.2022849849-0.1357179550.02745370450.136131006-0.2022849849-0.0275372585-0.0562616503-0.1357179550.0076357161Total =0.2594485843Total =-0.0675186807Total =-0.0594636065Total =0.1379392043Total =-0.2078161774Total =0.0411904781cov(x,y) =0.0648621461cov(x,y) =-0.0168796702cov(x,y) =-0.0148659016cov(x,y) =0.0344848011cov(x,y) =-0.0519540443cov(x,y) =0.0102976195