Nikulka,+S



=Alcohol Abuse vs. Crime Rates =

Brainstorming
 * low income vs. delayed retirement
 * hours of sleep vs. work habits
 * abuse of drugs vs. students average
 * family violence vs. alcohol abuse
 * spousal abuse vs. divorce rate

Question
 * Does alcohol abuse have a correlation with crime rates in Canada? (2003-2008)

VS.

Variables
 * Independant- alcohol consumption (x)
 * Dependant- crime rates (y)

Hypothesis
 * I believe that the more alcohol you consume to the point of abuse, crime rates will increase.

Information
 * When people consume alcohol to the point of abuse, they have less control over their actions, which could cause them to make reckless decisions. I'm trying to prove this statement.

Raw Data
 * []
 * []

Sampling Technique and Bias The data was collected using a simple random sample. This is a sampling bias because not every member of the population will be asked.


 * ====Year ==== || ====Youths Charged ==== ||
 * ====2003 ==== || ====235 ==== ||
 * ====2004 ==== || ====268 ==== ||
 * ====2005 ==== || ====<span style="font-family: Arial,sans-serif;">305 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2006 ==== || ====<span style="font-family: Arial,sans-serif;">454 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2007 ==== || ====<span style="font-family: Arial,sans-serif;">388 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2008 ==== || ====<span style="font-family: Arial,sans-serif;">335 ==== ||




 * ====<span style="font-family: Arial,sans-serif;">Year ==== || ====<span style="font-family: Arial,sans-serif;">Youth Alcohol Consumption ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2003 ==== || ====<span style="font-family: Arial,sans-serif;">464,437 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2004 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2005 ==== || ====<span style="color: #000000; font-family: Arial,sans-serif;">475,980 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2006 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2007 ==== || ====<span style="font-family: Arial,sans-serif;">455,510 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2008 ==== || ====<span style="font-family: Arial,sans-serif;">457,214 ==== ||

<span style="font-family: Arial,sans-serif;">[]

<span style="font-family: Arial,sans-serif;">

One Variable Data

 * ====<span style="font-family: Arial,sans-serif;">Year ==== || ====<span style="font-family: Arial,sans-serif;">Alcohol(x) ==== || ====<span style="font-family: Arial,sans-serif;">Deviation ==== || ====<span style="font-family: Arial,sans-serif;">Deviation Squared ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2003 ==== || ====<span style="font-family: Arial,sans-serif;">464,437 ==== || ====<span style="font-family: Arial,sans-serif;">78,656 ==== || ====<span style="font-family: Arial,sans-serif;">6,186,766,336 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2004 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">none ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2005 ==== || ====<span style="color: #000000; font-family: Arial,sans-serif;">475,980 ==== || ====<span style="font-family: Arial,sans-serif;">90,199 ==== || ====<span style="font-family: Arial,sans-serif;">8,135,859,601 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2006 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">none ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2007 ==== || ====<span style="font-family: Arial,sans-serif;">455,510 ==== || ====<span style="font-family: Arial,sans-serif;">69,729 ==== || ====<span style="font-family: Arial,sans-serif;">4,862,133,441 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2009 ==== || ====<span style="font-family: Arial,sans-serif;">457,214 ==== || ====<span style="font-family: Arial,sans-serif;">71,433 ==== || ====<span style="font-family: Arial,sans-serif;">5,102,673,489 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">SUM ==== || ====<span style="font-family: Arial,sans-serif;">**1853141** ==== ||  || ====<span style="font-family: Arial,sans-serif;">**2.428x10^10** ==== ||

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Mean- 1,853,141 /4 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 463,285.25

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Median- 475,980+455,510 /2 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 465,745

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Mode- no numbers are repeated

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Range- 475,980-455,510 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 20,470

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">SD- 2.428x10^10 / (4-1) <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 6,070,000,000(then square root taken out) <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 77,910.204


 * ====<span style="font-family: Arial,sans-serif;">Year ==== || ====<span style="font-family: Arial,sans-serif;">Crime(y) ==== || ====<span style="font-family: Arial,sans-serif;">Deviation ==== || ====<span style="font-family: Arial,sans-serif;">Deviation Squared ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2003 ==== || ====<span style="font-family: Arial,sans-serif;">235 ==== || ====<span style="font-family: Arial,sans-serif;">-95.83 ==== || ====<span style="font-family: Arial,sans-serif;">9,183.38 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2004 ==== || ====<span style="font-family: Arial,sans-serif;">268 ==== || ====<span style="font-family: Arial,sans-serif;">-62.83 ==== || ====<span style="font-family: Arial,sans-serif;">3,947.60 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2005 ==== || ====<span style="font-family: Arial,sans-serif;">305 ==== || ====<span style="font-family: Arial,sans-serif;">-25.83 ==== || ====<span style="font-family: Arial,sans-serif;">667.18 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2006 ==== || ====<span style="font-family: Arial,sans-serif;">454 ==== || ====<span style="font-family: Arial,sans-serif;">123.17 ==== || ====<span style="font-family: Arial,sans-serif;">15,170.84 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2007 ==== || ====<span style="font-family: Arial,sans-serif;">388 ==== || ====<span style="font-family: Arial,sans-serif;">57.17 ==== || ====<span style="font-family: Arial,sans-serif;">3,268.40 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">2008 ==== || ====<span style="font-family: Arial,sans-serif;">335 ==== || ====<span style="font-family: Arial,sans-serif;">4.17 ==== || ====<span style="font-family: Arial,sans-serif;">17.38 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">SUM ==== || ====**<span style="font-family: Arial,sans-serif;">1985 **==== ||  || ====**<span style="font-family: Arial,sans-serif;">32,254.78 **==== ||

