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.

Properties

Description

General parameters

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).

Sample size

Number of total valid samples

Number of rows with valid values, not including missing values.

Values, frequencies and quantiles

Distinct values

The number of non coincident (tied) values.

Absolute frequencies

The number of occurrences of each value.

Relative frequencies

The proportion of the occurrence of each value.

Cumulative frequencies

The proportion of values lower than or equal to each observed value.

Partial sums

The sum of values lower than or equal to each observed value.

Partial means

The average of values lower than or equal to each observed value.

Lorenz curve

Calculates the Lorenz distribution in a tabular format.

Pietra curve

Generic quantiles

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.

Rank

Quantile parameters

Value for generic quantiles

The threshold value for quantiles.