Acc3304_Exam 4

Emma performed analytics with accounting data. She wants to create a dashboard to present accounts payable metrics and include three charts. Which of the following is a chart Emma should create?

(wrong) Average days sales outstanding

Nissa is creating a daily report that will have visualizations presenting technical details of the data conversion project she's managing. Which party would most likely be the appropriate audience for this visualization?

(wrong) Staff-level employees

Exploring a new data set and understanding its composition commonly involves the data analytics technique data summarization, which involves simplifying data to quickly identify the composition of categorical and quantitative values. We compress the data into smaller, easier-to-understand outputs, called data summaries. To do this, we typically group a data set by a specific

(wrong) data summarization. (Wrong) data Summaries

You are presented with a data set of 6 test scores: 47, 46, 46, 44, 43 and 26. Which grade is an outlier?

26

No more than how many colors should a single visualization use?

4

What percentage of men have a color vision deficiency (CVD)?

8%

You are presented with a data set of 10 test scores: 99, 85, 84, 83, 83, 81, 80, 80, 79, and 66. What is the average test score?

82

Businesses like to use a ________ confidence interval when they perform forecasting.

95%

You are presented with a data set of 10 test scores: 99, 85, 84, 83, 83, 81, 80, 80, 79, and 66. Which grade(s) are an outlier?

96 and 66

The "lower confidence bound" and "upper confidence bound" are part of what?

A confidence interval

Seasonality

A consistent movement that repeats on a regular basis. an example is an increase in revenue every June, July, and August due to summer beach sales.

What uses complex calculations to predict the outcomes and probabilities associated with a decision that influences a data set?

A simulation

The first step in analyzing a data set is learning about its data. Besides discovering patterns, exploration can find unexpected data points. What are these data points called that fall outside the data set's norm?

Anomalies

Kevin is an auditor who is looking at call center metrics that the business tracks. There are four charts that he is auditing. He realizes that one of them does not belong with the theme of call center metrics. Which of the following metrics would be irrelevant to the call center?

Average age of customer

Theo is an auditor who is looking at human resources (HR) metrics that the business tracks. There are four charts that he is auditing. He realizes that one of them does not belong with the theme of HR metrics. Which of the following metrics would be irrelevant to HR?

Average payment processing time

Kira wants to use an icon to represent "savings." Which of the following icon choices would be the best visual cue?

Bank

Micah works at the zoo and wants to illustrate the cost of maintenance for each of the animals that are in the Safari exhibit. There are 12 types of animals in the Safari exhibit. What type of chart should Micah use for his report to management?

Bar chart

What type of chart was first adopted by businesses because they are the easiest to understand?

Bar charts

Dalton collected customer review data for his customer support audit that he is performing. He's trying to find the lowest score that the customer support staff received, the highest score, the median score, and how all the other scores fall between those values. What type of chart should he create?

Box plot

Griffin is tasked with visualizing hourly wages of tax directors in his accounting firm. Griffin's visualization will show the maximum, minimum, and median hourly wage. Which chart would help him visualize that information?

Box plot

The known fixed costs are compared to the estimated variable costs to predict what?

Break-even Analysis

Lina is creating visualizations that will present big ideas about the core functions of the business, such as accounting, finance, marketing, and sales. Who is most likely her visualization audience?

CEO

The first step in analyzing a data set is learning about its data. Exploratory data analytics techniques reveal the key characteristics of a data set. Exploratory data analytics techniques help us identify three key factors of a data set. Which of the key factors is the descriptive components within a data set?

Categorical values

Diagnostic Analytics

Category of data analytics that tells us why something happened.

Jasmine has done data analysis around the current communication system at work. It turns out that the employees send over 100 emails every day to communicate with one another. She wants to prepare a data story to help management understand that the company should adopt an instant internal communication system like Microsoft Teams or Slack. What part of the story would present the results of her data analysis?

Climax

Bar charts are best used for what?

Comparison

Mirabel wants to create key performance indicators to help monitor for suspicious transactions by using an accounts payable data set. What can she use to present these key performance indicators if she wants to include many charts, in one view, which will be updated on a regular basis?

Dashboard

Five data analytics-related job titles were discussed in the text. Which of the following job titles would need an expert understanding of database administration?

Data Engineer

________ is a data analytics technique that presents data in a graphical format.

Data Visualization

Five data analytics-related job titles were discussed in the text. Which of the following job titles would best fit the following description: "Collects, manipulates, and analyzes data across a business."

Data analyst

Five data analytics-related job titles were discussed in the text. Which of the following job titles would best fit the following description: "Builds the technological infrastructure and architecture for gathering, growing, and storing raw data."

Data engineer

Five data analytics-related job titles were discussed in the text. Which of the following job titles would best fit the following description: "Designs and programs algorithms to collect and analyze data and perform predictive analytics."

Data scientist

What is the first step in most complex data analytics techniques?

Data summarization

There are four widely used categories of data analysis. Which two looks at the past and uses historical data to learn more about what occurred and why it occurred?

