DAXTrig&Statistics Flashcards

1
Q

ACOS([CosineValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

ACOSH([HypCosineValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ACOT([CotangentValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

ACOTH([HypCotangentValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ASIN([SineValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

ASINH([HypSineValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ATAN([TangentValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ATANH([HypTangentValue])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

COS([Angle])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

COSH([HypAngle])

A

Calculates the hyperbolic cosine of ‘HypAngle’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

COT([Tangent])

A

Calculates the cotangent of ‘Tangent’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

COTH([HypTangent])

A

Calculates the hyperbolic cotangent of ‘HypTangent’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SIN([Angle])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

SINH([Number])

A

Returns the hyperbolic sine of ‘Number’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

TAN([Angle])

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

TANH([Number])

A

Returns the hyperbolic tangent of ‘Number’.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Calculates the inverse of the cumulative beta probability distribution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

CHISQ.DIST(2, 3, TRUE)

A

Returns the chi-squared probability density function.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

CHISQ.DIST.RT(2, 3)

A

Returns the right-tailed chi-squared distribution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

CHISQ.INV(0.05, 4)

A

Returns the inverse of the chi-squared cumulative distribution.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

CHISQ.INV.RT(0.05, 4)

A

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

23
Q

COMBIN(5, 2)

A

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

24
Q

COMBINA(5, 2)

A

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

25
Q

CONFIDENCE.NORM(0.05, 2, 50)

A

Calculates the confidence interval for a normal distribution.

26
Q

CONFIDENCE.T(0.05, 2, 50)

A

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

27
Q

EXPON.DIST(2, 3, TRUE)

A

Returns the exponential distribution.

28
Q

GEOMEAN(2, 4, 8)

A

Calculates the geometric mean of a set of values.

29
Q

GEOMEANX(‘Sales’[Amount], ‘Sales’[Category])

A

Calculates the geometric mean for a column or expression.

30
Q

LINEST(‘Sales’[Sales], ‘Sales’[Profit], TRUE, TRUE)

A

Performs a linear regression analysis on a dataset.

31
Q

LINESTX(‘Sales’[Sales], ‘Sales’[Quantity], TRUE, TRUE)

A

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

32
Q

NORM.DIST(2, 3, TRUE)

A

Returns the cumulative standard normal distribution.

33
Q

NORM.INV(0.05)

A

Returns the inverse of the standard normal distribution.

34
Q

NORM.S.DIST(2)

A

Returns the cumulative standard normal distribution for a specific value.

35
Q

NORM.S.INV(0.05)

A

Returns

36
Q

PERCENTILE.EXC(‘Sales’[Amount], 0.25)

A

Calculates the exclusive percentile for a column or table.

37
Q

PERCENTILE.INC(‘Sales’[Amount], 0.25)

A

Calculates the inclusive percentile for a column or table.

38
Q

PERCENTILEX.EXC(‘Sales’[Amount], [Rank])

A

Calculates the exclusive percentile with a dynamic ranking column.

39
Q

PERCENTILEX.INC(‘Sales’[Amount], [Rank])

A

Calculates the inclusive percentile with a dynamic ranking column.

40
Q

PERMUT(5, 2)

A

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

41
Q

POISSON.DIST(2, 3, TRUE)

A

Returns the Poisson distribution.

42
Q

STDEV.P(‘Sales’[Amount])

A

Calculates the population standard deviation.

43
Q

STDEV.S(‘Sales’[Quantity])

A

Calculates the sample standard deviation.

44
Q

STDEVX.P(‘Sales’[Amount], ‘Sales’[Category])

A

Calculates the population standard deviation for a table or column.

45
Q

STDEVX.S(‘Sales’[Quantity], ‘Sales’[Category])

A

Calculates the sample standard deviation for a table or column.

46
Q

T.DIST(2, 3, TRUE)

A

Returns the cumulative Student’s t-distribution.

47
Q

T.DIST.2T(2, 3)

A

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

48
Q

T.DIST.RT(2, 3)

A

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

49
Q

T.INV(0.05, 2)

A

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

50
Q

T.INV.2t(0.05, 2)

A

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

51
Q

VAR.P(‘Sales’[Amount])

A

Calculates the population variance.

52
Q

VAR.S(‘Sales’[Quantity])

A

Calculates the sample variance.

53
Q

VARX.P(‘Sales’[Amount], ‘Sales’[Category])

A

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

54
Q

VARX.S(‘Sales’[Quantity], ‘Sales’[Category])

A

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