NORM.S.DIST
The NORM.S.DIST function returns the standard normal distribution of a value.
NORM.INV
The NORM.INV function returns the value of the inverse of the cumulative normal distribution for the specified mean and standard deviation.
NORM.DIST
The NORM.DIST function returns the value of the normal distribution for the specified mean and standard deviation.
STDEV.S
The STDEV.S function returns the sample standard deviation of the values contained in a column.
STDEV.P
The STDEV.P function returns the standard deviation of the total population contained in a column.
VAR.S
The VAR.S function returns the variance of a sample of the population contained in a column.
VAR.P
The VAR.P function returns the variance of the entire population contained in a column.
Calculation of total sales by category regardless of the selected country
If we have a [Total sales] measure that sums the sales amounts, we can display sales by category by taking the field containing the list of categories, ProductCategory[Category], into a table along with the [Total sales] measure:
COUNTA
The COUNTA function returns the number of cells in a column that are not blank. That is, it counts not only numeric values, texts, and dates like the COUNT function, but it also counts logical values.
BETA.DIST
The BETA.DIST function returns the value of the beta distribution for a given x value. The beta distribution is a family of continuous probability distributions defined on the interval [0, 1] by two positive shape parameters, named alpha and beta.
