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
The Scheduling Difficulty mean and median are very different. Which is best to use, mean or median?
median
If you wanted to only find the single lowest # Apps someone had, what function would you use?
MIN
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
“IFS” statements allow you to add additional conditions, if needed
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
To total the value of selected cells when specific conditions are met
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
To average the value of selected cells when specific conditions are met
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
SUMIFS and AVERAGEIFS have one more required argument in the syntax
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
Find the total sales for all employees