DMattsonChap10HW1.xlsx - Time Office 1.48 1 1.75 1 0.78 1...

This preview shows page 1 - 2 out of 14 pages.

TimeOffice The times to clear a problem call (in minutes) to two independ1.481Part IDetermine if there is a difference in the mean time to clear a pr1.751Show all steps to the hypothesis test 0.781Show calculations for the pooled variance AND the test statistic2.851You may use either the critical value approach OR the p-value a0.521State your conclusion clearly in terms of the problem1.6014.151Part IIGo back and test if the variances between the times to clear pro3.971Use the F.test function1.481State the hypothesis3.101State the p-value1.021What is your conclusion? Did you use the appropriate test in Pa0.531PART I 0.931Office 1Office 21.601Sample Mean2.21402.01150.801Sample Std Dev1.71801.89171.051Count20206.3213.931Data5.451H0: u2 - u1 = 0Hypothesized Difference0.971H1: u2 - u1 7.5523.7520.1021.102t-Test: Two-Sample Assuming Equal Variances0.6020.522Variable 1Variable 23.302Mean2.2142.01152.102Variance2.9516568421 3.57855026320.582Observations20204.022Sp^2Pooled Variance3.26510355263.752Hypothesized Mean Difference00.652df381.922t Stat0.35438599270.602P(T<=t) one-tail0.36250436711.532t Critical one-tail1.68595446024.232P(T<=t) two-tail0.72500873420.082t Critical two-tail2.02439416391.4821.652

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture