Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 16 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 KiB |
| Average record size in memory | 152.0 B |
Variable types
| NUM | 13 |
|---|---|
| CAT | 5 |
Aktualisierung has constant value "16" | Constant |
LAN_ew_AGS is highly correlated with OBJECTID_1 and 1 other fields | High correlation |
OBJECTID_1 is highly correlated with LAN_ew_AGS and 1 other fields | High correlation |
Fallzahl is highly correlated with LAN_ew_EWZ and 3 other fields | High correlation |
LAN_ew_EWZ is highly correlated with Fallzahl and 3 other fields | High correlation |
AGS_TXT is highly correlated with OBJECTID_1 and 1 other fields | High correlation |
Death is highly correlated with LAN_ew_EWZ and 3 other fields | High correlation |
cases7_bl is highly correlated with LAN_ew_EWZ and 3 other fields | High correlation |
death7_bl is highly correlated with LAN_ew_EWZ and 3 other fields | High correlation |
OBJECTID_1 has unique values | Unique |
LAN_ew_AGS has unique values | Unique |
LAN_ew_GEN has unique values | Unique |
LAN_ew_EWZ has unique values | Unique |
OBJECTID has unique values | Unique |
Fallzahl has unique values | Unique |
AGS_TXT has unique values | Unique |
GlobalID has unique values | Unique |
faelle_100000_EW has unique values | Unique |
Death has unique values | Unique |
cases7_bl_per_100k has unique values | Unique |
cases7_bl has unique values | Unique |
death7_bl has unique values | Unique |
cases7_bl_per_100k_txt has unique values | Unique |
SHAPE_Length has unique values | Unique |
SHAPE_Area has unique values | Unique |
Reproduction
| Analysis started | 2020-12-29 12:33:35.935308 |
|---|---|
| Analysis finished | 2020-12-29 12:33:55.752317 |
| Duration | 19.82 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.75 |
| Q1 | 4.75 |
| median | 8.5 |
| Q3 | 12.25 |
| 95-th percentile | 15.25 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 7.5 |
Descriptive statistics
| Standard deviation | 4.760952286 |
|---|---|
| Coefficient of variation (CV) | 0.5601120336 |
| Kurtosis | -1.2 |
| Mean | 8.5 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0 |
| Sum | 136 |
| Variance | 22.66666667 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% | |
| 11 | 1 | 6.2% | |
| 10 | 1 | 6.2% | |
| 9 | 1 | 6.2% | |
| 8 | 1 | 6.2% | |
| 7 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 6.2% | |
| 2 | 1 | 6.2% | |
| 3 | 1 | 6.2% | |
| 4 | 1 | 6.2% | |
| 5 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.75 |
| Q1 | 4.75 |
| median | 8.5 |
| Q3 | 12.25 |
| 95-th percentile | 15.25 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 7.5 |
Descriptive statistics
| Standard deviation | 4.760952286 |
|---|---|
| Coefficient of variation (CV) | 0.5601120336 |
| Kurtosis | -1.2 |
| Mean | 8.5 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0 |
| Sum | 136 |
| Variance | 22.66666667 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% | |
| 11 | 1 | 6.2% | |
| 10 | 1 | 6.2% | |
| 9 | 1 | 6.2% | |
| 8 | 1 | 6.2% | |
| 7 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 6.2% | |
| 2 | 1 | 6.2% | |
| 3 | 1 | 6.2% | |
| 4 | 1 | 6.2% | |
| 5 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.0 B |
| Mecklenburg-Vorpommern | 1 |
|---|---|
| Thüringen | 1 |
| Bremen | 1 |
| Baden-Württemberg | 1 |
| Saarland | 1 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| Mecklenburg-Vorpommern | 1 | 6.2% | |
| Thüringen | 1 | 6.2% | |
| Bremen | 1 | 6.2% | |
| Baden-Württemberg | 1 | 6.2% | |
| Saarland | 1 | 6.2% | |
| Sachsen | 1 | 6.2% | |
| Hamburg | 1 | 6.2% | |
| Schleswig-Holstein | 1 | 6.2% | |
| Bayern | 1 | 6.2% | |
| Sachsen-Anhalt | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
Frequencies of value counts
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 22 |
|---|---|
| Median length | 10 |
| Mean length | 11.5 |
| Min length | 6 |
LAN_ew_BEZ
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 25.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.0 B |
| Land | |
|---|---|
| Freistaat | |
| Freie und Hansestadt | 1 |
| Freie Hansestadt | 1 |
| Value | Count | Frequency (%) | |
| Land | 11 | 68.8% | |
| Freistaat | 3 | 18.8% | |
| Freie und Hansestadt | 1 | 6.2% | |
| Freie Hansestadt | 1 | 6.2% |
Frequencies of value counts
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 12.5% |
Histogram of lengths of the category
Length
| Max length | 20 |
|---|---|
| Median length | 4 |
| Mean length | 6.6875 |
| Min length | 4 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5197919.438 |
|---|---|
| Minimum | 681202 |
| Maximum | 17947221 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 681202 |
|---|---|
| 5-th percentile | 910465.75 |
| Q1 | 2061846.75 |
| median | 3286632 |
| Q3 | 6714462 |
| 95-th percentile | 14330358 |
| Maximum | 17947221 |
| Range | 17266019 |
| Interquartile range (IQR) | 4652615.25 |
Descriptive statistics
| Standard deviation | 4947234.003 |
|---|---|
| Coefficient of variation (CV) | 0.9517719662 |
| Kurtosis | 1.76745119 |
| Mean | 5197919.438 |
| Median Absolute Deviation (MAD) | 1558936.5 |
| Skewness | 1.544805277 |
| Sum | 83166711 |
| Variance | 2.447512428e+13 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 2194782 | 1 | 6.2% | |
| 2903773 | 1 | 6.2% | |
| 1608138 | 1 | 6.2% | |
| 17947221 | 1 | 6.2% | |
| 1847253 | 1 | 6.2% | |
| 3669491 | 1 | 6.2% | |
| 681202 | 1 | 6.2% | |
| 6288080 | 1 | 6.2% | |
| 4093903 | 1 | 6.2% | |
| 11100394 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 681202 | 1 | 6.2% | |
| 986887 | 1 | 6.2% | |
| 1608138 | 1 | 6.2% | |
| 1847253 | 1 | 6.2% | |
| 2133378 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 17947221 | 1 | 6.2% | |
| 13124737 | 1 | 6.2% | |
| 11100394 | 1 | 6.2% | |
| 7993608 | 1 | 6.2% | |
| 6288080 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.75 |
| Q1 | 4.75 |
| median | 8.5 |
| Q3 | 12.25 |
| 95-th percentile | 15.25 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 7.5 |
Descriptive statistics
| Standard deviation | 4.760952286 |
|---|---|
| Coefficient of variation (CV) | 0.5601120336 |
| Kurtosis | -1.2 |
| Mean | 8.5 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0 |
| Sum | 136 |
| Variance | 22.66666667 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% | |
| 11 | 1 | 6.2% | |
| 10 | 1 | 6.2% | |
| 9 | 1 | 6.2% | |
| 8 | 1 | 6.2% | |
| 7 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 6.2% | |
| 2 | 1 | 6.2% | |
| 3 | 1 | 6.2% | |
| 4 | 1 | 6.2% | |
| 5 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104045.375 |
|---|---|
| Minimum | 11168 |
| Maximum | 383008 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 11168 |
|---|---|
| 5-th percentile | 12736.25 |
| Q1 | 26761.5 |
| median | 54835.5 |
| Q3 | 127866.75 |
| 95-th percentile | 331952.5 |
| Maximum | 383008 |
| Range | 371840 |
| Interquartile range (IQR) | 101105.25 |
Descriptive statistics
| Standard deviation | 112744.1674 |
|---|---|
| Coefficient of variation (CV) | 1.083605758 |
| Kurtosis | 1.612359809 |
| Mean | 104045.375 |
| Median Absolute Deviation (MAD) | 40591.5 |
| Skewness | 1.550408578 |
| Sum | 1664726 |
| Variance | 1.271124729e+10 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 39647 | 1 | 6.2% | |
| 37820 | 1 | 6.2% | |
| 126421 | 1 | 6.2% | |
| 231686 | 1 | 6.2% | |
| 314934 | 1 | 6.2% | |
| 11168 | 1 | 6.2% | |
| 35484 | 1 | 6.2% | |
| 19341 | 1 | 6.2% | |
| 132204 | 1 | 6.2% | |
| 13259 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 11168 | 1 | 6.2% | |
| 13259 | 1 | 6.2% | |
| 19341 | 1 | 6.2% | |
| 23784 | 1 | 6.2% | |
| 27754 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 383008 | 1 | 6.2% | |
| 314934 | 1 | 6.2% | |
| 231686 | 1 | 6.2% | |
| 132204 | 1 | 6.2% | |
| 126421 | 1 | 6.2% |
| Distinct | 1 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.0 B |
| 2020/12/28 23:00:00 |
|---|
| Value | Count | Frequency (%) | |
| 2020/12/28 23:00:00 | 16 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1.75 |
| Q1 | 4.75 |
| median | 8.5 |
| Q3 | 12.25 |
| 95-th percentile | 15.25 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 7.5 |
Descriptive statistics
| Standard deviation | 4.760952286 |
|---|---|
| Coefficient of variation (CV) | 0.5601120336 |
| Kurtosis | -1.2 |
| Mean | 8.5 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0 |
| Sum | 136 |
| Variance | 22.66666667 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% | |
| 11 | 1 | 6.2% | |
| 10 | 1 | 6.2% | |
| 9 | 1 | 6.2% | |
| 8 | 1 | 6.2% | |
| 7 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 6.2% | |
| 2 | 1 | 6.2% | |
| 3 | 1 | 6.2% | |
| 4 | 1 | 6.2% | |
| 5 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 16 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 14 | 1 | 6.2% | |
| 13 | 1 | 6.2% | |
| 12 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.0 B |
| {3A3E2817-BB19-4F8C-8BCA-D8FF591140D4} | 1 |
|---|---|
| {80394DDF-C6A4-4A6E-BE8E-0259A81B22A9} | 1 |
| {1FF920F4-62CD-4A4F-B8C9-F042F2A3E00A} | 1 |
| {3FD77024-C29B-4843-9BE8-682AD48E60C9} | 1 |
| {FC5BA936-C95C-432C-8A33-9EB2F30B660F} | 1 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| {3A3E2817-BB19-4F8C-8BCA-D8FF591140D4} | 1 | 6.2% | |
| {80394DDF-C6A4-4A6E-BE8E-0259A81B22A9} | 1 | 6.2% | |
| {1FF920F4-62CD-4A4F-B8C9-F042F2A3E00A} | 1 | 6.2% | |
| {3FD77024-C29B-4843-9BE8-682AD48E60C9} | 1 | 6.2% | |
| {FC5BA936-C95C-432C-8A33-9EB2F30B660F} | 1 | 6.2% | |
| {93277AC4-E8FC-48C7-8940-028DC2ED66AF} | 1 | 6.2% | |
| {4132268B-54DE-4327-AC1E-760E915112F1} | 1 | 6.2% | |
| {256D2405-A7C8-4FEC-93DF-29F3C808CD25} | 1 | 6.2% | |
| {0F3E860C-5181-4D3F-A421-1D51F50315EA} | 1 | 6.2% | |
| {E9B4296F-9BE2-4E53-9A58-CCF1396CB03D} | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
Frequencies of value counts
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 38 |
|---|---|
| Median length | 38 |
| Mean length | 38 |
| Min length | 38 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1835.829998 |
|---|---|
| Minimum | 694.4677633 |
| Maximum | 3104.663565 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 694.4677633 |
|---|---|
| 5-th percentile | 787.9211581 |
| Q1 | 1449.228344 |
| median | 1933.659356 |
| Q3 | 2110.36055 |
| 95-th percentile | 2706.44723 |
| Maximum | 3104.663565 |
| Range | 2410.195801 |
| Interquartile range (IQR) | 661.132206 |
Descriptive statistics
| Standard deviation | 622.4520244 |
|---|---|
| Coefficient of variation (CV) | 0.3390575516 |
| Kurtosis | 0.2574221869 |
| Mean | 1835.829998 |
| Median Absolute Deviation (MAD) | 328.6027995 |
| Skewness | -0.07302979954 |
| Sum | 29373.27997 |
| Variance | 387446.5227 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 2573.708452 | 1 | 6.2% | |
| 1959.798842 | 1 | 6.2% | |
| 1946.412371 | 1 | 6.2% | |
| 1264.544725 | 1 | 6.2% | |
| 1858.414214 | 1 | 6.2% | |
| 819.0722897 | 1 | 6.2% | |
| 2087.187176 | 1 | 6.2% | |
| 3104.663565 | 1 | 6.2% | |
| 2134.0797 | 1 | 6.2% | |
| 1920.90634 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 694.4677633 | 1 | 6.2% | |
| 819.0722897 | 1 | 6.2% | |
| 1264.544725 | 1 | 6.2% | |
| 1297.912032 | 1 | 6.2% | |
| 1499.667115 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 3104.663565 | 1 | 6.2% | |
| 2573.708452 | 1 | 6.2% | |
| 2399.545225 | 1 | 6.2% | |
| 2134.0797 | 1 | 6.2% | |
| 2102.454167 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1936.125 |
|---|---|
| Minimum | 152 |
| Maximum | 6398 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 152 |
|---|---|
| 5-th percentile | 177.5 |
| Q1 | 502 |
| median | 1039.5 |
| Q3 | 2646 |
| 95-th percentile | 6269.75 |
| Maximum | 6398 |
| Range | 6246 |
| Interquartile range (IQR) | 2144 |
Descriptive statistics
| Standard deviation | 2074.706594 |
|---|---|
| Coefficient of variation (CV) | 1.07157678 |
| Kurtosis | 0.7351050266 |
| Mean | 1936.125 |
| Median Absolute Deviation (MAD) | 728.5 |
| Skewness | 1.372522317 |
| Sum | 30978 |
| Variance | 4304407.45 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 6398 | 1 | 6.2% | |
| 907 | 1 | 6.2% | |
| 412 | 1 | 6.2% | |
| 1851 | 1 | 6.2% | |
| 186 | 1 | 6.2% | |
| 152 | 1 | 6.2% | |
| 532 | 1 | 6.2% | |
| 598 | 1 | 6.2% | |
| 1172 | 1 | 6.2% | |
| 6227 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 152 | 1 | 6.2% | |
| 186 | 1 | 6.2% | |
| 394 | 1 | 6.2% | |
| 412 | 1 | 6.2% | |
| 532 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 6398 | 1 | 6.2% | |
| 6227 | 1 | 6.2% | |
| 4587 | 1 | 6.2% | |
| 2838 | 1 | 6.2% | |
| 2582 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 149.0437824 |
|---|---|
| Minimum | 77.23217784 |
| Maximum | 364.6636973 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 77.23217784 |
|---|---|
| 5-th percentile | 83.181839 |
| Q1 | 107.5034273 |
| median | 137.0907519 |
| Q3 | 150.6432661 |
| 95-th percentile | 296.4389702 |
| Maximum | 364.6636973 |
| Range | 287.4315194 |
| Interquartile range (IQR) | 43.13983885 |
Descriptive statistics
| Standard deviation | 73.9015617 |
|---|---|
| Coefficient of variation (CV) | 0.4958379378 |
| Kurtosis | 4.559253196 |
| Mean | 149.0437824 |
| Median Absolute Deviation (MAD) | 24.16977948 |
| Skewness | 2.044894744 |
| Sum | 2384.700518 |
| Variance | 5461.440821 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 135.3744984 | 1 | 6.2% | |
| 145.1154942 | 1 | 6.2% | |
| 139.056755 | 1 | 6.2% | |
| 161.5346654 | 1 | 6.2% | |
| 138.8070053 | 1 | 6.2% | |
| 85.16505939 | 1 | 6.2% | |
| 90.42838982 | 1 | 6.2% | |
| 364.6636973 | 1 | 6.2% | |
| 77.23217784 | 1 | 6.2% | |
| 131.3220257 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 77.23217784 | 1 | 6.2% | |
| 85.16505939 | 1 | 6.2% | |
| 87.21968853 | 1 | 6.2% | |
| 90.42838982 | 1 | 6.2% | |
| 113.1951065 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 364.6636973 | 1 | 6.2% | |
| 273.6973945 | 1 | 6.2% | |
| 172.1811096 | 1 | 6.2% | |
| 161.5346654 | 1 | 6.2% | |
| 147.0127997 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7755.9375 |
|---|---|
| Minimum | 616 |
| Maximum | 24912 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 616 |
|---|---|
| 5-th percentile | 1085.5 |
| Q1 | 2377.5 |
| median | 5174 |
| Q3 | 10270.25 |
| 95-th percentile | 22128.75 |
| Maximum | 24912 |
| Range | 24296 |
| Interquartile range (IQR) | 7892.75 |
Descriptive statistics
| Standard deviation | 7515.281857 |
|---|---|
| Coefficient of variation (CV) | 0.9689714309 |
| Kurtosis | 0.5351574545 |
| Mean | 7755.9375 |
| Median Absolute Deviation (MAD) | 3326.5 |
| Skewness | 1.263587408 |
| Sum | 124095 |
| Variance | 56479461.4 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 16319 | 1 | 6.2% | |
| 6972 | 1 | 6.2% | |
| 1242 | 1 | 6.2% | |
| 3414 | 1 | 6.2% | |
| 616 | 1 | 6.2% | |
| 1296 | 1 | 6.2% | |
| 21201 | 1 | 6.2% | |
| 24912 | 1 | 6.2% | |
| 5839 | 1 | 6.2% | |
| 5325 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 616 | 1 | 6.2% | |
| 1242 | 1 | 6.2% | |
| 1296 | 1 | 6.2% | |
| 2091 | 1 | 6.2% | |
| 2473 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 24912 | 1 | 6.2% | |
| 21201 | 1 | 6.2% | |
| 16319 | 1 | 6.2% | |
| 14849 | 1 | 6.2% | |
| 8744 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.625 |
|---|---|
| Minimum | 3 |
| Maximum | 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4.5 |
| Q1 | 13.25 |
| median | 33.5 |
| Q3 | 50.25 |
| 95-th percentile | 93.75 |
| Maximum | 108 |
| Range | 105 |
| Interquartile range (IQR) | 37 |
Descriptive statistics
| Standard deviation | 30.35319862 |
|---|---|
| Coefficient of variation (CV) | 0.8067295315 |
| Kurtosis | 0.6187512943 |
| Mean | 37.625 |
| Median Absolute Deviation (MAD) | 19.5 |
| Skewness | 1.003663497 |
| Sum | 602 |
| Variance | 921.3166667 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 30 | 1 | 6.2% | |
| 28 | 1 | 6.2% | |
| 89 | 1 | 6.2% | |
| 23 | 1 | 6.2% | |
| 54 | 1 | 6.2% | |
| 67 | 1 | 6.2% | |
| 49 | 1 | 6.2% | |
| 15 | 1 | 6.2% | |
| 5 | 1 | 6.2% | |
| 108 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 3 | 1 | 6.2% | |
| 5 | 1 | 6.2% | |
| 7 | 1 | 6.2% | |
| 8 | 1 | 6.2% | |
| 15 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 108 | 1 | 6.2% | |
| 89 | 1 | 6.2% | |
| 67 | 1 | 6.2% | |
| 54 | 1 | 6.2% | |
| 49 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.0 B |
| 85,2 | 1 |
|---|---|
| 138,8 | 1 |
| 139,1 | 1 |
| 145,1 | 1 |
| 135,4 | 1 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| 85,2 | 1 | 6.2% | |
| 138,8 | 1 | 6.2% | |
| 139,1 | 1 | 6.2% | |
| 145,1 | 1 | 6.2% | |
| 135,4 | 1 | 6.2% | |
| 87,2 | 1 | 6.2% | |
| 113,2 | 1 | 6.2% | |
| 131,3 | 1 | 6.2% | |
| 364,7 | 1 | 6.2% | |
| 172,2 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
Frequencies of value counts
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.75 |
| Min length | 4 |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.85829039 |
|---|---|
| Minimum | 2.443409917 |
| Maximum | 30.04011032 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 2.443409917 |
|---|---|
| 5-th percentile | 2.621774505 |
| Q1 | 10.95251499 |
| median | 15.58376583 |
| Q3 | 20.02354315 |
| 95-th percentile | 29.87173266 |
| Maximum | 30.04011032 |
| Range | 27.5967004 |
| Interquartile range (IQR) | 9.071028162 |
Descriptive statistics
| Standard deviation | 9.302046724 |
|---|---|
| Coefficient of variation (CV) | 0.5865731108 |
| Kurtosis | -0.7912237374 |
| Mean | 15.85829039 |
| Median Absolute Deviation (MAD) | 4.738305095 |
| Skewness | -0.01272884394 |
| Sum | 253.7326462 |
| Variance | 86.52807325 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 15.24970704 | 1 | 6.2% | |
| 15.03245296 | 1 | 6.2% | |
| 2.443409917 | 1 | 6.2% | |
| 29.81560677 | 1 | 6.2% | |
| 30.04011032 | 1 | 6.2% | |
| 14.21729029 | 1 | 6.2% | |
| 2.681229367 | 1 | 6.2% | |
| 4.228598866 | 1 | 6.2% | |
| 19.72501538 | 1 | 6.2% | |
| 20.91912646 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 2.443409917 | 1 | 6.2% | |
| 2.681229367 | 1 | 6.2% | |
| 3.109519828 | 1 | 6.2% | |
| 4.228598866 | 1 | 6.2% | |
| 13.19382036 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 30.04011032 | 1 | 6.2% | |
| 29.81560677 | 1 | 6.2% | |
| 29.28325566 | 1 | 6.2% | |
| 20.91912646 | 1 | 6.2% | |
| 19.72501538 | 1 | 6.2% |
| Distinct | 16 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.867620854 |
|---|---|
| Minimum | 0.0540986322 |
| Maximum | 8.661119201 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 128.0 B |
Quantile statistics
| Minimum | 0.0540986322 |
|---|---|
| 5-th percentile | 0.08865860736 |
| Q1 | 1.632337438 |
| median | 2.583459701 |
| Q3 | 4.030020052 |
| 95-th percentile | 6.924384144 |
| Maximum | 8.661119201 |
| Range | 8.607020569 |
| Interquartile range (IQR) | 2.397682614 |
Descriptive statistics
| Standard deviation | 2.347794837 |
|---|---|
| Coefficient of variation (CV) | 0.8187256811 |
| Kurtosis | 1.230216465 |
| Mean | 2.867620854 |
| Median Absolute Deviation (MAD) | 1.554624554 |
| Skewness | 0.9585607475 |
| Sum | 45.88193367 |
| Variance | 5.512140597 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) | |
| 4.413413309 | 1 | 6.2% | |
| 2.681298894 | 1 | 6.2% | |
| 8.661119201 | 1 | 6.2% | |
| 0.1180168717 | 1 | 6.2% | |
| 6.345472459 | 1 | 6.2% | |
| 2.485620508 | 1 | 6.2% | |
| 0.0540986322 | 1 | 6.2% | |
| 2.365069806 | 1 | 6.2% | |
| 2.070323546 | 1 | 6.2% | |
| 0.318379114 | 1 | 6.2% | |
| Other values (6) | 6 | 37.5% |
| Value | Count | Frequency (%) | |
| 0.0540986322 | 1 | 6.2% | |
| 0.1001785991 | 1 | 6.2% | |
| 0.1180168717 | 1 | 6.2% | |
| 0.318379114 | 1 | 6.2% | |
| 2.070323546 | 1 | 6.2% |
| Value | Count | Frequency (%) | |
| 8.661119201 | 1 | 6.2% | |
| 6.345472459 | 1 | 6.2% | |
| 4.413413309 | 1 | 6.2% | |
| 4.35421266 | 1 | 6.2% | |
| 3.92195585 | 1 | 6.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| OBJECTID_1 | LAN_ew_AGS | LAN_ew_GEN | LAN_ew_BEZ | LAN_ew_EWZ | OBJECTID | Fallzahl | Aktualisierung | AGS_TXT | GlobalID | faelle_100000_EW | Death | cases7_bl_per_100k | cases7_bl | death7_bl | cases7_bl_per_100k_txt | SHAPE_Length | SHAPE_Area | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | Schleswig-Holstein | Land | 2903773 | 15 | 23784 | 2020/12/28 23:00:00 | 1 | {FC5BA936-C95C-432C-8A33-9EB2F30B660F} | 819.072290 | 394 | 85.165059 | 2473 | 15 | 85,2 | 20.919126 | 2.159546 |
| 1 | 2 | 2 | Hamburg | Freie und Hansestadt | 1847253 | 6 | 35484 | 2020/12/28 23:00:00 | 2 | {0F3E860C-5181-4D3F-A421-1D51F50315EA} | 1920.906340 | 598 | 113.195106 | 2091 | 5 | 113,2 | 3.109520 | 0.100179 |
| 2 | 3 | 3 | Niedersachsen | Land | 7993608 | 9 | 103750 | 2020/12/28 23:00:00 | 3 | {3FD77024-C29B-4843-9BE8-682AD48E60C9} | 1297.912032 | 1851 | 87.219689 | 6972 | 28 | 87,2 | 29.815607 | 6.345472 |
| 3 | 4 | 4 | Bremen | Freie Hansestadt | 681202 | 5 | 13259 | 2020/12/28 23:00:00 | 4 | {4132268B-54DE-4327-AC1E-760E915112F1} | 1946.412371 | 186 | 90.428390 | 616 | 3 | 90,4 | 2.443410 | 0.054099 |
| 4 | 5 | 5 | Nordrhein-Westfalen | Land | 17947221 | 10 | 383008 | 2020/12/28 23:00:00 | 5 | {561D658F-3EE5-46E3-BC95-3528C6558AB9} | 2134.079700 | 6227 | 138.807005 | 24912 | 108 | 138,8 | 19.725015 | 4.413413 |
| 5 | 6 | 6 | Hessen | Land | 6288080 | 7 | 132204 | 2020/12/28 23:00:00 | 6 | {93277AC4-E8FC-48C7-8940-028DC2ED66AF} | 2102.454167 | 2582 | 139.056755 | 8744 | 49 | 139,1 | 15.917825 | 2.681299 |
| 6 | 7 | 7 | Rheinland-Pfalz | Land | 4093903 | 11 | 70024 | 2020/12/28 23:00:00 | 7 | {E9B4296F-9BE2-4E53-9A58-CCF1396CB03D} | 1710.445997 | 1328 | 122.694651 | 5023 | 38 | 122,7 | 13.193820 | 2.485621 |
| 7 | 8 | 8 | Baden-Württemberg | Land | 11100394 | 1 | 231686 | 2020/12/28 23:00:00 | 8 | {80394DDF-C6A4-4A6E-BE8E-0259A81B22A9} | 2087.187176 | 4587 | 147.012800 | 16319 | 67 | 147,0 | 18.996173 | 4.354213 |
| 8 | 9 | 9 | Bayern | Freistaat | 13124737 | 2 | 314934 | 2020/12/28 23:00:00 | 9 | {1FF920F4-62CD-4A4F-B8C9-F042F2A3E00A} | 2399.545225 | 6398 | 161.534665 | 21201 | 89 | 161,5 | 29.283256 | 8.661119 |
| 9 | 10 | 10 | Saarland | Land | 986887 | 12 | 19341 | 2020/12/28 23:00:00 | 10 | {E3396A6F-8A30-4FDF-8DF7-DEF77DD38BEA} | 1959.798842 | 412 | 131.322026 | 1296 | 7 | 131,3 | 4.228599 | 0.318379 |
Last rows
| OBJECTID_1 | LAN_ew_AGS | LAN_ew_GEN | LAN_ew_BEZ | LAN_ew_EWZ | OBJECTID | Fallzahl | Aktualisierung | AGS_TXT | GlobalID | faelle_100000_EW | Death | cases7_bl_per_100k | cases7_bl | death7_bl | cases7_bl_per_100k_txt | SHAPE_Length | SHAPE_Area | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 7 | 7 | Rheinland-Pfalz | Land | 4093903 | 11 | 70024 | 2020/12/28 23:00:00 | 7 | {E9B4296F-9BE2-4E53-9A58-CCF1396CB03D} | 1710.445997 | 1328 | 122.694651 | 5023 | 38 | 122,7 | 13.193820 | 2.485621 |
| 7 | 8 | 8 | Baden-Württemberg | Land | 11100394 | 1 | 231686 | 2020/12/28 23:00:00 | 8 | {80394DDF-C6A4-4A6E-BE8E-0259A81B22A9} | 2087.187176 | 4587 | 147.012800 | 16319 | 67 | 147,0 | 18.996173 | 4.354213 |
| 8 | 9 | 9 | Bayern | Freistaat | 13124737 | 2 | 314934 | 2020/12/28 23:00:00 | 9 | {1FF920F4-62CD-4A4F-B8C9-F042F2A3E00A} | 2399.545225 | 6398 | 161.534665 | 21201 | 89 | 161,5 | 29.283256 | 8.661119 |
| 9 | 10 | 10 | Saarland | Land | 986887 | 12 | 19341 | 2020/12/28 23:00:00 | 10 | {E3396A6F-8A30-4FDF-8DF7-DEF77DD38BEA} | 1959.798842 | 412 | 131.322026 | 1296 | 7 | 131,3 | 4.228599 | 0.318379 |
| 10 | 11 | 11 | Berlin | Land | 3669491 | 3 | 94442 | 2020/12/28 23:00:00 | 11 | {C7033073-2BB0-486B-97AF-5B3C639E7219} | 2573.708452 | 1172 | 145.115494 | 5325 | 30 | 145,1 | 2.681229 | 0.118017 |
| 11 | 12 | 12 | Brandenburg | Land | 2521893 | 4 | 37820 | 2020/12/28 23:00:00 | 12 | {B560AF89-5895-4BE4-96F8-0F581CD8A858} | 1499.667115 | 814 | 135.374498 | 3414 | 37 | 135,4 | 18.879505 | 3.921956 |
| 12 | 13 | 13 | Mecklenburg-Vorpommern | Land | 1608138 | 8 | 11168 | 2020/12/28 23:00:00 | 13 | {A27F5628-E790-45BE-898D-F0A6841C0F7E} | 694.467763 | 152 | 77.232178 | 1242 | 8 | 77,2 | 30.040110 | 3.142812 |
| 13 | 14 | 14 | Sachsen | Freistaat | 4071971 | 13 | 126421 | 2020/12/28 23:00:00 | 14 | {256D2405-A7C8-4FEC-93DF-29F3C808CD25} | 3104.663565 | 2838 | 364.663697 | 14849 | 54 | 364,7 | 15.249707 | 2.365070 |
| 14 | 15 | 15 | Sachsen-Anhalt | Land | 2194782 | 14 | 27754 | 2020/12/28 23:00:00 | 15 | {66106BBE-F04B-4F92-80E1-5B5B30DA25B5} | 1264.544725 | 532 | 172.181110 | 3779 | 23 | 172,2 | 14.217290 | 2.690416 |
| 15 | 16 | 16 | Thüringen | Freistaat | 2133378 | 16 | 39647 | 2020/12/28 23:00:00 | 16 | {3A3E2817-BB19-4F8C-8BCA-D8FF591140D4} | 1858.414214 | 907 | 273.697394 | 5839 | 41 | 273,7 | 15.032453 | 2.070324 |