Chapter 2 Displaying and Summarizing Data Part 1

Chapter 2: Displaying and Summarizing Data Part 1: Displaying Data With Charts and Graphs Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-1

Excel Insert Tab – Charts Group Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-2

Column and Bar Charts n Can be used for any measurement scale (nominal, ordinal, interval, or ratio) Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-3

Line Charts n Useful for variables data, particularly over time Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-4

Pie Charts n Useful for attributes to show relative proportions Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-5

Area Charts n Combines features of pie and line charts Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-6

Scatter Diagrams n Shows relationships between two variables Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-7

Radar Chart n Allows you to plot multiple dimensions of several data series. Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-8

Other Excel Charts Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-9

Ethics and Data Presentation Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-10

Contingency Tables and Cross-Tabulations n Cross tabulation (contingency table) – a table that displays the number of observations in a data set for different subcategories of two categorical variables. Subcategories must be mutually exclusive and exhaustive. Age Group Gender 1 2 3 4 5 6 7 Total Female 1 6 3 1 1 0 0 14 Male 0 0 2 3 1 3 4 13 Total 1 6 5 4 2 3 6 27 Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-11

Tools for Cross Tabulation n n Excel Pivot Tables PHStat Two-Way Tables & Charts Copyright © 2010 Pearson Education, Inc. Publishing as Prentice Hall 2(1)-12