A local college newsletter reported that the average American college student spends one hour (60 minutes) on a social media website daily. But you wonder if there is a difference between males and females. Attached below is a sample of 60 users of the website (30 males and 30 females) and their recorded daily time spent on the website, Complete (a) and (b) below. Click the icon to view the sample times a. Assuming that the variances in the population of times spent on the website per day are equal, is there evidence of a difference in the mean time spent on the website per day between males and females? (Use a 0.05 level of significance.) Let u, be the mean daily time spent on the website for male college students and u2 be the mean daily time spent on the website for female college students. Determine the hypotheses. Choose the correct answer below. A HO H1 = H2 Hy H1 - H2 - X Sample times O C. Ho H1 # 12 H1 P1= H2 Daily time spent (in minutes) on the website for 30 males Determine the test statistic 180 960 60 30 10 5 690 270 60 180 180 180 240 240 210 45 120 240 30 120 20 45 60 180 60 15 45 30 120 100 1STAT = (Round to two decimal places as needed) Daily time spent (in minutes) on the website for 30 females 60 75 30 60 15 120 120 120 150 10 100 60 60 90 150 60 60 60 270 90 30 30 45 180 90 15 150 10 180 45 Print DoneFile Edit View Insert Format Data Tools Extensions Help Q 5 2 5 7 100% - $ XLMiner Analysis ToolPak % X .0 .00 123 Defaul 10 + BI SA JSON A Sampling G23 fx t-Test: Paired Two Sample for Means A B C D E F G H I 1 Males Females Steps Description Males Females t-Test: Two-Sample Assuming Equal N 180 60 Step 4-1 Sample size 30 30 =count(B2:B31) Variances 960 75 Sample Mean 157.5 84.5 =average(B2:B31) 60 30 Sample Variance 40773.7069 3679.913793 =var.s(B2:B31) Variable 1 Range: A1:A31 30 60 Variable 2 Range: B1:B31 10 15 Step 4-2 Mean Difference 73 =F3-G3 5 120 Step 4-3 Pooled Variance 22226.81034 =((F2-1)*F4 + (G2-1)*G4M(F2+G2-2) Hypothesized Mean Difference: 8 690 120 Step 4-4 Pooled Sd 149.0865867 =sqrt(F7) 0 g 270 120 Step 4-5 Degree of freedom 58 =F2+G2-2 Labels 10 60 150 Step 4-6 test-statistic 1.896399874 =F6/(F8*sqrt(1/F2+1/G2)) 11 180 10 Step 4-7 Alpha: 0.05 p-value 0.06289151804 =t.dist.2t(F10,F9) 12 180 100 Output Range: D14 13 180 60 OK 14 240 60 t-Test: Two-Sample Assuming Equal Variances 15 240 90 16 210 150 Males Females t-Test: Two-Sample Assuming 17 45 60 Mean 157.5 84.5 Unequal Variances 18 120 60 Variance 40773.7069 3679.9137 z-Test: Two-Sample for Means 19 240 60 Observations 30 30 20 30 270 Pooled Variance 22226.81034 Help, Examples, Upgrades 21 120 90 Hypothesized M 22 20 30 df 58 23 45 30 t Stat 1.896399874 24 60 45 P(T