QNT561One-SampleHypothesisTestingElectionResultsSpeedX2.xlsx

SpeedX Output

Descriptive statistics
Payment
count 220
mean 21.63
sample standard deviation 5.84
sample variance 34.05
minimum 9.0
maximum 39.0
range 30.0
population variance 33.90
population standard deviation 5.82
standard error of the mean 0.39
confidence interval 90.% lower 20.98
confidence interval 90.% upper 22.28
margin of error 0.65
z 1.645
skewness 0.32
kurtosis -0.23
coefficient of variation (CV) 26.98%
Hypothesis Test: Mean vs. Hypothesized Value
21.632 hypothesized value
21.632 mean Payment
5.835 std. dev.
0.393 std. error
220 n
-0.00 z
1.0000 p-value (two-tailed)
20.985 confidence interval 90.% lower
22.279 confidence interval 90.% upper
0.647 margin of error
2.0
Normal distribution
P(lower) P(upper) z X mean std.dev
.0003 .9997 -3.43 1.645 21.632 5.835

3

2

1

0

-1

-2

-3

f(z)

z

-3.43

SpeedX

Payment z-score Mean 21.6318181818
27 0.9220433152 Standard Deviation 5.8220494957
24 0.4067608528 z test 0.5000018479
14 -1.3108473549 p-value 0.4999981521
39 2.9831731645
13 -1.4826081757
31 1.6090865983
26 0.7502824944
33 1.9526082399
13 -1.4826081757
23 0.2350000321
17 -0.7955648926
24 0.4067608528
18 -0.6238040718
34 2.1243690606
13 -1.4826081757
23 0.2350000321
16 -0.9673257134
32 1.7808474191
30 1.4373257775
29 1.2655649567
21 -0.1085216095
19 -0.4520432511
22 0.0632392113
14 -1.3108473549
27 0.9220433152
20 -0.2802824303
11 -1.8261298173
20 -0.2802824303
30 1.4373257775
24 0.4067608528
18 -0.6238040718
21 -0.1085216095
24 0.4067608528
18 -0.6238040718
27 0.9220433152
27 0.9220433152
27 0.9220433152
21 -0.1085216095
22 0.0632392113
23 0.2350000321
18 -0.6238040718
17 -0.7955648926
23 0.2350000321
26 0.7502824944
20 -0.2802824303
20 -0.2802824303
22 0.0632392113
21 -0.1085216095
13 -1.4826081757
36 2.4678907022
18 -0.6238040718
25 0.5785216736
26 0.7502824944
19 -0.4520432511
16 -0.9673257134
28 1.093804136
16 -0.9673257134
20 -0.2802824303
16 -0.9673257134
14 -1.3108473549
25 0.5785216736
14 -1.3108473549
35 2.2961298814
17 -0.7955648926
16 -0.9673257134
19 -0.4520432511
19 -0.4520432511
17 -0.7955648926
18 -0.6238040718
22 0.0632392113
23 0.2350000321
22 0.0632392113
27 0.9220433152
23 0.2350000321
23 0.2350000321
21 -0.1085216095
20 -0.2802824303
18 -0.6238040718
29 1.2655649567
32 1.7808474191
27 0.9220433152
15 -1.1390865342
21 -0.1085216095
26 0.7502824944
32 1.7808474191
20 -0.2802824303
29 1.2655649567
25 0.5785216736
15 -1.1390865342
21 -0.1085216095
30 1.4373257775
24 0.4067608528
23 0.2350000321
14 -1.3108473549
18 -0.6238040718
22 0.0632392113
37 2.639651523
24 0.4067608528
35 2.2961298814
29 1.2655649567
24 0.4067608528
17 -0.7955648926
27 0.9220433152
15 -1.1390865342
19 -0.4520432511
12 -1.6543689965
19 -0.4520432511
21 -0.1085216095
19 -0.4520432511
21 -0.1085216095
15 -1.1390865342
17 -0.7955648926
20 -0.2802824303
21 -0.1085216095
31 1.6090865983
19 -0.4520432511
27 0.9220433152
19 -0.4520432511
26 0.7502824944
26 0.7502824944
26 0.7502824944
23 0.2350000321
12 -1.6543689965
20 -0.2802824303
34 2.1243690606
21 -0.1085216095
24 0.4067608528
20 -0.2802824303
21 -0.1085216095
16 -0.9673257134
23 0.2350000321
13 -1.4826081757
19 -0.4520432511
18 -0.6238040718
31 1.6090865983
29 1.2655649567
23 0.2350000321
28 1.093804136
19 -0.4520432511
19 -0.4520432511
22 0.0632392113
24 0.4067608528
21 -0.1085216095
23 0.2350000321
14 -1.3108473549
25 0.5785216736
17 -0.7955648926
22 0.0632392113
21 -0.1085216095
18 -0.6238040718
22 0.0632392113
15 -1.1390865342
27 0.9220433152
14 -1.3108473549
23 0.2350000321
25 0.5785216736
24 0.4067608528
24 0.4067608528
17 -0.7955648926
16 -0.9673257134
30 1.4373257775
24 0.4067608528
17 -0.7955648926
27 0.9220433152
24 0.4067608528
17 -0.7955648926
10 -1.9978906381
25 0.5785216736
15 -1.1390865342
13 -1.4826081757
29 1.2655649567
21 -0.1085216095
22 0.0632392113
11 -1.8261298173
25 0.5785216736
30 1.4373257775
23 0.2350000321
18 -0.6238040718
19 -0.4520432511
18 -0.6238040718
14 -1.3108473549
21 -0.1085216095
22 0.0632392113
17 -0.7955648926
19 -0.4520432511
23 0.2350000321
31 1.6090865983
26 0.7502824944
25 0.5785216736
15 -1.1390865342
16 -0.9673257134
28 1.093804136
27 0.9220433152
22 0.0632392113
12 -1.6543689965
25 0.5785216736
12 -1.6543689965
21 -0.1085216095
19 -0.4520432511
26 0.7502824944
16 -0.9673257134
21 -0.1085216095
30 1.4373257775
16 -0.9673257134
25 0.5785216736
13 -1.4826081757
11 -1.8261298173
13 -1.4826081757
22 0.0632392113
28 1.093804136
14 -1.3108473549
21 -0.1085216095
30 1.4373257775
19 -0.4520432511
14 -1.3108473549
31 1.6090865983
9 -2.1696514588
14 -1.3108473549
21 -0.1085216095
28 1.093804136

Election

0.4

0.3

0.2

0.1

0.0

Dashed line is the test statistic and shaded are is the critical region

D

e

n

s

i

t

y

1.282

0.1

0

1.772

Critical Region and the test statistic

1

2

3

4

5

6

7

8

9

A

B

C

D

E

0

.

4

0

.

3

0

.

2

0

.

1

0

.

0

D

a

s

h

e

d

l

i

n

e

i

s

t

h

e

t

e

s

t

s

t

a

t

i

s

t

i

c

a

n

d

s

h

a

d

e

d

a

r

e

i

s

t

h

e

c

r

i

t

i

c

a

l

r

e

g

i

o

n

D

e

n

s

i

t

y

1

.

2

8

2

0

.

1

0

1

.

7

7

2

C

r

i

t

i

c

a

l

R

e

g

i

o

n

a

n

d

t

h

e

t

e

s

t

s

t

a

t

i

s

t

i

c