Support #943

g_indresp - exercise variable

Added by Emma Cook about 6 years ago. Updated over 5 years ago.

Data inconsistency
Start date:
% Done:



Good afternoon,

I'm hoping to use US to look at the correlations between mood and exercise for different cohorts of the population. I'm using the g_swemwbs_dv variable to represent mood and hoping to use the exercise group of variables (mainly g_vday, g_mday .. g_vwhrs/g_vwmin and g_mwhrs/g_mwmin).

When I look at the data out of the 42,000 odd responses, and 37,099 excluding proxy responses, there is an extremely small sample of people left who recorded doing any exercise whatsoever over the past 7 days. I don't think this can be a realistic representation of the exercise that people really do, and was just wondering if it was something I had done wrong while I was cleaning the data, or whether these questions were not answered particularly accurately by the respondents?

Any help or suggestions would be greatly appreciated because I've come to such a dead end and not sure whether I should continue using this data to answer the question I am addressing about the correlation between mood and exercise participation.

Thank you,



Updated by Stephanie Auty about 6 years ago

  • Category set to Data inconsistency
  • Status changed from New to In Progress
  • Assignee set to Stephanie Auty
  • Target version set to M7
  • % Done changed from 0 to 10
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer


Updated by Stephanie Auty about 6 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Stephanie Auty to Emma Cook
  • % Done changed from 10 to 70

Dear Emma,

The variables you are looking at for time spent exercising, g_vwhrs, g_vwmin, g_mwhrs and g_mwmin, are the weekly hours and minutes. If you look at the questionnaire (from you can see from the routing that these questions were only asked if the respondent could not or did not answer g_vdhrs, g_vdmin, g_mdhrs and g_mdmin, which are the daily hours and minutes. There are a great deal more responses to these questions. To use both sets of questions you could divide the weekly hours and minutes by the number of days of that type of exercise, and combine this with the answer for daily hours and minutes.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer


Updated by Stephanie Auty over 5 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 70 to 100

Also available in: Atom PDF