{"id":28159,"date":"2014-10-08T10:32:14","date_gmt":"2014-10-08T14:32:14","guid":{"rendered":"http:\/\/quotulatiousness.ca\/blog\/?p=28159"},"modified":"2014-10-08T10:32:14","modified_gmt":"2014-10-08T14:32:14","slug":"something-is-wrong-when-your-data-adjustment-is-to-literally-double-the-reported-numbers","status":"publish","type":"post","link":"https:\/\/quotulatiousness.ca\/blog\/2014\/10\/08\/something-is-wrong-when-your-data-adjustment-is-to-literally-double-the-reported-numbers\/","title":{"rendered":"Something is wrong when your “data adjustment” is to literally double the reported numbers"},"content":{"rendered":"

In Forbes<\/em>, Trevor Butterworth looks at an odd data analysis piece where the “fix” for a discrepancy in reported drinks per capita is to just assume everyone under-reported and to double<\/strong> that number<\/a>:<\/p>\n

“Think you drink a lot? This chart will tell you.”<\/p>\n

The chart, reproduced below breaks down the distribution of drinkers into deciles, and ends with the startling conclusion that 24 million American adults \u2014 10 percent of the adult population over 18 \u2014 consume a staggering 74 drinks a week.<\/p>\n

\"Time<\/p>\n

The source for this figure is “Paying the Tab<\/a>,” by Phillip J. Cook, which was published in 2007. If we look at the section where he arrives at this calculation, and go to the footnote, we find that he used data from 2001-2002 from NESARC, the National Institute on Alcohol Abuse and Alcoholism, which had a representative sample of 43,093 adults over the age of 18. But following this footnote, we find that Cook corrected these data for under-reporting by multiplying the number of drinks each respondent claimed they had drunk by 1.97 in order to comport with the previous year\u2019s sales data for alcohol in the US. Why? It turns out that alcohol sales in the US in 2000 were double what NESARC\u2019s respondents \u2014 a nationally representative sample, remember \u2014 claimed to have drunk.<\/p>\n

While the mills of US dietary research rely on the great National Health and Nutrition Examination Survey to digest our diets and come up with numbers, we know, thanks to the recent work<\/a> of Edward Archer, that recall-based survey data are highly unreliable: we misremember what we ate, we misjudge by how much; we lie. Were we to live on what we tell academics we eat, life for almost two thirds of Americans would be biologically implausible.<\/p>\n

But Cook, who is trying to show that distribution is uneven, ends up trying to solve an apparent recall problem by creating an aggregate<\/em> multiplier to plug the sales data gap. And the problem is that this requires us to believe that every drinker<\/em> misremembered by a factor of almost two. This might not much of a stretch for moderate drinkers; but did everyone who drank, say, four or eight drinks per week systematically forget that they actually had eight or sixteen? That seems like a stretch.<\/p>\n

We are also required to believe that just as those who drank consumed significantly more than they were willing to admit, those who claimed to be consistently teetotal never touched a drop. And, we must also forget that those who aren\u2019t supposed to be drinking at all are also younger than 18, and their absence from Cook\u2019s data may well constitute a greater error.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

In Forbes, Trevor Butterworth looks at an odd data analysis piece where the “fix” for a discrepancy in reported drinks per capita is to just assume everyone under-reported and to double that number: “Think you drink a lot? This chart will tell you.” The chart, reproduced below breaks down the distribution of drinkers into deciles, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[66,13],"tags":[104,244,290],"class_list":["post-28159","post","type-post","status-publish","format-standard","hentry","category-health-science","category-usa","tag-booze","tag-publichealth","tag-statistics"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2hpV6-7kb","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/28159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/comments?post=28159"}],"version-history":[{"count":1,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/28159\/revisions"}],"predecessor-version":[{"id":28161,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/posts\/28159\/revisions\/28161"}],"wp:attachment":[{"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/media?parent=28159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/categories?post=28159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quotulatiousness.ca\/blog\/wp-json\/wp\/v2\/tags?post=28159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}