AIS Ch 3

Which of the following is not considered a data visualization tool? Multiple Choice Excel. Chart Maker. Power BI. Python.

Chart Maker.

To readily identify color differences between amounts expected and amounts realized, what exploratory data visualization tool might be used? Multiple choice question. histogram Conditional formatting column chart

Conditional formatting

_____data are numerical data that can take on any numerical value

Continuous

Which type of visualization is used in communicating the findings of the analysis to interested stakeholders? Multiple Choice Exploratory Diagnostic Prescriptive Explanatory

Explanatory

_______data visualizations are part of Share the Story in the AMPS Model.

Explanatory

_______data visualizations that are useful in communicating the findings of the analysis to stakeholders.

Explanatory

Which type of visualization is a graphical representation that is useful for uncovering patterns and useful insights in the data, generally as part of descriptive or diagnostic analytics? Multiple Choice Explanatory Descriptive Predictive Exploratory

Exploratory

Sensitivity analysis table evaluating assumptions made Descriptive Diagnostic Predictive Prescriptive

Prescriptive

break-even graph: Descriptive Diagnostic Predictive Prescriptive

Prescriptive

Which type of chart would best compare hours studied and test scores? Multiple Choice Scatter plot. Map. Histogram. Vertical bar.

Scatter plot.

Storytelling is considered to be primarily in which part of the AMPS model? Multiple choice question. Share the Story Perform the Analysis Ask the Question Master the Data

Share the Story

Which type of graphical summary is used by a company to track various measures? Multiple Choice trackboard graphical interface dashboard web page

dashboard

Storytelling primarily uses which type of data visualizations? Multiple choice question. exploratory data visualizations explanatory data visualizations

explanatory data visualizations

Which type of chart is best to describe the economic conditions of each country? Multiple Choice Map. Doughnut chart. Treemap. Pie chart.

map

Which type of chart would best show outbreaks of the flu by region? Multiple Choice Pie chart. Map. Histogram. Scatterplot.

map

Understanding the data also includes selection of appropriate______

metrics

______data are a type of categorical data that cannot be ranked.

nominal

______ data are a type of categorical data that can be ranked.

ordinal

The best visualization type to show the relative proportion of Tesla's domestic sales to China, to Europe and to the United States, would be which of the following? Multiple Choice pie chart. bar chart. line graph. scatterplot.

pie chart.

These regression results are from Lab 3-3 Excel: Using Scatterplots and Regression to Evaluate the Relationship between Advertising Expenditures and Sales. Given these results, what is the dependent variable? Advertising R&D Expenditures Sales Cannot be determined

sales

To assess the relationship between advertising expense and sales, what exploratory data visualization might be used? Multiple choice question. histogram boxplot bar chart scatterplot

scatterplot

Part of understanding the data is to find relevant ________ for the data.

sources

This dashboard is based on Lab 3-7 Excel: Create a Dashboard in Excel Using Pivot Tables and Slicers and uses filters and slicers to evaluate the quantity sold in each state. Given these results, how many Mavic 2 products are sold in Missouri (MO)? 15 29 24 282

15

What does the following data visualization tell us about the relationship between labor cost per lawn mowed and monthly (profit) margin (the extent to which revenues exceed expenses) as shown on the vertical axis? As labor cost increases, the monthly (profit) margin increases. As labor cost increases, the monthly (profit) margin decreases. As labor cost decreases, the monthly (profit) margin decreases. As labor cost decreases, the monthly (profit) margin stays the sam

As labor cost increases, the monthly (profit) margin decreases.

Which type of graphical summary is used by a company to continuously track various measures? Multiple Choice Trackboard Graphical interface Dashboard Web page

Dashboard

Histograms: Descriptive Diagnostic Predictive Prescriptive

Descriptive

Line and bar charts: Descriptive Diagnostic Predictive Prescriptive

Descriptive

Pie charts: Descriptive Diagnostic Predictive Prescriptive

Descriptive

DescriptiveBox plots highlighting extreme observations: Descriptive Diagnostic Predictive Prescriptive

Diagnostic

Scatterplot: Descriptive Diagnostic Predictive Prescriptive

Diagnostic

Which type of visualization is used in communicating the findings of the analysis to interested stakeholders? Multiple Choice Explanatory. Descriptive. Predictive. Exploratory.

Explanatory