Descriptive and Diagnostic

Naomi is an accountant who is visualizing sales of the current best-selling product — a hand sanitizer. She realizes that there was a sharp increase in the demand for hand sanitizers after the pandemic. Her visualization story will also include why hand sanitizer is the best-selling product. What type of analytics did she perform?

Diagnostic

Choose from the definitions below the best definition of event log data.

Event log data is data about activities in a system and includes the timestamp of when the activities occur.

What part of the story arc presents suggestions for improvement or predictions of what may happen if the audience take certain actions?

Falling action

What is the process of estimating future events based on the combination of past and present time series data?

Forecasting

When you tag a location in a social media post, what type of analytics are you practicing?

Geospatial analytics

Choose from the definitions below the best definition of geospatial analytics.

Geospatial analytics is a technique that gathers, transforms, and visualizes geographic data and imagery.

Cyrus is tasked with visualizing a ratio of sales divided by the number of employees in each of the store locations to see which stores would need a potential increase in headcount. Which chart would help him visualize that information?

Geospatial map

Victor, who works for a bank, has created an interactive dashboard that charts customer locations via a bank mobile app that tracks the customer location and the locations where the customer credit card payment is being made. Victor is using which type of chart to visualize this information?

Geospatial map

Malika, the accountant, is creating a visualization for the Environment, Social, and Governance (ESG) report. She is charting the sustainability efforts of the company and the improvement that it has had over the past year around sustainability. Which color scheme should she use?

Green

Which type of chart focuses on the use of different colors to represent the values of the data set it visualizes?

Heat map

Celine has created a scatter plot diagram that identifies outliers in the company's daily transactions that her bosses hope will help identify fraudulent transactions. Reading it properly requires strong technical knowledge. Which party would most likely be the appropriate audience for this visualization?

Internal audit department

What part of the story arc describes the subject matter and why it is being presented?

Introduction

Bank

Kira wants to use an icon to represent "savings". which of the following icon choices would be the best visual clue? -Handshake -Checkmark -Bank -Tree

CEO

Lina is creating visualizations that will present big ideas about the core functions of the business, such as accounting, finance, marketing, and sales. Who is most likely her visualization audience?

As an accountant working at a university, Malik wants to chart the number of students who are attending the university, full-time, over the course of the past 10 years. Which chart should Malik use?

Line chart

Setting the tone of the visualization

Milo, an accountant, is presenting sales data from the past quarter to the CFO. The sales were not good in the past quarter, as they severely missed the projections. He wants to be able to present data in a way that the CFO will remember, since the CFO hears many presentations in a day. What should he focus on when presenting the bad news?

What is a popular simulation that predicts the probability of different outcomes in the presence of many random variables?

Monte Carlo simulation

Diagnostic

Naomi is an accountant who is visualizing sales of the current best- selling product- a hand sanitizer. She realizes that there was a sharp increase in the demand for hand sanitizers after the pandemic. Her visualization story will also include why hand sanitizer is the best selling product. What type of analytics did she perform?

is additional movements in the time series data that cannot be explained as a trend or seasonality. A drastic spike in revenue at the end of February due to a large customer order for a one-time event is an example of

Noise

There are human aspects behind all data. Out of the following, which data scenario requires an extra level of respect when speaking to it?

Number of claims filed in a life insurance company

What is a popular method of summarizing smaller data sets in Excel?

Pivot table

There are four widely used categories of data analytics. Which one uses statistical modeling and algorithms to predict what is likely to happen?

Predictive analytics

There are four widely used categories of data analysis. Which two analyze historical data and predict future events, providing recommendations on what the business should do?

Predictive and Prescriptive

Choose from the definitions below the best definition of process mining.

Process mining uses event log data to show what individuals, systems, and machines are doing in a visual format.

What type of values is the following? total sale amount, hotel tax amount, sales tax percentage.

Quantitaive values

The first step in analyzing a data set is learning about its data. Exploratory data analytics techniques reveal the key characteristics of a data set. Exploratory data analytics techniques help us identify three key factors of a data set. Which of the key factors is the numeric data points that can be summed, counted, or otherwise analyzed using mathematical operations?

Quantitative values

There are four widely used categories of data analytics. Choose the best description for prescriptive analytics.

Requires advanced programming

What is a type of network analysis that investigates social structures on social media?

Social network analysis

You recently joined Facelink, the latest social network craze. Facelink suggests 3 "friends" for you to link with based on your current connections. What type of network analysis is Facelink practicing?

Social network analysis

Five data analytics-related job titles were discussed in the text. Which of the following job titles would best fit the following description: "The role is math oriented and focuses on collection and interpretation of quantitative data using defined scientific methods."

Statistician

What is a collection of dashboards, stand-alone visualizations, infographics, and other presentation materials?

Storyboard

Choose from the definitions below the best definition of textual analysis.

Textual analysis is a category of data analytics techniques used to interpret objects that include words.

