Label lab alt submission jpgcopyright mcgraw-hill education

Richardson, Teeter, Terrell – Introduction to Data Analytics for Accounting, 1st Edition – Chapter 10

Chapter 10 End-of-Chapter Assignment and Lab

a. categorical
b. numerical
c. diagnostic
d. predictive
3. (LO 10-2) ____________ are observations on values taken on by a variable at different points

in time.

a. Scatter plots; trends
b. Scatter plots; correlation
c. Graphs; correlation
d. Graphs; trends
6. (LO 10-3) Correlations, scatter plots, regression results and time series analysis are generally associated with _________ analytics.

a. predictive
b. prescriptive
c. diagnostic
d. descriptive

a. Box plots
b. Scatter plots
c. PivotCharts
d. Time Series
8. (LO 10-4) Scatter plots are more meaningful if they include a _____________ .

a. time series prediction
b. box plot
c. trend line
d. categorical variable
9. (LO 10-3) An outlier showing on a box plot will typically appear ________ the maximum or minimum value within the expected range.

While bar charts and pie charts can both be used for categorical or numerical data, bar charts are

more optimal for categorical data because the differences in values are more readily seen,

2. (LO 10-1, LO 10-2) How does sorting help the decision maker more quickly grasp information

conveyed in a bar chart?

When there are multiple bits of information that are meaningful on their own, it does not make as

much sense to aggregate them or summarize them in a visualization. When using a table with

how to interpret the un-aggregated numbers.

Brief Exercises


Trend of Net Income over the Past Five Years	Bar Chart or Line Chart


Numerical Data	Bar Chart or Line Chart

Data Term

	General direction something is going.
Proportion

	values of two variables each plotted on its own axis to exhibit possible correlation
Time Series Data


Scatter plots	Diagnostic or Predictive


Pie Charts	Descriptive

the rest of the students measured.

c. Weight is more varied than height.

are other variables that should be considered. The scatter plot visually displays the positive correlation

that the correlation value implies.

Submission 1.jpg”

2. Clear all of the filters in your slicers and take a screenshot. Label it “Lab 10-1 Submission 1.jpg”

Multiple Choice Questions:

1. Which settings would you adjust to change which pivottables will interact with a specific slicer?

2. Where do you change the heading (caption) of a slicer?

a. Report Connections

a. 4

b. 5

b. IPA

c. Stout

c. 1/22/2020

d. 4/8/2020

Richardson, Teeter, Terrell – Introduction to Data Analytics for Accounting, 1st Edition – Chapter 10

1. Select AR in the Dashboard-Level Supplier_St (and maintain the filter for Malt-Wheat), so that

Copyright © 2021 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill

Education.

1. Were there any products that weren’t purchased in every state (except for Nevada(NV))?

a. Yes, Hops

purchase orders created with Arkansas suppliers?

a. 1/11/2019

Malt-Wheat purchased?

a. 1/11/2019

b. 12/2/2019

c. 12/24/2019

c. 6

d. 7

d. 18

Lab 10-2

Education.

10-9

Education.

10-10

a. AR

b. TX

b. Imperial Stout

c. Stout

10-11

Richardson, Teeter, Terrell – Introduction to Data Analytics for Accounting, 1st Edition – Chapter 10

10-12

Multiple Choice Questions:

Richardson, Teeter, Terrell – Introduction to Data Analytics for Accounting, 1st Edition – Chapter 10

a. Hops
b. Malt - Barley
c. Malt - Wheat
2. Which raw material is purchased most frequently from suppliers in Washington?

10-14