Roung,+E


 * __ ​ Data Management Culminating Task __

__Brainstorming__** - Comparing Gas Prices in Ontario to the most commonly bought car

- Crime Rate of Canadian men vs. crime rate of Canadian Women

- How many cigarettes packages are purchased a year in Canada vs. number of patients with cancer Canada

- Number of Harry Potter books sold vs. Number of Harry Potter movies sold

- Number of Myspace users vs. the obesity rate

//- Number of Facebook users vs. the obesity rate in Canada//

__**Stage 1: Initial Proposal**__ Facebook is a global social networking website that is privately owned and operated by Facebook, Inc. Users can add friends, send them messages, and update their personal profiles to notify friends about themselves. Additionally, users can join networks organized by city, workplace, school, and region. //**Question:** Is there a correlation between the number of facebook users and the obesity rate of Canada?//

//**Variables:** The number of facebook users since 2005 to 2008 vs. the obesity rate of Canada since 2005 to 2008.


 * Hypothesis:** Although the obesity rate of Canada was increasing prior to the creation of Facebook (2004) I believe that it's creation has played a role in the overall increase of obesity in Canada due to its popularity. I believe this because in order for the majority of facebook users to use their profile they need to be seated at a computer. This could result in individuals remaining seated for longer periods of time decreasing their amount of daily exercise/activity. Therefore I believe that the relationship will be moderate and positive.//

//**Reason for Choice:** I chose this topic because like many of my peers I have a facebook account and have noticed the increased and still increasing amount of time I am on the computer. Although I may not be on as much as others I've noticed that it is somewhat adictive. This is what lead me to choose the topic that I chose.//


 * //Raw Data://**

RED- represents the percent of the population that is obese GREEN- represents the percent of the population that is obese or overweight **
 * This chart represents the obesity rate in Canadian Province and Canada overall in 2004/2005


 * This represents the number of Facebook users in Canada at the beginning of years 2007 and 2008**



**This chart shows the number of facebook users in many different countries in 2008 Canada has 10,862,040 users.**
 * Country || Facebook users 30/12/08 ||
 * USA || 42,078,960 ||
 * UK || 14,937,810 ||
 * **Canada** || **10,862,040** ||
 * Turkey || 7,394,340 ||
 * France || 6,587,240 ||
 * Italy || 5,585,700 ||
 * Australia || 4,330,040 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Colombia || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">3,632,760 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Chile || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">4,153,020 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Spain || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">2,596,080 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Argentina || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">2,255,300 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Venezuela || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,874,220 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Indonesia || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">897,040 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Sweden || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,696,700 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Denmark || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,776,260 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Belgium || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,655,940 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Mexico || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,440,640 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Norway || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,456,140 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Germany || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,255,480 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Hong Kong || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,458,520 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Switzerland || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,122,900 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">India || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">1,071,280 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Greece || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">999,580 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">South Africa || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">920,200 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Finland || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">918,940 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Egypt || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">822,560 ||
 * <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">Malaysia || <span style="color: #111111; display: block; font-family: 'Verdana','sans-serif'; msobidifontfamily: 'Times New Roman'; msofareastfontfamily: 'Times New Roman'; text-align: center;">850,420 ||




 * __Bias__

Non-Response Bias** is when a particular group is under represented in a survey or study because they do not participate or they do not return the survey. In order to figure out what Canada's obesity rate is everyone or as close as possible needs to be surveyed. When it comes to an issue like body weight not everyone may feel comfortable telling someone their weight and simply will not participate or return the survey. This will affect the final results because the population isn't well represented.
 * Solution:** Privatize the survey making the participants feel somewhat anonymous in that their answer would not be read by anyone but the surveyor. This would increase the number of people participating in the survey.


 * Response Bias** is when people participating in the survey give false or miselading answers. This is because the respondent may want to influence results or they may feel pressured, embarassed or maybe even uncomfortable and cannot answer the question(s) honestly. Again when it comes to the issue of body weight not everyone is comfortable expressing the truth. Participants may put down false or misleading answers which will skew the results. This means that the results aren't a good representation.
 * Solution:** Again, privatize the survey. Mimic the same atmosphere as a national election in that only the surveyor reads the answers. This will decrease the amount of false or misleading surveys and the end results would be a better representation.

__**Sampling Technique**__


 * Voluntary Response Sample-** A survey would be sent out to determine the individuals body weight and it is at the discretion of the participant to return/answer the question. The survey would contain only one question: What is your current body weight? This survey could be done online, over the phone, or in the mail.


 * Convenience Sample-** This could also fall under the category of a convenience sample because the survey could have been handed out at doctors offices or businesses.


 * __Stage Three__**


 * __One Variable Analysis__**


 * __Mean__**= 25.28
 * __Median__**= 21.14
 * __Mode__**= No Mode


 * __[[image:Number_of_Facebook_Users_in_Canada_Per_Year.jpg]]

Mean__**= 20.79
 * __Median__**= 21.15
 * __Mode__**= No Mode


 * __Two Variable Analysis__**
 * [[image:graph_facebook_vs_obesity_line_of_best_fit.jpg]]

__Correlation Coefficient__** 20.09 22.18 28.88** || **22.7 22.9 23.5 32.0** || **144 403.61 491.95 834.05** || **515.29 524.41 552.25 1024** || **272.4 460.061 497.73 924.16** ||
 * **x** || **y** || **x^2** || **y^2** || **xy** ||
 * **12.0
 * **83.15** || **101.1** || **1873.61** || **2615.95** || **2154.35** ||
 * Eqaution to find the Correlation Coefficient**
 * [[image:equation.jpg width="327" height="68"]]

= 0.562 = positive moderate**

The end result of 0.562 confirms that my correlation is moderate and positive. This matches up with my hypothesis. After doing further research I discovered the data I found can be somewhat misleading especially when it comes to the number of facebook users there are in Canada. This is because of the term 'active', not all accounts on facebook are active accounts. This means that not every account on facebook is being used, although it may have been at some point there is no way (for me) to tell which accounts are being used and which ones aren't. There is also the issue of 'fake' accounts. These are accounts that have been created for reasons such as: a joke, a mistake, ect. Although these count as an account they are misleading because this means that there is more then one account per person. This can be put under the category of measurement bias.
 * __Final Statement__**


 * Work Cited**

(1) Baillargeon, E. (2008, January 2). //Facebook users in Canada by province//. Retrieved January 3, 2010, from []

(2) Burcher, N. (2009, March 17). //Facebook Usage Statistics by Country//. Retrieved December 6, 2009, from []

(3) Cravit, C. R. (2010). //Canada the fat?//. Retrieved January 3, 2010, from http://www.50plus.com/Health/BrowseAllArticles/index.cfm?documentID=20183

(4) Chronic Disease Surveillance Division. (n.d.). //Obesity in Canada - Snapshot//. Retrieved January 3, 2010, from []

(5) Frosst, M. (2007). //Obesity - The key figures according to Canada's statistics//. Retrieved January 3, 2010, from []

(6) //Obesity rates in Canada//. (2009, August 21). Retrieved December 6, 2009, from

(7) TrafficSynergy Team. (2009, September 1). //The Facebook Country//. Retrieved December 6, 2009, from []

(8)Zuckerberg, M. (2010). //Facebook | Timeline//. Retrieved January 3, 2010, from http://www.facebook.com/press/info.php?timeline