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

Studied by 253 people
5.0(1)
get a hint
hint

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

1 / 15

Tags & Description

A list of all formulas in Modules 13-23 and their uses

Studying Progress

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

Explore top notes

Note
Studied by 28 people
Updated ... ago
5.0 Stars(2)
Note
Studied by 22 people
Updated ... ago
5.0 Stars(1)
Note
Studied by 7 people
Updated ... ago
5.0 Stars(2)
Note
Studied by 2996 people
Updated ... ago
4.8 Stars(52)
Note
Studied by 23 people
Updated ... ago
5.0 Stars(2)
Note
Studied by 4 people
Updated ... ago
5.0 Stars(1)
Note
Studied by 6 people
Updated ... ago
5.0 Stars(1)
Note
Studied by 45 people
Updated ... ago
5.0 Stars(1)

Explore top flashcards

Flashcard35 terms
Studied by 67 people
Updated ... ago
5.0 Stars(2)
Flashcard127 terms
Studied by 7 people
Updated ... ago
5.0 Stars(1)
Flashcard82 terms
Studied by 4 people
Updated ... ago
5.0 Stars(1)
Flashcard59 terms
Studied by 14 people
Updated ... ago
5.0 Stars(1)
Flashcard406 terms
Studied by 5 people
Updated ... ago
5.0 Stars(1)
Flashcard45 terms
Studied by 2 people
Updated ... ago
5.0 Stars(1)
Flashcard260 terms
Studied by 1 person
Updated ... ago
5.0 Stars(1)
Flashcard33 terms
Studied by 20 people
Updated ... ago
5.0 Stars(3)