A social study is developed in order to review the amount of time (hours) students spent on playing online game in a week. Students from public school and private school are selected randomly to join the survey. Following is the obtained data
: Public school student 10.8 8.5 8.8 11.2 10.0 9.5
Private school student 11.2 12.5 10.5 11.3 12.5 12.8
Assume the weekly hours spent on playing online game are normally distributed and the variances are the same. Refer to the below Excel summary report generated at 5% significance level, prepare a report in p-value approach to conclude if the amount of time students spent on playing online game in a week for the two types of schools are different. (The report must include
(i) null hypothesis and alternative hypothesis,
(ii) calculated test statistics,
(iii) p-value and
(iv) conclusion with reason.) t-Test: Two-Sample Assuming Equal Variances
Public school student Private school student
Mean 9.8 11.8
Variance 1.156 0.856
Observations 6 6
Pooled Variance 1.006
Hypothesized Mean
Difference 0 df
10 t Stat -3.4538
P(T<=t)one-tail>
t Critical one-tail 1.8125
P(T<=t)two-tail>
t Critical two-tail 2.2281