Knowledge Base

Sort the Results Table

Aim

• To sort the results table based on the row headers.
• To sort the results table based on the values in a column.
• To change the order of and group the dependent variables in the results table.

Prerequisites

• You have run analysis (Analysis > Results > Statistics and Charts).

Procedure

Sort the Table Rows Based on Their Headers

Example: Sort the results table based on the header Treatment, an independent variable with values Drug and Vehicle.

1. Click the Layout button and under On Rows move Treatment to the highest position in the list. See Modify the Layout of the Results Table.
2. Right-click one of the headers you want to sort, and select Sort Ascending or Sort Descending.

Note: If you sort the rows based on the headers on the second, third, etc. column, the rows are sorted only within that level, not globally. For example: to have all rows marked with Subject 1 at the top of the table, then all rows with Subject 2, etc., click the Layout button and move Subjects to the top of the list under On Rows, then sort the subject headers.

Sort the Table Rows Based on the Cell Values

Example: Sort the table based on the values of Frequency of zone entries.

Right-click one of the cells containing the values you want to sort, and select one of the two sorting options.

Sort the Dependent Variables in the Results Table

Example: Sort the results table by the dependent variables; first Distance moved, then Movement, and then In zone.

1. Click the Show/Hide button at the top-right corner and select Dependent Variables.
2. In the window that appears, select a dependent variable and click the Up and Down buttons to move a variable to a higher or lower position in the table.

Result: The dependent variable at the top of the list in that window is shown in the first row or column in the results table.

How to Read the Group Charts

Charts are generated automatically from the results in the Group Statistics & Charts table.

In this example, charts are generated for the dependent variables Distance moved (shown on top), Velocity, and In zone (on the other two tabbed pages). The horizontal axis shows the zones (In Border and In Center). Two data series (from the result containers Control and Treated) are plotted.

Chart Tabs

Each tab refers to a dependent variable defined in the Analysis Profile. A tab may contain one or more charts, one for each Trial Statistic specified for that dependent variable.

Notes

• A chart is not created for the trial statistics Standard Deviation, Standard Error, and Variance.
• Charts in EthoVision XT have limited formatting options and are mainly meant for inspection purposes. If you want to make a chart for a publication, export the statistics table to Excel or a statistics program.
• If you delete a dependent variable and subsequently add it again to the Analysis Profile, the properties of the new chart are set to default.
• Chart settings are stored for each combination of data profile and analysis profile. If you make an exact copy of a data/analysis profile, the resulting charts have default settings.
• Effect of Data selection: Results per time bin — If in the Data Profile you specify Results per time bin, time bins are always shown on the horizontal axis. The first value is 0:00:00 and represents the results calculated in the first time bin (for example, from 0 s to one minute).
• Effect of Data selection: Results per zone — If in the Data Profile you specify to Calculate the results per zone, you can show the zones on the horizontal axis or as data series. See Customize the Group Charts.
• If you specify both time bins and results per zone, time bins are displayed on the horizontal axis and zone statistics as data series.
• If you specify more than 1000 time bins in your Data Profile, the group charts are not displayed.

To Export Group Charts

You can export one chart at a time. To export a chart as an image file, do one of the following:

• Right-click the chart and select Export Chart.
• Click the chart and then click the Export Chart button just above the chart.

The default file name is the same as the chart title. Four formats are available: Portable Network Graphics (*.png), JPEG file (*.jpg), Windows Bitmap (*.bmp), and Graphics Interchange Format (*.gif).

To copy the chart to an external program, right-click the chart and select Copy, then paste it into the other program.

Source: EthoVision XT 19 Help, Noldus Information Technology