The time married men with children spend on child care averages 5.8 hours per week (Time, March 12, 2012). You belong to a professional group on family practices that would like to do its own study to determine if the time married men in your area spend on child care per week differs from the reported mean of 5.8 hours per week. A sample of 40 married couples will be used with the data collected showing the hours per week the husband spends on child care. The sample data is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet a. What are the hypotheses if your group would like to determine if the population mean number of hours married men are spending in child care differs from the mean reported by Time in your area? Howe-9 5.8 Ha :pi-w 5.8 b. What is the sample mean and the p-value? What is the sample mean (to 1 decimal)? |:| hours Calculate the value of the test statistic (to 2 decimals). D What is the p-value (to 4 decimals)? Do not round intermediate calculations. |:| c. Select your own level of significance. What is your conclusion? Do not reject v M the null. We _ enough evidence to disprove the reported time. B C D E G Hours Spent in Child Care Formulas 5.4 Sample Size 40 1.7 7.1 Sample Mean (1 decimal) 6.5 =AVERAGE(A2:A41) 2.2 11.0 Sample Standard Deviation (4 decimals) #N/A 4.8 7.8 Hypothesized Mean 5.8 7.6 10 3.6 Test Statistic (2 decimals) -11.01 =(G2-5.8)/(STDEV.S(A1:A41)/SQRT(41)) 6.8 8.6 Degrees of Freedom #N/A 7.8 14 6.3 p-value (4 decimals) #NUM! =T.DIST.2T(D10,39) 15 8.1 16 9.1 17 5.9 18 1.5 19 0.8 20 11.1 21 1.9 22 3.2 23 9.9 24 7.6 25 3.5 26 9.6 27 8.1 28 9.5 29 10.9 30 7.4 31 5.6 32 1.8 33 0.8 34 8.7 35 3.9 36 3.7 37 11.6 38 11.0 39 9.5 40 2.1 41 11.7 42 43 44