skip the i-GuideIllinois State UniversityAdmissions at ISUAcademics at ISUEvents at ISUMap of ISUISU A to Z ListingISU AccessibilityISU 150th Anniversary
Web Support Services's eStoryboard

Charts: Excel Files by Chapter

[Note these files are in Microsoft Office 2007 format.
To open the files in Excel 2003 or earlier versions,
download and install the Office 2007 compatibility pack]

Chapter 1

Figure 1.1: The Misery Index (inflation + unemployment rates) 1964-2007
Figure 1.2: Times Series Data
Figure 1.3: Census Bureau Racial and Ethnic Categories
Figure 1.4: Cross Sectional Times Series Data
Figure 1.5: Violent Crime Rates: FBI Uniform Crime Report and National Crime Victimization Survey, per 1,000 population
Figure 1.6: Income and Homeownership: Aggregate Data
Figure 1.7: Income and Homeownership: Household Data.
Figure 1.8: Cherry Picking Budget Data
Figure 1.9: National Debt, Fiscal Years: 1954-2008 (% of GDP)
Figure 1.10: New York City Murder Rate, Dinkins and Giuliani Administrations (per 100,000 population)
Figure 1.11: New York City Violent Crime Rates: NYPD Counts and NCVS Estimates (per 100,000 population)
Figure 1.12: New York City Murder and Unemployment Rates


Chapter 3

Figure 3.1: Graphical Distortion of Data
Figure 3.2: Components of a Chart
Figure 3.3: When Graphical Design Goes Badly
Figure 3.4: Revised Chart, without 3-D Effects.
Figure 3.5: Revised Chart, with Data from Text.
Figure 3.6: Comparing Two Pie Charts
Figure 3.7: Exploding 3-D Pie Chart
Figure 3.8: Bar Charts Are Better Than Pie Charts
Figure 3.9: Pie Charts on a Gutman Scale
Figure 3.10: Rotated Bar Chart, Two Data Series
Figure 3.11: Stacked Bar Chart with Nominal Categories
Figure 3.12: Stacked (100%) Bar Chart
Figure 3.13: Scaling Effects in a Bar Chart with Two Data Series
Figure 3.14: Scaling Effect in a Bar Chart
Figure 3.15: A Really Bad Bar Chart
Figure 3.16: Revised Enrollment Chart
Figure 3.17: Bar Chart with Annual Change Data
Figure 3.18: A Histogram
Figure 3.19: A Time Series Trend
Figure 3.20: Illustration of Scaling Distortion
Figure 3.21: Using a Log Scale
Figure 3.22: Trend with Exponential Growth Rate
Figure 3.23: Log Scale of Expenditure Trend
Figure 3.24: Time Series Chart with Second Y-axis and Annotations
Figure 3.25: Scatterplot with Data Labels and Trendline
Figure 3.26: Scatterplot with Log-scaled Y-axis
Figure 3.27: Components of a Boxplot
Figure 3.28: Comparing Boxplots, with Labels for Individual Cases
Figure 3.29: Sparklines


Chapter 4

Figure 4.1: Cross National Measures of Civic Participation
Figure 4.2: Participation in Political Activities in the Past Year (2004)
Figure 4.3: Three Measures of Voter Turnout, 1952-2004
Figure 4.4: Reported Voter Turnout, by Age
Figure 4.5: Reported Voter Turnout by Education and Race, 2004
Figure 4.6: Voter Turnout, % of Voting Age and Voting Eligible Populations
Figure 4.7: Social Capital and Average Voter Turnout, 1996-2004


Chapter 5

Figure 5.1: Enrollment and First International Science Study Results: Last Year of Secondary School.
Figure 5.2: School Spending and Student Achievement, 25 OECD Nations: 2003
Figure 5.3: Educational Attainment and Student Achievement, 25 OECD Nations
Figure 5.4: Mothers' Explanations for Math Achievement
Figure 5.5: Trends in Average NAEP Reading and Math Scale-Scores, by Age: 1971-2004
Figure 5.6: NAEP Math and Reading Scale Scores, by Race, Ethnicity and Age, 2004
Figure 5.7: NAEP 8th Grade Science Scores, by Race, Ethnicity and Parents' Highest Level of Education, 2005
Figure 5.8: Average NAEP Reading Scale Scores, By Race and Age
Figure 5.9: % Students Meeting State and National 8th-Grade Math Standards, by State: 2005
Figure 5.10: Low Income and Math Achievement, Chicago Public Schools, 2006
Figure 5.11: % Students Meeting or Exceeding State Math Standards: Chicago and Illinois, 2006


Chapter 6

Figure 6.1: World Regional Trends in Extreme Poverty, 1981-2001
Figure 6.2: Corruption and Poverty in African Nations
Figure 6.3: Poverty Rates: Chile, Guyana and South America
Figure 6.4: Child Poverty In Rich Nations, 2000
Figure 6.5: U.S. Poverty Rates for Persons and Families, 1959-2005
Figure 6.6: Family Poverty Rates by Race, Ethnicity and Family Structure, 2003
Figure 6.7: Poverty Rates for Children and Elderly, 1959-2005
Figure 6.8: The Rich Get Richer
Figure 6.9: How President Bush Lowered the Poverty Rate