Data Management and Visualization -Week 1

My name is Dipika Pawar and this blog is a part of Data Management and Visualization course on coursera. The submission of the assignments will be in the form of blogs. So I choose medium as my medium of assignment.

Assignment 1:

In assignment 1, we have to choose dataset on which we have to work for the whole course. The five code books are given through which we have to select a subcategory and two topics/ variable on which we want to work.

STEP 1: Choose a data set that you would like to work with.

After reviewing five codebooks, I have decide to go with “portion of the GapMinder”. This data includes one year of numerous country-level indicators of health, wealth and development. I want work on health issue is the main reason to choose this handbook. In today’s world, the average life expectancy is increased. But some intoxication cause early death.

STEP 2. Identify a specific topic of interest

As I want to explore the average life expectancy including some intoxication, I would like to go with alcohol consumption and life expectancy. As the alcohol consumption is so injurious to health I would like to aim this issue to how much it’s dangerous. So I’m considering how the alcohol consumption will effect to health and other parameters or which parameters are related to to alcohol consumption.

STEP 3. Prepare a codebook of your own

As, GapMinder includes variables apart from health (wealth, development). So here I’m considering only incomeperperson, alcconsumption and lifeexpectancy as variables.

STEP 4. Identify a second topic that you would like to explore in terms of its association with your original topic.

The second topic which I would like to explore is urbanrate. While looking at the codebook, I thought that there might be possibility that urban rate is connected to alcohol consumption. We can see in urban area, people are less aware of their health and consume more toxic.

STEP 5. Add questions/items/variables documenting this second topic to your personal codebook.

Is there any relation between urban rate and alcohol consumption?

Is there any relation between life expectancy and alcohol consumption?

Is there any relation between Income and alcohol consumption?

The final Codebook:

STEP 6. Perform a literature review to see what research has been previously done on this topic

For the relation between urbanrate and alcohol consumption, I search so much on google scholar but there is not a single paper on it. When I had search on google itself, I got to know that there is nor direct relation between this two. The relation as in terms of stress and culture. Those can be in city and urban are also. So I don’t have to consider this term(urbanrate).

For the relation between life expectancy and alcohol consumption, I got lots of articles on it so do with income and alcohol consumption. Here are few articles and overview of their content.

Lifetime income patterns and alcohol consumption: Investigating the association between long- and short-term income trajectories and drinking[1]

Overview: In this paper, authors evaluated the relationship between long-term and short-term measures of income. They used the data of US Panel Study on Income Dynamics. They also gave inference like the low income associated with heavy consumption. “Lifetime income patterns may have an indirect association with alcohol use, mediated through current socioeconomic position.”[1]

A Review of Expectancy Theory and Alcohol Consumption[2]

According to their study , “Expectancy manipulations and alcohol consumption: three studies in the laboratory have shown that increasing positive expectancies through word priming increases subsequent consumption and two studies have shown that increasing negative expectancies decreases it”[2]

Alcohol-related mortality by age and sex and its impact on life expectancy: Estimates based on the Finnish death register[3]

In this article, the author studied plausible results on the connection between alcohol-related mortality and age and sex. Here are few statistics, “According to the results, 6% of all deaths were alcohol related. These deaths were responsible for a 2 year loss in life expectancy at age 15 years among men and 0.4 years among women, which explains at least one-fifth of the difference in life expectancies between the sexes. In the age group of 15–49 years, over 40% of all deaths among men and 15% among women were alcohol related. In this age group, over 50% of the mortality difference between the sexes results from alcohol-related deaths”[3]

STEP 7. Based on your literature review, develop a hypothesis about what you believe the association might be between these topics. Be sure to integrate the specific variables you selected into the hypothesis.

After exploring such articles, they are enough to establish the correlation between alcohol consumption and life expectancy and also with Income (apart from these three). After certain observation, following are my hypothesis:

• The alcohol consumption is highly correlated with life expectancy.
• The social culture , group of people associated with person, stress and Income have direct correlation with alcohol consumption.
• Urban rate is not directly connected to alcohol consumption.

Final Codebook:

Reference:

[1]Cerdá, Magdalena, et al. “Lifetime Income Patterns and Alcohol Consumption: Investigating the Association between Long- and Short-Term Income Trajectories and Drinking.” Social Science & Medicine, vol. 73, no. 8, 2011, pp. 1178–1185., doi:10.1016/j.socscimed.2011.07.025.

[2] Jones, Barry T., et al. “A Review of Expectancy Theory and Alcohol Consumption.” Addiction, vol. 96, no. 1, 2001, pp. 57–72., doi:10.1046/j.1360–0443.2001.961575.x.

[3]Makela, P. “Alcohol-Related Mortality by Age and Sex and Its Impact on Life Expectancy.” The European Journal of Public Health, vol. 8, no. 1, 1998, pp. 43–51., doi:10.1093/eurpub/8.1.43.