Unosostenibile_subset.xlsx

Dataset info

Number of variables	9
Number of observations	280
Missing cells	222 (8.8%)
Duplicate rows	0 (0.0%)
Total size in memory	19.8 KiB
Average record size in memory	72.5 B

Variables types

Numeric	8
Categorical	0
Boolean	0
Date	0
URL	0
Text (Unique)	0
Rejected	1
Unsupported	0

Warnings

`Attitudes` has 42 (15.0%) missing values	Missing
`Behaviour` has 43 (15.4%) missing values	Missing
`ECO` has 25 (8.9%) missing values	Missing
`ENV` has 25 (8.9%) missing values	Missing
`Knowingness` has 25 (8.9%) missing values	Missing
`SC_mean` has 25 (8.9%) missing values	Missing
`SOC` is highly correlated with `SC_mean` (ρ = 0.9327943903)	Rejected
`wellbeing_mean` has 12 (4.3%) missing values	Missing

Attitudes
Numeric

Distinct count	33
Unique (%)	11.8%
Missing (%)	15.0%
Missing (n)	42
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.143457383
Minimum	2.285714286
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.285714286
5-th percentile	3
Q1	3.857142857
Median	4.357142857
Q3	4.571428571
95-th percentile	4.785714286
Maximum	5
Range	2.714285714
Interquartile range	0.7142857143

Descriptive statistics

Standard deviation	0.5480837035
Coef of variation	0.1322769013
Kurtosis	0.1288715849
Mean	4.143457383
MAD	0.4428914423
Skewness	-0.9442810174
Sum	986.1428571
Variance	0.300395746
Memory size	2.3 KiB

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
4.428571429	25	8.9%
4.571428571	22	7.9%
4.714285714	16	5.7%
4.357142857	15	5.4%
3	15	5.4%
4.642857143	15	5.4%
4.5	13	4.6%
4.071428571	12	4.3%
4.142857143	10	3.6%
3.857142857	9	3.2%
Other values (22)	86	30.7%
(Missing)	42	15.0%

Minimum 5 values

Value	Count	Frequency (%)
2.285714286	1	0.4%
2.642857143	1	0.4%
2.857142857	1	0.4%
2.928571429	1	0.4%
3	15	5.4%

Maximum 5 values

Value	Count	Frequency (%)
5	1	0.4%
4.928571429	2	0.7%
4.857142857	6	2.1%
4.785714286	5	1.8%
4.714285714	16	5.7%

Behaviour
Numeric

Distinct count	39
Unique (%)	13.9%
Missing (%)	15.4%
Missing (n)	43
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.635889799
Minimum	2.117647059
Maximum	4.823529412
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.117647059
5-th percentile	2.941176471
Q1	3.352941176
Median	3.647058824
Q3	3.941176471
95-th percentile	4.529411765
Maximum	4.823529412
Range	2.705882353
Interquartile range	0.5882352941

Descriptive statistics

Standard deviation	0.4804923581
Coef of variation	0.1321526187
Kurtosis	0.03843411528
Mean	3.635889799
MAD	0.3822162738
Skewness	0.01005290909
Sum	861.7058824
Variance	0.2308729062
Memory size	2.3 KiB

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
3.823529412	16	5.7%
3.705882353	15	5.4%
3	15	5.4%
3.764705882	15	5.4%
3.411764706	14	5.0%
3.588235294	13	4.6%
4	13	4.6%
3.529411765	11	3.9%
3.294117647	11	3.9%
3.352941176	11	3.9%
Other values (28)	103	36.8%
(Missing)	43	15.4%

Minimum 5 values

Value	Count	Frequency (%)
2.117647059	1	0.4%
2.411764706	1	0.4%
2.470588235	1	0.4%
2.647058824	2	0.7%
2.705882353	2	0.7%

Maximum 5 values

Value	Count	Frequency (%)
4.823529412	1	0.4%
4.764705882	3	1.1%
4.705882353	2	0.7%
4.529411765	7	2.5%
4.470588235	1	0.4%

ECO
Numeric

Distinct count	33
Unique (%)	11.8%
Missing (%)	8.9%
Missing (n)	25
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.834477124
Minimum	2.333333333
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	2.333333333
5-th percentile	3
Q1	3.5
Median	3.875
Q3	4.166666667
95-th percentile	4.75
Maximum	5
Range	2.666666667
Interquartile range	0.6666666667

Descriptive statistics

Standard deviation	0.5337269391
Coef of variation	0.1391915825
Kurtosis	-0.2394568199
Mean	3.834477124
MAD	0.4285902858
Skewness	-0.08853670574
Sum	977.7916667
Variance	0.2848644456
Memory size	2.3 KiB

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
4	23	8.2%
3.5	18	6.4%
3.75	18	6.4%
3.916666667	17	6.1%
4.083333333	15	5.4%
3.666666667	15	5.4%
3.583333333	13	4.6%
4.25	13	4.6%
4.166666667	12	4.3%
3	12	4.3%
Other values (22)	99	35.4%
(Missing)	25	8.9%

