Question

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. 1.What is the sample mean and the -value? 2.What is the sample mean (to 1 decimal)?(hrs) 3.Calculate the value of the test statistic (to 2 decimals). 4.What is the -value (to 4 decimals)? Do not round intermediate calculations.

Excel Online templateSaved Comments А.ia Geterel Peste Fan Alg menc l ter Select 11只 Hours Spent in Child Care Formulas 5.0 1.6 3.7 7.7 09 5.5 10.3 4.T 7急 2.3 64 11.8 8.6 9.6 Sample SIze Sample ea(1 decimal) Sample Standard Devlation (4 declmal Hypothesized Mean Test Statistic (2 decimals) Degrees of Freedom p-value (4 decimals) 5.8 14 0.7 109 18 11.8 2.5 1.6 3.1 34 Data Help liproe Ohc :36 PM

Answer 1

Sample size = 40

Sample mean = 6.3

Sample standard deviation = 3.3364

Hypothesized mean = 5.8

Test statistic = 1.02

Degrees of freedom = 39

p- value = 0.3123