Jump to content

Cumulative Probability Plot Error

Kyle Parker

Recommended Posts

Hi All,

I am attempting to make a cumulative probability plot. My median shown in Spotfire is 102,144 and I confirmed that number in excel but when I plot a horizontal median line, it is located at 0.6 instead of 0.5. My data column is calculated to exclude zeros and my probability equation is Rank(Data) / Count(Data). I have tried multiple equations and searched the community to solve this problem but have not come up with a fix yet. Does anyone have any suggestions

Thanks in advance!


Link to comment
Share on other sites

The results seem to be correct. For the filtered data set, Median(X) = 102144 and Median(Y)=0.60. For the unfiltered data (Reset All Filters),Median(X) = 89803 and Median(Y)=0.50.You can check this by exporting the filtered data to an excel file, then open that excel file and calculate the Median of this[Oil EUR/1,000' Probit] column in MS Excel.
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...