Minimum 5 values

Value	Count	Frequency (%)
2.333333333	1	0.4%
2.5	2	0.7%
2.583333333	1	0.4%
2.75	1	0.4%
2.833333333	4	1.4%

Maximum 5 values

Value	Count	Frequency (%)
5	3	1.1%
4.916666667	4	1.4%
4.833333333	3	1.1%
4.75	5	1.8%
4.666666667	7	2.5%

ENV
Numeric

Distinct count	46
Unique (%)	16.4%
Missing (%)	8.9%
Missing (n)	25
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.945021146
Minimum	1.333333333
Maximum	4.882352941
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.333333333
5-th percentile	3.058823529
Q1	3.647058824
Median	4
Q3	4.294117647
95-th percentile	4.588235294
Maximum	4.882352941
Range	3.549019608
Interquartile range	0.6470588235

Descriptive statistics

Standard deviation	0.4785013757
Coef of variation	0.1212924742
Kurtosis	2.753964439
Mean	3.945021146
MAD	0.3717242991
Skewness	-1.02240586
Sum	1005.980392
Variance	0.2289635665
Memory size	2.3 KiB

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
4.058823529	16	5.7%
4	15	5.4%
4.294117647	14	5.0%
3.882352941	14	5.0%
4.411764706	13	4.6%
4.235294118	11	3.9%
3.823529412	11	3.9%
4.176470588	11	3.9%
4.117647059	10	3.6%
3.941176471	10	3.6%
Other values (35)	130	46.4%
(Missing)	25	8.9%

Minimum 5 values

Value	Count	Frequency (%)
1.333333333	1	0.4%
2.666666667	1	0.4%
2.705882353	1	0.4%
2.823529412	1	0.4%
2.882352941	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
4.882352941	2	0.7%
4.823529412	1	0.4%
4.705882353	2	0.7%
4.666666667	2	0.7%
4.647058824	4	1.4%

Knowingness
Numeric

Distinct count	45
Unique (%)	16.1%
Missing (%)	8.9%
Missing (n)	25
Infinite (%)	0.0%
Infinite (n)	0

Mean	4.015250545
Minimum	1.722222222
Maximum	5
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.722222222
5-th percentile	3.038888889
Q1	3.555555556
Median	4.055555556
Q3	4.5
95-th percentile	4.85
Maximum	5
Range	3.277777778
Interquartile range	0.9444444444

Descriptive statistics

Standard deviation	0.5901188923
Coef of variation	0.1469693823
Kurtosis	0.4033819968
Mean	4.015250545
MAD	0.4834379939
Skewness	-0.5704751466
Sum	1023.888889
Variance	0.3482403071
Memory size	2.3 KiB

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
3.888888889	13	4.6%
3.444444444	11	3.9%
4.5	11	3.9%
4.555555556	11	3.9%
4.166666667	11	3.9%
4.333333333	11	3.9%
3.611111111	10	3.6%
3.277777778	10	3.6%
3.833333333	10	3.6%
3.555555556	9	3.2%
Other values (34)	148	52.9%
(Missing)	25	8.9%

Minimum 5 values

Value	Count	Frequency (%)
1.722222222	1	0.4%
1.944444444	1	0.4%
2.333333333	1	0.4%
2.611111111	1	0.4%
2.777777778	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
5	6	2.1%
4.944444444	3	1.1%
4.888888889	4	1.4%
4.833333333	4	1.4%
4.777777778	7	2.5%

SC_mean
Numeric

Distinct count	250
Unique (%)	89.3%
Missing (%)	8.9%
Missing (n)	25
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.929878008
Minimum	1.722222222
Maximum	4.855431061
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1.722222222
5-th percentile	3.147494553
Q1	3.667289138
Median	3.961251167
Q3	4.25638033
95-th percentile	4.596000622
Maximum	4.855431061
Range	3.133208839
Interquartile range	0.589091192

Descriptive statistics

Standard deviation	0.462845387
Coef of variation	0.117776019
Kurtosis	1.277096818
Mean	3.929878008
MAD	0.363450855
Skewness	-0.6429408322
Sum	1002.118892
Variance	0.2142258523
Memory size	2.3 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.208683473	2	0.7%
3.888888889	2	0.7%
3.444444444	2	0.7%
4.254901961	2	0.7%
4.555555556	2	0.7%
3	2	0.7%
4.201058201	1	0.4%
4.2351385	1	0.4%
4.24572051	1	0.4%
4.095549331	1	0.4%
Other values (239)	239	85.4%
(Missing)	25	8.9%

Minimum 5 values

Value	Count	Frequency (%)
1.722222222	1	0.4%
2.698568316	1	0.4%
2.888888889	1	0.4%
2.904450669	1	0.4%
2.961562403	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
4.855431061	1	0.4%
4.835823218	1	0.4%
4.833333333	1	0.4%
4.82368503	1	0.4%
4.771864301	1	0.4%

SOC
Highly correlated

This variable is highly correlated with SC_mean and should be ignored for analysis

Correlation	0.9327943903

Unnamed_0
Numeric

