DAXTrig&Statistics

Question 1

ACOS([CosineValue])

Answer 1

Calculates the arccosine (inverse cosine) of ‘CosineValue’ and returns the angle in radians.

Question 2

ACOSH([HypCosineValue])

Answer 2

Calculates the inverse hyperbolic cosine of ‘HypCosineValue’ and returns the result.

Question 3

ACOT([CotangentValue])

Answer 3

Calculates the arccotangent (inverse cotangent) of ‘CotangentValue’ and returns the angle in radians.

Question 4

ACOTH([HypCotangentValue])

Answer 4

Calculates the inverse hyperbolic cotangent of ‘HypCotangentValue’ and returns the result.

Question 5

ASIN([SineValue])

Answer 5

Calculates the arcsine (inverse sine) of ‘SineValue’ and returns the angle in radians.

Question 6

ASINH([HypSineValue])

Answer 6

Calculates the inverse hyperbolic sine of ‘HypSineValue’ and returns the result.

Question 7

ATAN([TangentValue])

Answer 7

Calculates the arctangent (inverse tangent) of ‘TangentValue’ and returns the angle in radians.

Question 8

ATANH([HypTangentValue])

Answer 8

Calculates the inverse hyperbolic tangent of ‘HypTangentValue’ and returns the result.

Question 9

COS([Angle])

Answer 9

Calculates the cosine of ‘Angle’ where ‘Angle’ is in radians.

Question 10

COSH([HypAngle])

Answer 10

Calculates the hyperbolic cosine of ‘HypAngle’.

Question 11

COT([Tangent])

Answer 11

Calculates the cotangent of ‘Tangent’.

Question 12

COTH([HypTangent])

Answer 12

Calculates the hyperbolic cotangent of ‘HypTangent’.

Question 13

SIN([Angle])

Answer 13

Returns the sine of the given ‘Angle’ in radians.

Question 14

SINH([Number])

Answer 14

Returns the hyperbolic sine of ‘Number’.

Question 15

TAN([Angle])

Answer 15

Returns the tangent of the given ‘Angle’ in radians.

Question 16

TANH([Number])

Answer 16

Returns the hyperbolic tangent of ‘Number’.

Question 17

BETA.DIST(0.2, 2, 3, TRUE)

Answer 17

Returns the probability density function or the cumulative distribution function for the beta distribution.

Question 18

BETA.INV(0.3, 2, 3, 4)

Answer 18

Calculates the inverse of the cumulative beta probability distribution.

Question 19

CHISQ.DIST(2, 3, TRUE)

Answer 19

Returns the chi-squared probability density function.

Question 20

CHISQ.DIST.RT(2, 3)

Answer 20

Returns the right-tailed chi-squared distribution.

Question 21

CHISQ.INV(0.05, 4)

Answer 21

Returns the inverse of the chi-squared cumulative distribution.

Question 22

CHISQ.INV.RT(0.05, 4)

Answer 22

Returns the right-tailed inverse of the chi-squared cumulative distribution.

Question 23

COMBIN(5, 2)

Answer 23

Returns the number of combinations for a given number of items.

Question 24

COMBINA(5, 2)

Answer 24

Returns the number of combinations (including repetitions) for a given number of items.

Question 25

CONFIDENCE.NORM(0.05, 2, 50)

Answer 25

Calculates the confidence interval for a normal distribution.

Question 26

CONFIDENCE.T(0.05, 2, 50)

Answer 26

Calculates the confidence interval for a Student's t-distribution.

Question 27

EXPON.DIST(2, 3, TRUE)

Answer 27

Returns the exponential distribution.

Question 28

GEOMEAN(2, 4, 8)

Answer 28

Calculates the geometric mean of a set of values.

Question 29

GEOMEANX('Sales'[Amount], 'Sales'[Category])

Answer 29

Calculates the geometric mean for a column or expression.

Question 30

LINEST('Sales'[Sales], 'Sales'[Profit], TRUE, TRUE)

Answer 30

Performs a linear regression analysis on a dataset.

Question 31

LINESTX('Sales'[Sales], 'Sales'[Quantity], TRUE, TRUE)

Answer 31

Performs a linear regression analysis for a specified table and columns.

Question 32

NORM.DIST(2, 3, TRUE)

Answer 32

Returns the cumulative standard normal distribution.

Question 33

NORM.INV(0.05)

Answer 33

Returns the inverse of the standard normal distribution.

Question 34

NORM.S.DIST(2)

Answer 34

Returns the cumulative standard normal distribution for a specific value.

Question 35

NORM.S.INV(0.05)

Answer 35

Returns

Question 36

PERCENTILE.EXC('Sales'[Amount], 0.25)

Answer 36

Calculates the exclusive percentile for a column or table.

Question 37

PERCENTILE.INC('Sales'[Amount], 0.25)

Answer 37

Calculates the inclusive percentile for a column or table.

Question 38

PERCENTILEX.EXC('Sales'[Amount], [Rank])

Answer 38

Calculates the exclusive percentile with a dynamic ranking column.

Question 39

PERCENTILEX.INC('Sales'[Amount], [Rank])

Answer 39

Calculates the inclusive percentile with a dynamic ranking column.

Question 40

PERMUT(5, 2)

Answer 40

Returns the number of permutations for a given number of items.

Question 41

POISSON.DIST(2, 3, TRUE)

Answer 41

Returns the Poisson distribution.

Question 42

STDEV.P('Sales'[Amount])

Answer 42

Calculates the population standard deviation.

Question 43

STDEV.S('Sales'[Quantity])

Answer 43

Calculates the sample standard deviation.

Question 44

STDEVX.P('Sales'[Amount], 'Sales'[Category])

Answer 44

Calculates the population standard deviation for a table or column.

Question 45

STDEVX.S('Sales'[Quantity], 'Sales'[Category])

Answer 45

Calculates the sample standard deviation for a table or column.

Question 46

T.DIST(2, 3, TRUE)

Answer 46

Returns the cumulative Student's t-distribution.

Question 47

T.DIST.2T(2, 3)

Answer 47

Returns the two-tailed Student's t-distribution.

Question 48

T.DIST.RT(2, 3)

Answer 48

Returns the right-tailed Student's t-distribution.

Question 49

T.INV(0.05, 2)

Answer 49

Returns the inverse of the Student's t-distribution.

Question 50

T.INV.2t(0.05, 2)

Answer 50

Returns the two-tailed inverse of the Student's t-distribution.

Question 51

VAR.P('Sales'[Amount])

Answer 51

Calculates the population variance.

Question 52

VAR.S('Sales'[Quantity])

Answer 52

Calculates the sample variance.

Question 53

VARX.P('Sales'[Amount], 'Sales'[Category])

Answer 53

Calculates the population variance for a table or column with optional grouping.

Question 54

VARX.S('Sales'[Quantity], 'Sales'[Category])

Answer 54

Calculates the sample variance for a table or column with optional grouping.