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

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

Correct Syntax for the "=RAND" Function

=RAND()

Correct Syntax for the "=NORM.DIST" Function

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

Correct Syntax for the "=COUNT" Function

=COUNT(Range)

Correct Syntax for the "=CONFIDENCE.NORM" Function

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

Correct Syntax for the "=COUNTIF" Function

=COUNTIF(Range)

Correct Syntax for the "=COUNTA" Function

=COUNTA(Range)

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

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

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

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

Correct Syntax for the "=SQRT" Function

=SQRT(Number)

Correct Syntax for the "=MIN" Function

=MIN(Number)

Correct Syntax for the "=T.DIST" Function

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

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

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

Correct Syntax for the "=STDEV.S" Function

=STDEV.S(Range)

Correct Syntax for the "=VAR.S" Function

=VAR.S(Range)

Correct Syntax for the "=MEDIAN" Function

=MEDIAN(Range)

Correct Syntax for the "=AVERAGE" Function

=AVERAGE(Range)