Excluding data table values from graphs and analyses

How do you exclude a value without removing it?

If a value is too high or too low to be believable, you can exclude it. Excluded values are shown in blue italics on the data table, but are not included in analyses and are not shown on graphs. From the point of view of analyses and graphs, it is the same as if you had deleted the value, but the number remains on the data table to document its value.

To exclude data:

1.	Select the cell or cells you wish to exclude.

2.	Click the Exclude button from the Change toolbar. Or pull down the Edit menu and choose Exclude Values (the Exclude command is also on the shortcut menu accessed by the right mouse button).

The excluded values appear in blue italics.

•	Repeat the process to include the value again.

Read about outlier elimination in the Prism Statistics Guide.

Note: If you want to remove entire data sets from a graph or analysis, excluding is not the best way to do it. Instead, use the following procedure.

To remove a data set from a Graph:

•	Click on the Add/Remove data sets button from the Change toolbar. Select the data set to remove. This dialog will also let you add data sets to a graph.

To remove a data set from a Results sheet:

•	Click on the Analyze different data sets button from the Change toolbar.

•	Then check the data sets that you want to include in your analysis.