Studied by 246 People

0.0(0)

get a hint

hint

Tags & Description

New cards16

Still learning0

Almost done0

Mastered0

16 Terms

New cards

Correct Syntax for the "=RAND" Function

=RAND()

New cards

New cards

Correct Syntax for the "=NORM.DIST" Function

=NORM.DIST(Upper limit ,mean ,STD, TRUE), or =NORM.DIST(Lower limit ,mean ,STD, TRUE)

New cards

New cards

Correct Syntax for the "=COUNT" Function

=COUNT(Range)

New cards

New cards

Correct Syntax for the "=CONFIDENCE.NORM" Function

=CONFIDENCE.NORM(Alpha, STD, Sample Size)

New cards

New cards

Correct Syntax for the "=COUNTIF" Function

=COUNTIF(Range)

New cards

New cards

Correct Syntax for the "=COUNTA" Function

=COUNTA(Range)

New cards

New cards

Correct Syntax for the "=NORM.S.INV" Function

=NORM.S.INV(Probability) -> (1-Level of Sig / 2)

New cards

New cards

Correct Syntax for the "=NORM.S.DIST" Function

=NORM.S.DIST(Test Statistic, TRUE)

New cards

New cards

Correct Syntax for the "=SQRT" Function

=SQRT(Number)

New cards

New cards

Correct Syntax for the "=MIN" Function

=MIN(Number)

New cards

New cards

Correct Syntax for the "=T.DIST" Function

=T.DIST(Test Statistic, Degrees of Freedom, TRUE)

New cards

New cards

Correct Syntax for the "=T.INV.2T" Function

=T.INV.2T(Level of Sig., Degrees of Freedom)

New cards

New cards

Correct Syntax for the "=STDEV.S" Function

=STDEV.S(Range)

New cards

New cards

Correct Syntax for the "=VAR.S" Function

=VAR.S(Range)

New cards

New cards

Correct Syntax for the "=MEDIAN" Function

=MEDIAN(Range)

New cards

New cards

Correct Syntax for the "=AVERAGE" Function

=AVERAGE(Range)

New cards