Question on analysis for some Fox Insight data

Analyzing and Reusing Data
1

Hello everyone,

We are currently working with the raw CSV exports dataset from the Fox Insight and I was hoping to get some support on how to handle certain questionnaire variables represented in the data files.

1. Sometimes variables appear to be absent from the CSV export even though response options are listed in the questionnaire documentation (pdf questionnaire file). Specifically, if a response option receives no selections from participants, is the corresponding variable excluded from the CSV entirely? We are trying to determine whether missing columns indicate that the option was never selected or whether the variable was removed during export. Are variables with zero responses excluded from the export, or do these items appear under different variable names?

2. Structure of “Select All That Apply” (SATA) variables- For questions marked Select All That Apply (SATA), the CSV files appear to include one column per response option, but there is no column representing the question itself. Is there a recommended way to aggregate these variables back to the original question level? Additionally, is there a data dictionary or mapping resource for SATA questions that links each variable to its questionnaire item and response option?

Any clarification or support anyone can provide would be much appreciated.

thanks

Roberta

2 Likes
2

Hi @betamaro,

  1. Variables would not be excluded/removed, nor will they appear under a different variable name. Variables for unanswered questions would have a blank value, which represents the question not being answered (i.e., because they didn’t finish the visit, survey logic dictating that a condition serving the question to the participant is not met, or they skipped it if that was an option).
  2. I’m not aware of a specific method for aggregating these variables, but if you let us know some of the specific ones you’re working on we can try to connect you with other researcher in the community who may have experience doing so in the past. There are two versions of the data dictionary (machine readable and annotated with a bit of guidance) as well as the questionnaire forms themselves on the Resources page on the Fox DEN website which hopefully be helpful! Another resource would be this data wrangling guide.

Hope these help, definitely let me know if you have any follow-up questions!

Josh

2 Likes