Statistical Functions In AFC
The supported statistical functions are shown by example below:
| A | B | C | D | E | F | G | H | I |
2 | 5.0 | =RANK(C2,D2:H2) | -1.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | |
3 | 4.0 | ... | 0.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | |
4 | 2.0 | ... | 2.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | |
5 | 1.0 | ... | 4.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | |
4 | 2.0 | ... | 2.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | |
7 | 5.0 | =RANK(C7,D7:H7,I7) | -1.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 0.0 | 7.0 |
8 | 1.0 | ... | -1.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 1.0 | 7.0 |
9 | 2.0 | ... | 0.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 1.0 | 7.0 |
10 | 3.0 | ... | 2.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 1.0 | 7.0 |
11 | 5.0 | ... | 4.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 1.0 | 7.0 |
10 | 3.0 | ... | 2.0 | 2.0 | 0.0 | -1.0 | 2.0 | 4.0 | 1.0 | 7.0 |
13 | 1.0 | =RANK(C13,D13) | 6.0 | 6.0 | |
| A | B | C | D | E | F | G | H | I |
15 | 0.0 | =VARP(C15) | 1.0 | |
16 | 0.0 | ... | 4.0 | |
15 | 0.0 | ... | 1.0 | |
18 | 0.25 | =VARP(C18,D18) | 1.0 | 2.0 | |
19 | 0.25 | ... | 4.0 | 5.0 | |
18 | 0.25 | ... | 1.0 | 2.0 | |
21 | 4.64 | =VARP(C21:E21,G21,I21) | 1.0 | 2.0 | 3.0 | 100.0 | 5.0 | 200.0 | 7.0 | 7.0 |
22 | 2.0 | ... | 6.0 | 7.0 | 8.0 | 80.0 | 9.0 | | 10.0 | 7.0 |
21 | 4.64 | ... | 1.0 | 2.0 | 3.0 | 100.0 | 5.0 | 200.0 | 7.0 | 7.0 |
| A | B | C | D | E | F | G | H | I |
24 | 0.5 | =VAR(C24,D24) | 1.0 | 2.0 | |
25 | 0.5 | ... | 4.0 | 5.0 | |
24 | 0.5 | ... | 1.0 | 2.0 | |
27 | 5.8 | =VAR(C27:E27,G27,I27) | 1.0 | 2.0 | 3.0 | 100.0 | 5.0 | 200.0 | 7.0 | 7.0 |
28 | 2.5 | ... | 6.0 | 7.0 | 8.0 | 80.0 | 9.0 | | 10.0 | 7.0 |
27 | 5.8 | ... | 1.0 | 2.0 | 3.0 | 100.0 | 5.0 | 200.0 | 7.0 | 7.0 |
| A | B | C | D | E | F | G | H | I |
57 | 0.9352195295828235 | =SKEW(C57,D57,E57) | 1.0 | 2.0 | 4.0 | |
59 | -2.532706643504132 | =SKEW(C59:E59,F59:H59,I59) | -1.0 | 0.0 | 5.45 | 7.62 | 12.7 | 14.5 | -100.0 | 7.0 |
60 | -1.8491263727532468 | ... | -10.0 | 0.0 | 1.0 | 0.0 | -1.0 | -2.0 | 3.0 | 7.0 |
59 | -2.532706643504132 | ... | -1.0 | 0.0 | 5.45 | 7.62 | 12.7 | 14.5 | -100.0 | 7.0 |
| A | B | C | D | E | F | G | H | I |
62 | 0.3905325443786989 | =KURT(C62,D62,E62,F62) | 1.0 | 2.0 | 4.0 | -1.0 | |
64 | 6.5478454980828005 | =KURT(C64:E64,F64:H64,I64) | -1.0 | 0.0 | 5.45 | 7.62 | 12.7 | 14.5 | -100.0 | 7.0 |
65 | 4.2380757608131585 | ... | -10.0 | 0.0 | 1.0 | 0.0 | -1.0 | -2.0 | 3.0 | 7.0 |
64 | 6.5478454980828005 | ... | -1.0 | 0.0 | 5.45 | 7.62 | 12.7 | 14.5 | -100.0 | 7.0 |
| A | B | C | D | E | F |
67 | 7.933282355487847E-7 | =NORMDIST(C67,D67,E67,F67) | -10.0 | 2.0 | 2.5 | true | |
68 | 3.1671241836783715E-5 | ... | -8.0 | 2.0 | 2.5 | true | |
69 | 6.871379379158604E-4 | ... | -6.0 | 2.0 | 2.5 | true | |
70 | 0.008197535924596044 | ... | -4.0 | 2.0 | 2.5 | true | |
71 | 0.054799291699557995 | ... | -2.0 | 2.0 | 2.5 | true | |
72 | 0.21185539858339675 | ... | 0.0 | 2.0 | 2.5 | true | |
73 | 0.5 | ... | 2.0 | 2.0 | 2.5 | true | |
74 | 0.7881446014166033 | ... | 4.0 | 2.0 | 2.5 | true | |
75 | 0.945200708300442 | ... | 6.0 | 2.0 | 2.5 | true | |
76 | 0.991802464075404 | ... | 8.0 | 2.0 | 2.5 | true | |
77 | 0.9993128620620841 | ... | 10.0 | 2.0 | 2.5 | true | |
78 | 0.9999683287581632 | ... | 12.0 | 2.0 | 2.5 | true | |
79 | 0.9999992066717645 | ... | 14.0 | 2.0 | 2.5 | true | |
80 | 0.3445782583896758 | ... | -3.5 | -2.5 | 2.5 | true | |
81 | 0.36944134018176367 | ... | -3.5 | -2.5 | 3.0 | true | |
82 | 1.58451963641283E-6 | ... | -10.0 | 2.0 | 2.5 | false | |
83 | 5.3532090305954136E-5 | ... | -8.0 | 2.0 | 2.5 | false | |
84 | 9.53635280585937E-4 | ... | -6.0 | 2.0 | 2.5 | false | |
85 | 0.008957812117937159 | ... | -4.0 | 2.0 | 2.5 | false | |
86 | 0.04436833387178222 | ... | -2.0 | 2.0 | 2.5 | false | |
87 | 0.11587662110459308 | ... | 0.0 | 2.0 | 2.5 | false | |
88 | 0.15957691216057307 | ... | 2.0 | 2.0 | 2.5 | false | |
89 | 0.11587662110459308 | ... | 4.0 | 2.0 | 2.5 | false | |
90 | 0.04436833387178222 | ... | 6.0 | 2.0 | 2.5 | false | |
91 | 0.008957812117937159 | ... | 8.0 | 2.0 | 2.5 | false | |
92 | 9.53635280585937E-4 | ... | 10.0 | 2.0 | 2.5 | false | |
93 | 5.3532090305954136E-5 | ... | 12.0 | 2.0 | 2.5 | false | |
94 | 1.58451963641283E-6 | ... | 14.0 | 2.0 | 2.5 | false | |
95 | 0.1473080561213293 | ... | -3.5 | -2.5 | 2.5 | false | |
96 | 0.12579440923099772 | ... | -3.5 | -2.5 | 3.0 | false | |
97 | !FE | ... | -3.5 | -2.5 | 0.0 | true | | Excel says: #NUM! |
98 | !FE | ... | -3.5 | -2.5 | -1.0 | true | | Excel says: #NUM! |
99 | !FE | ... | -3.5 | -2.5 | 0.0 | false | | Excel says: #NUM! |
100 | !FE | ... | -3.5 | -2.5 | -1.0 | false | | Excel says: #NUM! |
99 | !FE | ... | -3.5 | -2.5 | 0.0 | false | | Excel says: #NUM! |
| A | B | C |
102 | 1.279812543885827E-12 | =NORMSDIST(C102) | -7.0 | |
103 | 9.865876450375138E-10 | ... | -6.0 | |
104 | 2.866515718770135E-7 | ... | -5.0 | |
105 | 3.1671241836783715E-5 | ... | -4.0 | |
106 | 0.0013498980316301035 | ... | -3.0 | |
107 | 0.02275013194817932 | ... | -2.0 | |
108 | 0.15865525393145707 | ... | -1.0 | |
109 | 0.18406012534675953 | ... | -0.9 | |
110 | 0.21185539858339675 | ... | -0.8 | |
111 | 0.24196365222307303 | ... | -0.7 | |
112 | 0.27425311775007366 | ... | -0.6 | |
113 | 0.3085375387259869 | ... | -0.5 | |
114 | 0.3445782583896758 | ... | -0.4 | |
115 | 0.38208857781104744 | ... | -0.3 | |
116 | 0.420740290560897 | ... | -0.2 | |
117 | 0.460172162722971 | ... | -0.1 | |
118 | 0.5 | ... | 0.0 | |
119 | 0.539827837277029 | ... | 0.1 | |
120 | 0.579259709439103 | ... | 0.2 | |
121 | 0.6179114221889526 | ... | 0.3 | |
122 | 0.6554217416103242 | ... | 0.4 | |
123 | 0.6914624612740131 | ... | 0.5 | |
124 | 0.7257468822499263 | ... | 0.6 | |
125 | 0.758036347776927 | ... | 0.7 | |
126 | 0.7881446014166033 | ... | 0.8 | |
127 | 0.8159398746532405 | ... | 0.9 | |
128 | 0.8413447460685429 | ... | 1.0 | |
129 | 0.9772498680518207 | ... | 2.0 | |
130 | 0.9986501019683699 | ... | 3.0 | |
131 | 0.9999683287581632 | ... | 4.0 | |
132 | 0.9999997133484281 | ... | 5.0 | |
133 | 0.9999999990134123 | ... | 6.0 | |
134 | 0.9999999999987201 | ... | 7.0 | |
133 | 0.9999999990134123 | ... | 6.0 | |
| A | B | C | D | E |
136 | 0.002862742576440258 | =LOGNORMDIST(C136,D136,E136) | 0.0010 | 0.0 | 2.5 | |
137 | 0.032732596490962385 | ... | 0.01 | 0.0 | 2.5 | |
138 | 0.17851632837994402 | ... | 0.1 | 0.0 | 2.5 | |
139 | 0.25986062021413336 | ... | 0.2 | 0.0 | 2.5 | |
140 | 0.3907906686191144 | ... | 0.5 | 0.0 | 2.5 | |
141 | 0.5 | ... | 1.0 | 0.0 | 2.5 | |
142 | 0.6092093313808856 | ... | 2.0 | 0.0 | 2.5 | |
143 | 0.7401393797858666 | ... | 5.0 | 0.0 | 2.5 | |
144 | 0.821483671620056 | ... | 10.0 | 0.0 | 2.5 | |
145 | 0.9672674035090376 | ... | 100.0 | 0.0 | 2.5 | |
146 | 0.9971372574235597 | ... | 1000.0 | 0.0 | 2.5 | |
147 | 0.32860257279352023 | ... | 0.2 | -0.5 | 2.5 | |
148 | 0.4026314416565423 | ... | 0.2 | -0.5 | 4.5 | |
149 | !FE | ... | 0.0 | -0.5 | 2.5 | | Excel says: #NUM! |
150 | !FE | ... | -1.0 | -0.5 | 2.5 | | Excel says: #NUM! |
151 | !FE | ... | 0.2 | -0.5 | 0.0 | | Excel says: #NUM! |
152 | !FE | ... | 0.2 | -0.5 | -1.0 | | Excel says: #NUM! |
151 | !FE | ... | 0.2 | -0.5 | 0.0 | | Excel says: #NUM! |
| A | B | C | D | E |
154 | 1.3755319528560164 | =CONFIDENCE(C154,D154,E154) | 1.0E-4 | 2.5 | 50.0 | |
155 | 0.6929519121748389 | ... | 0.05 | 2.5 | 50.0 | |
156 | 0.5815435768383369 | ... | 0.1 | 2.5 | 50.0 | |
157 | 0.508951232416014 | ... | 0.15 | 2.5 | 50.0 | |
158 | 0.4530969012184115 | ... | 0.2 | 2.5 | 50.0 | |
159 | 0.3664345389796085 | ... | 0.3 | 2.5 | 50.0 | |
160 | 0.23846813810223486 | ... | 0.5 | 2.5 | 50.0 | |
161 | 0.08957172731064579 | ... | 0.8 | 2.5 | 50.0 | |
162 | 0.044427995247128836 | ... | 0.9 | 2.5 | 50.0 | |
163 | 0.022170193955002714 | ... | 0.95 | 2.5 | 50.0 | |
164 | 4.431134638859067E-5 | ... | 0.9999 | 2.5 | 50.0 | |
165 | 0.8141610075736716 | ... | 0.1 | 3.5 | 50.0 | |
166 | 0.26007419393777875 | ... | 0.1 | 2.5 | 250.0 | |
167 | 0.26007419393777875 | ... | 0.1 | 2.5 | 250.9 | |
168 | !FE | ... | 0.0 | 2.5 | 50.0 | | Excel says: #NUM! |
169 | !FE | ... | -1.0 | 2.5 | 50.0 | | Excel says: #NUM! |
170 | !FE | ... | 1.0 | 2.5 | 50.0 | | Excel says: #NUM! |
171 | !FE | ... | 0.5 | 0.0 | 50.0 | | Excel says: #NUM! |
172 | !FE | ... | 0.5 | -1.0 | 50.0 | | Excel says: #NUM! |
173 | !FE | ... | 0.5 | 2.5 | 0.0 | | Excel says: #NUM! |
172 | !FE | ... | 0.5 | -1.0 | 50.0 | | Excel says: #NUM! |
| A | B | C | D | E |
175 | 81.20245878635673 | =NORMINV(C175,D175,E175) | 1.0E-4 | 90.5 | 2.5 | |
176 | 86.38786593262131 | ... | 0.05 | 90.5 | 2.5 | |
177 | 87.2961210861385 | ... | 0.1 | 90.5 | 2.5 | |
178 | 88.39594691606771 | ... | 0.2 | 90.5 | 2.5 | |
179 | 90.5 | ... | 0.5 | 90.5 | 2.5 | |
180 | 92.60405308393229 | ... | 0.8 | 90.5 | 2.5 | |
181 | 93.7038789138615 | ... | 0.9 | 90.5 | 2.5 | |
182 | 94.61213406737868 | ... | 0.95 | 90.5 | 2.5 | |
183 | 99.79754121364327 | ... | 0.9999 | 90.5 | 2.5 | |
184 | -89.1889987182299 | ... | 0.7 | -90.5 | 2.5 | |
185 | -87.8779974364598 | ... | 0.7 | -90.5 | 5.0 | |
186 | !FE | ... | 0.0 | 90.5 | 2.5 | | Excel says: #NUM! |
187 | !FE | ... | -1.0 | 90.5 | 2.5 | | Excel says: #NUM! |
188 | !FE | ... | 1.0 | 90.5 | 2.5 | | Excel says: #NUM! |
189 | !FE | ... | 0.7 | 90.5 | 0.0 | | Excel says: #NUM! |
190 | !FE | ... | 0.7 | 90.5 | -1.0 | | Excel says: #NUM! |
189 | !FE | ... | 0.7 | 90.5 | 0.0 | | Excel says: #NUM! |
| A | B | C |
192 | -3.719016485457308 | =NORMSINV(C192) | 1.0E-4 | |
193 | -3.0902323061677874 | ... | 0.0010 | |
194 | -2.3263478740408488 | ... | 0.01 | |
195 | -1.9599639845400545 | ... | 0.025 | |
196 | -1.6448536269514742 | ... | 0.05 | |
197 | -1.2815515655446004 | ... | 0.1 | |
198 | -1.0364333894937903 | ... | 0.15 | |
199 | -0.8416212335729143 | ... | 0.2 | |
200 | -0.6744897501960818 | ... | 0.25 | |
201 | -0.5244005127080409 | ... | 0.3 | |
202 | -0.3853204664075678 | ... | 0.35 | |
203 | -0.2533471031357999 | ... | 0.4 | |
204 | -0.12566134685507402 | ... | 0.45 | |
205 | -1.392137635291833E-16 | ... | 0.5 | |
206 | 0.12566134685507402 | ... | 0.55 | |
207 | 0.25334710313579967 | ... | 0.6 | |
208 | 0.38532046640756756 | ... | 0.65 | |
209 | 0.5244005127080404 | ... | 0.7 | |
210 | 0.6744897501960816 | ... | 0.75 | |
211 | 0.8416212335729143 | ... | 0.8 | |
212 | 1.0364333894937898 | ... | 0.85 | |
213 | 1.2815515655446004 | ... | 0.9 | |
214 | 1.6448536269514724 | ... | 0.95 | |
215 | 1.959963984540054 | ... | 0.975 | |
216 | 2.32634787404084 | ... | 0.99 | |
217 | 3.0902323061677848 | ... | 0.999 | |
218 | 3.719016485457308 | ... | 0.9999 | |
219 | !FE | ... | 0.0 | | Excel says: #NUM! |
220 | !FE | ... | -1.0 | | Excel says: #NUM! |
221 | !FE | ... | 1.0 | | Excel says: #NUM! |
220 | !FE | ... | -1.0 | | Excel says: #NUM! |
| A | B | C | D | E |
223 | 0.0019781746262642497 | =LOGINV(C223,D223,E223) | 0.0010 | 1.5 | 2.5 | |
224 | 0.07337778342006672 | ... | 0.05 | 1.5 | 2.5 | |
225 | 0.18197628294943885 | ... | 0.1 | 1.5 | 2.5 | |
226 | 0.5465917581845832 | ... | 0.2 | 1.5 | 2.5 | |
227 | 4.481689070338063 | ... | 0.5 | 1.5 | 2.5 | |
228 | 36.7468711747476 | ... | 0.8 | 1.5 | 2.5 | |
229 | 110.37447626495552 | ... | 0.9 | 1.5 | 2.5 | |
230 | 273.7277686381404 | ... | 0.95 | 1.5 | 2.5 | |
231 | 10153.571204741784 | ... | 0.999 | 1.5 | 2.5 | |
232 | 0.827787567727408 | ... | 0.7 | -1.5 | 2.5 | |
233 | 3.070997918113044 | ... | 0.7 | -1.5 | 5.0 | |
234 | !FE | ... | 0.0 | 1.5 | 2.5 | | Excel says: #NUM! |
235 | !FE | ... | -1.0 | 1.5 | 2.5 | | Excel says: #NUM! |
236 | !FE | ... | 1.0 | 1.5 | 2.5 | | Excel says: #NUM! |
237 | !FE | ... | 0.7 | 1.5 | 0.0 | | Excel says: #NUM! |
238 | !FE | ... | 0.7 | 1.5 | -1.0 | | Excel says: #NUM! |
237 | !FE | ... | 0.7 | 1.5 | 0.0 | | Excel says: #NUM! |
| A | B | C | D | E | F | G |
240 | 0.2522154925789305 | =BETADIST(C240,D240,E240) | 0.6 | 1.5 | 0.5 | |
241 | 0.0 | ... | 0.0 | 1.5 | 0.5 | |
242 | 1.0 | ... | 1.0 | 1.5 | 0.5 | |
243 | !FE | ... | -0.0010 | 1.5 | 0.5 | | Excel says: #NUM! |
244 | !FE | ... | 1.001 | 1.5 | 0.5 | | Excel says: #NUM! |
245 | !FE | ... | 0.6 | 0.0 | 0.5 | | Excel says: #NUM! |
246 | !FE | ... | 0.6 | 1.5 | 0.0 | | Excel says: #NUM! |
245 | !FE | ... | 0.6 | 0.0 | 0.5 | | Excel says: #NUM! |
248 | 0.026900917354660405 | =BETADIST(C248,D248,E248,F248) | -0.1 | 1.5 | 0.5 | -0.3 | |
250 | 0.034896984506197104 | =BETADIST(C250,D250,E250,F250,G250) | -0.1 | 1.5 | 0.5 | -0.3 | 0.8 | |
251 | 0.0 | ... | -0.3 | 1.5 | 0.5 | -0.3 | 0.8 | |
252 | 1.0 | ... | 0.8 | 1.5 | 0.5 | -0.3 | 0.8 | |
253 | !FE | ... | 0.2 | 1.5 | 0.5 | 0.3 | 0.8 | | Excel says: #NUM! |
254 | !FE | ... | 0.9 | 1.5 | 0.5 | 0.3 | 0.8 | | Excel says: #NUM! |
255 | !FE | ... | 0.9 | 1.5 | 0.5 | 0.9 | 0.9 | | Excel says: #NUM! |
254 | !FE | ... | 0.9 | 1.5 | 0.5 | 0.3 | 0.8 | | Excel says: #NUM! |
| A | B | C | D | E | F |
257 | 1.0 | =BINOMDIST(C257,D257,E257,F257) | 2.0 | 3.0 | 0.0 | true | |
258 | 0.5120000000000001 | ... | 0.0 | 3.0 | 0.2 | true | |
259 | 0.8960000000000001 | ... | 1.0 | 3.0 | 0.2 | true | |
260 | 0.9920000000000002 | ... | 2.0 | 3.0 | 0.2 | true | |
261 | 1.0 | ... | 3.0 | 3.0 | 0.2 | true | |
262 | 0.64 | ... | 0.0 | 2.0 | 0.2 | true | |
263 | 0.36 | ... | 1.0 | 2.0 | 0.8 | true | |
264 | 1.0 | ... | 2.0 | 2.0 | 0.8 | true | |
265 | 0.0 | ... | 1.0 | 2.0 | 1.0 | true | |
266 | 1.0 | ... | 2.0 | 2.0 | 1.0 | true | |
267 | 0.5120000000000001 | ... | 0.9 | 3.9 | 0.2 | true | |
268 | 0.0 | ... | 2.0 | 3.0 | 0.0 | false | |
269 | 0.5120000000000001 | ... | 0.0 | 3.0 | 0.2 | false | |
270 | 0.38400000000000006 | ... | 1.0 | 3.0 | 0.2 | false | |
271 | 0.09600000000000003 | ... | 2.0 | 3.0 | 0.2 | false | |
272 | 0.008000000000000004 | ... | 3.0 | 3.0 | 0.2 | false | |
273 | 0.64 | ... | 0.0 | 2.0 | 0.2 | false | |
274 | 0.32 | ... | 1.0 | 2.0 | 0.8 | false | |
275 | 0.64 | ... | 2.0 | 2.0 | 0.8 | false | |
276 | 0.0 | ... | 1.0 | 2.0 | 1.0 | false | |
277 | 1.0 | ... | 2.0 | 2.0 | 1.0 | false | |
278 | 0.09600000000000003 | ... | 2.9 | 3.9 | 0.2 | false | |
279 | !FE | ... | -1.0 | 3.0 | 0.2 | true | | Excel says: #NUM! |
280 | !FE | ... | 4.0 | 3.0 | 0.2 | true | | Excel says: #NUM! |
281 | !FE | ... | 1.0 | 3.0 | -0.0010 | true | | Excel says: #NUM! |
282 | !FE | ... | 1.0 | 3.0 | 1.001 | true | | Excel says: #NUM! |
283 | !FE | ... | 1.0E9 | 1.0E10 | 0.5 | false | | Excel says: #NUM! |
282 | !FE | ... | 1.0 | 3.0 | 1.001 | true | | Excel says: #NUM! |
| A | B | C | D | E |
285 | 0.8 | =NEGBINOMDIST(C285,D285,E285) | 0.0 | 1.0 | 0.8 | |
286 | 0.16 | ... | 1.0 | 1.0 | 0.8 | |
287 | 0.031999999999999994 | ... | 2.0 | 1.0 | 0.8 | |
288 | 0.006399999999999998 | ... | 3.0 | 1.0 | 0.8 | |
289 | 0.64 | ... | 0.0 | 2.0 | 0.8 | |
290 | 0.256 | ... | 1.0 | 2.0 | 0.8 | |
291 | 0.07679999999999998 | ... | 2.0 | 2.0 | 0.8 | |
292 | 0.02047999999999999 | ... | 3.0 | 2.0 | 0.8 | |
293 | 0.5120000000000001 | ... | 0.0 | 3.0 | 0.8 | |
294 | 0.30720000000000003 | ... | 1.0 | 3.0 | 0.8 | |
295 | 0.12287999999999999 | ... | 2.0 | 3.0 | 0.8 | |
296 | 0.04095999999999999 | ... | 3.0 | 3.0 | 0.8 | |
297 | 0.04 | ... | 0.0 | 2.0 | 0.2 | |
298 | 0.06400000000000002 | ... | 1.0 | 2.0 | 0.2 | |
299 | 0.07680000000000001 | ... | 2.0 | 2.0 | 0.2 | |
300 | 0.08192000000000003 | ... | 3.0 | 2.0 | 0.2 | |
301 | 0.08192000000000003 | ... | 3.9 | 2.9 | 0.2 | |
302 | !FE | ... | 3.0 | 2.0 | 0.0 | | Excel says: #NUM! |
303 | !FE | ... | 3.0 | 2.0 | -0.1 | | Excel says: #NUM! |
304 | !FE | ... | 3.0 | 2.0 | 1.0 | | Excel says: #NUM! |
305 | !FE | ... | 3.0 | 2.0 | 1.1 | | Excel says: #NUM! |
306 | !FE | ... | -1.0 | 2.0 | 0.8 | | Excel says: #NUM! |
307 | !FE | ... | 3.0 | 0.0 | 0.8 | | Excel says: #NUM! |
306 | !FE | ... | -1.0 | 2.0 | 0.8 | | Excel says: #NUM! |
| A | B | C | D |
309 | 1.0 | =CHIDIST(C309,D309) | 0.0 | 1.0 | |
310 | 0.7518296342946255 | ... | 0.1 | 1.0 | |
311 | 0.4795001239653619 | ... | 0.5 | 1.0 | |
312 | 0.001565402337851315 | ... | 10.0 | 1.0 | |
313 | 1.0 | ... | 0.0 | 2.0 | |
314 | 0.9512294245194709 | ... | 0.1 | 2.0 | |
315 | 0.7788007833653048 | ... | 0.5 | 2.0 | |
316 | 0.6065306631317098 | ... | 1.0 | 2.0 | |
317 | 0.006737946999366549 | ... | 10.0 | 2.0 | |
318 | 1.0 | ... | 0.0 | 3.0 | |
319 | 0.9918374237331349 | ... | 0.1 | 3.0 | |
320 | 0.918891411700565 | ... | 0.5 | 3.0 | |
321 | 0.8012519576642457 | ... | 1.0 | 3.0 | |
322 | 0.01856613527707762 | ... | 10.0 | 3.0 | |
323 | 1.0 | ... | 0.0 | 5.0 | |
324 | 0.9998376833880724 | ... | 0.1 | 5.0 | |
325 | 0.9921232932829606 | ... | 0.5 | 5.0 | |
326 | 0.9625657732801898 | ... | 1.0 | 5.0 | |
327 | 0.07523524671081362 | ... | 10.0 | 5.0 | |
328 | 1.0 | ... | 0.0 | 10.0 | |
329 | 0.9999999975020487 | ... | 0.1 | 10.0 | |
330 | 0.9999933882894426 | ... | 0.5 | 10.0 | |
331 | 0.9998278843703372 | ... | 1.0 | 10.0 | |
332 | 0.44049328513798774 | ... | 10.0 | 10.0 | |
333 | 0.029252688081794043 | ... | 20.0 | 10.0 | |
334 | 8.566412109168291E-4 | ... | 30.0 | 10.0 | |
335 | 8.566412109168291E-4 | ... | 30.0 | 10.9 | |
336 | !FE | ... | -0.1 | 3.0 | | Excel says: #NUM! |
337 | !FE | ... | 0.5 | 0.0 | | Excel says: #NUM! |
338 | !FE | ... | 0.5 | -1.0 | | Excel says: #NUM! |
337 | !FE | ... | 0.5 | 0.0 | | Excel says: #NUM! |
| A | B | C | D | E |
340 | 1.0 | =FDIST(C340,D340,E340) | 0.0 | 1.0 | 1.0 | |
341 | 1.0 | ... | 0.0 | 1.0 | 2.0 | |
342 | 1.0 | ... | 0.0 | 2.0 | 1.0 | |
343 | 0.8050177709913279 | ... | 0.1 | 1.0 | 1.0 | |
344 | 0.7817821097832189 | ... | 0.1 | 1.0 | 2.0 | |
345 | 0.9128709291846353 | ... | 0.1 | 2.0 | 1.0 | |
346 | 0.06345103485022717 | ... | 100.0 | 1.0 | 1.0 | |
347 | 0.009852457022458162 | ... | 100.0 | 1.0 | 2.0 | |
348 | 0.07053456157965012 | ... | 100.0 | 2.0 | 1.0 | |
349 | 0.009900990098986774 | ... | 100.0 | 2.0 | 2.0 | |
350 | 0.02944408936627338 | ... | 5.5 | 1.0 | 20.0 | |
351 | 0.3256302980355189 | ... | 5.5 | 20.0 | 1.0 | |
352 | 1.783131322808374E-4 | ... | 5.5 | 20.0 | 20.0 | |
353 | 0.00423459019531231 | ... | 5.5 | 20.9 | 10.9 | |
354 | !FE | ... | -1.0 | 2.0 | 2.0 | | Excel says: #NUM! |
355 | !FE | ... | 1.0 | 0.0 | 1.0 | | Excel says: #NUM! |
356 | !FE | ... | 1.0 | 1.0 | 0.0 | | Excel says: #NUM! |
355 | !FE | ... | 1.0 | 0.0 | 1.0 | | Excel says: #NUM! |
| A | B | C | D | E | F |
358 | 0.0 | =GAMMADIST(C358,D358,E358,F358) | 0.0 | 1.5 | 0.5 | true | |
359 | 0.5063653754347426 | ... | 0.6 | 1.5 | 0.5 | true | |
360 | 0.6009248024834053 | ... | 1.6 | 0.5 | 4.5 | true | |
361 | 0.9263617169138677 | ... | 1.6 | 0.5 | 1.0 | true | |
362 | 0.0 | ... | 0.0 | 1.5 | 0.5 | false | |
363 | 0.7445987447547989 | ... | 0.6 | 1.5 | 0.5 | false | |
364 | 0.14734757732691886 | ... | 1.6 | 0.5 | 4.5 | false | |
365 | 0.09005211167454186 | ... | 1.6 | 0.5 | 1.0 | false | |
366 | !FE | ... | -0.1 | 0.5 | 0.5 | true | | Excel says: #NUM! |
367 | !FE | ... | 1.6 | 0.0 | 0.5 | true | | Excel says: #NUM! |
368 | !FE | ... | 1.6 | -1.0 | 0.5 | false | | Excel says: #NUM! |
369 | !FE | ... | 1.6 | 0.5 | 0.0 | true | | Excel says: #NUM! |
370 | !FE | ... | 1.6 | 0.5 | -1.0 | false | | Excel says: #NUM! |
369 | !FE | ... | 1.6 | 0.5 | 0.0 | true | | Excel says: #NUM! |
| A | B | C | D | E |
372 | 1.0 | =POISSON(C372,D372,E372) | 0.0 | 0.0 | true | |
373 | 1.0 | ... | 1.0 | 0.0 | true | |
374 | 1.0 | ... | 2.0 | 0.0 | true | |
375 | 1.0 | ... | 3.0 | 0.0 | true | |
376 | 0.3678794411714491 | ... | 0.0 | 1.0 | true | |
377 | 0.7357588823428982 | ... | 1.0 | 1.0 | true | |
378 | 0.9196986029286228 | ... | 2.0 | 1.0 | true | |
379 | 0.9810118431238645 | ... | 3.0 | 1.0 | true | |
380 | 0.13533528323661353 | ... | 0.0 | 2.0 | true | |
381 | 0.4060058497098406 | ... | 1.0 | 2.0 | true | |
382 | 0.6766764161830676 | ... | 2.0 | 2.0 | true | |
383 | 0.8571234604985524 | ... | 3.0 | 2.0 | true | |
384 | 0.02732372244729319 | ... | 0.0 | 3.6 | true | |
385 | 0.1256891232575487 | ... | 1.0 | 3.6 | true | |
386 | 0.30274684471600855 | ... | 2.0 | 3.6 | true | |
387 | 0.5152161104661604 | ... | 3.0 | 3.6 | true | |
388 | 0.5152161104661604 | ... | 3.9 | 3.6 | true | |
389 | 1.0 | ... | 0.0 | 0.0 | false | |
390 | 0.0 | ... | 1.0 | 0.0 | false | |
391 | 0.0 | ... | 2.0 | 0.0 | false | |
392 | 0.0 | ... | 3.0 | 0.0 | false | |
393 | 0.3678794411714491 | ... | 0.0 | 1.0 | false | |
394 | 0.3678794411714491 | ... | 1.0 | 1.0 | false | |
395 | 0.18393972058572455 | ... | 2.0 | 1.0 | false | |
396 | 0.061313240195241515 | ... | 3.0 | 1.0 | false | |
397 | 0.13533528323661353 | ... | 0.0 | 2.0 | false | |
398 | 0.27067056647322707 | ... | 1.0 | 2.0 | false | |
399 | 0.27067056647322707 | ... | 2.0 | 2.0 | false | |
400 | 0.1804470443154847 | ... | 3.0 | 2.0 | false | |
401 | 0.02732372244729319 | ... | 0.0 | 3.6 | false | |
402 | 0.0983654008102555 | ... | 1.0 | 3.6 | false | |
403 | 0.17705772145845985 | ... | 2.0 | 3.6 | false | |
404 | 0.21246926575015185 | ... | 3.0 | 3.6 | false | |
405 | 0.21246926575015185 | ... | 3.9 | 3.6 | false | |
406 | !FE | ... | -1.0 | 2.0 | true | | Excel says: #NUM! |
407 | !FE | ... | -1.0 | 2.0 | false | | Excel says: #NUM! |
408 | !FE | ... | 2.0 | -1.0 | true | | Excel says: #NUM! |
409 | !FE | ... | 2.0 | -1.0 | false | | Excel says: #NUM! |
408 | !FE | ... | 2.0 | -1.0 | true | | Excel says: #NUM! |
| A | B | C | D | E |
412 | 0.5 | =TDIST(C412,D412,E412) | 0.0 | 1.0 | 1.0 | |
413 | 1.0 | ... | 0.0 | 1.0 | 2.0 | |
414 | 0.5 | ... | 0.0 | 10.0 | 1.0 | |
415 | 0.4682744825748864 | ... | 0.1 | 1.0 | 1.0 | |
416 | 0.9365489651497728 | ... | 0.1 | 1.0 | 2.0 | |
417 | 0.4647327192101754 | ... | 0.1 | 2.0 | 1.0 | |
418 | 0.4602722655504662 | ... | 0.1 | 100.0 | 1.0 | |
419 | 0.0031829927643624726 | ... | 100.0 | 1.0 | 1.0 | |
420 | 4.9992501245380026E-5 | ... | 100.0 | 2.0 | 1.0 | |
421 | 0.057249147038858604 | ... | 5.5 | 1.0 | 1.0 | |
422 | 0.015752001519251217 | ... | 5.5 | 2.0 | 1.0 | |
423 | 1.4617107210140738E-7 | ... | 5.5 | 100.0 | 1.0 | |
424 | 1.4617107210140738E-7 | ... | 5.5 | 100.9 | 1.0 | |
425 | 1.4617107210140738E-7 | ... | 5.5 | 100.0 | 1.9 | |
426 | 2.9234214420281476E-7 | ... | 5.5 | 100.0 | 2.9 | |
427 | !FE | ... | -1.0 | 2.0 | 1.0 | | Excel says: #NUM! |
428 | !FE | ... | 1.0 | 0.0 | 1.0 | | Excel says: #NUM! |
429 | !FE | ... | 1.0 | 2.0 | 0.0 | | Excel says: #NUM! |
430 | !FE | ... | 1.0 | 2.0 | 3.0 | | Excel says: #NUM! |
429 | !FE | ... | 1.0 | 2.0 | 0.0 | | Excel says: #NUM! |
| A | B | C | D | E | F | G |
432 | 0.8977973461151123 | =BETAINV(C432,D432,E432) | 0.6 | 1.5 | 0.5 | |
433 | !FE | ... | 0.6 | 0.0 | 0.5 | | Excel says: #NUM! |
434 | !FE | ... | 0.6 | 1.5 | 0.0 | | Excel says: #NUM! |
435 | 0.3600888252258301 | ... | 0.45 | 2.2 | 3.3 | |
434 | !FE | ... | 0.6 | 1.5 | 0.0 | | Excel says: #NUM! |
437 | 0.3600888252258301 | =BETAINV(C437,D437,E437,F437,G437) | 0.45 | 2.2 | 3.3 | 0.0 | 1.0 | |
438 | !FE | ... | 0.45 | 2.2 | 3.3 | 3.0 | 1.0 | | Excel says: #NUM! |
439 | 0.7488986730575562 | ... | 0.6 | 1.5 | 0.5 | 0.3 | 0.8 | |
440 | 0.3600888252258301 | ... | 0.45 | 2.2 | 3.3 | 0.0 | 1.0 | |
441 | !FE | ... | 1.1 | 2.2 | 3.3 | 0.0 | 1.0 | | Excel says: #NUM! |
442 | !FE | ... | -0.1 | 2.2 | 3.3 | 0.0 | 1.0 | | Excel says: #NUM! |
441 | !FE | ... | 1.1 | 2.2 | 3.3 | 0.0 | 1.0 | | Excel says: #NUM! |
444 | 0.9284581422805787 | =BETAINV(C444,D444,E444,F444) | 0.6 | 1.5 | 0.5 | 0.3 | |
| A | B | C | D |
446 | 3.2188758249516325 | =CHIINV(C446,D446) | 0.2 | 2.4 | |
447 | 0.41389331157281367 | ... | 0.52 | 1.0 | |
448 | 2.8051184564879357 | ... | 0.73 | 5.0 | |
449 | 2.8051184564879357 | ... | 0.73 | 5.42 | |
450 | 5.749409689274468 | ... | 0.9999 | 23.0 | |
451 | 32.006899668662996 | ... | 0.1 | 23.0 | |
452 | 35.99736227382731 | ... | 0.33 | 33.0 | |
453 | 78.7495242510023 | ... | 0.0010 | 44.0 | |
454 | 2.407945608735304 | ... | 0.3 | 2.4 | |
455 | 13.815510558047702 | ... | 0.0010 | 2.0 | |
456 | !FE | ... | 0.0 | 1.0 | | Excel says: #NUM! |
457 | !FE | ... | 1.001 | 1.0 | | Excel says: #NUM! |
458 | !FE | ... | 0.2 | 0.99 | | Excel says: #NUM! |
459 | !FE | ... | 0.2 | 1.0E11 (#0.00) | | Excel says: #NUM! |
458 | !FE | ... | 0.2 | 0.99 | | Excel says: #NUM! |
| A | B | C | D | E |
461 | 0.666666666823178 | =FINV(C461,D461,E461) | 0.5 | 1.9 | 2.4 | |
462 | 0.0 | ... | 1.0 | 4.0 | 2.4 | |
463 | 1.0E9 | ... | 0.0 | 1.0 | 2.0 | |
464 | 8.45128505321545 | ... | 0.01 | 3.6 | 7.9 | |
465 | 0.6232351341573585 | ... | 0.7 | 5.0 | 3.0 | |
466 | 18.772269815522307 | ... | 0.0010 | 3.6 | 7.9 | |
467 | !FE | ... | -0.01 | 1.9 | 2.4 | | Excel says: #NUM! |
468 | !FE | ... | 1.1 | 1.9 | 2.4 | | Excel says: #NUM! |
469 | !FE | ... | 0.4 | 0.7 | 2.4 | | Excel says: #NUM! |
470 | !FE | ... | 0.5 | 1.0E11 (#0.00) | 2.4 | | Excel says: #NUM! |
471 | !FE | ... | 0.5 | 1.9 | 1.0E11 (#0.00) | | Excel says: #NUM! |
470 | !FE | ... | 0.5 | 1.0E11 (#0.00) | 2.4 | | Excel says: #NUM! |
| A | B | C |
473 | 0.6043677771171635 | =FISHERINV(C473) | 0.7 | |
474 | 0.0 | ... | 0.0 | |
475 | 0.76117386166057 | ... | 0.999 | |
476 | 0.009999666679999443 | ... | 0.01 | |
477 | 0.46211715726000974 | ... | 0.5 | |
478 | -0.46211715726000974 | ... | -0.5 | |
479 | 0.22982054821431688 | ... | 0.234 | |
480 | 0.9999092042625951 | ... | 5.0 | |
481 | 0.9999999994421064 | ... | 11.0 | |
482 | -0.9999999994421064 | ... | -11.0 | |
481 | 0.9999999994421064 | ... | 11.0 | |
| A | B | C | D | E |
484 | 4.951915547315796 | =GAMMAINV(C484,D484,E484) | 0.065 | 9.0 | 1.0 | |
485 | 1.5141277326714913 | ... | 0.78 | 1.0 | 1.0 | |
486 | 0.0 | ... | 0.0 | 3.0 | 2.0 | |
487 | 18.417894393294752 | ... | 0.7 | 8.0 | 2.0 | |
488 | 3.0154804227868324 | ... | 0.35 | 1.0 | 7.0 | |
489 | 80.86540232879742 | ... | 0.98 | 9.0 | 5.0 | |
490 | 134.7931377139853 | ... | 0.99 | 23.2 | 3.76 | |
491 | !FE | ... | -0.01 | 9.0 | 1.0 | | Excel says: #NUM! |
492 | !FE | ... | 1.01 | 9.0 | 1.0 | | Excel says: #NUM! |
493 | !FE | ... | 0.77 | 9.0 | -1.0 | | Excel says: #NUM! |
494 | !FE | ... | 0.35 | -0.01 | 100.0 | | Excel says: #NUM! |
495 | !FE | ... | 0.35 | 0.0 | 100.0 | | Excel says: #NUM! |
494 | !FE | ... | 0.35 | -0.01 | 100.0 | | Excel says: #NUM! |
| A | B | C | D |
497 | 1.8797510544618512 | =TINV(C497,D497) | 0.065 | 60.0 | |
498 | 8.431427402612772E-8 | ... | 1.0 | 123.0 | |
499 | 1.0 | ... | 0.5 | 1.0 | |
500 | 0.8164965810235691 | ... | 0.5 | 2.0 | |
501 | 0.5095254497089412 | ... | 0.7 | 1.0 | |
502 | 2.946712882834883 | ... | 0.01 | 15.0 | |
503 | !FE | ... | 1.1 | 60.0 | | Excel says: #NUM! |
504 | !FE | ... | 0.065 | -1.0 | | Excel says: #NUM! |
505 | !FE | ... | 0.065 | 0.5 | | Excel says: #NUM! |
506 | !FE | ... | -0.01 | 2.0 | | Excel says: #NUM! |
507 | !FE | ... | 1.01 | 3.0 | | Excel says: #NUM! |
506 | !FE | ... | -0.01 | 2.0 | | Excel says: #NUM! |
| A | B | C | D | E | F |
509 | 1.0 | =HYPGEOMDIST(C509,D509,E509,F509) | 3.0 | 5.0 | 3.0 | 5.0 | |
510 | 1.0 | ... | 5.0 | 5.0 | 5.0 | 5.0 | |
511 | 1.0 | ... | 2.0 | 2.0 | 4.0 | 4.0 | |
512 | 0.1 | ... | 3.0 | 3.0 | 3.0 | 5.0 | |
513 | 0.02054543894736772 | ... | 1420.0 | 5000.0 | 2000.0 | 7000.0 | |
514 | 0.399122807017544 | ... | 12.5 | 15.8 | 17.0 | 20.0 | |
515 | 4.008407827379104E-219 | ... | 200.0 | 200.0 | 200.0 | 1027.0 | |
516 | 0.031158540466480204 | ... | 150.0 | 500.0 | 200.0 | 700.0 | |
517 | 0.46233230134158926 | ... | 1.0 | 4.0 | 4.0 | 20.0 | |
518 | 0.46052631578947373 | ... | 1.0 | 5.0 | 3.0 | 20.0 | |
519 | 0.13157894736842107 | ... | 2.0 | 5.0 | 3.0 | 20.0 | |
520 | 0.008771929824561405 | ... | 3.0 | 5.0 | 3.0 | 20.0 | |
521 | 3.9824620818412155E-308 | ... | 500.0 | 500.0 | 500.0 | 1027.0 | |
522 | 1.8756333854232614E-9 | ... | 12.0 | 23.0 | 45.0 | 654.0 | |
523 | 0.031158540466480204 | ... | 150.5 | 500.3 | 200.7 | 700.0 | |
524 | 0.02054543894736772 | ... | 1420.0 | 5000.0 | 2000.0 | 7000.0 | |
525 | 4.008407827379104E-219 | ... | 200.0 | 200.0 | 200.0 | 1027.0 | |
526 | 0.14285714285714285 | ... | 1.0 | 5.0 | 3.0 | 7.0 | |
527 | !FE | ... | -1.0 | 4.0 | 3.0 | 7.0 | | Excel says: #NUM! |
528 | !FE | ... | 4.0 | 3.0 | 5.0 | 7.0 | | Excel says: #NUM! |
529 | !FE | ... | 3.0 | 5.0 | 2.0 | 7.0 | | Excel says: #NUM! |
530 | !FE | ... | 1.0 | 6.0 | 1.0 | 5.0 | | Excel says: #NUM! |
531 | !FE | ... | 2.0 | 2.0 | 8.0 | 7.0 | | Excel says: #NUM! |
530 | !FE | ... | 1.0 | 6.0 | 1.0 | 5.0 | | Excel says: #NUM! |
| A | B | C | D | E | F | G | H |
533 | 1.0 | =RSQ(C533:E533,F533:H533) | 1.0 | 2.0 | 1.0 | 1.0 | 2.0 | 1.0 | |
534 | 0.0 | ... | 1.0 | 2.0 | 3.0 | 1.0 | 2.0 | 1.0 | |
535 | 0.25 | ... | 1.0 | 2.0 | 1.0 | 1.0 | 2.0 | 2.0 | |
536 | 0.8733526620980497 | ... | 10.0 | 0.0 | 30.0 | 1.0 | 2.0 | 30.0 | |
537 | 0.75 | ... | 2.2 | 3.0 | 2.0 | 3.0 | 4.0 | 1.0 | |
538 | 0.9162708201667651 | ... | 2.4 | 3.5 | 2.0 | 3.0 | 4.8 | 1.0 | |
539 | 0.5714285714285715 | ... | 2.0 | 3.0 | 2.0 | 3.0 | 4.0 | 1.0 | |
540 | 0.13775510204081634 | ... | 3.0 | 4.0 | 22.0 | -3.0 | 2.0 | 1.0 | |
541 | 0.6694776662730966 | ... | 56.0 | 51.0 | 37.58 | 71.0 | 39.0 | 32.0 | |
542 | 0.08184371528741509 | ... | 123.0 | 12312.0 | 123123.0 | 459.0 | 34232.0 | 5657.0 | |
543 | !NaN/AE | ... | 3.0 | 3.0 | 3.0 | 3.0 | 4.0 | 1.0 | | Excel says: #DIV/0! |
542 | 0.08184371528741509 | ... | 123.0 | 12312.0 | 123123.0 | 459.0 | 34232.0 | 5657.0 | |
545 | 1.0 | =RSQ(C545:D545,E545:F545) | 2.0 | 44.0 | 34.0 | -2.0 | |
546 | !NA | =RSQ(C546:E546,F546) | 2.0 | 44.0 | 34.0 | -2.0 | | Excel says: #N/A |
| A | B | C | D | E | F | G | H |
548 | 0.5 | =PEARSON(C548:E548,F548:H548) | 2.0 | 2.0 | 1.0 | 2.0 | 1.0 | 1.0 | |
549 | -0.8660254037844386 | ... | 1.0 | 2.0 | 1.0 | 2.0 | 0.0 | 1.0 | |
550 | 0.8182161488708816 | ... | 56.0 | 51.0 | 37.58 | 71.0 | 39.0 | 32.0 | |
551 | 0.9982069443604055 | ... | 12332.0 | 2311.0 | 232311.0 | 3234.0 | 3455.0 | 12312.0 | |
552 | -0.27300239632881634 | ... | 3.0 | 4.0 | -6.0 | -4.0 | 2.0 | 1.0 | |
553 | 0.9145538895877268 | ... | 2.345 | 3.45 | 1.87 | 3.0 | 4.0 | 1.0 | |
554 | -0.9449111825230679 | ... | 3.0 | 4.0 | 6.0 | 2.0 | 2.0 | 1.0 | |
555 | 0.24346831983299175 | ... | 33.0 | 3.0 | 1.0 | 3.0 | 4.0 | 1.0 | |
556 | -0.9449111825230679 | ... | 3.0 | 4.0 | 6.0 | 2.0 | 2.0 | 1.0 | |
557 | -0.9449111825230679 | ... | 3.0 | 4.0 | 6.0 | 2.0 | 2.0 | 1.0 | |
558 | 0.24346831983299175 | ... | 33.0 | 3.0 | 1.0 | 3.0 | 4.0 | 1.0 | |
559 | !NaN/AE | ... | 3.0 | 2.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
560 | !NaN/AE | ... | 3.0 | 3.0 | 3.0 | 3.0 | 4.0 | 1.0 | | Excel says: #DIV/0! |
559 | !NaN/AE | ... | 3.0 | 2.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
562 | !NA | =PEARSON(C562:E562,F562:G562) | 33.0 | 3.0 | 1.0 | 3.0 | 4.0 | | Excel says: #N/A |
| A | B | C | D | E | F | G | H | I |
564 | 0.1749427963281397 | =TTEST(C564:D564,E564:F564,G564,H564) | 1.0 | 2.0 | 2.0 | 4.0 | 1.0 | 3.0 | |
565 | 0.10241638233196894 | ... | 1.0 | 2.0 | 2.0 | 4.0 | 1.0 | 1.0 | |
566 | 0.1558763988901216 | ... | 1.0 | 2.0 | 2.0 | 4.0 | 1.0 | 2.0 | |
567 | 0.12198347391450554 | ... | -11.0 | 0.0 | 20.0 | 40.0 | 2.0 | 3.0 | |
568 | 0.15018832294241363 | ... | 100.0 | 89.0 | 73.0 | 24.0 | 1.0 | 3.0 | |
569 | 0.8428299275851661 | ... | 1002.0 | 3456.0 | 2342.0 | 1213.0 | 2.0 | 1.0 | |
570 | 0.003026634116318681 | ... | 11233.0 | 12321.0 | 34556.0 | 32423.0 | 2.0 | 2.0 | |
571 | 0.2249215315788642 | ... | -234.0 | 546.0 | 5342.0 | 0.0 | 1.0 | 2.0 | |
572 | 0.40907121665655194 | ... | 1.34 | 2.48 | -2.25 | 4.44 | 1.0 | 1.0 | |
573 | 0.4162806083912417 | ... | 1.34 | 2.48 | -2.25 | 4.44 | 1.0 | 2.0 | |
574 | 0.42412415824824423 | ... | 1.34 | 2.48 | -2.25 | 4.44 | 1.0 | 3.0 | |
575 | 0.010045910514878575 | ... | 11233.0 | 12321.0 | 34556.0 | 32423.0 | 2.0 | 3.0 | |
576 | !FE | ... | 1.0 | 2.0 | 3.0 | 4.0 | 2.0 | 1.0 | | Excel says: #DIV/0! |
577 | !NaN/AE | ... | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | | Excel says: #DIV/0! |
578 | !NaN/AE | ... | 3.0 | 3.0 | 4.0 | 4.0 | 2.0 | 3.0 | | Excel says: #DIV/0! |
579 | !FE | ... | 1.0 | 2.0 | 2.0 | 4.0 | 3.0 | 2.0 | | Excel says: #NUM! |
580 | !FE | ... | 1.0 | 2.0 | 3.0 | 4.0 | 4.0 | 1.0 | | Excel says: #NUM! |
579 | !FE | ... | 1.0 | 2.0 | 2.0 | 4.0 | 3.0 | 2.0 | | Excel says: #NUM! |
582 | !NA | =TTEST(C582:D582,E582:G582,H582,I582) | 1.0 | 2.0 | 2.0 | 4.0 | 1.0 | 2.0 | 1.0 | 7.0 | Excel says: #N/A |
| A | B | C | D | E | F | G | H | I |
584 | 0.460172162722971 | =ZTEST(C584:F584,G584,H584) | 3.0 | 3.0 | 7.0 | 4.0 | 4.0 | 5.0 | |
585 | 0.8849303297782918 | ... | 3.0 | 6.0 | 7.0 | 8.0 | 9.0 | 5.0 | |
586 | !FE | ... | 3.0 | 6.0 | 7.0 | 8.0 | 9.0 | 0.0 | | Excel says: #NUM! |
587 | !FE | ... | 3.0 | 6.0 | 7.0 | 8.0 | 9.0 | -1.0 | | Excel says: #NUM! |
586 | !FE | ... | 3.0 | 6.0 | 7.0 | 8.0 | 9.0 | 0.0 | | Excel says: #NUM! |
589 | 0.9677672599610899 | =ZTEST(C589:F589,G589) | 3.0 | 3.0 | 7.0 | 4.0 | 6.0 | |
590 | 0.13666083914614902 | ... | 3.0 | 6.0 | 7.0 | 4.0 | 4.0 | |
589 | 0.9677672599610899 | ... | 3.0 | 3.0 | 7.0 | 4.0 | 6.0 | |
592 | 0.6172027580021179 | =ZTEST(C592:G592,H592,I592) | 2.0 | 3.0 | 7.0 | 4.0 | 2.0 | 4.0 | 3.0 | 7.0 |
593 | 0.9101437525605001 | ... | -1.0 | 0.0 | 7.0 | 4.0 | 4.0 | 4.0 | 2.0 | 7.0 |
594 | 0.0 | ... | 2.0 | 3.0 | 7.0 | 4.0 | 4.0 | 0.0 | 1.0 | 7.0 |
595 | 0.0312037092843529 | ... | 2.0 | 3.0 | 7.0 | 4.0 | 4.0 | -1.0 | 6.0 | 7.0 |
596 | 0.3521753935250074 | ... | 1993.0 | 2231.0 | 4565.0 | 2311.0 | 2312.0 | 2324.0 | 2112.0 | 7.0 |
597 | 0.17574708802314143 | ... | 2.2 | 3.8 | 7.5 | 0.0 | 4.0 | 1.0 | 6.0 | 7.0 |
598 | 0.5 | ... | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 2.0 | 7.0 |
597 | 0.17574708802314143 | ... | 2.2 | 3.8 | 7.5 | 0.0 | 4.0 | 1.0 | 6.0 | 7.0 |
| A | B | C | D | E | F | G | H |
600 | 1.0 | =CHITEST(C600:E600,F600:H600) | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
601 | 0.015888560447750184 | ... | 58.0 | 11.0 | 10.0 | 45.35 | 17.56 | 16.09 | |
602 | 1.0 | ... | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | 1.0 | |
603 | 0.10539922456626115 | ... | 12.0 | 3.0 | 4.0 | 18.0 | 2.0 | 2.0 | |
604 | 0.07047338213403015 | ... | 4.0 | 0.0 | 10.0 | 2.0 | 1.0 | 16.09 | |
605 | 0.05030575984901521 | ... | 58.0 | 11.0 | 10.0 | 45.35 | 17.56 | 10.0 | |
606 | 0.05030575984901521 | ... | 58.0 | 11.0 | 10.0 | 45.35 | 17.56 | 10.0 | |
607 | 0.4356234202769099 | ... | 12345.0 | 12345.0 | 32345.0 | 12312.0 | 12323.0 | 32123.0 | |
608 | 0.3672008481173127 | ... | -11.0 | 17.0 | 10.32 | -12.0 | 17.56 | 16.09 | |
609 | !NaN/AE | ... | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | | Excel says: #DIV/0! |
608 | 0.3672008481173127 | ... | -11.0 | 17.0 | 10.32 | -12.0 | 17.56 | 16.09 | |
611 | !NA | =CHITEST(C611,D611) | 14.0 | 11.0 | | Excel says: #N/A |
612 | 0.09871452354038054 | =CHITEST(C612:D612,E612:F612) | 58.0 | 11.0 | 48.0 | 14.0 | |
613 | 0.42541284832120996 | =CHITEST(C613:F613,C614:D615) | 55.0 | 12.0 | 48.0 | 14.0 | |
614 | !NA | =CHITEST(C614:E614,F614:G614) | 58.0 | 11.0 | 10.0 | 45.35 | 17.56 | | Excel says: #N/A |
615 | 0.01073954491118552 | =CHITEST(C615:E616,F615:H616) | 58.0 | 11.0 | 10.0 | 45.35 | 17.56 | 16.09 | |
616 | !NA | =CHITEST(C615:E616,F615:G616) | 2.0 | 3.0 | 4.0 | 3.0 | 4.0 | 5.0 | | Excel says: #N/A |
| A | B | C | D | E | F | G | H |
618 | 0.4374999999989781 | =FTEST(C618:E618,F618:H618) | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | |
619 | 0.849508257559715 | ... | -2.0 | 2.0 | 3.3 | 0.0 | 5.0 | 6.0 | |
620 | 0.6999999999983649 | ... | 0.0 | 1.0 | 3.0 | -1.0 | 3.0 | 0.0 | |
621 | 0.4510117372358122 | ... | 2210.0 | 2131.0 | 1232.0 | 1233.0 | 3243.0 | 2133.0 | |
622 | 0.5999999999985984 | ... | 5.0 | 4.0 | 3.0 | 5.0 | 3.0 | 2.0 | |
623 | 2.4691358021585335E-10 | ... | 10000.0 | 10000.0 | 100000.0 | 1.0 | 1.0 | 2.0 | |
624 | 0.9999999999976641 | ... | 1.0 | 5.0 | 2.0 | 1.0 | 5.0 | 2.0 | |
625 | 0.4374999999989781 | ... | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | |
626 | !FE | ... | 2.0 | 2.0 | 3.0 | 3.0 | 3.0 | 3.0 | | Excel says: #DIV/0! |
625 | 0.4374999999989781 | ... | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | |
628 | !FE | =FTEST(C628,D628:H628) | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | | Excel says: #DIV/0! |
629 | 0.1606255430235463 | =FTEST(C629:D629,E629:H629) | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | |
630 | 0.6263943592109936 | =FTEST(C630:E630,F630:G630) | 2.2 | 2.0 | 3.0 | 4.0 | 5.0 | |
| A | B | C | D | E |
632 | 1.3333333333333333 | =STANDARDIZE(C632,D632,E632) | 42.0 | 40.0 | 1.5 | |
633 | -1.04 | ... | 1.2 | 3.8 | 2.5 | |
634 | 0.8103727714748784 | ... | 3000.0 | 2000.0 | 1234.0 | |
635 | 0.0 | ... | 0.0 | 0.0 | 1.0 | |
636 | -1.3333333333333333 | ... | -1.0 | 3.0 | 3.0 | |
637 | !FE | ... | 42.0 | 40.0 | 0.0 | | Excel says: #NUM! |
638 | !FE | ... | 42.0 | 40.0 | -1.0 | | Excel says: #NUM! |
637 | !FE | ... | 42.0 | 40.0 | 0.0 | | Excel says: #NUM! |
| A | B | C |
640 | 1.524063822508502 | =GAMMALN(C640) | 0.2 | |
641 | -0.049872441306312076 | ... | 1.1 | |
642 | -4.171596401647548E-11 | ... | 1.0 | |
643 | 0.005854806806903181 | ... | 0.99 | |
644 | !FE | ... | -1.0 | | Excel says: #NUM! |
645 | !FE | ... | 0.0 | | Excel says: #NUM! |
644 | !FE | ... | -1.0 | | Excel says: #NUM! |
| A | B | C | D | E |
647 | 0.8646647167633873 | =EXPONDIST(C647,D647,E647) | 1.0 | 2.0 | true | |
648 | 0.2706705664732254 | ... | 1.0 | 2.0 | false | |
649 | 0.81362602396059 | ... | 14.0 | 0.12 | true | |
650 | 0.022364877124729197 | ... | 14.0 | 0.12 | false | |
651 | 0.9901767180337184 | ... | 1.34 | 3.45 | true | |
652 | 0.03389032278367159 | ... | 1.34 | 3.45 | false | |
653 | 0.7695220309333644 | ... | 1223.0 | 0.0012 | true | |
654 | 2.765735628799628E-4 | ... | 1223.0 | 0.0012 | false | |
655 | 0.19562755841064988 | ... | 1.1 | 2.2 | false | |
656 | !FE | ... | -0.01 | 2.2 | false | | Excel says: #NUM! |
657 | !FE | ... | 1.1 | 0.0 | false | | Excel says: #NUM! |
656 | !FE | ... | -0.01 | 2.2 | false | | Excel says: #NUM! |
| A | B | C | D | E | F |
659 | 0.6321205588285577 | =WEIBULL(C659,D659,E659,F659) | 1.0 | 1.0 | 1.0 | true | |
660 | 0.0 | ... | 0.0 | 21.0 | 321.0 | false | |
661 | 0.10516068318563021 | ... | 1.0 | 2.0 | 3.0 | true | |
662 | 0.1293998029923359 | ... | 1.1 | 2.2 | 3.7 | false | |
663 | 0.10516068318563021 | ... | 1.0 | 2.0 | 3.0 | true | |
664 | 0.1293998029923359 | ... | 1.1 | 2.2 | 3.7 | false | |
665 | 0.929581390069277 | ... | 105.0 | 20.0 | 100.0 | true | |
666 | !FE | ... | 102.0 | 0.0 | 100.0 | false | | Excel says: #NUM! |
667 | !FE | ... | 105.0 | 20.0 | -1.0 | true | | Excel says: #NUM! |
668 | !FE | ... | -0.01 | 30.0 | 100.0 | false | | Excel says: #NUM! |
667 | !FE | ... | 105.0 | 20.0 | -1.0 | true | | Excel says: #NUM! |
| A | B | C |
670 | 0.8673005276940532 | =FISHER(C670) | 0.7 | |
671 | 0.0 | ... | 0.0 | |
672 | 3.8002011672502 | ... | 0.999 | |
673 | 0.010000333353334718 | ... | 0.01 | |
674 | 0.5493061443340549 | ... | 0.5 | |
675 | -0.5493061443340549 | ... | -0.5 | |
676 | 0.2384170173623709 | ... | 0.234 | |
677 | !FE | ... | 1.0 | | Excel says: #NUM! |
678 | !FE | ... | 1.2 | | Excel says: #NUM! |
679 | !FE | ... | -1.0 | | Excel says: #NUM! |
678 | !FE | ... | 1.2 | | Excel says: #NUM! |
| A | B | C | D | E | F | G | H |
696 | 0.0 | =STDEVPA(C696) | 2.3 | |
698 | 1.4142135623730951 | =STDEVPA(C698:F698) | 2.0 | 2.0 | 0.0 | 4.0 | |
699 | 0.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | |
700 | 2.5664907948403006 | ... | -2.3 | 3.4 | 0.0 | 4.0 | |
699 | 0.0 | ... | 0.0 | 0.0 | 0.0 | 0.0 | |
702 | 1.3844373104863459 | =STDEVPA(C702:H702) | 2.0 | 3.0 | 0.0 | 4.0 | 2.0 | 4.0 | |
703 | 1.4907119849998598 | ... | 2.0 | 3.0 | false | 4.0 | true | 4.0 | |
| A | B | C | D | E | F | G | H | I |
705 | 0.46291004988627565 | =STEYX(C705:E705,F705:H705) | 4.0 | 5.0 | 3.0 | 4.0 | 3.0 | 8.0 | |
706 | 2.5495097567963927 | ... | 1.0 | 2.0 | 5.0 | 6.0 | 2.0 | 3.0 | |
707 | 0.5715476066494084 | ... | 4.0 | 4.2 | 3.0 | 0.0 | 3.0 | 6.0 | |
708 | 5.637745352698231 | ... | 3.0 | 2.0 | -5.0 | 6.0 | 2.1 | 3.0 | |
709 | 0.8819620983110001 | ... | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | |
710 | 1.683745824048273 | ... | 4.1 | 3.0 | 0.0 | 4.0 | 3.0 | 6.0 | |
711 | 4.439209645700573 | ... | 4.1 | -3.4 | 3.0 | 3.9 | 3.0 | 6.0 | |
712 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
713 | 0.0 | ... | 3.0 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | |
712 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
715 | !NA | =STEYX(C715:E715,F715:G715) | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | | Excel says: #N/A |
716 | !FE | =STEYX(C716,D716) | 4.1 | 3.0 | | Excel says: #DIV/0! |
718 | 3.305718950210041 | =STEYX(C718:I718,C719:I719) | 2.0 | 3.0 | 9.0 | 1.0 | 8.0 | 7.0 | 5.0 | 7.0 |
719 | 3.81051177665153 | =STEYX(C718:E719,F718:H719) | 6.0 | 5.0 | 11.0 | 7.0 | 5.0 | 4.0 | 4.0 | 7.0 |
| A | B | C | D | E | F | G | H | I |
722 | -0.9449111825230679 | =CORREL(C722:E722,F722:H722) | 4.0 | 5.0 | 3.0 | 4.0 | 3.0 | 8.0 | |
723 | 0.05241424183609594 | ... | 3.0 | 2.0 | 5.0 | 6.0 | 2.0 | 3.0 | |
724 | -0.7777137710478189 | ... | 4.0 | 4.2 | 3.0 | 0.0 | 3.0 | 6.0 | |
725 | 0.4044433256155759 | ... | 3.0 | 2.0 | -5.0 | 6.0 | 2.1 | 3.0 | |
726 | -0.18898223650461365 | ... | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | |
727 | -0.8277881133609988 | ... | 4.1 | 3.0 | 0.0 | 4.0 | 3.0 | 6.0 | |
728 | 0.6319111138501405 | ... | 4.1 | -3.4 | 3.0 | 3.9 | 3.0 | 6.0 | |
729 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
730 | !NaN/AE | ... | 3.0 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | | Excel says: #DIV/0! |
729 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
732 | !NA | =CORREL(C732:E732,F732:G732) | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | | Excel says: #N/A |
733 | !NaN/AE | =CORREL(C733,D733) | 4.1 | 3.0 | | Excel says: #DIV/0! |
735 | 0.24072846024282468 | =CORREL(C735:I735,C736:I736) | 2.0 | 3.0 | 9.0 | 1.0 | 8.0 | 7.0 | 5.0 | 7.0 |
736 | 0.1788854381999832 | =CORREL(C735:E736,F735:H736) | 6.0 | 5.0 | 11.0 | 7.0 | 5.0 | 4.0 | 4.0 | 7.0 |
| A | B | C | D | E | F | G | H | I |
752 | -0.3 | =SLOPE(C752:E752,F752:H752) | 4.0 | 5.0 | 3.0 | 3.0 | 3.0 | 8.0 | |
753 | 0.8633093525179856 | ... | 3.0 | 2.0 | -5.0 | 6.0 | 2.1 | 3.0 | |
754 | -0.07857142857142857 | ... | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | |
755 | -1.15 | ... | 4.1 | 3.0 | 0.0 | 4.0 | 3.0 | 6.0 | |
756 | 1.662447257383966 | ... | 4.1 | -3.4 | 3.0 | 3.9 | 3.0 | 6.0 | |
757 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
758 | 0.0 | ... | 3.0 | 3.0 | 3.0 | 4.0 | 3.0 | 6.0 | |
757 | !NaN/AE | ... | 4.1 | 3.0 | 3.0 | 4.0 | 4.0 | 4.0 | | Excel says: #DIV/0! |
760 | !NA | =SLOPE(C760:E760,F760:G760) | 4.1 | 3.0 | 3.0 | 4.0 | 3.0 | | Excel says: #N/A |
762 | 0.3055555555555556 | =SLOPE(C762:I762,C763:I763) | 2.0 | 3.0 | 9.0 | 1.0 | 8.0 | 7.0 | 5.0 | 7.0 |
763 | 0.24 | =SLOPE(C762:E763,F762:H763) | 6.0 | 5.0 | 11.0 | 7.0 | 5.0 | 4.0 | 4.0 | 7.0 |
| A | B | C | D | E |
778 | 4.0 | =CRITBINOM(C778,D778,E778) | 6.0 | 0.5 | 0.75 | |
779 | 3.0 | ... | 4.3 | 0.5 | 0.75 | |
780 | 4.0 | ... | 6.7 | 0.45 | 0.75 | |
781 | 5.0 | ... | 6.7 | 0.82 | 0.45 | |
782 | 7.0 | ... | 7.0 | 0.999999 | 0.34 | |
783 | 7.0 | ... | 7.0 | 0.999999 | 0.999999 | |
784 | 0.0 | ... | 6.0 | 1.0E-6 | 0.33 | |
785 | !FE | ... | -0.01 | 0.45 | 0.78 | | Excel says: #NUM! |
786 | !FE | ... | 6.0 | 0.45 | 1.0 | | Excel says: #NUM! |
787 | !FE | ... | 6.0 | 0.45 | -0.01 | | Excel says: #NUM! |
788 | !FE | ... | 6.0 | 1.0 | 0.45 | | Excel says: #NUM! |
789 | !FE | ... | 6.0 | 0.0 | 0.75 | | Excel says: #NUM! |
790 | !FE | ... | -1.0 | 0.5 | 0.75 | | Excel says: #NUM! |
791 | !FE | ... | 1.0E10 | 0.5 | 0.75 | | Excel says: #NUM! |
790 | !FE | ... | -1.0 | 0.5 | 0.75 | | Excel says: #NUM! |
| A | B | C | D | E | F | G | H | I |
793 | 0.5 | =PERCENTRANK(C793:E793,F793) | 1.0 | 2.0 | 4.0 | 2.0 | |
794 | 0.0 | ... | 1.0 | 2.0 | 6.0 | 1.0 | |
795 | 0.5 | ... | 1.0 | 2.2 | 6.23 | 2.2 | |
796 | 1.0 | ... | 1.0 | 2.0 | 6.0 | 6.0 | |
797 | 0.75 | ... | 1.0 | 2.0 | 4.0 | 3.0 | |
798 | 0.625 | ... | 1.0 | 2.0 | 6.0 | 3.0 | |
799 | 0.821 | ... | -2.4 | -3.4 | 6.0 | 3.0 | |
800 | !NA | ... | 1.0 | 2.0 | 6.0 | 7.0 | | Excel says: #N/A |
801 | !NA | ... | 1.0 | 2.0 | 6.0 | 0.0 | | Excel says: #N/A |
800 | !NA | ... | 1.0 | 2.0 | 6.0 | 7.0 | | Excel says: #N/A |
803 | 0.821 | =PERCENTRANK(C803:E803,F803,G803) | -2.4 | -3.4 | 6.0 | 3.0 | 3.0 | |
804 | 0.82142 | ... | -2.4 | -3.4 | 6.0 | 3.0 | 5.0 | |
805 | 0.821428 | ... | -2.4 | -3.4 | 6.0 | 3.0 | 6.0 | |
806 | !FE | ... | -2.4 | -3.4 | 6.0 | 3.0 | 0.99 | | Excel says: #NUM! |
805 | 0.821428 | ... | -2.4 | -3.4 | 6.0 | 3.0 | 6.0 | |
808 | 0.4 | =PERCENTRANK(C808:H808,I808) | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | 3.0 | 7.0 |
809 | 0.4 | ... | 1.0 | 1.0 | 4.0 | 4.0 | 2.0 | 2.0 | 2.0 | 7.0 |
810 | 0.8 | ... | 1.0 | 1.0 | 4.0 | 4.0 | 2.0 | 2.0 | 4.0 | 7.0 |
811 | 0.7 | ... | 1.0 | 1.0 | 4.0 | 4.0 | 2.0 | 2.0 | 3.0 | 7.0 |
810 | 0.8 | ... | 1.0 | 1.0 | 4.0 | 4.0 | 2.0 | 2.0 | 4.0 | 7.0 |
813 | 1.0 | =PERCENTRANK(C813,D813) | 2.0 | 2.0 | |
814 | !NA | ... | 2.0 | 3.0 | | Excel says: #N/A |
813 | 1.0 | ... | 2.0 | 2.0 | |
| A | B | C | D | E | F | G | H | I |
816 | 2.0 | =MODE(C816:G816) | 1.0 | 2.0 | 2.0 | 4.0 | 5.0 | |
817 | 5.0 | ... | 2.0 | 5.0 | 3.0 | 4.0 | 5.0 | |
818 | 2.0 | ... | 2.0 | 2.0 | 1.0 | 1.0 | 4.0 | |
817 | 5.0 | ... | 2.0 | 5.0 | 3.0 | 4.0 | 5.0 | |
820 | 2.0 | =MODE(C820:I820) | 1.0 | 1.0 | 4.0 | 4.0 | 2.0 | 2.0 | 2.0 | 7.0 |
821 | 3.0 | ... | 2.0 | 2.0 | 4.0 | 3.0 | 3.0 | 3.0 | 4.0 | 7.0 |
822 | 5.0 | ... | 1.0 | 5.0 | 3.0 | 4.0 | 5.0 | 2.0 | 3.0 | 7.0 |
823 | 2.0 | ... | 1.0 | 7.0 | 3.0 | 4.0 | 5.0 | 2.0 | 2.0 | 7.0 |
824 | !NA | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 6.0 | 7.0 | 7.0 | Excel says: #N/A |
823 | 2.0 | ... | 1.0 | 7.0 | 3.0 | 4.0 | 5.0 | 2.0 | 2.0 | 7.0 |
826 | !NA | =MODE(C826) | 2.0 | | Excel says: #N/A |
| A | B | C | D | E | F | G | H | I |
828 | 3.0 | =TRIMMEAN(C828:G828,H828) | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.5 | |
829 | 4.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.5 | |
830 | 3.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.2 | |
831 | 3.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.0 | |
832 | 3.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.4 | |
831 | 3.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.0 | |
834 | 2.433333333333333 | =TRIMMEAN(C834:H834,I834) | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 0.1 | 7.0 |
835 | 2.65 | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 0.6 | 7.0 |
836 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 1.0 | 7.0 | Excel says: #NUM! |
837 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | -0.01 | 7.0 | Excel says: #NUM! |
836 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 1.0 | 7.0 | Excel says: #NUM! |
839 | 1.0 | =TRIMMEAN(C839,D839) | 1.0 | 0.5 | |
| A | B | C | D | E | F | G | H | I |
841 | 1.0 | =QUARTILE(C841:G841,H841) | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.0 | |
842 | 3.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
843 | 3.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 2.0 | |
844 | 5.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 4.5 | |
845 | !FE | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 5.0 | | Excel says: #NUM! |
846 | !FE | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | -0.01 | | Excel says: #NUM! |
845 | !FE | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 5.0 | | Excel says: #NUM! |
848 | 1.3 | =QUARTILE(C848:H848,I848) | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 1.0 | 7.0 |
849 | 2.8 | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 2.0 | 7.0 |
848 | 1.3 | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.0 | 1.0 | 7.0 |
| A | B | C | D | E | F | G | H |
851 | 3.0 | =PERCENTILE(C851:G851,H851) | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.5 | |
852 | 4.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.5 | |
853 | 1.8 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.2 | |
854 | 1.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 0.0 | |
855 | 5.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
856 | 2.2 | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 0.25 | |
857 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | -0.01 | | Excel says: #NUM! |
858 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | 1.1 | | Excel says: #NUM! |
857 | !FE | ... | 2.2 | -1.0 | 3.4 | 5.0 | 4.0 | -0.01 | | Excel says: #NUM! |
| A | B | C | D | E | F | G | H |
860 | 3.0 | =MEDIAN(C860:G860) | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | |
861 | 4.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | |
862 | 3.0 | ... | 2.0 | 1.0 | 3.0 | 5.0 | 4.0 | |
861 | 4.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | |
864 | 2.0 | =MEDIAN(C864) | 2.0 | |
866 | 2.7 | =MEDIAN(C866:H866) | 2.0 | 1.1 | 3.4 | 5.0 | 4.0 | 2.0 | |
867 | 3.5 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
868 | 3.5 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 2.0 | |
869 | 0.5 | ... | -5.0 | -2.0 | -4.0 | 4.0 | 5.0 | 3.0 | |
870 | 0.0 | ... | -5.0 | -2.0 | -4.0 | 4.0 | 5.0 | 2.0 | |
869 | 0.5 | ... | -5.0 | -2.0 | -4.0 | 4.0 | 5.0 | 3.0 | |
| A | B | C | D | E | F | G | H |
872 | 5.0 | =SMALL(C872:G872,H872) | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 4.0 | |
873 | 5.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 5.0 | |
874 | 1.0 | ... | 2.0 | 1.0 | 3.0 | 5.0 | 4.0 | 1.0 | |
875 | 2.0 | ... | 2.0 | 1.0 | 3.0 | 5.0 | 4.0 | 2.0 | |
876 | 2.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
877 | 3.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 2.0 | |
878 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 3.0 | |
879 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 2.0 | |
878 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 3.0 | |
881 | 2.2 | =SMALL(C881:F881,G881) | 5.0 | 2.2 | 4.0 | 4.0 | 1.0 | |
882 | !FE | ... | 5.0 | 2.0 | 4.0 | 4.0 | 0.0 | | Excel says: #NUM! |
881 | 2.2 | ... | 5.0 | 2.2 | 4.0 | 4.0 | 1.0 | |
884 | -2.0 | =SMALL(C884:E884,F884) | 5.0 | -2.0 | -4.0 | 2.0 | |
885 | !FE | ... | 5.0 | 2.0 | 4.0 | 4.0 | | Excel says: #NUM! |
884 | -2.0 | ... | 5.0 | -2.0 | -4.0 | 2.0 | |
887 | 5.0 | =SMALL(C887,D887) | 5.0 | 1.0 | |
| A | B | C | D | E | F | G | H |
889 | 5.0 | =LARGE(C889:G889,H889) | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 2.0 | |
890 | 5.0 | ... | 1.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
891 | 5.0 | ... | 2.0 | 1.0 | 3.0 | 5.0 | 4.0 | 1.0 | |
892 | 4.0 | ... | 2.0 | 1.0 | 3.0 | 5.0 | 4.0 | 2.0 | |
893 | 5.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 1.0 | |
894 | 5.0 | ... | 5.0 | 2.0 | 3.0 | 4.0 | 5.0 | 2.0 | |
895 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 3.0 | |
896 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 4.0 | |
895 | 4.0 | ... | 5.0 | 2.0 | 4.0 | 4.0 | 5.0 | 3.0 | |
898 | 2.2 | =LARGE(C898:F898,G898) | 5.0 | 2.2 | 4.0 | 4.0 | 4.0 | |
899 | !FE | ... | 5.0 | 2.0 | 4.0 | 4.0 | 0.0 | | Excel says: #NUM! |
898 | 2.2 | ... | 5.0 | 2.2 | 4.0 | 4.0 | 4.0 | |
901 | -2.0 | =LARGE(C901:E901,F901) | 5.0 | -2.0 | -4.0 | 2.0 | |
902 | !FE | ... | 5.0 | 2.0 | 4.0 | 4.0 | | Excel says: #NUM! |
901 | -2.0 | ... | 5.0 | -2.0 | -4.0 | 2.0 | |
| A | B | C | D | E | F | G | H | I |
904 | 1.0 | =FORECAST(C904,D904:F904,G904:I904) | 3.0 | 1.0 | 1.0 | 1.0 | 3.0 | 8.0 | 9.0 | 7.0 |
905 | 2.0 | ... | 2.0 | 1.0 | 2.0 | 3.0 | 1.0 | 2.0 | 3.0 | 7.0 |
906 | 5.0 | ... | 5.0 | 1.0 | 2.0 | 3.0 | 1.0 | 2.0 | 3.0 | 7.0 |
907 | 4.0 | ... | 2.0 | 2.0 | 4.0 | 6.0 | 1.0 | 2.0 | 3.0 | 7.0 |
908 | -5.9 | ... | -2.0 | 2.3 | 4.0 | 6.0 | 1.5 | 2.0 | 3.0 | 7.0 |
909 | 4.5769230769230775 | ... | 2.0 | 1.0 | 4.3 | 6.0 | -1.0 | 2.0 | 3.0 | 7.0 |
910 | 8.354838709677422 | ... | 1.0 | 7.0 | 3.0 | 3.0 | 3.0 | 8.0 | 9.0 | 7.0 |
911 | 5.322580645161291 | ... | 2.0 | 5.0 | 3.0 | 3.0 | 3.0 | 8.0 | 9.0 | 7.0 |
912 | -4.250830564784051 | ... | 3.0 | 2.0 | -5.0 | 6.0 | 2.1 | 3.0 | 1.0 | 7.0 |
913 | -0.105 | ... | 4.1 | 3.0 | -3.3 | 4.0 | 3.0 | 6.0 | 0.0 | 7.0 |
912 | -4.250830564784051 | ... | 3.0 | 2.0 | -5.0 | 6.0 | 2.1 | 3.0 | 1.0 | 7.0 |
915 | 7.0 | =FORECAST(C915,D915:E915,F915:G915) | 2.0 | 5.0 | 3.0 | 3.0 | 4.0 | |
916 | !NaN/AE | ... | 2.0 | 5.0 | 3.0 | 3.0 | 3.0 | | Excel says: #DIV/0! |
917 | !NA | =FORECAST(C917,D917:E917,F917:H917) | 2.0 | 5.0 | 3.0 | 3.0 | 4.0 | 4.0 | | Excel says: #N/A |