Question

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 . What is your conclusion? Use the obtained rounded values in your calculations. Sample mean: 33.11 years (to 2 decimals) Sample standard deviation: 4.7468 years (to 4 decimals) -value: 0.154 (to 3 decimals) -value: (to 3 decimals) Because -value , we . There is evidence to conclude that the mean age at which British men get married exceeds what it was in 2013. Excel giving me wrong p value.
Find me the P- Value
Data set
25
30
30
33
34
34
38
37
29
39
30
29
37
26
30
34
39
26
28
34
35
40
25
35
37
31
35
25
40
40
32
34
35
28
38
37
39
31
37
37
39
34
39
30
25
29
27

Answer 1

Answer:

The solution to these question can be defined as follows:

Step-by-step explanation:

$H_0: \mu = 33 \ versus\\\\ H_a: \mu > 33\\\\\bar{X} = 33.11\\\\S = 4.7468\\\\n = 47\\\\df = n - 1 = 46\\\\\alpha = 0.05$

Testing statistic:

$t = \frac{(\bar{X} - \mu)}{[\frac{S}{\sqrt{(n)}}]}$

$= \frac{(33.11 – 33)}{\frac{4.7468}{\sqrt{47}}}\\\\= \frac{0.11}{0.6924}\\\\= 0.1589\\\\P-value = 0.4372\\\\P-value > \alpha = 0.05$

Therefore the null hypothesis we do not deny, it is not clear enough so that the median age once British men get engaged is higher than in 2013.