Chapter 11, Problem 1RE

Graph the following data using a bar graph and a broken-line graph. (Source: U.S. Census Bureau)

Voter Turnout in U.S. Presidential Elections

$\begin{array}{cc}\text{Year}& \text{Percentage of Voting Age Population}\\ 1960& 62.8\\ 1964& 61.4\\ 1968& 60.7\\ 1972& 55.1\\ 1976& 53.6\\ 1980& 52.8\\ 1984& 53.3\\ 1988& 50.3\\ 1992& 55.2\\ 1996& 49.0\\ 2000& 50.3\\ 2004& 55.7\\ 2008& 57.1\\ 2012& 53.6\end{array}$

To determine

To graph:The given table with the help of a bar graph and broken line graph.

$\begin{array}{|cc|}\hline \text{Year}& \begin{array}{l}\text{Percentage of voting}\\ \text{age population}\end{array}\\ 1960& 62.8\\ 1964& 61.4\\ 1968& 60.7\\ 1972& 55.1\\ 1976& 53.6\\ 1980& 52.8\\ 1984& 53.3\\ 1988& 50.3\\ 1992& 55.2\\ 1996& 49.0\\ 2000& 50.3\\ 2004& 55.7\\ 2008& 57.1\\ 2012& 53.6\\ \hline\end{array}$

Explanation of Solution

Graph:

Consider the given table,

Steps to draw the bar graph with the help of EXCEL:

Step-1 Open $\boxed{\text{EXCEL}}$,

Step-2 Write the year in column $\text{A}$ and percentage of voting population in column $\text{B}$ as,

Step-3 Select the values of column $\text{A}$ and $\text{B}$, then go to $\boxed{\text{INSERT}}$ tab and click on the $\boxed{\text{CHARTS}}$.

The horizontal axis represents corporation and the vertical axis represents Revenue (Billions $\$$ ).

For broken line graph, select the appropriate option in the CHART option.