Community Trekker

Joined:

Feb 14, 2017

## HOW TO Calculate Abnormal rate by days in JMP？

all, i Calculate Abnormal rate in excel ,but the result is different from what i Calculate in JMP。
5 REPLIES

Super User

Joined:

Jun 22, 2012

## Re: HOW TO Calculate Abnormal rate by days in JMP？

Please excuse my ignorance, but I am not familiar with how you calculated the "Abnormal Quantity" that you are showing in your Excel table named "Excel result".

Jim

Joined:

May 28, 2014

## Re: HOW TO Calculate Abnormal rate by days in JMP？

How are you calculating abnormal rate in JMP to get the graph shown in the JMP Result tab in your Excel file?
In JMP, if you want to divide abnormal quantity by produce quantity, then you can use a column formula similar to what you did in Excel.
Here is a quick way to do so. Once you have the data in JMP, you can select the two columns and then right click on them. Choose New Formula Column, then Combine, and then ratio. You will now get the same values as you do in Excel This new column would be the Y axis.

Does that help?

Chris K,

Community Trekker

Joined:

Feb 14, 2017

## Re: HOW TO Calculate Abnormal rate by days in JMP？

dear

I want to use data in excel and Calculate Abnormal rate by JMP   directly.

i  upload how to Calculate Abnormal rate  in EXCEL

thank you,

Community Manager

Joined:

Jun 23, 2011

## Re: HOW TO Calculate Abnormal rate by days in JMP？

Thank you for posting a sample of your data.

I can see that you want to summarize the data in the first tab of the Excel workbook to compute the percentage of abnormal products made on each day.

To do this I started by creating a JMP data table from the data tab in the Excel workbook.

Then, I used the Tables->Summary command to summarize the data.

Then I added a New Column in the summary table and used the Formula Editor to compute the percentage abnormal.

That gives me a new column I can use in Graph Builder to plot date by % abnormal.

I hope that helps.

-Jeff

Community Trekker

Joined:

Feb 14, 2017

## Re: HOW TO Calculate Abnormal rate by days in JMP？

thank you very much！