Transcript The relationship of Alcohol and School

By:
Jacob Kemble
Matt Kelly
Taylor Shannon

We realize that alcohol can play a huge role on
the performance of a college student. We
conducted a survey with 13 questions which
asked 75 business students questions about
how much alcohol they consume and how it
effects their schoolwork.



The college we chose was Cal State University
San Marcos.
We chose to give the surveys to students
attending classes in the College of Business.
We conducted 75 surveys in various classes.
Drinking and School
Disclaimer: This survey is confidential: DO NOT PLACE YOUR NAME ON THIS SURVEY
Are you?
How old are you?
Male
Female
How many nights per week do you drink? Circle one
None
1
2
3
4
5
6
7
When you drink how many drinks do you consume per sitting? (Serving Size
Circle one:
1.5 oz. Liquor 12 oz. Beer
1-2 3-4 5-6 7-8 9-10 11-12 13-14 15-16 17-18 18+
What do you drink? Circle one:
Beer
Wine
Hard Liquor
Have you ever gotten a DUI? If so, how many times?
Have been arrested for being under the influence? If so, how many times?
Have you ever become sick after drinking too much? If so, how many times?
Has drinking caused you to be absent in class this semester? If so, how many times?
Has drinking caused you to miss assignment deadlines this semester? If so, how many times?
Have you ever had alcohol on campus?
Have you ever been intoxicated while in class? If so, how many times?
What is your current grade point average?
Variety
6 oz Wine)

For our research, we decided to answer the
question whether or not alcohol affects
students’ performance in school. We set out to
find if there is any correlation between various
alcohol related factors and students’ GPA.
Null Hypothesis: Students who drink more than 5
nights a week will have a GPA lower than 3.0.
Alternative Hypothesis: Students who drink more than
5 nights a week can have a GPA higher than 3.0.
 H₀ = µ ≤ 3.0
 HA = µ > 3.0
Males: 43
Females: 33
-Minimum: 20 Years Old
-Maximum: 46 Years Old
-Minimum: 20 Years Old
-Maximum: 43 Years Old
Total Number of
People Surveyed: 75
44%
56%
Males (42)
Females (33)
25
Age of People Surveyed
20
Number of People in Survey
20
15
Mean: 24
Median: 22
Mode: 21
Standard Dev: 5.37
Variance: 28.82
Min: 20
Max:46
14
11
10
6
7
5
3
1
1
1
2
1
2
1
1
1
1
1
1
31 32 33
35
39 40
43
46
0
20 21 22 23 24 25 26 27 28 29
Age
Total Number of
People Surveyed:
75
10%
28%
Beer (21)
32%
Hard Liquor (10)
13%
17%
None (13)
Variety (24)
Wine (7)
Number of People Who Drink
25
Mean: 2
Median: 2
Mode: 1
Standard Dev.: 1.73
Variance: 2.99
23
20
15
13
13
10
10
9
5
3
3
1
0
0
1
2
3
4
Nights Per Week
5
6
7
25
Number of People Who Drink
Mean: 3.96 Median: 3.5
Mode: 3.5 Standard Dev.: 3.72
Variance: 13.83
Min: 0
Max: 17.5
20
20
18
15
13
10
9
6
5
4
3
0
0
0
1 to 2
3 to 4
5 to 6
7 to 8
9 to 10
Number of Drinks
11 to 12
13 to 14
1
1
15 to 16
17 to 18
69
DUI
No DUI
6
Out of the 75 surveyed
students:
75
60
Arrested
•The average GPA of the
10 students who have
been arrested was 3.025
Multiple Arrests
45
Total Arrests
•The student that was
arrested the most times
(4) had the lowest GPA of
the group (2.70)
30
15
0
10
3
16
GPA
•There is a negative
correlation between
students GPA and the
number of classes they
miss due to alcohol.
4.00
3.80
3.60
3.40
3.20
3.00
GPA
2.80
•As the number of
missed classes rises,
GPA decreases.
2.60
2.40
2.20
2.00
0
1
2
3
4
5
Number of Classes Absent Due to Alcohol
6
7
30 +
•0%
0
26 to 30
•1.33%
1
20 to 25
•6.67%
5
16 to 20
•1.33%
1
11 to 15
•5.33%
4
6 to 10
•20%
15
1 to 5
•40%
30
0
•25.33%
19
0
5
10
15
20
25
30
35
Yes
21%
No
79%
Totals:
Yes: 16 Students
No: 59 Students

Sample Size:

Sample Mean: 3.12





Variance:
Standard
Deviation:
75
0.093536
0.305837
Lowest GPA: 2.6
Highest GPA: 3.8
Sample Size:
75
Sample Mean:
2
Variance:
2.99
Standard
Deviation:
1.72806
Lowest:
Highest:
0
7
Correlation Between Number of Nights
Drinking and GPA
4.00
3.80
3.60
GPA
3.40
3.20
3.00
2.80
2.60
2.40
0
1
2
3
4
5
6
7
Number of Nights Drinking per Week
Sample size:
75
Standard Deviation: 0.305837
Variance:
0.093536
Sample Mean:
Lowest GPA:
Highest GPA:
3.12
2.6
3.8
8



There is a positive relation between the number
of nights a student drinks, and their GPA.
When comparing these results to our
hypothesis, we found that the number of nights
a student drinks during a week did negatively
affect students’ GPA.
As the number of nights per week a student
drinks, the more their GPA decreases.
Histogram of Number of people and
how many school assignments
missed due to alcohol
60
57
50
Number of People
40
30
20
10
7
4
3
2
1
0
0
1
2
3
6
Number of Missed Assignments
7
Mean:
1
Median:
0
Mode:
0
Standard
Deviation:
1.457877
Variance:
2.125405
Minimum:
Maximum:
0
7



We completed a regression analysis comparing
the number of nights students drink alcohol to
their GPA.
The dependant variable (y) was the students’
GPA
The independent variable (x) was the number
of nights students consume alcohol in a week.
Regression Analysis of Number of Nights of consuming Alcohol to their GPA.
SUMMARY
OUTPUT
Regression Statistics
0.23715489
Multiple R
5
0.05624244
R Square
4
0.04331425
Adjusted R Square
9
0.29913975
Standard Error
3
Observations
75
ANOVA
df
Residual
73
MS
F
Significance F
0.38929145 4.35037410
0.389291452
2
4 0.040496214
0.08948459
6.532375215
2
Total
74
6.921666667
Regression
Intercept
X Variable 1
SS
1
Coefficients Standard Error
t Stat
P-value
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
3.03020409
56.1577615
3.13774377
1 0.053958776
5 8.22718E-62 2.922664406
5 2.922664406 3.137743775
0.04197212
2.08575504 0.04049621
0.08207765
4 0.020123228
4
4 0.001866589
9 0.001866589 0.082077659


Overall, we concluded to
not reject our null
hypothesis.
Over 57% of the students
who drank over 5 nights a
week have a GPA of less
than 3.0.
40
40
35
28
30
25
GPA over 3.0
20
GPA equal or under 3.0
15
10
5
3
4
0
Drinking over 5
nights per week
Drinking less than 5
nights per week


Next time would improve:

By increasing our sample size.

Have more specific questions; not using ranges.
 Ex. (1-2 drinks, 3-4 drinks)

Decrease the amount of questions in our survey.
Lastly…
• Make sure you team up with reliable
teammates, who don’t drop the class with
one week left of school.
Ex.
Photo courtesy of Ashty’s myspace