CSUSM Smoking and GPA Analysis Business Statistics 304Slide 2Mission StatementCal State San Marcos Smoking SurveyExcel Spreadsheet Set-upRelated InformationBackground Information/FactorsMean, Variance, Frequency and ModeMean for AgeMean, Variance & Standard Deviation for GPAMean Standard Deviation and FrequencySlide 12Slide 13Slide 14Slide 15Slide 16Slide 17Slide 18Slide 19Slide 20Slide 21Slide 22Slide 23Slide 24Slide 25Slide 26Slide 27Conditional ProbabilityMutually Exclusive EventsSlide 30Graphical RepresentationSlide 32Slide 33Slide 34Slide 35Slide 36Slide 37Gender Vs. GPA (Male)Gender Vs. GPA (Female)Smoking Vs. GPA (Male)Smoking Vs. GPA (Female)Binomial FormulaSampling ErrorMargin of ErrorHypothesis test non-smokersHypothesis test smokersSlide 47Slide 48Correlation RegressionConclusionSuggestionCSUSM Smoking and GPA AnalysisBusiness Statistics 304•Walter Evans•Farzana Mohsini•Sheryl Lejano•Ryan ThomasThree Reasons•Students smoke for pleasure.•Students’ smoking habits may be tied to a person’s family history.•Smoking may depend of student age and knowledge .Mission Statement•Smoking has a negative, positive or neutral impact on the success of students.•Our analysis will assist us in planning and implementing smoking intervention programs for Cal State San Marcos.• Programs may be helpful in preventing the habit of tobacco use in school. • Help us take action in making an effort to inform the council and promote a lesser degree of smoking on campus. •Our group would like to determine whether or not smoking on campus is decreasing or increasing and why that is so.• To properly evaluate the extensiveness of a student smoker’s habits and the level of success a student has accomplished.Cal State San Marcos Smoking Survey•Gender: Male Female ••Class: Freshman Sophomore Junior Senior ••Age: 17-20 21-24 25-28 29-32 33-36 37-40 >40 •What is your major? _____________•What is your G.P.A.? <= 2.0 2.01~2.4 2.41~2.80 2.81~3.20 3.21~3.60 >3.6 ••Do you have a family history of smoking? YES NO •When I see a person smoking, it…• makes him/her more attractive. • makes him/her less attractive • has no impact on their attractiveness.•Would you date a person who is smoker? YES NO ••Do you smoke tobacco?•YES NO ••If YES, how many times do you smoke a day?•1-3 times 4-6 times 7-9 times >10 times ••How long have you been smoking? < 1 year 1-3 years 3-10 years >10 years ••Thank you for your help on this research project! It is greatly appreciated!Excel Spreadsheet Set-up# Gender Class Age Major G.P.A. History Attractiveness Date? Smoke Per Day YearsRelated Information•Causes for Smoking.•Time of day (cigarettes/day)•Duration of smoking•Family History of smoking•Student smoking percentage•number of student smokers•Given the nature and the student lifestyle, we expect 17% of our surveyed sample to be smokers. •Proceed in our research by surveying 105 students on campus to operate as a sample for the standard population of the school.Background Information/Factors•Health risks (first and second hand)•Cancer susceptibility •based on time spent on campus in direct connection with smoking•Comparing and contrasting smoker comfort versus non-smoker discomfort•Non-smokers hidden annoyances toward smoking•Smoker’s Nonsmokers awareness of nonsmokers smokers•Determining possible reasons for smoking (stress, habit, social conformity?)Mean, Variance, Frequency and ModeMean for Age•Used midpoints•Total, Non-Smoking, & SmokingMean Total StudentsAge # of Students18.5 2022.5 5726.5 1430.5 734.5 038.5 1>40 5Mean 23.80288462Mean Non-SmokingAge # of Students18.5 1522.5 5226.5 1130.5 634.5 038.5 0>40 5Mean 23.84269663Mean SmokingAge # of Students18.5 522.5 526.5 330.5 134.5 038.5 1>40 0Mean 23.56666667Mean, Variance & Standard Deviation for GPA•Used Midpoints•Total, Non-Smoking, & SmokingMean GPA Total< 2.0 02.205 32.605 213.005 253.405 44> 3.6 11Mean3.133317308VarianceStd DevMean GPA Smoking< 2.0 02.205 12.605 53.005 43.405 5> 3.6 0Mean2.951666667VarianceStd DevMean GPA Non-Smoking< 2.0 02.205 22.605 163.005 213.405 39> 3.6 11Mean3.163932584VarianceStd DevMean Standard Deviation and FrequencyMean = 23.80288462Standard Deviation= 5.026830087Mean Standard Deviation and FrequencyMean = 23.84269663Standard Deviation= 4.966704771Mean Standard Deviation and FrequencyMean = 23.56666667Standard Deviation= 5.548058433Mean Standard Deviation and FrequencyMean= 3.133317308Standard Deviation= 0.37522654Mean Standard Deviation and FrequencyMean= 3.163932584Standard Deviation= 0.365036947Mean Standard Deviation and FrequencyMean= 2.951666667Standard Deviation= 0.396172161Mean Standard Deviation and FrequencyMean= 4.769230769Standard Deviation= 3.491748515Mean Standard Deviation and FrequencyMean= 3.4Standard Deviation= 3.10617959Mean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyMean Standard Deviation and FrequencyConditional ProbabilityConditional Probability Rules:15 Smokers 90 Nonsmokers11 Smoker Male4 Smoker FemaleTotal Population: 43 Female 62 MalesContinuous VariablesProbability Rule 4: Addition Rule for Any Two Events, E1 and E2 P(E1 or E2)=P(E1)+P(E2)-P(E1 and E2).Mutually Exclusive EventsProbability Rule 5: Addition Rule for Mutually Exclusive EventsTwo Mutually Exclusive Events E1 and E2 ↑ E1 and E2E1 E2Conditional ProbabilityTable 1. Smoker NonsmokerMale 11 51 Total 105Female 4 39Table 2. GPA>3.0 GPA<3.0Smoking Male 7 4 Total 15 SmokersSmoking Female 2 2Graphical Representation GPA>3.0 GPA<3.0Smoking Male 7 4Total 15 SmokersSmoking Female 2 2Graphical Representation GPA>3.0 GPA<3.0Smoking Male 7 4Total 15 SmokersSmoking Female 2 2Conditional ProbabilityTable 3. GPA>3.0 GPA<3.0 Total 90 NonsmokersNonsmoking Male 38 13 51 MalesNonsmoking Female 30 9 39 FemalesConditional ProbabilityTable 5. Age > 20 Age ≤20 Total 105Male 51 11 62 MalesFemale 33 10 43 Females Table 6. Age > 20 Age ≤20 Total 15Male Smokers 8 3 11 Males SmokersFemale Smokers 2 2 4 Females SmokersConditional ProbabilityEvent 1= Male P(E1)=62/105 0.590476 Event 2=