Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- HOW TO Calculate Abnormal rate by days in JMP？

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 26, 2017 7:49 AM
(1338 views)

you are your god.

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 26, 2017 8:42 AM
(1332 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 26, 2017 9:10 AM
(1328 views)

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,

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 27, 2017 6:43 AM
(1305 views)

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,

you are your god.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 27, 2017 7:50 AM
(1297 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Apr 28, 2017 6:36 AM
(1266 views)