4 Replies Latest reply on Apr 9, 2018 2:29 AM by Rui Sun

# Multiple cumulative distribution functions in one plot

In the attached workbook I was able to draw one consolidated cumulative frequency function for all carriers. However, I want a line for each carrier, three lines in total, all in one plot for easy comparison. Could you please advise on how to achieve that? Thanks!

• ###### 1. Re: Multiple cumulative distribution functions in one plot

Good morning

not certain I fully understand the goal - your statement identifies the need for 3 plots - 1 for each carrier but one carrier has only a single data point which is insufficient for your running calcualtions

that said see the attached and below

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Multiple cumulative distribution functions in one plot

Hi Jim,

I only uploaded a sample and my real data has around 1M points for each carrier, so it would suffice for the plot.

However the end of each curve (for the sake of discussion let's suppose that single point has been expanded to a curve) should reach 100% level, meaning that 100% of values for that carrier is less than or equal to x. This can be observed from my original workbook. Could you please revise the solution to reflect this property?

In other words, a point (x, y) on a curve means y percent of the data is less than or equal to x; thus, each curve should approximately cover the range (0, 100).

Kind Regards,

Ryan

• ###### 3. Re: Multiple cumulative distribution functions in one plot

got it

see the attached

I modified the formula to this

and it returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

2 of 2 people found this helpful
• ###### 4. Re: Multiple cumulative distribution functions in one plot

Hi Jim,

Actually I think the formula should be `RUNNING_SUM(COUNT([DELIVERY_TIME])) / WINDOW_SUM(COUNT([DELIVERY_TIME]))`.

Thanks,

Ryan

1 of 1 people found this helpful