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

studied byStudied 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 Note
studied byStudied by 28 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 22 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 7 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 2996 people
Updated ... ago
4.8 Stars(52)
note Note
studied byStudied by 23 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 4 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 6 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 45 people
Updated ... ago
5.0 Stars(1)

Explore top flashcards

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