cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Exclude and Show Data in Fit Y by X and Graph Builder

I am doing some analysis with data that is in error. However, when I exclude it, I still want it to show on the graph for some different reasons. I know this should be very simple, but I am having a hard time finding any pointers on how to do this. Any help would be greatly appreciated.

14 REPLIES 14

Re: Exclude and Show Data in Fit Y by X and Graph Builder

If you have Automated Recalc enabled for Oneway and exclude rows,then they also disappear from the plot, without any calculation such as ANOVA.

David_Burnham
Super User (Alumni)

Re: Exclude and Show Data in Fit Y by X and Graph Builder

Graph Builder hiding points that are excluded but not hidden has causes me problems on many occasions. I'm not sure putting it in the documentation makes it right!
-Dave

Re: Exclude and Show Data in Fit Y by X and Graph Builder

I am using the Big Class example for my demonstration. I clear row states so that all rows have their default row state. I launch Bivariate with weight (Y) versus height (X) through Analyze > Fit Y by X. This platform does not respond to Exclude row state changes by default so click the red triangle and select Redo > Automatic Recalc. I click the red triangle and select Fit Line. The results use and show all the observations (rows).

Capture.PNG

I select and hide the observations for females.

Capture.PNG

The hidden rows disappear from the scatter plot but the regression remains unchanged.

I unhide the selected rows and then exclude them.

Capture.PNG

All of the data is shown but the regression uses only the 22 observations for males.

Is this kind of control not what you want?

 

julian
Community Manager Community Manager

Re: Exclude and Show Data in Fit Y by X and Graph Builder

Hi @dkraeuter_sunne,

 

As others mentioned, Row Hide and Row Exclude are independent for most platforms other than Graph Builder. But, there is a hidden option to show excluded rows in Graph Builder: while holding shift, click the Red Triangle > Show Excluded Rows. The excluded rows will now show on your plot as slightly transparent. 

 

I hope this helps!

 

@julian

 

 

 Show Excluded.gif

 

XanGregg
Staff

Re: Exclude and Show Data in Fit Y by X and Graph Builder

One way to get the effect of show+exclude in Graph Builder is to use the Frequency role.

Select the points you want to keep.

Right-click > Rows > Name Selection in Column...

This will create a new column with 1s for the selected rows and 0s for the other rows.

Use that column in the Freq role (lower right corner). You might also use it in the Overlay or Color roles to give those values a different appearance.