Who know about statistics

profiletrillone79
i5sampleztestmegastat.xlsx

Sheet1

THREE RIVERS BANK Z-TEST
ATM 1 ATM 2 Descriptive statistics
100 115
130 120 ATM 1 ATM 2
125 131 count 30 30
88 114 mean 123.93 126.57
96 88 sample standard deviation 20.50 19.45
112 96 sample variance 420.20 378.32
150 132 minimum 88.0 88.0
147 143 maximum 155.0 152.0
111 121 range 67.0 64.0
142 135
96 95 standard error of the mean 3.74 3.55
155 130
137 145 confidence interval 95.% lower 116.60 119.61
144 152 confidence interval 95.% upper 131.27 133.53
98 100 margin of error 7.34 6.96
101 136 z 1.96 1.96
120 127
150 152 skewness -0.09 -0.58
151 140 kurtosis -1.33 -0.78
100 99 coefficient of variation (CV) 16.54% 15.37%
115 143
128 132 normal curve GOF
120 152 p-value .1328 .3080
116 113 chi-square(df=3) 5.600 3.600
122 125 E 5.000 5.000
139 140 O(-0.97) 8 6
130 148 O(-0.43) 3 3
100 92 O(+0.00) 4 3
145 135 O(+0.43) 4 5
150 146 O(+0.97) 3 8
O(inf.) 8 5
Hypothesis Test: Independent Groups (z-test)
ATM 1 ATM 2
123.93 126.57 mean
20.50 19.45 std. dev.
30 30 n
-2.633 difference (ATM 1 - ATM 2)
5.159 standard error of difference
0 hypothesized difference
-0.51 z
.6098 p-value (two-tailed) RETAIN. There is no significant difference. P=.60 which is larger than .01.
The bright yellow indicates Reject at the .01 level.
Dull yellow indicates Reject at the .05 alpha level / Retain at the .01 alpha level.
Black & white indicates Retain. There is no difference.

Runs Plot

100 130 125 88 96 112 150 147 111 142 96 155 137 144 98 101 120 150 151 100 115 128 120 116 122 139 130 100 145 150

Transactions

ATM 1

Runs Plot

115 120 131 114 88 96 132 143 121 135 95 130 145 152 100 136 127 152 140 99 143 132 152 113 125 140 148 92 135 146

Transactions

ATM 2