Chapter 3 - Determining Effective Data Display with Charts Flashcards Preview

Quantitive Analysis with Excel > Chapter 3 - Determining Effective Data Display with Charts > Flashcards

Flashcards in Chapter 3 - Determining Effective Data Display with Charts Deck (18)
Loading flashcards...
1

List 5 data graphic principles

1. Above all else, show the data
2. Maximize the data-ink ratio
3. Erase non-data-ink
4. Erase redundant data-ink
5. Revise and edit

2

What refers to the portion of ink that is devoted to displaying the data versus the portion of the graphic that can be removed without losing the data?

The data-ink ratio

3

What are small word-sized charts or graphics that are embedded within the words, numbers, and images they represent?

Sparklines

4

What makes multiple comparisons of trends and patterns much easier?

Sparklines

5

Which chart compares values across categories in a vertical orientation?

The column chart

6

Which chart compares values across categories in a horizontal orientation?

The bar chart

7

Which chart indicates trends over time or by category by the height of the lines?

The line chart

8

Which chart compares the contribution each value in a single numeric data series makes to the whole or 100%?

The pie chart

9

Which chart combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend values over time or categories?

The area chart

10

Which chart plots numeric values on both the x- and y-axes based on the value of the data?

The x-y (Scatter) chart

11

Which chart illustrates the cumulative effects of data in categories?

The stacked chart

12

True or False:

Increasing the number of pie segments to improve the visual display of data

False

13

Which chart shows individual percentages contained in a pie chart for more than one series?

The doughnut chart

14

What is used to smooth out the data?

The moving average trend line

15

Which chart is used as a powerful method of displaying and comparing data across categories?

The radar chart

16

What chart allows three-dimensional data to be plotted in 2-D on two axes?

The bubble chart

17

Which chart features a set of charts that summarize several sets of data graphically?

The dashboard chart

18

List 2 more advance chart types

1. The radar chart
2. The bubble chart