<span style="font-family: Arial,sans-serif;">Mean- 1985 /6 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">= 330.83

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Median- 305+404 /2 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">=354.5

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Mode- no numbers are repeated

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">Range- 454-235 <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">=219

<span style="font-family: Arial,sans-serif; margin-bottom: 0in;">SD- 32,254.78 / (6-1) <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">=5,375.79(then square root taken out) <span style="font-family: Arial,sans-serif; margin-bottom: 0in;">=73.31

Two Variable Data

 * ====<span style="font-family: Arial,sans-serif;">X ==== || ====<span style="font-family: Arial,sans-serif;">Y ==== || ====<span style="font-family: Arial,sans-serif;">X^2 ==== || ====<span style="font-family: Arial,sans-serif;">Y^2 ==== || ====<span style="font-family: Arial,sans-serif;">XY ==== ||
 * ====<span style="font-family: Arial,sans-serif;">464,437 ==== || ====<span style="font-family: Arial,sans-serif;">235 ==== || ====<span style="font-family: Arial,sans-serif;">2.157x10^11 ==== || ====<span style="font-family: Arial,sans-serif;">55,225 ==== || ====<span style="font-family: Arial,sans-serif;">109,142,695 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">268 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">71,824 ==== || ====<span style="font-family: Arial,sans-serif;">268 ==== ||
 * ====<span style="color: #000000; font-family: Arial,sans-serif;">475,980 ==== || ====<span style="font-family: Arial,sans-serif;">305 ==== || ====<span style="font-family: Arial,sans-serif;">2.265x10^11 ==== || ====<span style="font-family: Arial,sans-serif;">93,025 ==== || ====<span style="font-family: Arial,sans-serif;">145,173,900 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">454 ==== || ====<span style="font-family: Arial,sans-serif;">none ==== || ====<span style="font-family: Arial,sans-serif;">206,116 ==== || ====<span style="font-family: Arial,sans-serif;">454 ==== ||
 * ====455,510==== || ====<span style="font-family: Arial,sans-serif;">388 ==== || ====<span style="font-family: Arial,sans-serif;">2.074x10^11 ==== || ====<span style="font-family: Arial,sans-serif;">150,544 ==== || ====<span style="font-family: Arial,sans-serif;">176,737,880 ==== ||
 * ====<span style="font-family: Arial,sans-serif;">457,214 ==== || ====<span style="font-family: Arial,sans-serif;">335 ==== || ====<span style="font-family: Arial,sans-serif;">2.090x10^11 ==== || ====<span style="font-family: Arial,sans-serif;">112,225 ==== || ====<span style="font-family: Arial,sans-serif;">153,166,690 ==== ||
 * ====**1,853,151**==== || ====<span style="font-family: Arial,sans-serif;">**1985** ==== || ====<span style="font-family: Arial,sans-serif;">**8.586x10^11** ==== || ====<span style="font-family: Arial,sans-serif;">**688,959** ==== || ====<span style="font-family: Arial,sans-serif;">**584,221,851** ==== ||

Correlation Co-efficient
r= __3,505,331,106 - 3,678,484,885__ (1.717x10^12)(193,529)

r= -__173,153,779__ 576,445,394.6

r= -0.300

moderate negative