Question: 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?

Using the information below and the attached inserts, can you kindly helpme compute the problems found in the main attached? Excel template -

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 time

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!