Data Processing Tips

<< Click to Display Table of Contents >>

Navigation:  ANALYSIS with INTERACT > Lag Sequential Analysis >

Data Processing Tips

As mentioned before, data selection BEFORE you run the Sequential analysis routine has immense impact on the results:

oPer default, the LSA routine compares all Codes with all other Codes, independent of their Class.

oThis can lead to confusing results, if you used Codes that do overlap in time.

oTo avoid this, select only mutual exclusive Classes for analysis if you run the Analysis - Evaluation - Timeline Chart Btn_TLC_Chart_AllData command.

oIf your sessions contain multiple phases or periods that you coded, it is possible to restrict your data to a specific phase or period using the Trim on Code command within the Timeline Chart window.

oUse Excel or SPSS for further processing the results.

oIf you run the sequential analysis routine multiple times, using different Lag values (e.g.using Lag 1, lag 2 and lag 3), you can see how often a behavior followed a specific key Event as a first, second or third behavior.

Conditional Formatting

INTERACT offers a data visualization btn_tlc_visualdataexploration command, as described in the topic Lag Sequential Analysis, that divides your results in 4 value groups.

If you need to specify further levels or want to adjust the colors, you need to export your results to MS to Excel.

Excel offers a very powerful and easy to apply functionality called Conditional Formatting. This function allows you to format cells based on their content and this can be of enormous help while interpreting and scanning your results!

You can format your cells in a way that all values, that exceed a specific range, jump to your attention - simply by changing their color, frame or back ground colors.

External processing

You can export the results, as shown in the 'Results' table, for further use in any other computer program accepting textual input.

Select the tab with the results to export.

There are multiple ways of getting the data out:

Arrow-Right-OrangeExport to Excel - You can create an Excel file that holds all tabs of the Results dialog:

Click on the Export to Excel icon in the toolbar of the Results dialog.

Name and save the results using the upcoming Save as dialog.

Arrow-Right-OrangeExport current Tab - You can export the current tab for further processing in a third-party destination program:

Click the Save as Btn_save icon in the toolbar of the Results dialog.

In the upcoming Save as dialog, name the file and add your preferred suffix (*.txt, *.csv, or *.xls) to specify the format of the resulting file.

Click Save to create the export file.

Arrow-Right-OrangeThrough the Windows clip board - This enables you to directly insert those results in any program excepting textual input such as e.g. MS Word, NotePad, MS Excel etc:

Click Copy Btn_copy at the bottom of the 'Results' table, to copy the data of the selected tab into the windows clip board.

Choose Edit - Paste... from the menu of your target application.

 

IMPORTANT: All of these options export the accumulated data as shown in the Results table.
To generate a Set-based export files, use the command Analysis - Statistics - Sequence analysis - CSV Export per DataSet.