Question

The average age of an adult's first vacation without a parent or guardian was reported to be 23 years old. A travel agent believes that the average age is different from reported. They sample 28 adults and they asked their age in years when they first vacationed as an adult without a parent or guardian, data shown below.

30

23

22

24

25

22

24

28

27

21

25

27

28

25

22

26

20

25

22

23

24

18

26

21

23

28

24

22

H₀: μ = 23Test the claim using a 10% level of significance.

The hypotheses for this problem are:

H₁: μ ≠ 23

Find the test statistic. Round answer to 4 decimal places. test statistic

t = ____________

Please help with solving problem in excel and formula.

Answer 1

Sample Mean = = 24.11

Sample Standard deviation = S = 2.77

n = 28

Hypothesis:

Ho: = 23

Ha: 23

Test statistic:

Degree of freedom = n-1 = 28-1 = 27

Critical value:

                 ...................Using t table

Using Excel Function: tinv(0.10,27)

Conclusion:

Test statistic > Critical value, i.e. 2.12 > 1.7033, That is Reject Ho at 10% level of significance.

Therefore, Reject the claim that, The average age of an adult's first vacation without a parent or guardian was reported to be 23 years old.