Project

General

Profile

Support #180

Sports Club membership among Scottish adults

Added by Chris Martin almost 7 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Data inconsistency
Target version:
Start date:
08/07/2013
Due date:
% Done:

100%

Estimated time:

Description

Hi,

I have a query relating to the variable b_club, (sports club membership).

I am wanting to calculate two figures for Scotland only:
a) The %age of adults who have played a sports/exercise in last 12 months who are a member of a sports club,(ie the same definition as when question is asked and
b) the %age of all adults who are a member of a sports club (assuming rightly or wrong that those who have not done a sports/exercise in last year are NOT a member of a sports club).

I think I might be doing something wrong. (Output attached)

First, I exclude anyone outside Scotland and those who don't have a weight. This leaves me with 2,908 cases. (All figures unweighted for ease here).

Then, I exclude cases with only proxy info (these cases have no info on sports participation or membership questions) and the one case where all the relevant data is missing. This leave me with 2,682. I thought this should be my denominator, representative of all adults in Scotland.

However, see the table below (also row 247 in the attached output) of whether undertaken any sports in last year by sports club membership.

b_club sports club member      Total
-9 -8 1 2
sports_any2 Yes 0 654 0 3 657
No 345 0 471 1209 2025
Total 345 654 471 1212 2682

For sports club membership among adult population, the numerator would be the 471 who are sports club members (giving 18%: 471/2682*100). (Or 17% if I applied the appropriate weight.)

However, there are 345 cases where the sports club member question is missing even when they have done a sport in the last year and 3 cases where they have been asked the sports membership question even though they’ve not participated in any sport in the last year. Moreover, I don’t think the 345 are a random sub-group, which makes me worry about the estimates.

I wonder if you could tell me how to deal with the 345 + 3 cases in terms of my estimates, or whether I'm making a more fundamental mistake.

Many thanks,
Chris

History

#1 Updated by Redmine Admin almost 7 years ago

  • Category set to Data inconsistency
  • Target version set to M2
  • % Done changed from 0 to 50

Thanks for making us aware of this error. B_club should have been asked if the response to any of the sports questions was non-missing and the respective none-of-these option was not confirmed. The Blaise script erroneously had the latter clause for the first sports item pointing to the second sports item. The table below shows the combinations of the implemented variables. Anysports1 is 1 if any of the sports from the first show card was mentioned, anysports2 from the second show card, etc.


     +-------------------------------------------------------------------------------------------------------------------------+
     |       b_club     b_sports196     b_sports296     b_sports396   b_indmode   anysports1   anysports2   anysports3   _freq |
     |-------------------------------------------------------------------------------------------------------------------------|
  1. |      missing    inapplicable    inapplicable    inapplicable         ftf            0            0            0      72 |
  2. |      missing    inapplicable    inapplicable    inapplicable   telephone            0            0            0     326 |
  3. |      missing   not mentioned       mentioned       mentioned         ftf            1            0            0    5789 |
     |-------------------------------------------------------------------------------------------------------------------------|
  4. | inapplicable         missing         missing         missing         ftf            0            0            0      13 |
  5. | inapplicable         refused         refused         refused         ftf            0            0            0       4 |
  6. | inapplicable      don't know      don't know      don't know         ftf            0            0            0      16 |
  7. | inapplicable      don't know      don't know       mentioned         ftf            0            0            0       2 |
  8. | inapplicable       mentioned         refused       mentioned         ftf            0            0            0       3 |
  9. | inapplicable       mentioned      don't know       mentioned         ftf            0            0            0      88 |
 10. | inapplicable       mentioned       mentioned       mentioned         ftf            0            0            0   13005 |
     |-------------------------------------------------------------------------------------------------------------------------|
 11. |        proxy           proxy           proxy           proxy       proxy            0            0            0    3882 |
     |-------------------------------------------------------------------------------------------------------------------------|
 12. |      refused   not mentioned         refused         refused         ftf            1            0            0       1 |
     |-------------------------------------------------------------------------------------------------------------------------|
 13. |          yes   not mentioned         refused       mentioned         ftf            1            0            0       2 |
 14. |          yes   not mentioned      don't know   not mentioned         ftf            1            0            1      10 |
 15. |          yes   not mentioned      don't know       mentioned         ftf            1            0            0       5 |
 16. |          yes   not mentioned   not mentioned   not mentioned         ftf            1            1            1    3831 |
 17. |          yes   not mentioned   not mentioned       mentioned         ftf            1            1            0     622 |
 18. |          yes   not mentioned       mentioned   not mentioned         ftf            1            0            1    2918 |
 19. |          yes       mentioned      don't know   not mentioned         ftf            0            0            1       2 |
 20. |          yes       mentioned      don't know       mentioned         ftf            0            0            0       1 |
 21. |          yes       mentioned   not mentioned   not mentioned         ftf            0            1            1     312 |
 22. |          yes       mentioned   not mentioned       mentioned         ftf            0            1            0     285 |
 23. |          yes       mentioned       mentioned   not mentioned         ftf            0            0            1     342 |
     |-------------------------------------------------------------------------------------------------------------------------|
 24. |           no      don't know       mentioned   not mentioned         ftf            0            0            1       2 |
 25. |           no   not mentioned         refused   not mentioned         ftf            1            0            1       2 |
 26. |           no   not mentioned         refused       mentioned         ftf            1            0            0       2 |
 27. |           no   not mentioned      don't know      don't know         ftf            1            0            0       1 |
 28. |           no   not mentioned      don't know   not mentioned         ftf            1            0            1      20 |
 29. |           no   not mentioned      don't know       mentioned         ftf            1            0            0      18 |
 30. |           no   not mentioned   not mentioned   not mentioned         ftf            1            1            1    5756 |
 31. |           no   not mentioned   not mentioned       mentioned         ftf            1            1            0    1063 |
 32. |           no   not mentioned       mentioned   not mentioned         ftf            1            0            1    8805 |
 33. |           no       mentioned         refused   not mentioned         ftf            0            0            1       2 |
 34. |           no       mentioned         refused       mentioned         ftf            0            0            0       2 |
 35. |           no       mentioned      don't know   not mentioned         ftf            0            0            1      22 |
 36. |           no       mentioned      don't know       mentioned         ftf            0            0            0      45 |
 37. |           no       mentioned   not mentioned   not mentioned         ftf            0            1            1     920 |
 38. |           no       mentioned   not mentioned       mentioned         ftf            0            1            0     689 |
 39. |           no       mentioned       mentioned   not mentioned         ftf            0            0            1    5717 |
     +-------------------------------------------------------------------------------------------------------------------------+

Line 3 is the routing error from above (n=5789).
Other oddities are:
Line 1: should have been applicable for this module (n=72)
Line 2: we haven't got any CATI data (telephone mode), although b_club should have been asked (n=326)
Line 12: b_club not asked, although asked with other combinations of a partial refusal (n=1)

#2 Updated by Chris Martin almost 7 years ago

Many thanks.

#3 Updated by Redmine Admin almost 7 years ago

  • Status changed from New to Closed
  • % Done changed from 50 to 100

Also available in: Atom PDF