Statistics on Metadata

<< Click to Display Table of Contents >>

Navigation:  ANALYSIS with INTERACT > Statistics >

Statistics on Metadata

The Full Statistics result table lists all Metadata-Values per DataSet, at the far right of the table.

This is helpful to identify what set is about what kind of data, but it does NOT provide you with the number of occurrences per metadata-value.

Metadata Statistics

It is now possible to get summaries of all descriptive value types for all Codes per metadata value, across DataSets:

Click Analysis - Evaluation - Statistics btn_tlc_fullstatistics > Statistics on Metadata.

OR

Run Analysis - Analysis - Evaluation - Statistics btn_tlc_fullstatistics from within the Timeline Chart menu.

Select the Codes you are interested in and confirm your selection with OK

Select the DataSets you want to analyze and confirm with Apply.

The Results dialog now lists all Code occurrences per Metadata Value instead of per DataSet:

Metadata_FrequenciesPerCode

Switch between tabs for Frequencies and Duration values.

Futher Analysis in Excel

If you need statistics in different aggregations as available in the INTERACT Results, it is fairly easy to transfer the available results to Excel and organize your data in a Pivot-Table.

To create a pivot table in which can freely organize the level of aggregation, you need to transfer the results to Excel.

Click the Export to Excel button of your current Results windows

or

Click the Copy icon.

Create a new worksheet in Excel.

Select Home - Paste to insert the values.

Create Pivot Table

Note: This is just a very short example! Further details about creating this Excel functionality is available in the Microsoft documentation.

Once your data is available in MS Excel:

Make sure the selection is kept after insert.

Select Insert - Pivot Table.

StatisticOnVariables_2

Confirm the dialog asking you to create the pivot table based on the selected data:

StatisticOnVariables_3

Each column from the INTERACT Full statistics results table is now listed as a Pivot Table field on the right side of your Excel Window.

Example based on Metadata

Depending on your research question, you will need to select other columns. In this example we want to know how many sessions (DataSets) were observed, split by Gender value.

Select one of the Meta Variables (Gender in this case)

Drag the DataSets field into the summary area, in order to count the occurrences per variable:

StatisticOnVariables_4

This results in a neat little Pivot Table, showing you the numbers of male and female participants:

StatisticsOnVariables_8

This tells you that there are 10 female participants and 22 males.

If you drag the 'Age' field into the rows area a well, the table will extend itself like this:

StatisticOnVariables_6

Whereas dragging the 'Age' field into the Columns area, your table will look like this:

StatisticOnVariables_7

You can create all kind of nested tables. Feel free to play around with it and take a look at one of the many Excel tutorials for this function.

Duplicate Table

To create multiple tables for separate variables:

Select and Copy the table just created.

Paste it underneath and select another Variable-Field to display.