BANA 2082 - Exam 1 Questions & Answers
Business Analytics II (University of Cincinnati)
BANA 2082 - Exam 1 Questions & Answers
Business Analytics II (University of Cincinnati)
lOMoARcPSD|lOMoARcPSD|
1.) Data dashboards are a type of _________ analytics.
Answer: desciptive
2.) ______...
BANA 2082 - Exam 1 Questions & Answers
Business Analytics II (University of Cincinnati)
BANA 2082 - Exam 1 Questions & Answers
Business Analytics II (University of Cincinnati)
lOMoARcPSD|47166518lOMoARcPSD|47166518
1.) Data dashboards are a type of _________ analytics.
Answer: desciptive
2.) _______________ analytics are techniques that use models, constructed from past data, to
predict
the future or to ascertain the impact of one variable on another.
Answer: predictive
3.) _______________ analytics use techniques that take input data and yield a best course of
action.
Answer: prescriptive
4.) Corporate-level managers use ______ to summarize sales by region, current inventory
levels, and
other company-wide metrics all in a single screen.
Answer: data dashboards
5.) A forecast that helps direct police officers to areas where crimes are likely to occur based on
past data
is an example of
Answer: predictive analytics.
6.) The company identified in Chapter 3, Analytics in Action, is
Answer: Cincinnati Zoo & Botanical Garden
7.) The Analytics in Action example in Chapter 3 concerned
Answer: a data dashboard
8.) Chapter 3 focuses on
,Answer: data visualization
9.) Data-ink is the ink used in a table or chart that
Answer: is necessary to convey the meaning of the data to the audience.
10.) The ratio of the amount of ink used in a table or chart that is necessary to convey
information to the
total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink
that is not
necessary to convey information has what effect on the data-ink ratio?
Answer: reduces
11.) Deleting the grid lines in a table and the horizontal lines in a chart
Answer: increases the data-ink ratio
12.) In many cases, white space in a chart can improve
Answer: readability
13.) Tables should be used instead of charts when
Answer: the values being displayed have different units or very different magnitudes
14.) Which one of the following statements is not true concerning PivotTables in Excel?
Answer: PivotTables can only be used if one variable is categorical and the other is quantitative
data
15.) Fields may be chosen to represent all of the following except ____________ in the body of
a
PivotTable.
Answer: filters
16.) The software package most commonly used for creating simple charts is
Answer: Excel
17.) In the file, MajorSalary, data have been collected from 111 College of Business graduates
on their
monthly starting salaries. Create a PivotTable. Which major has the greatest number of
graduates?
Answer: Accounting
, 18.) Using a PivotTable and the MajorSalary data, determine the average starting salary of
management
majors. Round your answer to two decimal places and do not include a dollar sign.
Answer: 3180
19.) Using a PivotTable and the MajorSalary data, determine the highest starting salary for Info
Systems
majors. Round your answer to two decimal places and do not include a dollar sign.
Answer: 5030
20.) The attached file shows the number of U.S. locations for the top 20 U.S. franchises. Create
a
PivotTable and group the number of locations starting at zero, ending at 39,999 by 10,000. How
many
franchises are in the 0 to 9999 category?
Answer: 13
21.) Based on the assigned web article, in the Dodgers Front Office how many people have the
term
analyst or research in their titles?
Answer: 21
22.) A _____________ is a graphical presentation of the relationship between two quantitative
variables.
Answer: scatter chart
23.) A _____________ is a line that provides an approximation of the relationship between the
variables.
Answer: trendline
24.) In order to visualize three variables in a two-dimensional graph, we use a
Answer: bubble chart
25.) DJ needs to display data over time. Which of the following charts should he use?
Answer: Line chart
26.) A line chart that has no axes but is used to provide information on overall trends for time
series data
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EXCELLENTSCORES1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.99. You're not tied to anything after your purchase.
