View Single Post
  #1   Report Post  
Kev
 
Posts: n/a
Default histogram or pie chart or?

Greetings from the UK...

I have a list of around 1000 numbers, all integers whose values can range
from 1 through to 4000. Most of these numbers repeat themselves in the
list .
What I want to do is produce a chart showing the number of times each
descrete number appears , its value and the percentage of times it appears
in the list .
I think ( dangerous for me !) I should be looking at a histogram or a even a
pie chart but so far my attempts (using the data analysis and chart
wizards) are not what I want.

As an example a list of 12 numbers could be 2, 3, 2, 4, 2, 4, 2, 2, 4,
2, 4,3 and what I want to get to is a chart showing that:
"2" appeared 6 times in the list equating to 50% of the 12 entries,
"4" appeared 4 times in the list equating to 33.3% of the12 entries,
"3 " appeared 2 times in the list equating to 16.6% of the 12 entries

value anyones help.