Support #180
closed
Sports Club membership among Scottish adults
100%
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 2682For 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
Updated by Redmine Admin over 11 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)
Updated by
Updated by Redmine Admin over 11 years ago
- Status changed from New to Closed
- % Done changed from 50 to 100