ACCT SB Ch10

The box in a box plot shows where the _________ of the observations are found.

majority

Breakeven sales is the point where the target profit is _______

zero

True or false: Excel automatically sorts and evaluates the data according to your desired scale.

False

True or false: While bar charts represent bins/intervals, histograms represent categories.

False

In ________, the primary method of presenting data already defaults to visualizations, so the benefit of drilling down using charts is automatically processed.

Tableau

True or false: Correlation values range from -1 to 1.

True

True or false: Dashboards typically have filters available to allow decision-makers to hone on a particular time period, category, product, or geographical area.

True

True or false: The vertical axis in a histogram is always associated with a count of observations in each particular bin.

True

Time series data should be visualized using a bar or ______ chart.

line

The upper confidence interval of a sales forecast gives management a _________-case scenario.

best

In diagnostic analytics, outliers are assessed by either eyeballing the data or by constructing a _________ plot to see if it departs from the expected distribution.

box

Time series data is displayed in ________ order.

chronological

Scatter plots reflect ___________ by showing values of two variables each plotted on its own axis.

correlation

_________ is a measure of how much the change in one measure impacts a change in the other measure.

correlation

A ______ of the method is typically the first part of a full written report.

description

Dashboards typically have _________ available so that it is easy for decision-makers to hone on a particular time period, category, product, or geographical area.

filters

Brief recommendations are typically the ______ part of an executive summary.

final

The statement of the problem is typically the __________ part of an executive summary.

first

The ________ axis is generally used for labels in a data visualization.

horizontal

If you are providing a full report, the executive summary should serve as a(n) _______ for what your audience will learn throughout the rest of the report.

introduction

Trend lines can help identify _______ by showing if there is an observation out of the norm pulling the trend in a different direction.

outliers

As part of diagnostic analytics, data in a pivottable can be sliced, diced and filtered to see how the ______ charts shift and change shape, bringing additional insight to a scenario.

pivot

When forecasting using time series data, you can visualize items that have already happened, and also _________ the future with the use of a forecasting line chart.

predict

___________ analytics are performed by identifying patterns in historical data to judge future likelihood or probability.

predictive

___________ data should be visualized starting at zero.

ratio

Correlation, ________ and forecasting are three common methods for running predictive analytics.

regression

Depending on the amount of information you wish to convey and how much your audience is interested in reading about your analysis, you may provide just an executive summary or a full written ____

report

In a visualization of a breakeven point of units sold, the breakeven is found at the intersection of total cost and total _____

revenue

___________ plots reflect correlation by showing values of two variables each plotted on its own axis.

scatter

_________ analysis is used to test different assumptions (such as different levels of sales growth or different cost of capital discount rates) and see their effect on the outcome.

sensitivity

A ________ chart makes it easy to identify which company had the highest sales.

sorted

When performing sensitivity analysis, sometimes graphs and bar charts are best; other times a simple _____ is the most effective visualization.

table

The ________ line will help visualize how well the linear regression model "fits" the actual observation, or data points.

trend

_________ are a data visualization tool to show the general direction something is going.

trends

Used for values in data visualization

vertical

Data _______ presents the results of analysis in an accessible way through charts or graphs.

visualization