BIG ASS PROJECT STATS

BIG ASS PROJECT - Average of days a week Age 19 20 21 22 23 24 26 Grand Total 4.5 3.21 3.5 3 4.08 2.77 4 4 3 3.43 Average of GPA Year in School 1 2

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Average of days a week Age Total 17 18 19 20 21 22 23 24 26 Grand Total 4.5 3.21 3.5 3 4.08 2.77 4 4 3 3.43 Average of GPA Year in School 1 2 3 4 5 Grand Total Total 2.63 2.45 2.98 2.9 3.06 2.76 Anova test Sum of Male or Female Drinking ticket Total 0 24 1 20 Grand Total 44 drinking tickets no affiliation necessary Male Female 20 24 Male or Female Age Year in School Greek days a week drinks a night drink and drive GPA 1 21 4 0 7 14 1 1.9 1 21 4 0 2 12 0 3.1 0 21 4 0 5 9 1 0.9 1 19 3 0 6 1 0 3.1 0 17 1 0 7 7 1 2.7 1 20 3 0 6 10 1 3 1 20 2 0 4 10 0 2.3 1 18 1 0 7 7 1 3.7 0 20 3 0 1 20 0 2.3 0 19 2 0 1 1 1 1.9 1 23 5 0 3 3 1 2.98 0 18 1 0 2 2 0 3.1 1 22 4 0 3 3 0 3 1 19 1 0 7 17 1 2.2 1 20 3 0 2 2 1 2 0 20 2 0 3 7 0 3.6 1 20 2 0 4 7 1 2.3 1 18 1 0 0 0 0 3 1 20 3 0 0 0 0 3.7 0 20 3 0 2 2 0 2.7 1 17 1 0 1 7 1 2 0 18 1 0 4 4 0 3 1 21 1 0 7 8 0 2 0 19 2 0 4 10 1 3.5 0 17 2 0 6 4 1 3 0 18 1 0 3 7 0 3 0 18 1 0 0 0 0 2.4 0 24 5 0 7 8 1 3.7 0 21 3 0 2 1 0 2.6 1 18 1 0 4 4 1 2.8 0 26 5 0 3 4 0 3.9 1 21 3 0 6 6 1 1 1 17 1 0 4 5 1 1.7 1 22 5 0 3 8 1 3 0 22 5 0 1 5 0 3.25 0 20 3 1 7 10 1 2.5 0 18 1 1 4 12 0 1.3 1 22 4 1 2 4 1 4 0 19 2 1 7 10 1 3.5 1 19 2 1 4 4 0 3 1 21 4 1 5 14 1 3.3 0 21 4 1 6 7 0 3 1 21 4 1 7 4 0 2.5 1 22 4 1 7 15 0 3 1 21 3 1 2 5 0 3 0 19 1 1 2 3 0 3.5 0 19 1 1 3 5 0 3 1 22 3 1 1 2 0 3.8 1 19 1 1 3 4 0 3.3 0 20 3 1 2 3 0 3.6 0 21 3 1 2 3 0 3.1 0 18 1 1 2 3 0 3.2 0 1 1 1 0 0 1 0 0 1 1 1 0 0 1 1 1 0 1 1 1 1 1 0 0 0 1 1 22 19 22 18 19 22 19 19 19 21 18 20 24 23 21 18 22 22 18 19 20 22 19 18 23 19 19 22 4 2 4 1 1 4 1 2 2 3 1 2 5 4 3 1 3 4 1 2 4 5 2 1 3 1 2 3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 5 3 0 3 5 2 0 2 3 4 1 6 0 0 2 2 7 3 1 4 7 6 3 3 5 3 0 3 10 10 0 10 12 3 0 3 4 20 1 11 0 0 6 7 7 10 7 4 7 5 3 7 9 7 0 1 0 0 0 1 0 0 0 0 1 1 0 1 0 0 0 1 1 1 0 1 1 0 1 0 1 1 4 2 3.1 2.7 2.7 2 1 3.2 2.9 3.2 2.5 2.75 1.8 2 4 3.2 3.73 3.71 1.75 1.5 4 2.8 0 3.9 4 2.1 1.25 2.25 Average amount of money Drinking ticket 35 0 10 0 10 0 12 0 30 0 15 0 20 1 70 0 10 0 0 1 30 0 5 0 5 1 37 1 20 1 15 0 35 0 0 0 0 0 10 0 17 1 20 0 17 1 35 1 15 0 35 0 0 0 80 1 60 0 19 0 28 1 50 0 80 1 25 0 10 0 15 1 60 0 20 1 20 0 10 1 20 1 30 0 20 0 100 1 10 1 10 0 5 1 5 0 10 1 10 0 5 0 15 0 0 20 30 20 0 20 45 10 0 10 20 70 0 40 0 0 45 25 20 45 20 22 75 50 90 7 50 15 0 0 0 1 0 1 1 1 0 0 1 1 0 0 0 0 0 0 0 0 1 0 1 0 0 1 1 0 Average of Average amount of money Age Total 17 18 19 20 21 22 23 24 26 Grand Total 35.5 23.86 21.72 20 21.31 24.77 53.33 40 28 24.68 age 17 18 19 Average amount of money spent p 20 21 28 35.5 22 23 24 40 26 53.33 21.31 24.77 Average amount of money 35.5 23.86 21.72 unt of money spent per age in $ 20 21.31 28 35.5 24.77 53.33 40 23.86 28 21.72 20 21.31 24.77 Male or Female days a week drinks a night drink and drive 0 7 10 1 0 5 9 1 0 4 12 0 0 7 10 1 0 7 7 1 0 6 7 0 0 1 20 0 0 1 1 1 0 2 3 0 0 3 5 0 0 2 2 0 0 2 3 0 0 2 3 0 0 2 3 0 0 0 0 0 0 3 7 0 0 0 0 0 0 3 10 1 0 2 3 0 0 2 2 0 0 0 0 0 0 4 4 0 0 4 10 1 0 1 1 0 0 6 11 1 0 6 4 1 0 3 7 0 0 2 7 1 0 0 0 0 0 7 8 1 0 2 1 0 0 6 5 0 0 3 4 0 0 3 3 1 0 1 5 0 0 3 7 0 1 7 14 1 1 2 12 0 1 6 1 0 1 2 4 1 1 4 4 0 1 5 14 1 1 6 10 1 1 4 10 0 1 7 7 1 1 7 4 0 1 3 3 1 1 7 15 0 1 2 5 0 1 1 2 0 1 3 3 0 1 3 4 0 GPA Average amount of money 2.5 15 0.9 10 1.3 60 3.5 20 2.7 30 3 30 2.3 10 1.9 0 3.5 10 3 5 3.1 5 3.6 10 3.1 5 3.2 15 4 0 3.6 15 2.7 0 2 20 3.2 10 2.7 10 2.9 0 3 20 3.5 35 1.8 0 2 40 3 15 3 35 3.71 25 2.4 0 3.7 80 2.6 60 3.9 50 3.9 28 4 90 3.25 10 2.1 7 1.9 35 3.1 10 3.1 12 4 20 3 10 3.3 20 3 15 2.3 20 3.7 70 2.5 20 2.98 30 3 100 3 10 3.8 5 3 5 3.3 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 7 1 2 5 3 4 5 0 0 2 1 3 7 4 0 0 2 7 3 1 4 7 4 6 4 3 5 3 17 3 2 10 10 7 12 0 0 3 7 4 8 20 0 0 6 7 10 7 4 7 4 6 5 8 9 7 1 1 1 0 0 1 0 0 0 0 1 1 0 1 0 0 0 1 1 0 1 1 1 1 1 1 1 1 2.2 2 2 3.1 2.7 2.3 1 3 3.7 3.2 2 2.5 2 2.75 4 3.2 3.73 1.75 1.5 4 2.8 0 2.8 1 1.7 3 1.25 2.25 37 20 20 30 20 35 45 0 0 10 17 20 17 70 0 0 45 20 45 20 22 75 19 50 80 25 50 15 Drinking ticket Do you drink? 1 1 0 1 0 1 0 1 0 1 0 1 0 1 1 1 0 1 1 1 0 1 0 1 0 1 0 1 0 0 0 1 0 0 1 1 1 1 0 1 0 0 0 1 1 1 0 1 0 1 0 1 0 1 0 1 0 0 1 1 0 1 0 1 1 1 0 1 0 1 1 1 0 1 0 1 0 1 1 1 1 1 1 1 0 1 1 1 0 1 0 1 0 1 1 1 1 1 0 1 1 1 1 1 t-Test: Two-Sample Assuming Equal Variances Mean Variance Observations Pooled Variance Hypothesized Mean Difference df t Stat P(T<=t) one-tail t Critical one-tail P(T<=t) two-tail t Critical two-tail 1 0 1 0 1 0 1 0 0 0 1 1 1 1 0 0 0 0 0 1 0 1 0 0 1 0 1 0 1 1 1 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 1 1 Female Male Variable 1 Variable 2 3.11 3.68 4.79 5.01 36 44 4.91 0 78 -1.15 0.13 1.66 0.26 1.99 Average of days a week Male or Female Total 0 1 Grand Total 3.11 3.68 3.43 Average Days a week between Males a 3.8 3.7 3.6 Average days a week 3.5 3.4 3.3 3.2 3.1 3 2.9 2.8 Males Males Females 3.68 3.68 3.11 a week between Males and Females 3.11 Females Male or Female Age Year in School Greek days a week drinks a night drink and drive GPA 1 21 4 0 7 14 1 1.9 1 21 4 0 2 12 0 3.1 0 20 3 1 7 10 1 2.5 0 21 4 0 5 9 1 0.9 1 19 3 0 6 1 0 3.1 0 18 1 1 4 12 0 1.3 1 22 4 1 2 4 1 4 0 19 2 1 7 10 1 3.5 0 17 1 0 7 7 1 2.7 1 19 2 1 4 4 0 3 1 21 4 1 5 14 1 3.3 1 20 3 0 6 10 1 3 1 20 2 0 4 10 0 2.3 0 21 4 1 6 7 0 3 1 18 1 0 7 7 1 3.7 0 20 3 0 1 20 0 2.3 1 21 4 1 7 4 0 2.5 0 19 2 0 1 1 1 1.9 1 23 5 0 3 3 1 2.98 1 22 4 1 7 15 0 3 1 21 3 1 2 5 0 3 0 19 1 1 2 3 0 3.5 0 19 1 1 3 5 0 3 1 22 3 1 1 2 0 3.8 0 18 1 0 2 2 0 3.1 1 22 4 0 3 3 0 3 1 19 1 1 3 4 0 3.3 0 20 3 1 2 3 0 3.6 0 21 3 1 2 3 0 3.1 0 18 1 1 2 3 0 3.2 0 22 4 1 0 0 0 4 1 19 1 0 7 17 1 2.2 1 19 2 1 1 3 1 2 1 20 3 0 2 2 1 2 1 22 4 1 5 10 0 3.1 1 18 1 1 3 10 0 2.7 0 20 2 0 3 7 0 3.6 1 20 2 0 4 7 1 2.3 0 19 1 1 0 0 0 2.7 0 22 4 1 3 10 1 2 1 19 1 1 5 12 0 1 0 19 2 1 2 3 0 3.2 1 18 1 0 0 0 0 3 1 20 3 0 0 0 0 3.7 0 20 3 0 2 2 0 2.7 0 19 2 1 0 0 0 2.9 1 21 3 1 2 3 0 3.2 1 17 1 0 1 7 1 2 1 18 1 1 3 4 1 2.5 0 18 1 0 4 4 0 3 1 21 1 0 7 8 0 2 1 20 2 1 4 20 1 2.75 0 0 0 1 0 1 1 0 0 1 0 1 0 1 1 1 0 0 1 0 1 0 1 1 0 0 1 1 19 24 23 21 17 18 22 18 22 18 18 19 24 20 22 19 21 18 18 26 21 23 17 22 22 19 19 22 2 5 4 3 2 1 3 1 4 1 1 2 5 4 5 2 3 1 1 5 3 3 1 5 5 1 2 3 0 1 1 1 0 1 1 0 1 1 0 1 0 1 1 1 0 1 0 0 0 1 0 0 0 1 1 1 4 1 6 0 6 0 2 3 2 7 0 3 7 1 4 7 2 6 4 3 6 3 4 3 1 3 5 3 10 1 11 0 4 0 6 7 7 7 0 10 8 7 4 7 1 5 4 4 6 3 5 8 5 7 9 7 1 0 1 0 1 0 0 0 1 1 0 1 1 0 1 1 0 0 1 0 1 1 1 1 0 0 1 1 3.5 1.8 2 4 3 3.2 3.73 3 3.71 1.75 2.4 1.5 3.7 4 2.8 0 2.6 3.9 2.8 3.9 1 4 1.7 3 3.25 2.1 1.25 2.25 Average amount of money Drinking ticket Do you drink? 35 0 1 10 0 1 15 1 1 10 0 1 12 0 1 60 0 1 20 1 1 20 0 1 30 0 1 10 1 1 20 1 1 15 0 1 20 1 1 30 0 1 70 0 1 10 0 1 20 0 1 0 1 1 30 0 1 100 1 1 10 1 1 10 0 1 5 1 1 5 0 1 5 0 1 5 1 1 10 1 1 10 0 1 5 0 1 15 0 1 0 0 0 37 1 1 20 0 1 20 1 1 30 0 1 20 1 1 15 0 1 35 0 1 0 0 0 20 1 1 45 1 1 10 1 1 0 0 0 0 0 0 10 0 1 0 0 0 10 0 1 17 1 1 20 1 1 20 0 1 17 1 1 70 1 1 35 0 40 0 15 0 45 35 25 20 0 45 80 20 22 75 60 50 19 28 50 90 80 25 10 7 50 15 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 1 0 0 1 0 0 1 1 0 1 1 1 0 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Sum of drink and drive Total Total 35 survey number male =1 Male or Female Age 1 1 2 1 3 0 4 0 5 1 6 0 7 1 8 0 9 0 10 1 11 1 12 1 13 1 14 0 15 1 16 0 17 1 18 0 19 1 20 1 21 1 22 0 23 0 24 1 25 0 26 1 27 1 28 0 29 0 30 0 31 0 32 1 33 1 34 1 35 1 36 1 37 0 38 1 39 0 40 0 41 1 42 0 43 1 44 1 45 0 46 0 47 1 48 1 49 1 50 0 51 1 Yes=1 Year in School Greek 21 4 21 4 20 3 21 4 19 3 18 1 22 4 19 2 17 1 19 2 21 4 20 3 20 2 21 4 18 1 20 3 21 4 19 2 23 5 22 4 21 3 19 1 19 1 22 3 18 1 22 4 19 1 20 3 21 3 18 1 22 4 19 1 19 2 20 3 22 4 18 1 20 2 20 2 19 1 22 4 19 1 19 2 18 1 20 3 20 3 19 2 21 3 17 1 18 1 18 1 21 1 0 0 1 0 0 1 1 1 0 1 1 0 0 1 0 0 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 0 1 0 1 1 0 0 1 1 1 1 0 0 0 1 1 0 1 0 0 days a week drinks a night 7 14 2 12 7 10 5 9 6 1 4 12 2 4 7 10 7 7 4 4 5 14 6 10 4 10 6 7 7 7 1 20 7 4 1 1 3 3 7 15 2 5 2 3 3 5 1 2 2 2 3 3 3 4 2 3 2 3 2 3 0 0 7 17 1 3 2 2 5 10 3 10 3 7 4 7 0 0 3 10 5 12 2 3 0 0 0 0 2 2 0 0 2 3 1 7 3 4 4 4 7 8 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 1 0 0 0 1 0 1 1 0 0 1 0 1 0 1 1 1 0 0 1 0 1 0 1 1 0 0 1 1 20 19 24 23 21 17 18 22 18 22 18 18 19 24 20 22 19 21 18 18 26 21 23 17 22 22 19 19 22 2 2 5 4 3 2 1 3 1 4 1 1 2 5 4 5 2 3 1 1 5 3 3 1 5 5 1 2 3 1 0 1 1 1 0 1 1 0 1 1 0 1 0 1 1 1 0 1 0 0 0 1 0 0 0 1 1 1 4 4 1 6 0 6 0 2 3 2 7 0 3 7 1 4 7 2 6 4 3 6 3 4 3 1 3 5 3 20 10 1 11 0 4 0 6 7 7 7 0 10 8 7 4 7 1 5 4 4 6 3 5 8 5 7 9 7 Yes=1 Yes=1 Yes=1 drink and drive GPA Average amount of money Drinking ticket Do you drink? 1 1.9 35 0 1 0 3.1 10 0 1 1 2.5 15 1 1 1 0.9 10 0 1 0 3.1 12 0 1 0 1.3 60 0 1 1 4 20 1 1 1 3.5 20 0 1 1 2.7 30 0 1 0 3 10 1 1 1 3.3 20 1 1 1 3 15 0 1 0 2.3 20 1 1 0 3 30 0 1 1 3.7 70 0 1 0 2.3 10 0 1 0 2.5 20 0 1 1 1.9 0 1 1 1 2.98 30 0 1 0 3 100 1 1 0 3 10 1 1 0 3.5 10 0 1 0 3 5 1 1 0 3.8 5 0 1 0 3.1 5 0 1 0 3 5 1 1 0 3.3 10 1 1 0 3.6 10 0 1 0 3.1 5 0 1 0 3.2 15 0 1 0 4 0 0 0 1 2.2 37 1 1 1 2 20 0 1 1 2 20 1 1 0 3.1 30 0 1 0 2.7 20 1 1 0 3.6 15 0 1 1 2.3 35 0 1 0 2.7 0 0 0 1 2 20 1 1 0 1 45 1 1 0 3.2 10 1 1 0 3 0 0 0 0 3.7 0 0 0 0 2.7 10 0 1 0 2.9 0 0 0 0 3.2 10 0 1 1 2 17 1 1 1 2.5 20 1 1 0 3 20 0 1 0 2 17 1 1 1 1 0 1 0 1 0 0 0 1 1 0 1 1 0 1 1 0 0 1 0 1 1 1 1 0 0 1 1 2.75 3.5 1.8 2 4 3 3.2 3.73 3 3.71 1.75 2.4 1.5 3.7 4 2.8 0 2.6 3.9 2.8 3.9 1 4 1.7 3 3.25 2.1 1.25 2.25 70 35 0 40 0 15 0 45 35 25 20 0 45 80 20 22 75 60 50 19 28 50 90 80 25 10 7 50 15 1 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 1 0 0 1 0 0 1 1 0 1 1 1 1 0 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Hypothesis 1: Alpha n= df t Stat P(T<=t) one-tail t Critical one-tail Conclusion H0: Mean days a week and Greek =4 H1: Mean days a week and Greek not =4 0.05 45 44 6.95 0 1.68 Reject Null Hypothesis there is significant evidence showing that Mean does not =4 one sample proportion Hypothesis 2: H0: drunk drivers =.34 H1: drunk drivers not =.34 Alpha 0.05 Chi Square Hypothesis 3: Alpha H0: Is a relationship between GPA and Number of drinks a night H1: There is NOT a relationship between GPA and number of drinks a night 0.05 one sample mean Hypothesis 4: Alpha H0: Mean =5 H1: Mean not= 5 0.05 Anova Hypothesis 5: Alpha F value P value F critical n DF Conclusion: H0: Mean number drinking students GPA's and Class Standing are related H1: Mean number drinking students GPA's and Class Standing are NOT related 0.05 0.16 0.85 3.89 72 71 Do not reject Nul Hypothesis there is evidence showing the relationship between GPA's and Class Sta two sample proportion Hypothesis 6: H0: males = Females H1: Males Not= Females Alpha 0.05 t-Test: Two-Sample Assuming Equal Variances Female Male Variable 1 Variable 2 Mean 3.11 3.68 Variance 4.79 5.01 Observations 36 44 Pooled Variance 4.91 Hypothesized Mean Difference 0 df 78 t Stat -1.15 P(T<=t) one-tail 0.13 t Critical one-tail 1.66 P(T<=t) two-tail 0.26 t Critical two-tail 1.99 conclusion: Reject Null Hypothesis There is evidence that males drink more in proportion days a week at the .05 level Mean does not =4 e NOT related nship between GPA's and Class Standing days a week at the .05 level Average of GPA Male or Female 0 Year in School 1 2 3 4 5 1 2 3 4 5 Total 2.83 3.09 2.97 2.6 3.16 2.9 2.45 1.89 2.98 3.1 2.93 2.65 2.76 Females 0 Total 1 Males 1 Total Grand Total Anova: Single Factor SUMMARY Groups Count Year in School Average GPA Females Average GPA Males ANOVA Source of Variation Between Groups Within Groups Total Sum 5 5 5 15 14.65 13.34 Average Variance 3 2.5 2.93 0.05 2.67 0.25 SS 0.3 11.21 11.51 df 2 12 14 MS 0.15 0.93 F 0.16 P-value 0.85 Year in School Year In School Average GPA Females Average GPA Males 2.83 2.45 3.09 1.89 SUMMARY OUTPUT 2.97 2.98 2.6 3.1 Regression Statistics 3.16 2.93 Multiple R R Square 1 Adjusted R Square 2 Standard Error 3 Observations 4 5 ANOVA 1 2 3 4 5 df Regression Residual Total Intercept Total 0.14 0.02 -0.31 1.81 5 1 3 4 Coefficients 0.19 0.96 F value P value F critical 3.5 0.16 0.85 3.89 Male average GPA and Year in School F crit 3.89 Average GPA 3 2.5 2 1.5 1 0.5 0 1 2 3 Year In School 4 5 SS 0.18 9.82 10 MS 0.18 3.27 F Significance F 0.06 0.83 Standard Error t Stat P-value Lower 95%Upper 95% Lower 95.0%pper 95.0% U 11.91 0.02 0.99 -37.72 38.09 -37.72 38.09 4.06 0.24 0.83 -11.95 13.87 -11.95 13.87 ...
View Full Document

This note was uploaded on 04/08/2008 for the course BUS 2801 taught by Professor Wilson during the Spring '07 term at E. Illinois.

Ask a homework question - tutors are online