DAXTrig&Statistics Flashcards
ACOS([CosineValue])
Calculates the arccosine (inverse cosine) of ‘CosineValue’ and returns the angle in radians.
ACOSH([HypCosineValue])
Calculates the inverse hyperbolic cosine of ‘HypCosineValue’ and returns the result.
ACOT([CotangentValue])
Calculates the arccotangent (inverse cotangent) of ‘CotangentValue’ and returns the angle in radians.
ACOTH([HypCotangentValue])
Calculates the inverse hyperbolic cotangent of ‘HypCotangentValue’ and returns the result.
ASIN([SineValue])
Calculates the arcsine (inverse sine) of ‘SineValue’ and returns the angle in radians.
ASINH([HypSineValue])
Calculates the inverse hyperbolic sine of ‘HypSineValue’ and returns the result.
ATAN([TangentValue])
Calculates the arctangent (inverse tangent) of ‘TangentValue’ and returns the angle in radians.
ATANH([HypTangentValue])
Calculates the inverse hyperbolic tangent of ‘HypTangentValue’ and returns the result.
COS([Angle])
Calculates the cosine of ‘Angle’ where ‘Angle’ is in radians.
COSH([HypAngle])
Calculates the hyperbolic cosine of ‘HypAngle’.
COT([Tangent])
Calculates the cotangent of ‘Tangent’.
COTH([HypTangent])
Calculates the hyperbolic cotangent of ‘HypTangent’.
SIN([Angle])
Returns the sine of the given ‘Angle’ in radians.
SINH([Number])
Returns the hyperbolic sine of ‘Number’.
TAN([Angle])
Returns the tangent of the given ‘Angle’ in radians.
TANH([Number])
Returns the hyperbolic tangent of ‘Number’.
BETA.DIST(0.2, 2, 3, TRUE)
Returns the probability density function or the cumulative distribution function for the beta distribution.
BETA.INV(0.3, 2, 3, 4)
Calculates the inverse of the cumulative beta probability distribution.
CHISQ.DIST(2, 3, TRUE)
Returns the chi-squared probability density function.
CHISQ.DIST.RT(2, 3)
Returns the right-tailed chi-squared distribution.
CHISQ.INV(0.05, 4)
Returns the inverse of the chi-squared cumulative distribution.
CHISQ.INV.RT(0.05, 4)
Returns the right-tailed inverse of the chi-squared cumulative distribution.
COMBIN(5, 2)
Returns the number of combinations for a given number of items.
COMBINA(5, 2)
Returns the number of combinations (including repetitions) for a given number of items.
CONFIDENCE.NORM(0.05, 2, 50)
Calculates the confidence interval for a normal distribution.
CONFIDENCE.T(0.05, 2, 50)
Calculates the confidence interval for a Student’s t-distribution.
EXPON.DIST(2, 3, TRUE)
Returns the exponential distribution.
GEOMEAN(2, 4, 8)
Calculates the geometric mean of a set of values.
GEOMEANX(‘Sales’[Amount], ‘Sales’[Category])
Calculates the geometric mean for a column or expression.
LINEST(‘Sales’[Sales], ‘Sales’[Profit], TRUE, TRUE)
Performs a linear regression analysis on a dataset.
LINESTX(‘Sales’[Sales], ‘Sales’[Quantity], TRUE, TRUE)
Performs a linear regression analysis for a specified table and columns.
NORM.DIST(2, 3, TRUE)
Returns the cumulative standard normal distribution.
NORM.INV(0.05)
Returns the inverse of the standard normal distribution.
NORM.S.DIST(2)
Returns the cumulative standard normal distribution for a specific value.
NORM.S.INV(0.05)
Returns
PERCENTILE.EXC(‘Sales’[Amount], 0.25)
Calculates the exclusive percentile for a column or table.
PERCENTILE.INC(‘Sales’[Amount], 0.25)
Calculates the inclusive percentile for a column or table.
PERCENTILEX.EXC(‘Sales’[Amount], [Rank])
Calculates the exclusive percentile with a dynamic ranking column.
PERCENTILEX.INC(‘Sales’[Amount], [Rank])
Calculates the inclusive percentile with a dynamic ranking column.
PERMUT(5, 2)
Returns the number of permutations for a given number of items.
POISSON.DIST(2, 3, TRUE)
Returns the Poisson distribution.
STDEV.P(‘Sales’[Amount])
Calculates the population standard deviation.
STDEV.S(‘Sales’[Quantity])
Calculates the sample standard deviation.
STDEVX.P(‘Sales’[Amount], ‘Sales’[Category])
Calculates the population standard deviation for a table or column.
STDEVX.S(‘Sales’[Quantity], ‘Sales’[Category])
Calculates the sample standard deviation for a table or column.
T.DIST(2, 3, TRUE)
Returns the cumulative Student’s t-distribution.
T.DIST.2T(2, 3)
Returns the two-tailed Student’s t-distribution.
T.DIST.RT(2, 3)
Returns the right-tailed Student’s t-distribution.
T.INV(0.05, 2)
Returns the inverse of the Student’s t-distribution.
T.INV.2t(0.05, 2)
Returns the two-tailed inverse of the Student’s t-distribution.
VAR.P(‘Sales’[Amount])
Calculates the population variance.
VAR.S(‘Sales’[Quantity])
Calculates the sample variance.
VARX.P(‘Sales’[Amount], ‘Sales’[Category])
Calculates the population variance for a table or column with optional grouping.
VARX.S(‘Sales’[Quantity], ‘Sales’[Category])
Calculates the sample variance for a table or column with optional grouping.