Flashcard decks

Generated Deck

37 flashcardsby Carissa
Study these flashcardsFree · spaced repetition · iPhone, Android, Mac & web

All cards

1
A coffee shop report shows last month’s sales totals per drink category. Which type of analytics is this?
  • Descriptive analytics
  • Predictive analytics
  • Prescriptive analytics
2
What does descriptive analytics do?
Summarizes past or current data
3
A hotel uses historical booking data to estimate next weekend’s room occupancy. Which type of analytics is this?
  • Predictive analytics
  • Descriptive analytics
  • Prescriptive analytics
4
Which business question is best answered by prescriptive analytics?
Which employee schedule minimizes labor cost while meeting staffing requirements
5
A company measures job satisfaction using only commuting distance, recorded accurately. What is the main problem?
The measure lacks validity because commuting distance does not measure job satisfaction
6
Which representations of a business process can serve as a model?
A written description, a diagram, and an equation (all three)
7
Which statement best describes a decision model?
A logical or mathematical representation used to analyze a situation and support a decision
8
A print shop has fixed cost \$400 and variable cost \$3 per unit. What is the cost for 80 units?
\$640, found by \$400 + 3 × 80
9
What is a deterministic model?
A model in which all input values are known or assumed known with certainty
10
In a worksheet with one employee per row, what is a record and what is a field?
Each row is a record and each column is a field
11
How can a manager display only orders with Status Pending while keeping all other orders in the worksheet?
Filter the Status column to show Pending
12
Which situation best illustrates the Pareto principle?
A small percentage of customers accounts for a large percentage of total sales
13
Which Excel function searches the top row of a table for a value and returns a value from the same column?
HLOOKUP
14
What does the Excel function DSUM do?
Adds the values in a specified field for records that meet the criteria
15
Which Excel feature rejects values other than whole numbers 1-5 typed into a cell?
Data Validation
16
Which PivotTable setup gives one row per department, one column per month, and total expense in each cell?
Rows: Department; Columns: Month; Values: Sum of Expense Amount
17
What is the main purpose of a slicer connected to a PivotTable?
To filter the PivotTable using selectable buttons
18
Which chart is most appropriate for showing a weekly customer count trend over 12 weeks?
  • Line chart
  • Pie chart
  • Scatter chart
  • Bubble chart
19
Which chart is most appropriate for comparing total employees across six departments?
  • Bar or column chart
  • Line chart
  • Scatter chart
20
In a pie chart of company expenses, what does each slice’s size represent?
The proportion of that category relative to total expenses
21
Which chart is most appropriate for examining the relationship between floor area and selling price of 40 houses?
  • Scatter chart
  • Pie chart
  • Line chart
  • Column chart
22
In a bubble chart with advertising spending on the x-axis and revenue on the y-axis, what can bubble size represent?
A third numerical variable, such as number of employees
23
Which Excel tool puts a horizontal bar in each cell, with longer bars for larger inventory values?
Data bars
24
Which Excel tool places a miniature line chart in a cell to show a product’s 12-month sales trend?
Line Sparklines
25
What is the main purpose of a dashboard?
To summarize key business measures for monitoring and decision making
26
A company randomly surveys 100 of its 2000 customers. What are the population and the sample?
The population is all 2000 customers; the sample is the 100 selected customers
27
15 of 60 customer orders were placed online. What is the relative frequency of online orders?
25%, since \$\frac{15}{60}=0.25\$
28
Which measure best describes a typical rent when one luxury apartment is an extreme high value?
  • Median
  • Mean
  • Maximum
  • Range
29
Why is the median better than the mean when there is an unusually high value?
It is less affected by extreme values
30
A distribution has a long tail on the right caused by a few large purchases. How is it described?
Positively skewed (right skewed)
31
What does an 80th percentile of 6 days for repair time mean?
About 80% of repairs take 6 days or less
32
The first quartile is \$30 and the third quartile is \$80. What is the interquartile range?
\$50, since \$80-30=50\$
33
How do you calculate the interquartile range?
\$IQR = Q_3 - Q_1\$
34
What is the appropriate next step when you find a possible outlier in delivery times?
Check the original record and business context to see whether it is an error or a legitimate unusual delay
35
What does a correlation of r = 0.85 between store size and annual sales indicate?
A strong positive linear relationship
36
A regression of productivity on training hours gives R square = 0.81. What does it mean?
The model explains 81% of the variation in productivity in the sample
37
A delivery time regression was fitted using trips of 5-25 miles. Which prediction is extrapolation?
Predicting delivery time for a 40-mile trip
Study all 37 cards for free