The time married men with children spend on child care averages 6.2 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 6.2 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.

(PLEASE EXCEL ATTACHED)

?

http x Stud X Min X EXCE X Cen X Relc X Upl X C Acc X b Fow X *Ask X + X O about:blank G R ? . . . X Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do Comments X Cut Arial 10 A" A" ab Wrap Text Number Autosum - 8 0 Paste [ Copy BIUDabA BEE Merge & Center $ ~ % 9 08 Conditional Format Cell Insert Delete Format Clear Sort & Find & Format Painter Formatting . as Table . Styles v Filter . Select ~ Undo Clipboard Font Alignment Number Tables Cells Editing D4 B C D E F G H K L M N O P Q R S Hours Spent in W N - Child Care Formulas 5.5 Sample Size 40 11.1 6.3 Sample Mean (1 decimal) #N/A 6.7 10.3 Sample Standard Deviation (4 decimals) #N/A 9.2 7.5 Hypothesized Mean 62 5.2 10 5.6 Test Statistic (2 decimals) #N/A 11 10.1 10.2 Degrees of Freedom #N/A 3.8 2.0 p-value (4 decimals) #N/A 10.9 2.6 3.6 0.7 7.0 8.2 1.6 6.8 23 8.9 3.4 5.2 78 Data + Calculation Mode: Automatic Workbook Statistics Help Improve Office - 100% + Type here to search O EI W X o O O 6:15 AM 65 10/3/2020 23http x Stuc X Min X EXCE X Cen X Relc X *Upl X C Acc X b Fow X Ask X + X O about:blank G R ? . . . X Excel template - Saved Comments File Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Arial 10 A" A ab Wrap Text Number Autosum ~ 9 0 [ Copy BE E Merge & Center Cell Clear Sort & Find & BIUDabA $ ~ % 9 08 Conditional Format Insert Delete Format Paste Format Painter Formatting . as Table . Styles v Filter . Select Alignment Number Tables Cells Editing Undo Clipboard Font D4 D E F G H J K L M N O P Q R S A B C 25 5.2 26 7.8 27 0.8 28 6.8 29 7.8 30 9.7 31 7.0 32 7.9 33 9 .1 34 5.6 8.8 6.7 37 10.3 38 8.2 39 8.4 40 5.9 41 85 42 43 44 45 46 47 48 49 50 51 9 Data + Help Improve Office - 100% + Calculation Mode: Automatic Workbook Statistics Type here to search O EI W X O O 6:16 AM 65 10/3/2020 23