Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Negative Binomial Regression

Authors: Joseph M Hilbe

2nd Edition

1139005960, 9781139005968

More Books

Students also viewed these Mathematics questions

Question

Is your university a pure service? Explain.

Answered: 1 week ago

Question

Evaluate promotional campaigns.

Answered: 1 week ago

Question

Discuss the differences between compiled and interpreted languages.

Answered: 1 week ago

Question

3. Avoid making mistakes when reaching our goals

Answered: 1 week ago