data test #1

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
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

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