qba 1720 Flashcards
Which is an example of quantitative data?
Employee ID
Hours worked
Gender
hours worked
Which is an example of qualitative data?
Weight
Social Security Number
Height
social security number
What type of chart is best to show how the parts make up a total?
Pie
Histogram
Line
pie
What type of chart can plot qualitative data?
Pie chart
Bar/column chart
Both of these
both of these
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
“IFS” allow you to add additional conditions, if needed
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
The number of times a specified value appears in a range of selected cells
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
Cells to look in, value(s) to look for
What is the purpose of a pivot table?
To break down summarized data
To summarize data
To reorganize tables of data
To summarize data
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
Pivot table
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
The unique values from that field are each shown in a separate row
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
pie chart
What chart would you create to display the number of movies for each genre?
A. Scatterplot
B. Line Chart
C. Column / Bar Chart
column / bar chart
What chart would you use to display the total box office for each genre?
A. Column / Bar Chart
B. Pie Chart
C. Line Chart
column / bar chart
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
line chart
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
scatterplot