Spreadsheet: 830407d1684904662-what-is-the-right-arguments-as-an-array-to-calculate-correlation-for-a-lot-of-variables-correlation
Sheet: Sheet2 (2)

Main | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |  | Correlation | #01 | #02 | #03 | #04 | #05 | #06 | #07 | #08 | #09 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24
#01 | 31353698860 | 31993148698 | 32347045323 | 32724704075 | 35615921503 | 43309291965 |  | #01 | 1
#02 | 5000744000 | 9611930731 | 5783209041 | 4648800367 | 4359155470 | 5048862700 |  | #02 | -0.2970149881746219 | 1
#03 | 10662320924 | 10768784941 | 10084817430 | 10065438111 | 9741684073 | 13179153859 |  | #03 | 0.8156248226077153 | 0.04650993594254105 | 1
#04 | 10468273888 | 10319472770 | 5896451023 | 3904630720 | 5845208519 | 9041149338 |  | #04 | 0.08281907197098806 | 0.5164035525453777 | 0.5105415214796343 | 1
#05 | 15223848048 | 20516821718 | 22148985910 | 23403435611 | 24388184381 | 26137851468 |  | #05 | 0.7085833482913289 | -0.225396959415342 | 0.2990823595236392 | -0.5201412610992708 | 1
#06 | 10195553186 | 11877329244 | 13342929078 | 15340510909 | 17547391128 | 20992787274 |  | #06 | 0.9109834968150126 | -0.4308978557854041 | 0.5346910134344449 | -0.3067725564656891 | 0.9051952056231337 | 1
#07 | 10220595710 | 11926427418 | 13413291659 | 15480419688 | 17708082699 | 21182755836 |  | #07 | 0.909619715019483 | -0.4324135362408507 | 0.5322394584535532 | -0.3095951368526043 | 0.9056232212568924 | 0.9999921596709062 | 1
#08 | 3840463547 | 4877526063 | 6022404941 | 7284007661 | 7618358388 | 9259931780 |  | #08 | 0.842491991817425 | -0.4486893332156719 | 0.4507896924110816 | -0.4498514580463526 | 0.9446441019892315 | 0.9835823720001112 | 0.983985455723239 | 1
#09 | 6380132163 | 7048901355 | 7390886718 | 8196412027 | 10089724311 | 11922824056 |  | #09 | 0.9460648266786011 | -0.4046400940512712 | 0.5930334115772959 | -0.1693487897918362 | 0.842838496494345 | 0.9863487968943732 | 0.9859864968447999 | 0.9404599965548089 | 1
#10 | -571885192 | 2544158141 | 2819983070 | 3397823729 | 3778377767 | 5088018578 |  | #10 | 0.7299917431236306 | -0.1123364672119283 | 0.37407536419232 | -0.4255854649607092 | 0.9910637953998307 | 0.8920211026794679 | 0.8921419441873769 | 0.9236893757720819 | 0.8367426894440166 | 1
#11 | -1180475670 | 1359691272 | 1981858588 | 2966339860 | 3494688084 | 4164876660 |  | #11 | 0.7066224601527187 | -0.2538650997492602 | 0.2814854636237881 | -0.5317530535187768 | 0.9971736164979316 | 0.9139678771185524 | 0.9146091844374268 | 0.951463745425609 | 0.853591335842268 | 0.9846819702445543 | 1
#12 | 197613719 | -418095793 | -527258068 | -741198704 | -964958593 | -1122839274 |  | #12 | -0.7412571201989272 | 0.2478796751937855 | -0.313317621851296 | 0.4784964138056306 | -0.9928190688126094 | -0.9310640564459804 | -0.9315477523869082 | -0.9544322933740633 | -0.883113364386761 | -0.9830959964125303 | -0.9967998918127419 | 1
#13 | -982861951 | 941595479 | 1454600520 | 2225141156 | 2529729491 | 3042037386 |  | #13 | 0.6943998144726483 | -0.2554597956297369 | 0.2707583585210986 | -0.5483196859662888 | 0.9972153417316851 | 0.9071565905846359 | 0.9078482098761197 | 0.9491897315598535 | 0.842827041167107 | 0.9838416126499085 | 0.9996628533275782 | -0.9943882538254178 | 1
#14 | 3090357922 | 2498524371 | 4787087216 | 5699392105 | 5596559049 | 8207526452 |  | #14 | 0.8683830825641398 | -0.6021064659210055 | 0.542552215621475 | -0.389563330699936 | 0.8236226746222292 | 0.9445416912760848 | 0.9445800860233132 | 0.9542652661189022 | 0.9081211770450186 | 0.7922089223449531 | 0.8256460757526689 | -0.8275369648559632 | 0.8238953033461272 | 1
#15 | -10213415270 | -6810125820 | -2620673382 | -3048988374 | -5682429817 | -5812675134 |  | #15 | 0.07465628287435697 | -0.135867061263712 | -0.2186620948044308 | -0.8269668686012601 | 0.6824460254902038 | 0.3726156603963266 | 0.3738193314410186 | 0.519036695038805 | 0.227067274568407 | 0.6458848564875169 | 0.6573420553494793 | -0.6019190305188427 | 0.6744394804741165 | 0.4318798452948055 | 1
#16 | 7353387181 | 3890792414 | -973062773 | -2935799536 | 240434737 | -2486662271 |  | #16 | -0.52163370048085 | 0.3606803809267774 | -0.1669884361828707 | 0.7338198619829774 | -0.9049662562642983 | -0.7632124158473128 | -0.7642371104512296 | -0.8644655950144253 | -0.6482678992892318 | -0.8726743111873486 | -0.8954268599031031 | 0.8603119599606703 | -0.905600122463194 | -0.8086067864878936 | -0.865575641755402 | 1
#17 | 230329833 | -420809035 | 1193351061 | -285395805 | 154563969 | -91810953 |  | #17 | -0.1843831054368142 | -0.281399446276601 | -0.2782853722645411 | -0.2344529124226304 | -0.1040070978181894 | -0.1694544119076857 | -0.1706912495028662 | -0.1391294295579034 | -0.1952799949795363 | -0.1658941825249494 | -0.1505020643931269 | 0.1645119305478041 | -0.145744246819616 | -0.004638045626833873 | 0.295723438849638 | -0.05718946805617157 | 1
#18 | 16519307605 | 12855586796 | 17029658512 | 19822671759 | 20790317296 | 25407492485 |  | #18 | 0.8676523428674998 | -0.7102797368226695 | 0.5431780033595762 | -0.2972172565626289 | 0.7010954385807574 | 0.9123383851023364 | 0.9124970291201278 | 0.8931975053540359 | 0.9040957127696061 | 0.6596042436801143 | 0.7159596671387775 | -0.7293785770868174 | 0.7106153958713479 | 0.9677457196182025 | 0.2266043894064013 | -0.658223083681779 | -0.05471095957377597 | 1
#19 | 507758232 | 1497768124 | 2763961848 | 3905950912 | 4358948040 | 4781553708 |  | #19 | 0.7217034010875095 | -0.4877175314652265 | 0.2530744671192504 | -0.6046732544280302 | 0.9568406333577437 | 0.9405665259801297 | 0.9415554944132624 | 0.9775691797136262 | 0.8805431424285508 | 0.9173985549630208 | 0.9679041995765694 | -0.9639881573025791 | 0.9678437831021116 | 0.9036697456779673 | 0.6160539654170126 | -0.897391522256124 | -0.0841605193138388 | 0.8356027649879865 | 1
#20 | -5661576924 | -1156854210 | -4301608389 | -5416637744 | -5382528603 | -8130291159 |  | #20 | -0.7049902084594308 | 0.8349070305327563 | -0.5109639071403544 | 0.1630806368584486 | -0.3587521848093708 | -0.6654099393822053 | -0.6653634574929481 | -0.6344915411045079 | -0.6749601762214328 | -0.3027800438463151 | -0.3735543052908058 | 0.3859427611462165 | -0.3690160961196703 | -0.8170720912157597 | 0.003561882800930498 | 0.402386020188925 | -0.08882193079752407 | -0.9105036062648081 | -0.5591380392874539 | 1
#21 | 2832373639 | 2358164559 | 2421727441 | 2803224264 | 2500898277 | 3556657604 |  | #21 | 0.8120161007536743 | -0.4298452810002498 | 0.8565536817920468 | 0.1868591557229813 | 0.3295337394644725 | 0.6377307408898857 | 0.636783072477145 | 0.5864048899727282 | 0.6654648176974476 | 0.3450623786841741 | 0.3358175660585441 | -0.3533575228084537 | 0.3296580120501043 | 0.7397148788926415 | -0.1472612240523529 | -0.3141225015165355 | -0.2594212322577926 | 0.7985866582108649 | 0.4275581708195101 | -0.8418463936807443 | 1
#22 | 13303773192 | 9308650191 | 7407760598 | 8748380479 | 11278988866 | 14020201586 |  | #22 | 0.5984171588774865 | -0.3267883375459917 | 0.6519012849087561 | 0.5630440572459019 | -0.07337535258638017 | 0.3455230442963204 | 0.3442916111788474 | 0.1996622429335519 | 0.4696669139777242 | -0.05954002671723661 | -0.04549175744990308 | -0.01406051815015757 | -0.06477270183354832 | 0.3266324887600234 | -0.7113955234298136 | 0.2769809847447807 | -0.3135084208763146 | 0.5166118944308777 | 0.05857150477810361 | -0.6404015867978063 | 0.7307096081138965 | 1
#23 | 13227471578 | 13016599692 | 6416069991 | 4172276750 | 5558570884 | 5282622648 |  | #23 | -0.4922224588237631 | 0.6256529057352977 | -0.03251931376258076 | 0.8235934245182086 | -0.8427015563443921 | -0.7705876823253955 | -0.7721318318514779 | -0.8600877915161211 | -0.6674196623945458 | -0.772191682740833 | -0.8473015788779394 | 0.8181833687487534 | -0.8555932660179864 | -0.8380468332537089 | -0.7809064218841705 | 0.9431919614039437 | -0.1522315950490458 | -0.7505246185097595 | -0.9220198857477625 | 0.5563129577898256 | -0.3103958790973472 | 0.1653145240377772 | 1
#24 | 15223848048 | 20516821718 | 22148985911 | 23403435611 | 24388184381 | 26137851468 |  | #24 | 0.7085833482640611 | -0.2253969594136878 | 0.2990823594950646 | -0.5201412611302424 | 1 | 0.905195205600496 | 0.9056232212341206 | 0.9446441019746498 | 0.8428384964645683 | 0.9910637953967679 | 0.9971736164913925 | -0.9928190688024854 | 0.9972153417263199 | 0.8236226746152885 | 0.6824460255468883 | -0.9049662562858156 | -0.1040070977214826 | 0.7010954385582207 | 0.956840633349047 | -0.358752184792203 | 0.3295337394254327 | -0.07337535265118941 | -0.8427015563619842 | 1
 |  |  |  |  |  |  |  | Required Result
 |  |  |  |  |  |  |  | Please, I would like to have a formula inside the below table to calculate the correlation for all items, I mean something like the formulas in the earlier posts by other valuable members who thankfully put time and effort to help me, or something else, as you wish :)
 |  |  |  |  |  |  |  | Correlation | #01 | #02 | #03 | #04 | #05 | #06 | #07 | #08 | #09 | #10 | #11 | #12 | #13 | #14 | #15 | #16 | #17 | #18 | #19 | #20 | #21 | #22 | #23 | #24
 |  |  |  |  |  |  |  | #01
 |  |  |  |  |  |  |  | #02
 |  |  |  |  |  |  |  | #03
 |  |  |  |  |  |  |  | #04
 |  |  |  |  |  |  |  | #05
 |  |  |  |  |  |  |  | #06
 |  |  |  |  |  |  |  | #07
 |  |  |  |  |  |  |  | #08
 |  |  |  |  |  |  |  | #09
 |  |  |  |  |  |  |  | #10
 |  |  |  |  |  |  |  | #11
 |  |  |  |  |  |  |  | #12
 |  |  |  |  |  |  |  | #13
 |  |  |  |  |  |  |  | #14
 |  |  |  |  |  |  |  | #15
 |  |  |  |  |  |  |  | #16
 |  |  |  |  |  |  |  | #17
 |  |  |  |  |  |  |  | #18
 |  |  |  |  |  |  |  | #19
 |  |  |  |  |  |  |  | #20
 |  |  |  |  |  |  |  | #21
 |  |  |  |  |  |  |  | #22
 |  |  |  |  |  |  |  | #23
 |  |  |  |  |  |  |  | #24