8 Replies Latest reply on Jan 15, 2014 12:50 PM by KK Molugu

    Cumulative distribution giving impossibly high percentages

    Renee Jutras

      I have been trying to create a cumulative distribution from my data but keep getting sums of around 800%.

      Here is the histogram of my data, perfectly normal and as expected:

      histogram.png

      But when I add this table calculation:

      tablecalc.png

      I get this:

      cumdist-wrong.png

      Which looks like a great curve but the scale is completely wrong.

       

      I can't possibly imagine why it's doing this. I've tried calculating by every other option, and entering in custom calculations and everything but it doesn't change.

      Thoughts?

       

      I have attached a similar sample using the superstore data.