Distinct count	280
Unique (%)	100.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	139.5
Minimum	0
Maximum	279
Zeros (%)	0.4%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	13.95
Q1	69.75
Median	139.5
Q3	209.25
95-th percentile	265.05
Maximum	279
Range	279
Interquartile range	139.5

Descriptive statistics

Standard deviation	80.97324661
Coef of variation	0.5804533807
Kurtosis	-1.2
Mean	139.5
MAD	70
Skewness	0
Sum	39060
Variance	6556.666667
Memory size	2.3 KiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 279.], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
279	1	0.4%
95	1	0.4%
89	1	0.4%
90	1	0.4%
91	1	0.4%
92	1	0.4%
93	1	0.4%
94	1	0.4%
96	1	0.4%
87	1	0.4%
Other values (270)	270	96.4%

Minimum 5 values

Value	Count	Frequency (%)
0	1	0.4%
1	1	0.4%
2	1	0.4%
3	1	0.4%
4	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
279	1	0.4%
278	1	0.4%
277	1	0.4%
276	1	0.4%
275	1	0.4%

wellbeing_mean
Numeric

Distinct count	50
Unique (%)	17.9%
Missing (%)	4.3%
Missing (n)	12
Infinite (%)	0.0%
Infinite (n)	0

Mean	6.384328358
Minimum	0.3333333333
Maximum	10
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	0.3333333333
5-th percentile	3.225
Q1	5.333333333
Median	6.5
Q3	7.666666667
95-th percentile	9
Maximum	10
Range	9.666666667
Interquartile range	2.333333333

Descriptive statistics

Standard deviation	1.775325354
Coef of variation	0.2780755084
Kurtosis	0.07969487731
Mean	6.384328358
MAD	1.422328655
Skewness	-0.5046140057
Sum	1711
Variance	3.151780113
Memory size	2.3 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.666666667	16	5.7%
7	13	4.6%
7.166666667	12	4.3%
7.5	12	4.3%
5.5	11	3.9%
6	10	3.6%
6.333333333	10	3.6%
6.5	9	3.2%
8	9	3.2%
6.166666667	9	3.2%
Other values (39)	157	56.1%
(Missing)	12	4.3%

Minimum 5 values

Value	Count	Frequency (%)
0.3333333333	1	0.4%
1.5	1	0.4%
1.833333333	2	0.7%
2.166666667	1	0.4%
2.333333333	1	0.4%

Maximum 5 values

Value	Count	Frequency (%)
10	3	1.1%
9.833333333	2	0.7%
9.5	1	0.4%
9.333333333	2	0.7%
9.166666667	1	0.4%

First rows

	Attitudes	Behaviour	ECO	ENV	Knowingness	SC_mean	SOC	Unnamed_0	wellbeing_mean
0	4.428571	3.411765	4.083333	3.882353	4.444444	4.094927	4.25	0	8.833333
1	4.428571	4.529412	4.416667	4.411765	3.944444	4.300809	4.10	1	4.166667
2	3.571429	2.882353	3.083333	3.000000	3.277778	3.243853	3.50	2	6.500000
3	4.571429	4.000000	4.166667	4.352941	4.666667	4.412698	4.60	3	8.166667
4	4.357143	4.235294	3.916667	4.294118	3.833333	4.141923	4.10	4	8.000000
5	4.428571	3.294118	3.833333	3.529412	4.111111	3.944600	4.30	5	2.166667
6	3.000000	3.705882	2.833333	4.058824	3.833333	3.513072	3.55	6	8.333333
7	4.714286	3.941176	4.500000	4.352941	4.722222	4.459228	4.50	7	0.333333
8	4.428571	2.705882	3.416667	3.529412	4.277778	3.804077	4.20	8	8.166667
9	4.214286	3.529412	3.666667	3.941176	3.777778	3.840492	3.80	9	9.000000

Last rows

	Attitudes	Behaviour	ECO	ENV	Knowingness	SC_mean	SOC	Unnamed_0	wellbeing_mean
270	4.428571	2.941176	4.083333	3.588235	4.222222	3.863990	3.90	270	4.333333
271	NaN	NaN	NaN	NaN	NaN	NaN	NaN	271	8.333333
272	4.285714	3.117647	4.000000	4.294118	4.722222	4.041861	3.85	272	4.166667
273	3.928571	3.941176	4.083333	4.000000	3.444444	3.771397	3.35	273	4.833333
274	4.000000	3.705882	4.333333	3.647059	4.611111	4.105664	4.40	274	6.000000
275	3.357143	3.705882	3.500000	4.000000	4.166667	3.743231	3.75	275	8.166667
276	4.500000	3.764706	4.500000	4.176471	4.500000	4.254902	4.15	276	5.500000
277	NaN	NaN	NaN	NaN	NaN	NaN	NaN	277	NaN
278	3.857143	3.764706	3.666667	3.764706	3.888889	3.836913	4.00	278	4.666667
279	4.071429	3.000000	3.416667	3.823529	4.500000	3.857143	4.15	279	6.833333

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows