Unit 6

Question 1

Why do we want to avoid the pie chart in part-to-whole analysis, such as that shown above in the pie chart series?

Answer 1

All of Above:
- The human visual system is not very good at accurately comparing angles or areas
- It is difficult to compare and see trends across the same segment of a pie chart in a series of charts
- When there are many parts (segments) in a pie chart, it can be very difficult to see and label the narrower slices

Question 2

Based on the Pareto chart above, select the smallest number of diseases that account for over 60% of total insurer costs

Answer 2

• Hypertension
• Diabetes
• Acid reflux

Question 3

Select all of the problems below that apply to the specific Pareto chart above.

Answer 3

Visual clutter from many small values

Handling values that vary greatly in magnitude

Question 4

In the bump chart above, which status has the second-most number of children from 2000 to 2013?

Answer 4

Divorced

Question 5

For which question would it be best to use a Pareto chart?

Answer 5

You know the percentage of patients who were readmitted and the reason for their readmission and you want to know the smallest number of readmission reasons that account for a total of 80% of readmissions

Question 6

If we are interested in seeing how the proportion of patients change across age groups for a single region, which graph is best? For example, consider the question: how does the proportion of patients vary across age groups for the South region?

Answer 6

Either Percent of Total or Small Multiples -
Both of these graphs work well for this question. Percent of Total allows you to easily see how the proportions change for a single range over the age groups. Small Multiples group data by region together and the bars share a common baseline. This makes it easy to see the trend across age groups for a single region.

Question 7

What do you need to do in Tableau to create the line portion on the Pareto chart above for Insurer Cost, such that it shows a running sum of % of Insurer Cost?

Answer 7

Apply a quick table calculation, Running Total, to Insurer Cost and then Edit the table calculation and perform a secondary calculation: Percent of Total summarizing values from Disease. Finally, right click the rightmost axis and select Synchronize Axis.

Question 8

If we want to know which region has the lowest proportion of patients in an age range, what is the most effective graph? For example, consider the question: which region has the lowest proportion of patients in the 41-54 age range?

Question 9

To turn the graph above into the Bump chart shown below, you must right click on

Answer 9

Sum(Children) then choose the Quick Table Calculation
Rank
and then right click on Sum(Children)_____

and choose Compute using Status_______

Question 10

The position of the labels and bars on the grouped bar chart represents which graphic design principle?

Answer 10

Alignment and proximity

Question 11

What are the levels of situation awareness?

Answer 11

All of above:
- Perception of elements in the environment
- Comprehension of the current situation
- Projection of future status

Question 12

A dashboard is a VISUAL display of the most important INFORMATION needed to achieve one or more objectives that has been consolidated on a SINGLE computer screen so it can be monitored at a glance.

Question 13

The concept of a common baseline in charts such as the Grouped Bar Chart and Small Multiples is most related to which graphic design principle?

Answer 13

Alignment -
A common baseline means that the bars are all aligned (start) on the same line

Question 14

In the graphs above, the color palette used to encode the three regions uses which graphic design principle to visually differentiate the regions?

Answer 14

Contrast -
Since each region is a different category the selected color palette consists of distinct hues to maximize the contrast, or difference, between the visual elements encoding the regions

Question 15

Which of the following are characteristics of a well-designed dashboard?

Answer 15

Exceptionally well organized
# Condensed, primarily in the form of summaries
# Specific to the task at hand and to those who will use it
# Concise representations that communicate the information in the clearest and most direct way possible

Question 16

In the Healthcare Costs visualizationLinks to an external site., what property does disease have?

category

Question 17

Why do we need to provide an overview first?
It helps to give an overall sense of patterns in the data
It helps the user decide the next move in information retrieval
It helps in deciding where the important details lie in a graph
All of above

Question 18

What do you need to do in Tableau to create the line portion on the Pareto chart above for Insurer Cost, such that it shows a running sum of % of Insurer Cost?

Answer 18

NOT

Define a calculated field using the formula SUM([Insurer Cost]) and use the calculated field to make the line, then choose Quick Table Calculation->Percent of Total
Finally, right click the rightmost axis and select Synchronize Axis

Select Disease and Insurer cost in the Dimensions and Measure windows and then select the Pareto chart type in Show Me

Question 19

When you have a single bar chart showing percent of total for a number of items (say percent of patients for 10 different hospitals) you can best help the viewer determine their relative ranking by

Answer 19

Sorting the bars from lowest to highest (or highest to lowest) percent of patients

Question 20

Suppose you have the following data in Excel:

and you would like to produce the following graph:

Answer 20

Use Measure Names and Measure values

Question 21

Considering only the fields (variables) named “Insurer Cost” and “Disease”, to begin to create the Pareto chart above in Tableau, you drag

Answer 21

___Di
to Columns,

___Insurer Cost
to Rows, and then

to the right side of the graph.

Question 22

In the stacked bar chart it is difficult to perceive the changes in proportion across age ranges for the South region (orange) because

Answer 22

The orange segments do not share a common baseline and are fairly similar in length