Consider the simple linear regression equation: Y = A + Bx What does A represent?

The Y-Intercept

Which type of chart presents groups and subgroups as rectangular portions of the larger whole?

Tree map

Machine Learning (ML) uses algorithms and statistical models to train an AI system through patterns and trends in data sets. ML programs systems to perform tasks without explicit instructions and is a popular application of AI in data analytics. There are three machine learning approaches. Choose the best definition for unsupervised learning.

Uses algorithms to analyze unlabeled data sets for hidden patterns

Which of the following is not an example of a technical user requirement?

What the business will use the dashboard for

Network Analysis

analytics technique that visualizes relationships among participants in a data set to learn about the social structure those relationships create

Time Series

captures data that occurs in chronological order across a period of time.

Dashboard

collection of individual visualizations that allow the audience to view multiple pieces of data at once

Data visualization is only reliable when underlying data is

complete and accurate

Data visualization is only reliable when underlying data is

complete and accurate.

time trend

consistent movement in the time series daya that does not repeat. one example is an increase in revenue through a fiscal year due to a new product launch.

Exploring a new data set and understanding its composition commonly involves the data analytics technique data summarization, which involves simplifying data to quickly identify the composition of categorical and quantitative values. We compress the data into smaller, easier-to-understand outputs, called ________. To do this, we typically group a data set by a specific field, or column.

data summaries

Exploring a new data set and understanding its composition commonly involves the data analytics technique ________, which involves simplifying data to quickly identify the composition of categorical and quantitative values. We compress the data into smaller, easier-to-understand outputs, called data summaries. To do this, we typically group a data set by a specific field, or column.

data summarization

Linear regression is a statistical technique we use to estimate the relationships between a(n) ________ and one or more independent variables.

dependent variable

Exploring a new data set and understanding its composition commonly involves the data analytics technique data summarization, which involves simplifying data to quickly identify the composition of categorical and quantitative values. We compress the data into smaller, easier-to-understand outputs, called data summaries. To do this, we typically group a data set by a specific

field, or column.

Linear regression is a statistical technique we use to estimate the relationships between a(n) dependent variables and one or more ______________________.

independent variables

The first step toward creating a data visualization is

knowing your audience.

Jorge is preparing the company's annual report. Which of the following is considered a data visualization for this purpose?

line charts showing actual revenues

dependent variable

linear regression is a statistical technique we use to estimate the relationships between a(n) _________ and one or more independent variables

White space refers to

negative space that creates a visual pause.

Predictive Analytics

one of the 4 categories of data analytics that uses statistical modeling and algorithms to predict what is likely to happen

Climax

part of the story arc that shows the results of the analytics that have been performed

Forecasting

process of estimating future events based on the combination of past and present time series daya

Exploring a new data set and understanding its composition commonly involves the data analytics technique data summarization, which involves simplifying data to quickly identify the composition of categorical and ________. We compress the data into smaller, easier-to-understand outputs, called data summaries. To do this, we typically group a data set by a specific field, or column.

quantitative values

Monique works for a popular makeup and beauty store and wants to visualize daily sales of their top five products for the past year to see if there are any seasonal patterns. The goal of her analysis is to discover how different variables in her data set relate to one another. What type of data visualization technique will she use?

relationships

is a consistent movement in the time series data that repeats on a regular basis. An example is an increase in revenue every June, July and August due to summer beach sales.

seasonality

Tree Map

type of chart that presents groups and subgroups as rectangular portions of the larger whole

Clustering, or cluster analysis, is an analytics technique that categorizes data points into groups based on their similarities. The groups, called clusters, are determined by the distance between individual items, which indicates how closely related the data points are. Clustering is a(n) ________ Machine Learning (ML) technique in which the data input contains unlabeled data.

unsupervised

There are four widely used categories of data analytics. Choose the best description for diagnostic analytics.

wrong- Looks at historical data and condenses it into smaller more meaningful bits of information

Exploring a new data set and understanding its composition commonly involves the data analytics technique data summarization, which involves simplifying data to quickly identify the composition of categorical and quantitative values. We compress the data into smaller, easier-to-understand outputs, called data summaries. To do this, we typically group a data set by a specific

wrong-Quantitative values

Choose from the definitions below the best definition of social network analysis.

wrong-Social network analysis is an analytics technique that visualizes relationships among participants in a data set to learn about the social structure those relationships create.

Jade owns a successful coffee shop on a busy street in Brooklyn, New York. She wants to create a quick visualization that shows different days of the week and the number of people who like her Instagram posts on those days versus the likes her competitor coffee shops receive on Instagram for the same days. There are three competitors on Jade's street. Jade identifies the major category to be the days of the week and minor category to be the number of Instagram likes that her coffee shop receives versus the amount that her competitors receive. What type of chart should Jade use for her report?

wrong-bar chart

Amaya is creating a visualization that needs to set an energetic, enthusiastic, and optimistic tone. Which colors should she use in her visualization?

yellow,red, orange