BookmarkSubscribeRSS Feed

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

markbailey

Staff

Joined:

Jun 23, 2011

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

Learn it once, use it forever!
David_Burnham

Super User

Joined:

Jul 13, 2011

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
markbailey

Staff

Joined:

Jun 23, 2011

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?

 

Learn it once, use it forever!
Highlighted
julian

Staff

Joined:

Jun 25, 2014

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

Joined:

Jun 23, 2011

Solution

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.