View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
mshaffer mshaffer is offline
external usenet poster
 
Posts: 3
Default histogram from weighted data

On Jan 12, 1:27*pm, mshaffer wrote:
I'm trying to use the 2007 histogram tool (or frequency) to show me
the frequency of data, but my data is in a different form than
required for either of these tools. Let me use the following simple
case -- to show the frequency of student grades both tools assume I
have a list of student's test grades. What if I instead have more than
one column, e.g., "grade" and "number students with that grade"??

My application is actually different, but it's still 2 columns, a
numeric property and a weighting factor (e.g., fraction of the total).

TIA *:)


I've confused at least one person, so let me de-simplify ...

For more than 10,000 particles, I have for each particle: (1) its
calculated density and (2) its mass (relative to the whole, or
absolute, take your pick ... keep in mind these particles vary in size
and composition, so some particles can have the same mass but
different density). I need to plot the mass distribution according to
binned density values.

TIA :)