Demonstrating Pareto's Law with JMP graph

Question

Hi everyone,

I will like to create a graph to show that 80% of the revenue comes from the top 20% of the customers in a store. My current data columns are:

1. CustomerID (around 4000+ data points)

2. Revenue

Would there be a way to build this graph in JMP? I've tried the Pareto Plot but have not been too successful.

Thank you! Cheers.

Phil_Kay · Answer

I am not sure why you graph looks so different when you run the Graph Builder script. I think it is partly due to preferences that you have set. But it should show the same cumulative sales curve.

There are a few clicks involved so I thought it would be best to record a short video demo.

Some key points to achieve the graph:

* We order the Company axis by Sales by dragging Sales to the drop zone above centre of the x-axis.
* We select order descending after right-click on the x-axis labels
* We add Sales on the y-axis then we add it again (drop in the zone to the centre-right of the y-axis)
* We right-click on the y-axis labels to move one of the instances of the Sales variable to the right
* We change the statistic of the right y-axis to Cumulative Sum
* We right-click on the white space in the plot to change between bar and point plots for the variables

Are you able to recreate the graph now?

Cheers,

Phil

PearlyQuek · Answer

Thank you Phil!

Yes it helps greatly. I was wondering if you could share how you did the ordering, as well as how you obtained the cumulative sales line? In addition, would it be possible for the cumulative sales to be in % instead?

I opened the Graph Builder script and could only see this:

Phil_Kay · Answer

Hi,

Would this kind of graph help?

Example data table attached.

Regards,

Phil

Financial.jmp