Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 33.0. A news reporter

image text in transcribedimage text in transcribed
Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 33.0. A news reporter noted that this represents a continuation of the trend of waiting until a later age to wed. A new sample of 47 recently wed British men provided their age at the time of marriage. These data are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. Open spreadsheet Do these data indicate that the mean age of British men at the time of marriage exceeds the mean age in 2013? Test this hypothesis at o: = 0.05. What is your conclusion? Use the obtained rounded values in your calculations. Sample mean: 33.37 9 years (to 2 decimals) Sample standard deviation: -0 years (to 4 decimals) t-value: 0.1589 0 (to 3 decimals) p-value (Upper Tail): 0.4372 0 (to 3 decimals) Because p-value -@ o: = 0.05, we @ H0. There is @ evidence to conclude that the mean age at which British men get married exceeds what it was in 2013. C D F D B E Age Formulas Sample size 47 Sample mean 33.87234 =AVERAGE(A2:A48) Sample Standard Deviation 4.316888 =STDEV.S(A2:A48) 39 Hypothesized Mean 33 30 39 Test Statistic 0.15887 = (33.11 - 33)/(4.7468/SQRT(47)) Degrees of Freedom #N/A p-value (Lower Tail) 0.4372 #N/A p-value (Upper Tail) #N/A p-value (Two Tail) #N/A 26 35 Level of Significance (alpha) 0.05 40 Reject Null Hypothesis? #N/A 31 30 37 Data Range A:A

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

Trigonometry

Authors: Ron Larson, Rosemarie Menager Beeley, Larson/Hostetler

8th Edition

1111789177, 9781111789176

More Books

Students also viewed these Mathematics questions

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago

Question

3. How much information do we need to collect?

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago