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

Which formula is used to count non-numerical elements in a sample or population?

Which formula is used to count non-numerical elements in a sample or population?

=COUNTA

Which formula is used to generate random numbers for selecting a random sample?

=RAND

Which formula is finds the area under the distribution curve between two points?

=NORM.DIST

Which formula is used to find the area outside of two previously-calculated points

=1-NORM.DIST

Which formula is used to count the number of numerical elements in a sample or population?

=COUNT

Which formula is used to calculate the mean of a sample or population?

=AVERAGE

Which formula is used to find the Margin of Error?

=CONFIDENCE.NORM

Which formula is used to find the z-value?

=NORM.S.INV

Which formula is used to find the p-value (lower tail) when σ is known?

=NORM.S.DIST

Which formula is used to find the p-value (lower tail) when σ is unknown?

=T.DIST

Which formula is used to find the t-value?

=T.INV.2T

Which formula is used to find the square root of a number?

=SQRT

Which formula is used to find the standard deviation of a sample?

=STDEV.S

Which formula is used to find the variation of a sample?

=VAR.S

How do you use an exponent in Excel?

Use the "^" symbol before the number you are making an exponent (i.e: 3^3=27)

Which formula is used to count values based on if they have a certain criteria?

=COUNTIF