qba 1720 Flashcards

1
Q

Which is an example of quantitative data?

Employee ID
Hours worked
Gender

A

hours worked

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Which is an example of qualitative data?

Weight
Social Security Number
Height

A

social security number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What type of chart is best to show how the parts make up a total?

Pie
Histogram
Line

A

pie

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What type of chart can plot qualitative data?

Pie chart
Bar/column chart
Both of these

A

both of these

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Why do we use CountIFS instead of the CountIF version of the count function in Excel?

“IFS” has a simpler syntax
“IFS” allow you to add additional conditions, if needed
It’s an individual choice; you can use them interchangably

A

“IFS” allow you to add additional conditions, if needed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does a COUNTIFS function show you?

The total value of all the specified cells combined
The number of times a specified value appears in a range of selected cells
The average value of all of the specified cell values

A

The number of times a specified value appears in a range of selected cells

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does the CountIFS syntax tell you to select for the inputs? =COUNTIFS (Criteria_range1, criteria1, …)

Cells to lock, value(s) to make relative
Value(s) to look for, cells to look in
Cells to look in, value(s) to look for

A

Cells to look in, value(s) to look for

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the purpose of a pivot table?

To break down summarized data
To summarize data
To reorganize tables of data

A

To summarize data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which could you use to find the frequency that a value occurs in a range?

CountIFS
Pivot table
Either; they can both calculate the frequency of a value, just in different ways

A

Pivot table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

When you put a field into the Rows area of a pivot table builder, what is displayed?

The unique values from that field are each shown in a separate row
The total of the quantitative values in a row
All of the individual values shown in the center of the pivot table

A

The unique values from that field are each shown in a separate row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What chart would you create to display the % of each MPAA rating (G, PG, PG-13, R)

A. Scatterplot
B. Line Chart
C. Pie Chart

A

pie chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What chart would you create to display the number of movies for each genre?

A. Scatterplot
B. Line Chart
C. Column / Bar Chart

A

column / bar chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What chart would you use to display the total box office for each genre?

A. Column / Bar Chart
B. Pie Chart
C. Line Chart

A

column / bar chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What chart would you create to display how the total box office has changed over time?

A. Line Chart
B. Column / Bar Chart
C. Scatterplot

A

line chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What chart would you use to display the relationship between total box office and rotten tomatoes scores?

A. Column / Bar Chart
B. Scatterplot
C. Line Chart

A

scatterplot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What chart would you use to display the number of movies by MPAA Rating & Genre?

A. Contigency Table
B. Scatterplot
C. Grouped Frequency Table

A

contigency table

17
Q

What chart would you use to display the release dates by decade?

A. Contigency Table
B. Scatterplot
C. Grouped Frequency Table

A

grouped frequency table

18
Q

What chart would you use to display the data on total box office ?

A. Frequency Table
B. Pie Chart
C. Histogram

A

histogram

19
Q

What data would you select to create a pivot table?

A. The entire dataset (Employee ID, Q1 Sales, Q2 Sales)
B. A grouped frequency table
C. A descriptive statistics table

A

The entire dataset (Employee ID, Q1 Sales, Q2 Sales)

20
Q

What data do you select if you wanted to create a histogram for Q2 Sales by using Insert > Histogram?

A. The entire dataset (Employee ID, Q1 Sales, Q2 Sales)
B. A grouped frequency table on Q2 Sales
C. The Q2 Sales column only

A

The Q2 Sales column only

21
Q

What data would you select to create a column chart (which can then be formatted as a histogram) for Q2 Sales?

A. The entire dataset (Employee ID, Q1 Sales, Q2 Sales)
B. A grouped frequency table on Q2 Sales; the x values and their counts.
C. The Q2 Sales column only

A

A grouped frequency table on Q2 Sales; the x values and their counts.

22
Q

What type of chart requires summarized data (i.e., a frequency table)?

A. Pivot Table
B. Histogram (using INSERT -> HISTOGRAM)
C. Pie Chart

A

pie chart

23
Q

What type of chart can you insert using data from a pivot table?

A. Grouped Frequency Table
B. Histogram (using INSERT -> HISTOGRAM)
C. Column Chart

A

column chart

24
Q

Do students tend to find scheduling relatively easy or relatively difficult? (mean: 27 median: 32)

A

easy

25
Q

The Scheduling Difficulty mean and median are very different. Which is best to use, mean or median?

A

median

26
Q

If you wanted to only find the single lowest # Apps someone had, what function would you use?

A

MIN

27
Q

Why do we use “COUNTIFS” instead of the “COUNTIF” versions of the functions in Excel?

a. “IFS” have a simpler syntax
b. “IFS” statements allow you to add additional conditions, if needed
c. No real reason; you can use them interchangably

A

“IFS” statements allow you to add additional conditions, if needed

28
Q

What is the purpose of SUMIFS?

To average the value of selected cells when specific conditions are met
To count the number of cells that meet specific conditions
To total the value of selected cells when specific conditions are met

A

To total the value of selected cells when specific conditions are met

29
Q

What is the purpose of AVERAGEIFS?

To total the value of selected cells when specific conditions are met
To count the number of cells that meet specific conditions
To average the value of selected cells when specific conditions are met

A

To average the value of selected cells when specific conditions are met

30
Q

How are COUNTIFS different from SUMIFS and AVERAGEIFS?

COUNTIFS can only be used with qualitative data
COUNTIFS give you the option of counting, adding or averaging, making it a more robust option
SUMIFS and AVERAGEIFS have one more required argument in the syntax

A

SUMIFS and AVERAGEIFS have one more required argument in the syntax

31
Q

Assume you have data for sales generated by all employees in a company. In which scenario would you choose to use a regular SUM function rather than a SUMIFS function?

Find the total sales for all employees who had greater than $10,000 in sales
Find the total sales for all employees
Find the total sales for all part-time employees

A

Find the total sales for all employees