Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 33.5. 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 sareadsheet 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 a 0.05. What is your conclusion? Use the obtained rounded values in your calculations. years (to 2 decimals) years (to 4 decimals) Sample meant Sample standard deviation: t-value: (to 3 decimals) P-value (Upper Tail): (to 3 decimals) Because p-value >✔✔✔a-0.05, we fail to reject ✔ Ha. There is insufficient evidence to conclude that the mean age at which British men get married exceeds what it was in 2013.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.4: Distributions Of Data
Problem 23PFA
icon
Related questions
Question
100%
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
40
A
Age
36
32
26
37
37
29
37
31
32
37
26
29
27
31
27
34
31
35
29
31
33
35
37
37
31
33
27
27
27
34
28
31
32
27
30
30
26
39
25
39
31
33
27
35
32
28
40
B
C
Sample size
Sample mean
Sample Standard Deviation
Hypothesized Mean
Test Statistic
Degrees of Freedom
p-value (Lower Tail)
p-value (Upper Tail)
p-value (Two Tail)
Level of Significance (alpha)
Reject Null Hypothesis?
Data Range A:A
D
47
33.5
0.05
E
Formulas
F
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 40 A Age 36 32 26 37 37 29 37 31 32 37 26 29 27 31 27 34 31 35 29 31 33 35 37 37 31 33 27 27 27 34 28 31 32 27 30 30 26 39 25 39 31 33 27 35 32 28 40 B C Sample size Sample mean Sample Standard Deviation Hypothesized Mean Test Statistic Degrees of Freedom p-value (Lower Tail) p-value (Upper Tail) p-value (Two Tail) Level of Significance (alpha) Reject Null Hypothesis? Data Range A:A D 47 33.5 0.05 E Formulas F #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 33.5. 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 a = 0.05. What is your conclusion? Use the obtained rounded values in your calculations.
Sample mean:
Sample standard deviation:
t-value:
p-value (Upper Tail):
Because p-value > ✓
years (to 2 decimals)
years (to 4 decimals)
(to 3 decimals)
(to 3 decimals)
a = 0.05, we fail to reject ✔✔✔ Ho. There is insufficient ✔✔✔ evidence to conclude that the mean age at which British men get married exceeds what it was in 2013.
Transcribed Image Text:Data from the Office for National Statistics show that the mean age at which men in Great Britain get married was 33.5. 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 a = 0.05. What is your conclusion? Use the obtained rounded values in your calculations. Sample mean: Sample standard deviation: t-value: p-value (Upper Tail): Because p-value > ✓ years (to 2 decimals) years (to 4 decimals) (to 3 decimals) (to 3 decimals) a = 0.05, we fail to reject ✔✔✔ Ho. There is insufficient ✔✔✔ evidence to conclude that the mean age at which British men get married exceeds what it was in 2013.
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt