Descriptive Analysis

Median: number in the middle

  • contain outliers

Mode: the most frequent observation


Percentile

“P” or “K”

10th percentile → p = k = 0.10


Quartile

Min = p0

Q1 = p25

Q2 = p50

Q3 = p75

Q4 = p100 or Max


Dispersion: degree of variation in a given variable

Range: Max- Min

Variance : average of the squared differences from the mean, providing insight into the spread of data points

Standard deviation: a measure that quantifies the amount of variation or dispersion in a set of values, indicating how much the individual data points deviate from the mean

Mean absolute deviation: average absolute deviation from this mean


=COUNTA - for categorical functions

=COUNT - for numerical functions


Correlation = 0: No linear relationship