nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pareto plots

unknown

Hi Guys,

I have a JMP data table which has multiple tests (100+)in columns and next to each test column there is a column that says of that row (data point) passed or failed that test.

I would like to see which are my top failing tests. Is there a way to do this? I tried using the pareto plots but could not get it to do what I want. Can I use the pass/fail information that is near the test column to sort my top failing tests?

The file looks something like this: (there are 100+ values; I have shown only two values)

Value1 P/F Value2 P/F
250 P 1.56 P
222 P 1.89 P
223 P 1.25 P
21 F 1.58 P
20 F 2.22 F

So I want to see a pareto plot which shows the top fail as being Value1 with the bar on the chart showing 40% followed by another bar on the same pareto plot showing 10% for Value2.

How can I do this?

Thanks.

Accepted answers

All comments

unknown

Anybody?

As I understand, a pareto plot shows the relative frequency in a cumulative way, up to 100%. I don't know how you can to use a pareto to plot the fail percentages of 100+ columns. I would easily become a lot more than 100%. Do you mean sorted bar chart?

If so, you can try the script below. The script assumes that your table is organized as in your example (Value1, P/F 1, Value2, P/F 2,...). It can probably be simplified.

unknown

Thanks a lot, that worked.

unknown

One more question:

What if I have blank cell values? It seems to count the blank cell value in the total.

Can I omit the blank cells?

Thanks.