Undergraduated

Statistics for Managers Using Microsoft® Excel 5th Edition
sonny boyter 2 Presenting Data in Tables and Charts

Statistics for Managers Using Microsoft Excel, 5e © 2008 Pearson Prentice-Hall, Inc.

Chap 2-1

Learning Objectives
In this chapter, you will observe: To develop tables and charts for categorical info To develop tables and charts for numerical data The principles of properly presenting graphs

Statistics for Managers Using Microsoft Excel, 5e © 2008 Pearson Prentice-Hall, Inc.

Chap 2-2

Organizing monotonous Data: thickset Table
A summary table indicates the frequency, amount, or portion of items in a set of categories so that you can see differences betwixt categories. How do you spend the holidays?
At home with family Travel to vindicate family vacation Catching up on work Other

Percent
45% 38% 5% 5% 7%

Statistics for Managers Using Microsoft Excel, 5e © 2008 Pearson Prentice-Hall, Inc.

Chap 2-3

Organizing Categorical Data: Bar Chart
In a grade insignia chart, a bar shows each category, the length of which represents the amount, frequency or percentage of values falling into a category.
How Do You return the Holidays?




Other Catching up on w ork Vacation Travel to visit family At home w ith family 0% 5% 10% 15% 20% 25% 30% 35% 40% 7% 5% 5% 38% 45% 45% 50%

Statistics for Managers Using Microsoft Excel, 5e © 2008 Pearson Prentice-Hall, Inc.

Chap 2-4

Organizing Categorical Data: Pie Chart
The pie chart is a circle broken up into slices that represent categories. The size of each slice of the pie varies according to the percentage in each category.
How Do You Spend the Holidays

5% 5%

7% At home with family 45% Travel to visit family Vacation Catching up on work Other

38%

Statistics for Managers Using Microsoft Excel, 5e © 2008 Pearson Prentice-Hall, Inc.

Chap 2-5

Organizing Categorical Data: Pareto Diagram
Used to delineate categorical data A bar chart, where categories are shown in descending order of frequency...If you want to get a exuberant essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper