How does one calculate cumulative % ?

[Rudi]

Please help me with a formula.

How would I work out the cumulative % of the histogram table shown? TX

Bin	Frequency
5	9
10	13
20	21
40	44

[Rudi]

I have just found out by chance.

One needs the count of values from the source table from which the histogram was created. In the above example, the histogram was created from a table of 105 values, grouped into the bins. The cumulative % is then: =9/105*100 to total 8.57%.

[sdckapr]

The cumulative % is then: =9/105*100 to total 8.57%.

I know what you mean, but it is a pet peeve that you state it incorrectly:
9/105*100 = 8.57 = 857%

9/105 = 0.0857 = 8.57%

Steve

[Rudi]

Pet peeve or not...you are quite right!
Sorry about that!