Analysis with KoBo Excel Analyzer for the Repeat Group

User Support Data Management
,
2

Hi @esy_cari2020,

Kindly please follow the steps outlined to analyze the data from a repeat group using the Excel Analyzer:

  • Download the dataset in the xls version. Keep a backup of the same.
  • Download the data in the Excel Analyzer format.
  • By default you should see something as shown in the image below:
    Image 0
    Image 01431×862 51.7 KB

    Here, you should see only the dataset from the main survey i.e. the roster data (repeated group) is missing.
  • Now copy the data (sheet) that contains the repeat group from the xls version to the Excel Analyzer. It should then look something like this:
    Image 2
  • Once you have copied the roster data to the Excel Analyzer, change the name data tab that you wish to activate for the analysis by changing the name under the Data head from 2. Sheet Name: as shown in the image below:
    Image 3
    Image 31427×863 51.9 KB
  • Once you have made this change, you should be able to analyze all the variables that are within that repeat group.
    Image 4
    Image 41422×860 26.5 KB

    Please note, you will not be able to analyze the variables from the main dataset or other roster during this period. To analyze the required variables, you will need to define the same data tab like you just define for the roster.

Sample Excel Analyzer with Roster Data

Excel Analyzer (Sample).xlsx (1.3 MB)

Have a great day!

2 Likes