QMB 3200 Dr. Brook Final: Part A (Excel Formula Syntaxes Only)

studied byStudied by 246 People
0.0(0)
get a hint
hint

Correct Syntax for the "=RAND" Function

1/16

Tags & Description

A review of all Excel formula syntaxes, as in what each formula needs to work

Studying Progress

New cards
16
Still learning
0
Almost done
0
Mastered
0
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