Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the information below and the attached inserts, can you kindly help me compute the problems found in the main attached? Excel template - Saved
Using the information below and the attached inserts, can you kindly help me compute the problems found in the main attached?
Excel template - Saved v Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Arial 10 B Av ... Ev ab Numb D4 X V f A B C D E F G H Hours Sper Child Care Formulas 3.2 Sample Size 40 9.7 3.0 Sample Mean (1 decimal) #N/A 11.1 8.0 Sample Standard Deviation (4 decimals) #N/A 7.6 8.6 Hypothesized Mean 6 11.1 11.0 Test Statistic (2 decimals) #N/A 6.8 3.2 Degrees of Freedom IN/A 4.1 10.2 p-value (4 decimals) #N/A 5.9 6.6 7.5 4.0 7.9 2.3 11.4 9.0 6.0 7.8 1.6 5.5 5.6 7.7 7.2 2.2 3.9 0.6 0.9 5.5 2.6 0.6 1.4 1.6 9.0 6.0 11.7The time married men with children spend on child care averages 6.0 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.0 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 le 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? Ho:p,:]6 Ha:u:]6 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). What is the p-value (to 4 decimals)? Do not round intermediate calculations. c. Select your own level of signicance. What is your conclusion? v the null. We enough evidence to disprove the reported timeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started