Question

Part A. In the past it has been found that the arrival time have a population mean value of μ = 13 and a population standard deviation of σ = 6.26. Using the given data, test whether this mean has changed. Use the critical value approach to test the hypothesis. The significance level alpha is set at 0.05 . The original data of time taken is given below. Show the process by using excel (Formulas).

Part B. Test the hypothesis of Part A with p value approach. Show the calculation steps by Excel.

7

21

23

24

18

16

2

19

11

6

3

13

17

9

5

12

13

17

4

14

15

25

12

24

22

14

14

20

15

11

26

17

21

11

4

13

16

14

13

14

25

23

9

15

14

12

19

11

18

9

12

13

17

6

19

17

13

23

16

17

11

15

11

23

8

16

10

26

19

16

23

15

20

30

21

21

14

1

13

14

21

3

26

18

6

17

18

15

10

14

9

17

10

16

13

9

14

6

19

4

8

4

7

8

2

21

6

14

20

7

18

11

Answer 1

First we need to find the sample mean. Using excel formula "=average()" the mean of the sample is