Turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Help choosing JMP Analysis for Multiple Factors

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
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 7, 2017 10:40 AM
(8348 views)

Hello! I am using JMP 13 (regular) and learning about predictive and specialized modeling.

I have a dataset (attached) with over 100,000 observations of a process. 75% of the observations had a duration of 4 days or less. I'd like to know why some observations took over 4 days. I've identified some possible factors: 1 continuous and 16 categorical.

Can you please suggest one or more JMP analyses that I could apply to the data?

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Whenever I start a predictive modeling exercise, especially if I inherited the data from somewhere else with little knowledge of how, where, when, and under what circumstances the data were collected, I spend some time in what I call 'getting acquainted with the data' mode. I look for things like data quality, unusual or supicious observations, missing values (you have none of these), nonsense values, and any other feature that sticks out at me that might make modeling problematic. I always start with the Distribution platform to just get a feel for "Where's the middle, how spread out is the data, and is there anything odd or unusual going on?" From there especially with a relatively small set of predictor variables, I just use the Fit Y by X platform to look for relationships between predictors and responses...and compare what I see with my process/domain knowledge. If a scatter plot proves that 'water runs uphill' (in other words is counter known laws of physics, chemistry, biology, socioeconomic behavior, etc.) then I start to get suspicious and suspend the modeling work until I get to the bottom of the issues.

Data cleaning and prep is never fun...and takes work...but it's absolutely necessary.

8 REPLIES 8

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

I take it the Y column is the number of days? IF so, one can make an indicator column to represent those observations that are > 4 days and then use that for modeling to see which variables have the greatest impact on predicting the indictor variable.

Chris

Chris Kirchberg

Principal Systems Engineer, Life Sciences - JMP Global Technical Enablement

SAS Institute, Inc. - Denver, CO

Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com

JMP – A Division of SAS Institute | www.jmp.com

Principal Systems Engineer, Life Sciences - JMP Global Technical Enablement

SAS Institute, Inc. - Denver, CO

Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com

JMP – A Division of SAS Institute | www.jmp.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

You're welcome,

Decision Trees are a good quick way to see the possible impact and you can use an indicator column.

A simple column formula like:

If(:Hours > 4, 1, 0)

You can then change the model type to nominal and use as the response.

Best,

Chris

Chris Kirchberg

Principal Systems Engineer, Life Sciences - JMP Global Technical Enablement

SAS Institute, Inc. - Denver, CO

Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com

JMP – A Division of SAS Institute | www.jmp.com

Principal Systems Engineer, Life Sciences - JMP Global Technical Enablement

SAS Institute, Inc. - Denver, CO

Tel: +1-919-531-9927 ▪ Mobile: +1-303-378-7419 ▪ E-mail: chris.kirchberg@jmp.com

JMP – A Division of SAS Institute | www.jmp.com

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

Once your target column is built you might start with a partition or logistic regression.

Partition

http://www.jmp.com/support/help/Partition_Models.shtml

Webcast: https://www.jmp.com/en_us/events/ondemand/building-better-models/decision-trees.html

Logistic Regression

http://www.jmp.com/support/help/Logistic_Analysis.shtml#274628

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

I took a quick look at the raw data. Are you aware that a few of the X variables are only at "1"?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Help choosing JMP Analysis for Multiple Factors

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Whenever I start a predictive modeling exercise, especially if I inherited the data from somewhere else with little knowledge of how, where, when, and under what circumstances the data were collected, I spend some time in what I call 'getting acquainted with the data' mode. I look for things like data quality, unusual or supicious observations, missing values (you have none of these), nonsense values, and any other feature that sticks out at me that might make modeling problematic. I always start with the Distribution platform to just get a feel for "Where's the middle, how spread out is the data, and is there anything odd or unusual going on?" From there especially with a relatively small set of predictor variables, I just use the Fit Y by X platform to look for relationships between predictors and responses...and compare what I see with my process/domain knowledge. If a scatter plot proves that 'water runs uphill' (in other words is counter known laws of physics, chemistry, biology, socioeconomic behavior, etc.) then I start to get suspicious and suspend the modeling work until I get to the bottom of the issues.

Data cleaning and prep is never fun...and takes work...but it's absolutely necessary.