Studied by 253 people

5.0(1)

get a hint

hint

Tags & Description

0%

16 Terms

1

New cards

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

=COUNTA

New cards

2

New cards

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

=RAND

New cards

3

New cards

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

=NORM.DIST

New cards

4

New cards

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

=1-NORM.DIST

New cards

5

New cards

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

=COUNT

New cards

6

New cards

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

=AVERAGE

New cards

7

New cards

Which formula is used to find the Margin of Error?

=CONFIDENCE.NORM

New cards

8

New cards

Which formula is used to find the z-value?

=NORM.S.INV

New cards

9

New cards

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

=NORM.S.DIST

New cards

10

New cards

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

=T.DIST

New cards

11

New cards

Which formula is used to find the t-value?

=T.INV.2T

New cards

12

New cards

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

=SQRT

New cards

13

New cards

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

=STDEV.S

New cards

14

New cards

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

=VAR.S

New cards

15

New cards

How do you use an exponent in Excel?

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

New cards

16

New cards

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

=COUNTIF

New cards