I would spend 55 minutes defining the problem and then five minutes solving it. (Albert Einstein)
COUNT Number of quarters considered for the given row. | SECTOR | INDUSTRY | COUNTRY Country of companies main headquarter. | AVG(R1) Average R1 ratio [(Revenue-COGS)/Revenue] | P10(R1) 10th Percentile of R1 ratio [(Revenue-COGS)/Revenue] | P25(R1) 25th Percentile of R1 ratio [(Revenue-COGS)/Revenue] | P50(R1) 50th Percentile of R1 ratio [(Revenue-COGS)/Revenue] | AVG(R2) Average R2 ratio [Net_Income/(Revenue-COGS)] | P10(R2) 10th Percentile of R2 ratio [Net_Income/(Revenue-COGS)] | P25(R2) 25th Percentile of R2 ratio [Net_Income/(Revenue-COGS)] | P50(R2) 50th Percentile of R2 ratio [Net_Income/(Revenue-COGS)] | AVG(R3) Average R3 ratio [Dividends/Net_Income] | P10(R3) 10th Percentile of R3 ratio [Dividends/Net_Income] | P25(R3) 25th Percentile of R3 ratio [Dividends/Net_Income] | P50(R3) 50th Percentile of R3 ratio [Dividends/Net_Income] | AVG(R) Average R ratio [Dividends/Revenue] | P10(R) 10th Percentile of R ratio [Dividends/Revenue] | P25(R) 25th Percentile of R ratio [Dividends/Revenue] | P50(R) 50th Percentile of R ratio [Dividends/Revenue] |
---|