Which type of visualization is a graphical representation that is useful for uncovering patterns and useful insights in the data, generally as part of descriptive or diagnostic analytics? Multiple Choice Explanatory. Incorrect Descriptive. Predictive. Exploratory.

Exploratory.

The best visualization type to show the trend in sales over the past five years at Apple would be which of the following? Multiple Choice Bar chart Line Graph Histogram Scatterplot

Line Graph

Which type of chart is best for time trend data? Multiple Choice Vertical bar. Maps. Histogram. Line chart.

Line chart.

Which type of chart is best to show a persons' weight over time? Multiple Choice Line chart. Vertical Bar. Scatterplot. Pie chart.

Line chart.

Which type of chart would best show enrollment between 2005-2025? Multiple Choice Pie chart. Map. Line chart. Scatterplot.

Line chart.

Which of the following is NOT a well-known visualization tool? Multiple choice question. SPSS Statistical Software Microsoft Excel Microsoft Access Power BI Desktop

Microsoft Access

The best visualization type to show the relative proportion of Tesla's domestic sales to China, to Europe and to the United States would be which of the following? Multiple Choice Bar chart Pie chart Line Graph Scatterplot

Pie chart

Which common visualization type would be used to evaluate the composition of values? Multiple Choice Pie chart Bar chart Line Graph Scatterplot

Pie chart

Which type of chart would best show each division's relative profit within a corporation? Multiple Choice Pie chart. Map. Histogram. Scatterplot.

Pie chart.

This scatterplot is from Lab 3-3 Excel: Using Scatterplots and Regression to Evaluate the Relationship between Advertising Expenditures and Sales. Advertising is on the x-axis and sales are on the y-axis. What does the scatterplot suggest about the relationship between advertising and sales? Positively correlated Negatively correlated No discernible correlation. Cannot be determined

Positively correlated

Time series data with forecast : Descriptive Diagnostic Predictive Prescriptive

Predictive

_______are useful for identifying the possible correlation between two variables and for identifying a trend line or line of best fit.

Scatterplots

Which of the following is NOT an important consideration for developing and presenting visualizations? Multiple choice question. Choose the right chart Selecting appropriate metrics Direct user to most important information Create or reinforce knowledge

Selecting appropriate metrics

Which common visualization type would be used to compare values? Multiple Choice Pie chart Bar chart Line Graph Scatterplot

bar chart

Which common visualization type would be used to compare values? Multiple Choice pie chart. bar chart. line graph. scatterplot.

bar chart.

_______charts are data visualizations using vertical/horizontal bars that represent the total amount of observations in that category

bar, column

______data are numerical data that only take on whole-number (integer) values and have a finite set of values between any two observations.

discrete

A ________report delivered through a dashboard offers real-time updates of various measures continuously tracked by a company.

dynamic

__________data visualizations are often used as part of descriptive or diagnostic analytics.

exploratory

Exploratory data visualization is used to communicate results of the analysis to decision makers and other stakeholders. true or false

false

True or false: Excel is always the best visualization tool.

false

True or false: It is important to provide the decision maker more information than he or she can process.

false

Which type of chart is best to describe exam results for a class? Multiple Choice Treemap. Maps. Histogram. Pie chart.

histogram

_______charts are well suited to showing data changes or trend lines over time.

line

______charts are data visualizations in the form of a circle divided into sections representing the category's proportion of the whole

pie

Explanatory data visualizations are used to communicate the results to decision makers. Group startsTrue or False

true

Pie charts are rarely preferred if there are more than six categories (or "slices" of pie). Group startsTrue or False

true

Storytelling works to ensure that the message conveyed by the analyst is meaningful and relevant.

true

Which type of chart is best for categorical data? Multiple Choice Vertical bar. Maps. Histogram. Pie chart.

Vertical bar.

Is the data below presented more effectively as a visualization or in tabular format? There is no difference in effectiveness between the two presentations (for a sighted person). The data table is more effective at showing the trend (for a sighted person). The visualization line chart is more effective at showing the trend (for a sighted person).

The visualization line chart is more effective at showing the trend (for a sighted person).

Which of the following is typically excluded in an executive summary? Multiple Choice Statement of the problem, question or opportunity. Summary of the results. Brief recommendation. These are all included in an executive summary.

These are all included in an executive summary.

A line graph would be used for which visualization purpose? Multiple Choice Comparison of values Distribution of values Trends of values over time Relationships between values

Trends of values over time