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
What chart would you use to display the number of movies by MPAA Rating & Genre?
A. Contigency Table
B. Scatterplot
C. Grouped Frequency Table
contigency table
What chart would you use to display the release dates by decade?
A. Contigency Table
B. Scatterplot
C. Grouped Frequency Table
grouped frequency table
What chart would you use to display the data on total box office ?
A. Frequency Table
B. Pie Chart
C. Histogram
histogram
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
The entire dataset (Employee ID, Q1 Sales, Q2 Sales)
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
The Q2 Sales column only
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 grouped frequency table on Q2 Sales; the x values and their counts.
What type of chart requires summarized data (i.e., a frequency table)?
A. Pivot Table
B. Histogram (using INSERT -> HISTOGRAM)
C. Pie Chart
pie chart
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
column chart
Do students tend to find scheduling relatively easy or relatively difficult? (mean: 27 median: 32)
easy
