financial sectoral indicators (ECB/INPI)

These data are used to position a company’s financial ratios to a cohort of similar firms, based on a comparison by industry, turnover and year of year.

Each line of this data source allows you to consult the percentiles of each sector ratio, calculated on a cohort of selected balance sheets (50 minimum) based on their sector of activity, turnover and year of year.

The distribution of percentiles is carried out on a sample sorted in ascending order. The percentiles are calculated using a continuous percentile method, following a linear regression (see PostgreSQL percentile_cont method).

The values q10/q25/q50/q75/q90 mean the 10th, 25th, 50th, 75th, 90th percentiles of the distribution:
\- Q10 represents the value below which is 10 % of the data. If this value does not exist exactly in the data, it will be determined by linear interpolation.
\- Q25, or the first quartile, represents the value below which is 25 % of the data.
\- Q50, or median, is the value that divides the data into two equal halves, i.e. 50 % of the data is less than this value.
\- Q75, or the third quartile, is the value below which is 75 % of the data.
\- Q90 is the value below which is 90 % of the data.

Sectoral ratios from INPI/ECB financial indicators

本数据集用于将单家企业的财务比率对标至同类型企业群组，依据行业分类、营业额规模与年度维度开展对比分析。
本数据集的每一行数据均可用于查询各行业比率的百分位数，该百分位数基于所选的资产负债表群组（至少50份），依据其所属行业、营业额规模与年度维度计算得出。
百分位数的分布基于升序排序后的样本进行测算，其计算采用连续百分位数法结合线性回归逻辑（详见PostgreSQL的percentile_cont函数）。
q10、q25、q50、q75、q90分别代表分布序列的第10、25、50、75、90百分位数：
- Q10：指有10%的数据小于该值。若数据中不存在恰好匹配该值的样本，则通过线性插值法确定其具体数值。
- Q25，即第一四分位数，指有25%的数据小于该值。
- Q50，即中位数，指可将数据均分为两个相等部分的数值，即有50%的数据小于该值。
- Q75，即第三四分位数，指有75%的数据小于该值。
- Q90：指有90%的数据小于该值。
本数据集的行业比率数据源自法国国家工业产权局（INPI）与欧洲中央银行（ECB）的财务指标体系