Qnt 351 Week 5 Learning Team Assignment

Sample One and Sample Six ComparisonDO NOT SUBMIT THIS WORK TO YOUR SCHOOL. USE IT TO WRITE YOUR OWN Data SetDO NOT SUBMIT THIS WORK TO YOUR SCHOOL. USE IT TO WRITE YOUR OWNSample OneSample Six{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}AgeGenderStudy HoursSleep HoursGrade251281002422810027237983024610028125973123910022157962512686262379628138913025390212569729107882512682212377819247962722897{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}AgeGenderStudy HoursSleep HoursGrade25126982422678312258832136834022492252469522153100402561002720778381268631237963224791211289022246972813108827226822813578301248434214704015510026246953423768211459520227852123881 Descriptive StatisticsSample One{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}AgeMean 28.76Standard Deviation6.35GenderGradeMale 40.0%90.2Female 60.0%86.4Study HoursMean 2.88Standard Deviation1.27Sleep HoursMean 6Standard Deviation1.5Final GradeMean 87.92Standard Deviation9.16 Descriptive StatisticsSample Six{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}AgeMean 25.76Standard Deviation3.51Gender GradeMale 41.2%91.4Female 58.8%95.2Study HoursMean 2.94Standard Deviation1.34Sleep HoursMean 6.76Standard Deviation1.39Final GradeMean 93.65Standard Deviation6.72 Inferential StatisticsCorrelationSample One{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}Correlation CoefficientAge-0.02Study Hours0.64Sleep Hours-0.12Sample Six{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}Correlation CoefficientAge0.19Study Hours0.21Sleep Hours0.29{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}Combined Sample Correlation CoefficientAge-0.07Study Hours0.47Sleep Hours0.09 Inferential StatisticsComparing the Mean grades between groups One and Six{5C22544A-7EE6-4342-B048-85BDC9FD1C3A}t-Test: Two-Sample Assuming Equal Variances GradeSample OneGrade Sample SixMean87.9293.64706Variance83.9933345.11765Observations2517Pooled Variance68.44306Hypothesized Mean Difference0df40t Stat-2.2021P(T<=t) one-tail0.016743t Critical one-tail1.683851P(T<=t) two-tail0.033486t Critical two-tail2.021075 Null HypothesisH0: µA = µBHA: µA ≠ µBlf p Value < significance level, we reject the null hypothesisIn this case:a =0.05P value 0.033 < 0.05T stat -2.2 > -2.02Therefore, we reject the null hypothesisThe observed difference between the sample means (87.92 – 93.64) is convincing enough to say that the average grades between sample One and sample Six differ significantly.DO NOT SUBMIT THIS WORK TO YOUR SCHOOL. USE IT TO WRITE YOUR OWN Inferential StatisticsComparing the Mean Hours Studies between groups One and SixNull