Values, Frequencies and Quantiles in the Sheets tab
Values, Frequencies and Quantiles provide statistical functions to obtain specific position measures (quantiles) or to tabulate statistics associated to ordinal values.
They are univariate statistics.
Statistics on integer variables are continuous
If selected, statistics will be displayed as continuous values (e.g. 12,34 instead of a rounded off 12).
Number of total valid samples
Number of rows with valid values, not including missing values.
Values, frequencies and quantiles
The number of non coincident (tied) values.
The number of occurrences of each value.
The proportion of the occurrence of each value.
The proportion of values lower than or equal to each observed value.
The sum of values lower than or equal to each observed value.
The average of values lower than or equal to each observed value.
Calculates the Lorenz distribution in a tabular format.
The calculation of quantiles with an arbitrary number of data subsets. The number of subsets is set in the value for generic quantiles.
The default number is 4, i.e. the values of the lower and upper quantiles and median values are displayed.
Value for generic quantiles
The threshold value for quantiles.