data test #1

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/13

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced
Call with Kai

No study sessions yet.

14 Terms

1
New cards

measures of central tendancy

mean, excel, median

2
New cards

COUNTIFS Definition

counts rows that meet certain criteria

ex: How many married males over 60 ear > $125,000?

3
New cards

COUNTIFS formula

COUNTIFS(range 1, criteria 1, range 2, criteria 2)

ex: How many married males over 60 ear > $125,000?

=COUNTIFS (B:B, “Male”, C:C, “Married”, D:D, “>=60”, F:F, “>125,000”)

4
New cards

AVERAGEIFS defintion

calculates the average for rows meeting specific criteria

ex: What is the average spending of married females with >= 2 children?

5
New cards

AVERAGEIFS formula

ex: What is the average spending of married females with >= 2 children?

=AVERAGEIFS(G:G, B:B, “Female”, C:C, “Married”, E:E. “>=2”)

6
New cards
7
New cards
8
New cards
9
New cards
10
New cards
11
New cards
12
New cards
13
New cards
14
New cards