CENGAGE MINDTAP 9.3 Excel Activity 1 - Hypothesis Test for Mean, Known (Structured) Question 1 6/10 Submit Video Q Search this course ? Fowle Marketing Research, Inc., bases charges to a client on the assumption that telephone surveys can be completed in a mean time of 15 minutes or less. If a longer mean survey time is necessary, a premium rate is charged. Suppose a sample of 35 surveys produces the data in the Microsoft Excel Online file below. Use a known = 3.4 minutes. Is the premium rate justified? X Open spreadsheet a. Formulate the null and alternative hypotheses for this application. Ho: less than or equal to 15 < Ha greater than 15 b. Compute the value of the test statistic (to 2 decimals). c. What is the p-value (to 4 decimals)? d. Using = .01, is a premium rate justified for this client? Yes Check My Work Reset Problem Back Autosaved at 6:37 PM Next Co A-Z Office N A+ Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Arial 10 B ab General D4 fx A B 1234567820-23 Call Time (minutes) 20.3 13.7 16.2 18.1 13.9 17.3 14.6 17.4 18.5 11 9.8 15.1 13 16.6 14 17 15 14.5 16 20 17 11.3 18 16.3 19 20.5 20 21.7 21 16.4 22 12.2 23 18.5 24 25.9 25 14.5 26 21.6 27 15.6 28 15.9 29 14.7 30 17.6 31 18 32 16.7 33 11.6 34 16.8 35 13 36 13.2 37 38 39 D E F Formulas Hypothesis Test about a Population Mean: Sigma Known Case Sample Size Sample Mean Hypothesized Mean Value Population Standard Deviation Level of Significance Standard Error Critical Value Test Statistic (z) p-value (Lower Tail) p-value (Upper Tail) p-value (Two Tail) Reject Null Hypothesis? Sheet1 + Calculation Mode: Automatic Workbook Statistics Data range A:A 15 3.4 0.01 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A A 0 .00 .00 0 Editing Comments G H J K L M N Give Feedback to Microsoft - 100% + CENGAGE MINDTAP 9.4 Excel Activity 2a - Hypothesis Test for Mean, Unknown (Structured) Question 1 5.71/10 Submit Video Q Search this course ? The 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 file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet Co A-Z Office 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? N Ho:||=v Ha v 6 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 significance. What is your conclusion? Do not reject the null. We don't have Check My Work Reset Problem Back enough evidence to disprove the reported time. Autosaved at 6:39 PM Next A+ Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Arial 10 B ab Number D4 fx A B C D E Hours Spent in 1 Child Care 11 -234567822123456 9.7 Sample Size 6.0 1.1 10.3 10.4 8.7 7.7 Sample Mean (1 decimal) Sample Standard Deviation (4 decimals) Hypothesized Mean 2.4 10 11.4 Test Statistic (2 decimals) 2.7 8.0 Degrees of Freedom 5.8 1.1 p-value (4 decimals) 9.3 4.9 17 5.9 18 6.3 19 11.1 20 1.4 21 4.9 22 3.0 23 11.2 24 1.8 25 2.3 26 7.0 27 7.1 28 10.9 29 4.9 30 2.5 31 2.5 32 1.7 33 1.9 34 6.0 35 7.9 36 2.2 37 6.2 38 11.8 39 9.6 40 9.9 41 3 42 13 Data + Calculation Mode: Automatic Formulas 40 A 0 .00 .00 0 > F G H | J K L M N #N/A #N/A 6 #N/A #N/A #N/A Editing Comments O P R Workbook Statistics Give Feedback to Microsoft - 90% +