Discussion


Note: Images may be inserted into your messages by uploading a file attachment (see "Manage Attachments"). Even though it doesn't appear when previewed, the image will appear at the end of your message once it is posted.
Register Latest Topics
 
 
 


Reply
  Author   Comment  
peter_mikael

Registered:
Posts: 25
Reply with quote  #1 
Hi

I have information about the distribution of age and sex of our clients in a table:

AgeSex% of total clients
a) [0,20]F0,40%
a) [0,20]M0,40%
b) (20,40]F14,60%
b) (20,40]M19,60%
c) (40,60]F19,10%
c) (40,60]M24,80%
d) (60,80]F8,10%
d) (60,80]M10,80%
e) (80,105]F1,00%
e) (80,105]M1,30%

What would be the best way to display this visually? Maybe something like the attached image?
 

Attached Images
Name: fördelning.png, Views: 20, Size: 9.32 KB


sfew

Moderator
Registered:
Posts: 852
Reply with quote  #2 
Peter,

What you're trying to display is called a "frequency distribution." When you use bars to do this, as you have, the graph is called a "histogram." Histograms work fine with a single series of values, but you're displaying two series: one for females and one for males. Bars don't make it easy to compare the two distribution patterns. An alternative is to use lines instead of bars, in the form of a "frequency polygon." I've included an example below. Notice how much easier it is to see and compare the two distribution patterns when they're displayed as lines.

Also notice that I changed how the age groups are labeled. With your labels, you can't tell if a 20 year old would be counted in the first age group or the second. With my labels, this ambiguity is resolved.

The questions that you've asked here and elsewhere in this discussion forum are all addressed in my book Show Me the Numbers. You would save yourself a lot of time by reading it.

Attached Images
Name: Distribution by Sex and Age.png, Views: 20, Size: 27.86 KB



__________________
Stephen Few

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.