descending, i.e. the first (1) position was given to the powiat with the highest value of the feature or
ascending, i.e. the first (1) position was given to the powiat with the lowest value of the feature.
The powiats for whom the indicator took the same value were assigned the same position, another was left unused and the next one was assigned to the powiat with the next indicator value. For powiats in which the surveyed phenomenon did not occur, "x" was inserted instead of the position.
The summary list of positions is included in the MS Excel spreadsheet. To clarify the created ranking, the extreme positions are marked with the following colors:
- the first — in red,
- the last — in blue.
Pressing next to the powiat name displays the graph.
In MS Office 97-2003, the level of macro security should be set to "Medium" (before asking to open the workbook, you will be asked "Does the user agree to the macros within the workbook?") Or "Low" (macros will be initiated automatically) if it has not already been done.
If you are using the 2007 Office suite or later, the macro settings should be set as follows: "Disable all macros and display the notification" or "Enable all macros".
Symbols
(—) |
— |
magnitude zero. |
(0) |
— |
magnitude not zero, but less than 0.5 of a unit; |
(0,0) |
— |
magnitude not zero, but less than 0.5 of a unit. |
( . ) |
— |
data not available or not reliable. |
x |
— |
not applicable. |
# |
— |
data should not be published due to the necessity of maintaining statistical confidentiallity in accordance with the Law on Official Statistics. |
"Of which" |
— |
indicates that not all elements of the sum are given. |
Abbreviations
PLN |
= Polish zloty |
pcs |
= pieces |
vol. |
= volume |
kg |
= kilogram |
t |
= tonne |
km |
= kilometre |
m2 |
= square metre |
ha |
= hectare |
km2 |
= square kilometre |
m3 |
= cubic metre |
dam3 |
= cubic decametre |
kWh |
= kilowatt.hour |
In this publication, a MS Excel workbook was used as a tool of presenting statistical data, which contain information in the form of absolute and relative numbers (indicators).
Statistics most often and most commonly uses figures to describe the population or phenomena surveyed. The description may be aimed at presenting the size, structure or dynamics of the populations or phenomena.
The collective numerical characteristics of the statistical population are indicators.
The indicator is the quotient of two quantities corresponding to the constituent parts of a given population or representing the features of two different populations, or concerning the same population, but at different times or periods.
We distinguish three main types of indicators:
- indicators of structure,
- intensity indicators,
- indicators of dynamics.
Indicators of structure, also called structural numbers, determine the ratio of a certain size of a part of the statistical population to that of the total population.
The indicator or measure of intensity determines the ratio of the values characterizing two different populations or statistical phenomena related to each other in a certain causal or logical manner.
Indicators of dynamics express the ratio between numbers characterizing a certain size in two different periods or moments of time. They are used to study dynamic series, and so changes that occur in statistical populations over a period of time.
There are two basic measures of the dynamics of statistical population: absolute increase and relative increase.
The absolute increase is the difference between the values of the variable in consecutive periods (e.g. in consecutive years, months or days).
The relative increase is the ratio of the absolute increase to the value of the variable from the previous period. If this relative increase is multiplied by 100, we will get a percentage increase.
The absolute increase and relative increase may be positive, negative or may be equal to zero.
Indexes are the most commonly used measure of dynamics. The index is the ratio of the variable value from different periods to the value of the same variable from the determined comparative period.
Indices are the most commonly used measure of dynamics. The index is the ratio of the variable value from different periods to the value of the same variable from the determined comparative period.
Relative numbers were usually calculated based on absolute data expressed with greater accuracy than those given in the spreadsheets.
When calculating data per capita (1000 population, etc.) as of the end of the year (e.g. employment, public library collection), the population was assumed as of 31 XII, and when calculating data characterizing the size of the phenomenon during the year (e.g. vital statistics, dwellings completed) - as of 30 VI.
Automatic rounding of numbers in some cases could cause minor differences in sums of data at higher level of aggregation.
Methods for calculating the indicators included in the publication.