# Modify the layout of the results table

Aim

To make sure your results are grouped and displayed in the most useful way possible. This is particularly the case when exporting the results to another application.

note This applies to Trial Statistics and Group Statistics.

Prerequisites

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

General procedure

Click the Layout button on the toolbar, or choose Show/Hide > Layout.

By default, the results table shows the dependent variables and their statistics on the columns, and the trials on the rows. In the following example you can see how you can customize the layout of the table.

What do you want to do?

▪Add a header to the table

▪Remove a header from the table

▪Special headers in the Layout window

▪Move a header between rows and columns

▪Swap rows and columns

▪Modify the table hierarchy

▪Show and hide part of the table

▪Remove empty rows or columns

▪Reset the table layout

▪Move the headers in the Group statistics results table

Add a header to the table

example In the Trial Statistics page, add the independent variable Treatment, so that each row (trial) is labeled with the value of Treatment, either Compound or Vehicle.

1.Click the Layout button on the toolbar.

2.In the Available box, click the header you want to add.

3.Click the arrow button which points to the On Rows box.

4. optional Move the header up in the list to have trials separated based on the values of Treatment.

notes

▪If you click the arrow button which points to On Columns, the variable is placed in columns.

▪tip To add a new dependent variable, do this in the Analysis profile, then return to Analysis > Results > Statistics and Charts.

Remove a header from the table

example Remove the Arena name from your table headers.

1.Click the Layout button on the toolbar.

2.In the On Columns/On Rows box, click Arena.

3.Click the arrow button which points to the Available box.

▪To remove measurement units, in the Layout window de-select Measurement units.

▪To remove the detail of a dependent variable, like the body point name, in the Layout window de-select Detail about variable.

note Removing an element from the headers does not aggregate the results under that header. For example, if you remove Arena all results are still displayed for each arena separately. If you want to aggregate results, see Define groups of tracks.

Move a header between rows and columns

example The dependent variables (Velocity, In zone, etc.) are placed in columns. Move them to the rows, so that each row represents one trial*dependent variable combination.

1.Click the Layout button on the toolbar.

2.In the On Columns box, click Variable with detail.

3.Click the arrow button which points to the On Rows box.

Swap rows and columns

Select each item under On Columns and move it to On Rows. Next, select the items originally under On Rows and move them to On Columns.

Modify the table hierarchy

To place a header to a higher level in the table, click the element in the On Columns or On Rows box, and then click the Up button.

To place an element lower in the table hierarchy, click the element in the On Columns or On Rows box, and then click the Down button.

note It is not possible to put Time bin above the Selection Result.

Show and hide part of the table

1.Click the Show/Hide button at the top-right corner and select the corresponding element.

2.In the window that appears, select the trials, arenas, subjects, et. that you want to have in the table.

3.Click OK.

Remove empty rows or columns

tip Do this if you have many rows or columns that are empty, and you want to export only the rows and columns with significant results.

In the Layout window, select Hide empty rows or columns.

note Rows and columns are not removed if at least one dependent variable is calculated for that row or column.

Reset the table layout

To return to the default layout, click the Layout button and in the Layout window click the Reset Default button.

Move the headers in the Group statistics results table

The results of group statistics shows the group statistic under the trial statistic. In the example below, you find the group statistic Mean under the trial statistic Total for distance moved. This means that the result is the mean value of the total distance moved calculated for each trial in that group.

When you click the Layout button, the item Group Statistic with units is selected under On Columns.

You can move the Group statistics headers and the units to the table rows or move them to a higher level in the table.

▪Move a header between rows and columns

▪Modify the table hierarchy

▪tip To have the track groups in different columns, not rows, select Selection Result and move it to On Columns.

Special headers in the Layout window

▪Statistic with unit and Group statistic with unit show the names of the trial statistics and group statistic selected in the Analysis profile, respectively. If you move those headers in the table, the measurement units are moved to the same location.

▪Selection Result refers to the dataset specified in the Results boxes of the Data profile. If the Data profiles includes two or more Result boxes, for example to group tracks, the headers for the corresponding boxes are automatically added to the table.

note If you remove Selection Result from the rows and columns, the results for different groups are still kept separate, because the Data profile that specifies those groups is still active; only the headers disappear. If you want to merge results, use another Data profile.

▪Time bin refers to the times bins defined in the Results box of your Data profile. If you do not define time bins in the Data profile, and select Time bin in the Layout window, the headers Start-End are added; no time bin is created. See Results per time bin

▪Zone refers to the zones specified in the Results box of your Data profile. If zones are not specified, analysis is done for the whole arena and the table shows In Arena. See Calculate the results per zone

▪The independent variables that you have defined are not shown in the table by default. To export the table with the independent variable values as an analysis factor, click the Layout button and move that variable to On Rows or On Columns depending on how your statistics program treats analysis factors.

example An independent variable Group with possible values Mutant and WT has been defined in the Trial List. To have the values of this independent variable displayed for each trial, click Layout, select the variable Group on the left and move it to the On Rows box.

▪Missed samples. This is the percentage of samples that EthoVision XT could not analyze. To reduce this percentage, see Factors affecting the occurrence of missing samples in Sample rate

▪Subject not found. This is the percentage of the analyzed samples in which EthoVision XT could not find the subject. A lower value indicates high reliability of data. To reduce this value further, optimize the lighting conditions and adjust the Detection Settings to improve detection rate.

▪If you select track segments with Nesting, there is no special header for them. However, remember that the results are calculated over the track segments defined, not the entire tracks.

See also

▪The statistics result

▪Trial Statistics result

▪Group Statistics result