In: Statistics and Probability
The customers association thought that the mean number of days for a package to arrive in Australia is more than 13 days. Assume that the population standard deviation is unknown. Does the sample data obtained provide evidence that the mean arrival time for packages is more than 13 days at the 5% level of significance? Use the p value approach. Show the Calculation steps by Excel. What formulas in statistics are used? Data of arrival time is given below.
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 |