Spreadsheet: 828465d1683534081-what-is-the-right-arguments-as-an-array-to-calculate-correlation-for-a-lot-of-variables-realfilerealnumbers
Sheet: Sheet1

Correlation | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | No. | Item | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
1 | *=CORREL( |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | non-current assets | 586659031 | 480343056 | 20473172 | 605840237 | 322747307.5 | 282514680.9
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Current assets | 759051269 | 498365688 | 395887621 | 554353871 | 372772047 | 301115020.9
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | current liabilities | 554603731 | 413440842 | 653946455 | 484659284 | 534330646 | 537397873.2
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Non-current liabilities | 102298199 | 858026168 | 111387132 | 410342401 | 414886867.5 | 432636224.5
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Ownership rights | 826522204 | 873292758 | 320363304 | 389108069 | 136028619 | -50488566.8999999
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Sales revenue, operating revenue, activity revenue | 512718869.6 | 968361667.6 | 394995469.3 | 315618030.6 | 256756330.45 | 140289458.92
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | revenue | Total Revenues | 722623185 | 34417935 | 579008782 | 333651085 | 261843883.5 | 199611338.2
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Cost of Goods Sold Activity expenses, activity costs, operating costs, cost of obtaining revenue | COGS | 607374660.685714 | 598330946.685714 | 545185901.557143 | 243426089.4 | 212331709.835714 | 97832633.9371428
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Gross Profit / (Loss) Gross Profit Activity | Gross Profit | 614058451.264286 | 600547679.264286 | 593051593.542857 | 193797862.55 | 183294433.689285 | 56466648.5028569
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Earnings / (losses) activity Earnings / (losses) before interest and taxes, operating profits / (losses) | EBIT | 620742241.842857 | 602764411.842857 | 640917285.528572 | 144169635.7 | 154257157.542857 | 15100663.0685719
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Profits/(losses) of activity before taxes | EBT | 627426032.421429 | 604981144.421429 | 688782977.514286 | 94541408.85 | 125219881.396428 | -26265322.3657141
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | taxes owed | Tax | 634109823 | 607197877 | 736648669.5 | 44913182 | 96182605.2500002 | -67631307.8000001
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | Net profit / (loss) net profit / (loss) activity after taxes | net profit | 640793613.578571 | 609414609.578571 | 784514361.485714 | -4715044.85000002 | 67145329.1035712 | -108997293.234285
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Net cash flows from operating activities | 647477404.157143 | 611631342.157143 | 832380053.471429 | -54343271.6999999 | 38108052.9571432 | -150363278.668571
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | Net cash flows used in investing activities | 654161194.735714 | 613848074.735714 | 880245745.457143 | -103971498.55 | 9070776.81071424 | -191729264.102857
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Net cash flows used in financing activities | 660844985.314285 | 616064807.314286 | 928111437.442857 | -153599725.4 | -19966499.3357148 | -233095249.537143
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | Net change in cash and cash equivalents during a period | 667528775.892857 | 618281539.892857 | 975977129.428572 | -203227952.25 | -49003775.4821427 | -274461234.971428
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | total investment | 674212566.471428 | 620498272.471429 | 1023842821.41429 | -252856179.1 | -78041051.6285717 | -315827220.405714
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | Earnings before interest, taxes, depreciation, and amortization (EBITDA) | 680896357.049999 | 622715005.05 | 1071708513.4 | -302484405.95 | -107078327.775 | -357193205.84
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | working capital | 687580147.628571 | 624931737.628572 | 1119574205.38571 | -352112632.8 | -136115603.921429 | -398559191.274285
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | Capital Expenditures (CAPEX) | 694263938.207142 | 627148470.207143 | 1167439897.37143 | -401740859.65 | -165152880.067857 | -439925176.708571
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Free cash flow | 700947728.785714 | 629365202.785714 | 1215305589.35714 | -451369086.5 | -194190156.214286 | -481291162.142857
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | net debt | 707631519.364285 | 631581935.364286 | 1263171281.34285 | -500997313.35 | -223227432.360715 | -522657147.577142
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | Net financial value | 714315309.942857 | 633798667.942857 | 1311036973.32857 | -550625540.2 | -252264708.507143 | -564023133.011428