Statistical Functions In AFC

Statistical Functions

The supported statistical functions are shown by example below:

RANK

	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
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
13	1.0	=RANK( C13, D13 )	6.0	6.0

VARP (does not support blanks!)

	A	B	C	D	E	F	G	H	I
15	0.0	=VARP( C15 )	1.0
16	0.0	...	4.0
18	0.25	=VARP( C18, D18 )	1.0	2.0
19	0.25	...	4.0	5.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

VAR (does not support blanks!)

	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
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

STDEV (does not support blanks!)

	A	B	C	D	E	F	G	H	I
30	2.8284271247461903	=STDEV( C30, D30 )	-1.0	3.0
31	2.0816659994661326	=STDEV( C31, D31, E31 )	-1.0	0.0	3.0
33	40.688718279617696	=STDEV( C33:E33, F33:H33, I33 )	-1.0	0.0	5.45	7.62	12.7	14.5	-100.0	7.0
34	4.15187851918806	...	-10.0	0.0	1.0	0.0	-1.0	-2.0	3.0	7.0

STDEVP (does not support blanks!)

	A	B	C	D	E	F	G	H	I
36	0.0	=STDEVP( C36 )	7.0
37	1.5	=STDEVP( C37, D37 )	2.0	5.0
38	2.0548046676563256	=STDEVP( C38, D38, E38 )	2.0	0.0	5.0
40	37.6704332172529	=STDEVP( C40:E40, F40:H40, I40 )	-1.0	0.0	5.45	7.62	12.7	14.5	-100.0	7.0
41	3.843892584878203	...	-10.0	0.0	1.0	0.0	-1.0	-2.0	3.0	7.0

AVEDEV (does not support blanks!)

	A	B	C	D	E	F	G	H	I
43	0.0	=AVEDEV( C43 )	40.0
44	2.0	=AVEDEV( C44, D44 )	-1.0	3.0
45	1.5555555555555554	=AVEDEV( C45, D45, E45 )	-1.0	0.0	3.0
47	26.092653061224492	=AVEDEV( C47:E47, F47:H47, I47 )	-1.0	0.0	5.45	7.62	12.7	14.5	-100.0	7.0
48	2.693877551020408	...	-10.0	0.0	1.0	0.0	-1.0	-2.0	3.0	7.0

DEVSQ (does not support blanks!)

	A	B	C	D	E	F	G	H	I
50	0.0	=DEVSQ( C50 )	40.0
51	8.0	=DEVSQ( C51, D51 )	-1.0	3.0
52	8.666666666666668	=DEVSQ( C52, D52, E52 )	-1.0	0.0	3.0
54	9933.430771428571	=DEVSQ( C54:E54, F54:H54, I54 )	-1.0	0.0	5.45	7.62	12.7	14.5	-100.0	7.0
55	103.4285714285714	...	-10.0	0.0	1.0	0.0	-1.0	-2.0	3.0	7.0

SKEW (does not support blanks!)

	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

KURT (does not support blanks!)

	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

NORMDIST

	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!

NORMSDIST

	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

LOGNORMDIST

	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!

CONFIDENCE

	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!

NORMINV

	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!

NORMSINV

	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!

LOGINV

	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!

BETADIST

	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!
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!

BINOMDIST

	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!

NEGBINOMDIST

	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!

CHIDIST

	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!

FDIST

	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!

GAMMADIST

	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!

POISSON

	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!

TDIST

	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!

BETAINV

	A	B	C	D	E	F	G
432	0.41815900802612305	=BETAINV( C432, D432, E432 )	0.6	1.5	2.5
433	0.9410946369171143	...	0.6	2.5	0.5
434	0.8977973461151123	...	0.6	1.5	0.5
435	0.8977973461151123	=BETAINV( C435, D435, E435, F435 )	0.6	1.5	0.5	0.0
436	0.8977973461151123	=BETAINV( C436, D436, E436, , F436 )	0.6	1.5	0.5	1.0
437	0.8977973461151123	=BETAINV( C437, D437, E437, F437, G437 )	0.6	1.5	0.5	0.0	1.0
438	0.9182378768920898	=BETAINV( C438, D438, E438, F438 )	0.6	1.5	0.5	0.2
439	0.9182378768920898	=BETAINV( C439, D439, E439, F439, G439 )	0.6	1.5	0.5	0.2	1.0
440	0.2693392038345337	=BETAINV( C440, D440, E440, , F440 )	0.6	1.5	0.5	0.3
441	0.2693392038345337	=BETAINV( C441, D441, E441, F441, G441 )	0.6	1.5	0.5	0.0	0.3
442	0.28977973461151124	...	0.6	1.5	0.5	0.2	0.3
443	!FE	...	0.0	1.5	0.5	0.2	0.3		Excel says: #NUM!
444	!FE	...	-0.0010	1.5	0.5	0.2	0.3		Excel says: #NUM!
445	!FE	...	1.0	1.5	0.5	0.2	0.3		Excel says: #NUM!
446	!FE	...	0.6	0.0	0.5	0.2	0.3		Excel says: #NUM!
447	!FE	...	0.6	1.5	0.0	0.2	0.3		Excel says: #NUM!
448	!FE	...	0.6	1.5	0.5	0.3	0.3		Excel says: #NUM!
449	!FE	...	0.6	1.5	0.5	0.3	0.2		Excel says: #NUM!

CHIINV

	A	B	C	D
451	3.2188758249516325	=CHIINV( C451, D451 )	0.2	2.4
452	0.41389331157281367	...	0.52	1.0
453	2.8051184564879357	...	0.73	5.0
454	2.8051184564879357	...	0.73	5.42
455	5.749409689274468	...	0.9999	23.0
456	32.006899668662996	...	0.1	23.0
457	35.99736227382731	...	0.33	33.0
458	78.7495242510023	...	0.0010	44.0
459	2.407945608735304	...	0.3	2.4
460	13.815510558047702	...	0.0010	2.0
461	!FE	...	0.0	1.0		Excel says: #NUM!
462	!FE	...	1.001	1.0		Excel says: #NUM!
463	!FE	...	0.2	0.99		Excel says: #NUM!
464	!FE	...	0.2	1.0E11		Excel says: #NUM!

FINV

	A	B	C	D	E
466	0.666666666823178	=FINV( C466, D466, E466 )	0.5	1.9	2.4
467	0.0	...	1.0	4.0	2.4
468	1.0E9	...	0.0	1.0	2.0
469	8.45128505321545	...	0.01	3.6	7.9
470	0.6232351341573585	...	0.7	5.0	3.0
471	18.772269815522307	...	0.0010	3.6	7.9
472	!FE	...	-0.01	1.9	2.4		Excel says: #NUM!
473	!FE	...	1.1	1.9	2.4		Excel says: #NUM!
474	!FE	...	0.4	0.7	2.4		Excel says: #NUM!
475	!FE	...	0.5	1.0E11	2.4		Excel says: #NUM!
476	!FE	...	0.5	1.9	1.0E11		Excel says: #NUM!

FISHERINV

	A	B	C
478	0.6043677771171635	=FISHERINV( C478 )	0.7
479	0.0	...	0.0
480	0.76117386166057	...	0.999
481	0.009999666679999443	...	0.01
482	0.46211715726000974	...	0.5
483	-0.46211715726000974	...	-0.5
484	0.22982054821431688	...	0.234
485	0.9999092042625951	...	5.0
486	0.9999999994421064	...	11.0
487	-0.9999999994421064	...	-11.0

GAMMAINV

	A	B	C	D	E
489	4.951915547315796	=GAMMAINV( C489, D489, E489 )	0.065	9.0	1.0
490	1.5141277326714913	...	0.78	1.0	1.0
491	0.0	...	0.0	3.0	2.0
492	18.417894393294752	...	0.7	8.0	2.0
493	3.0154804227868324	...	0.35	1.0	7.0
494	80.86540232879742	...	0.98	9.0	5.0
495	134.7931377139853	...	0.99	23.2	3.76
496	!FE	...	-0.01	9.0	1.0		Excel says: #NUM!
497	!FE	...	1.01	9.0	1.0		Excel says: #NUM!
498	!FE	...	0.77	9.0	-1.0		Excel says: #NUM!
499	!FE	...	0.35	-0.01	100.0		Excel says: #NUM!
500	!FE	...	0.35	0.0	100.0		Excel says: #NUM!

TINV

	A	B	C	D
502	1.8797510544618512	=TINV( C502, D502 )	0.065	60.0
503	8.431427402612772E-8	...	1.0	123.0
504	1.0	...	0.5	1.0
505	0.8164965810235691	...	0.5	2.0
506	0.5095254497089412	...	0.7	1.0
507	2.946712882834883	...	0.01	15.0
508	!FE	...	1.1	60.0		Excel says: #NUM!
509	!FE	...	0.065	-1.0		Excel says: #NUM!
510	!FE	...	0.065	0.5		Excel says: #NUM!
511	!FE	...	-0.01	2.0		Excel says: #NUM!
512	!FE	...	1.01	3.0		Excel says: #NUM!

HYPGEOMDIST

	A	B	C	D	E	F
514	1.0	=HYPGEOMDIST( C514, D514, E514, F514 )	0.0	0.0	0.0	0.0
515	1.0	...	0.0	0.0	0.0	2.0
516	1.0	...	0.0	0.0	1.0	2.0
517	1.0	...	0.0	1.0	0.0	2.0
518	0.5	...	0.0	1.0	1.0	2.0
519	0.16666666666666666	...	0.0	1.0	5.0	6.0
520	0.16666666666666666	...	0.0	5.0	1.0	6.0
521	1.0	...	1.0	1.0	1.0	1.0
522	1.0	...	3.0	3.0	4.0	4.0
523	0.4	...	3.0	3.0	4.0	5.0
524	1.0	...	3.0	4.0	3.0	4.0
525	0.4	...	3.0	4.0	3.0	5.0
526	1.0	...	8.0	8.0	8.0	8.0
527	0.75	...	8.0	9.0	11.0	12.0
528	0.6818181818181818	...	8.0	10.0	10.0	12.0
529	0.75	...	8.0	11.0	9.0	12.0
530	1.0	...	8.0	8.0	12.0	12.0
531	1.0	...	8.0	12.0	8.0	12.0
532	0.985	...	0.0	1.0	3.0	200.0
533	0.13543107314499453	...	10.0	70.0	300.0	2000.0
534	0.09410799382905079	...	20.0	200.0	2000.0	20000.0
535	0.75	...	8.5	9.5	11.5	12.5
536	!FE	...	-1.0	4.0	3.0	20.0		Excel says: #NUM!
537	!FE	...	4.0	3.0	5.0	7.0		Excel says: #NUM!
538	!FE	...	4.0	5.0	3.0	7.0		Excel says: #NUM!
539	!FE	...	7.0	10.0	10.0	12.0		Excel says: #NUM!
540	!FE	...	15.0	15.0	15.0	14.0		Excel says: #NUM!
541	!FE	...	8.0	-1.0	11.0	12.0		Excel says: #NUM!
542	!FE	...	8.0	9.0	-1.0	12.0		Excel says: #NUM!
543	!FE	...	8.0	9.0	11.0	-1.0		Excel says: #NUM!

RSQ

	A	B	C	D	E	F	G	H
545	1.0	=RSQ( C545:E545, F545:H545 )	1.0	2.0	1.0	1.0	2.0	1.0
546	0.0	...	1.0	2.0	3.0	1.0	2.0	1.0
547	0.25	...	1.0	2.0	1.0	1.0	2.0	2.0
548	0.8733526620980497	...	10.0	0.0	30.0	1.0	2.0	30.0
549	0.75	...	2.2	3.0	2.0	3.0	4.0	1.0
550	0.9162708201667651	...	2.4	3.5	2.0	3.0	4.8	1.0
551	0.5714285714285715	...	2.0	3.0	2.0	3.0	4.0	1.0
552	0.13775510204081634	...	3.0	4.0	22.0	-3.0	2.0	1.0
553	0.6694776662730966	...	56.0	51.0	37.58	71.0	39.0	32.0
554	0.08184371528741509	...	123.0	12312.0	123123.0	459.0	34232.0	5657.0
555	!NaN/AE	...	3.0	3.0	3.0	3.0	4.0	1.0		Excel says: #DIV/0!
557	1.0	=RSQ( C557:D557, E557:F557 )	2.0	44.0	34.0	-2.0
558	!NA	=RSQ( C558:E558, F558 )	2.0	44.0	34.0	-2.0		Excel says: #N/A

PEARSON

	A	B	C	D	E	F	G	H
560	0.5	=PEARSON( C560:E560, F560:H560 )	2.0	2.0	1.0	2.0	1.0	1.0
561	-0.8660254037844386	...	1.0	2.0	1.0	2.0	0.0	1.0
562	0.8182161488708816	...	56.0	51.0	37.58	71.0	39.0	32.0
563	0.9982069443604055	...	12332.0	2311.0	232311.0	3234.0	3455.0	12312.0
564	-0.27300239632881634	...	3.0	4.0	-6.0	-4.0	2.0	1.0
565	0.9145538895877268	...	2.345	3.45	1.87	3.0	4.0	1.0
566	-0.9449111825230679	...	3.0	4.0	6.0	2.0	2.0	1.0
567	0.24346831983299175	...	33.0	3.0	1.0	3.0	4.0	1.0
568	-0.9449111825230679	...	3.0	4.0	6.0	2.0	2.0	1.0
569	-0.9449111825230679	...	3.0	4.0	6.0	2.0	2.0	1.0
570	0.24346831983299175	...	33.0	3.0	1.0	3.0	4.0	1.0
571	!NaN/AE	...	3.0	2.0	3.0	4.0	4.0	4.0		Excel says: #DIV/0!
572	!NaN/AE	...	3.0	3.0	3.0	3.0	4.0	1.0		Excel says: #DIV/0!
574	!NA	=PEARSON( C574:E574, F574:G574 )	33.0	3.0	1.0	3.0	4.0		Excel says: #N/A

TTEST

	A	B	C	D	E	F	G	H	I
576	0.1749427963281397	=TTEST( C576:D576, E576:F576, G576, H576 )	1.0	2.0	2.0	4.0	1.0	3.0
577	0.10241638233196894	...	1.0	2.0	2.0	4.0	1.0	1.0
578	0.1558763988901216	...	1.0	2.0	2.0	4.0	1.0	2.0
579	0.12198347391450554	...	-11.0	0.0	20.0	40.0	2.0	3.0
580	0.15018832294241363	...	100.0	89.0	73.0	24.0	1.0	3.0
581	0.8428299275851661	...	1002.0	3456.0	2342.0	1213.0	2.0	1.0
582	0.003026634116318681	...	11233.0	12321.0	34556.0	32423.0	2.0	2.0
583	0.2249215315788642	...	-234.0	546.0	5342.0	0.0	1.0	2.0
584	0.40907121665655194	...	1.34	2.48	-2.25	4.44	1.0	1.0
585	0.4162806083912417	...	1.34	2.48	-2.25	4.44	1.0	2.0
586	0.42412415824824423	...	1.34	2.48	-2.25	4.44	1.0	3.0
587	0.010045910514878575	...	11233.0	12321.0	34556.0	32423.0	2.0	3.0
588	!FE	...	1.0	2.0	3.0	4.0	2.0	1.0		Excel says: #DIV/0!
589	!NaN/AE	...	2.0	2.0	2.0	2.0	2.0	2.0		Excel says: #DIV/0!
590	!NaN/AE	...	3.0	3.0	4.0	4.0	2.0	3.0		Excel says: #DIV/0!
591	!FE	...	1.0	2.0	2.0	4.0	3.0	2.0		Excel says: #NUM!
592	!FE	...	1.0	2.0	3.0	4.0	4.0	1.0		Excel says: #NUM!
594	!NA	=TTEST( C594:D594, E594:G594, H594, I594 )	1.0	2.0	2.0	4.0	1.0	2.0	1.0	7.0	Excel says: #N/A

ZTEST

	A	B	C	D	E	F	G	H	I
596	0.460172162722971	=ZTEST( C596:F596, G596, H596 )	3.0	3.0	7.0	4.0	4.0	5.0
597	0.8849303297782918	...	3.0	6.0	7.0	8.0	9.0	5.0
598	!FE	...	3.0	6.0	7.0	8.0	9.0	0.0		Excel says: #NUM!
599	!FE	...	3.0	6.0	7.0	8.0	9.0	-1.0		Excel says: #NUM!
601	0.9677672599610899	=ZTEST( C601:F601, G601 )	3.0	3.0	7.0	4.0	6.0
602	0.13666083914614902	...	3.0	6.0	7.0	4.0	4.0
604	0.6172027580021179	=ZTEST( C604:G604, H604, I604 )	2.0	3.0	7.0	4.0	2.0	4.0	3.0	7.0
605	0.9101437525605001	...	-1.0	0.0	7.0	4.0	4.0	4.0	2.0	7.0
606	0.0	...	2.0	3.0	7.0	4.0	4.0	0.0	1.0	7.0
607	0.0312037092843529	...	2.0	3.0	7.0	4.0	4.0	-1.0	6.0	7.0
608	0.3521753935250074	...	1993.0	2231.0	4565.0	2311.0	2312.0	2324.0	2112.0	7.0
609	0.17574708802314143	...	2.2	3.8	7.5	0.0	4.0	1.0	6.0	7.0
610	0.5	...	2.0	2.0	2.0	2.0	2.0	2.0	2.0	7.0

CHITEST

	A	B	C	D	E	F	G	H
612	1.0	=CHITEST( C612:E612, F612:H612 )	1.0	1.0	1.0	1.0	1.0	1.0
613	0.015888560447750184	...	58.0	11.0	10.0	45.35	17.56	16.09
614	1.0	...	1.0	1.0	1.0	1.0	1.0	1.0
615	0.10539922456626115	...	12.0	3.0	4.0	18.0	2.0	2.0
616	0.07047338213403015	...	4.0	0.0	10.0	2.0	1.0	16.09
617	0.05030575984901521	...	58.0	11.0	10.0	45.35	17.56	10.0
618	0.05030575984901521	...	58.0	11.0	10.0	45.35	17.56	10.0
619	0.4356234202769099	...	12345.0	12345.0	32345.0	12312.0	12323.0	32123.0
620	0.3672008481173127	...	-11.0	17.0	10.32	-12.0	17.56	16.09
621	!NaN/AE	...	1.0	1.0	1.0	1.0	0.0	1.0		Excel says: #DIV/0!
623	!NA	=CHITEST( C623, D623 )	14.0	11.0		Excel says: #N/A
624	0.09871452354038054	=CHITEST( C624:D624, E624:F624 )	58.0	11.0	48.0	14.0
625	0.42541284832120996	=CHITEST( C625:F625, C626:D627 )	55.0	12.0	48.0	14.0
626	!NA	=CHITEST( C626:E626, F626:G626 )	58.0	11.0	10.0	45.35	17.56		Excel says: #N/A
627	0.01073954491118552	=CHITEST( C627:E628, F627:H628 )	58.0	11.0	10.0	45.35	17.56	16.09
628	!NA	=CHITEST( C627:E628, F627:G628 )	2.0	3.0	4.0	3.0	4.0	5.0		Excel says: #N/A

FTEST

	A	B	C	D	E	F	G	H
630	0.4374999999989781	=FTEST( C630:E630, F630:H630 )	2.2	2.0	3.0	4.0	5.0	6.0
631	0.849508257559715	...	-2.0	2.0	3.3	0.0	5.0	6.0
632	0.6999999999983649	...	0.0	1.0	3.0	-1.0	3.0	0.0
633	0.4510117372358122	...	2210.0	2131.0	1232.0	1233.0	3243.0	2133.0
634	0.5999999999985984	...	5.0	4.0	3.0	5.0	3.0	2.0
635	2.4691358021585335E-10	...	10000.0	10000.0	100000.0	1.0	1.0	2.0
636	0.9999999999976641	...	1.0	5.0	2.0	1.0	5.0	2.0
637	0.4374999999989781	...	2.2	2.0	3.0	4.0	5.0	6.0
638	!FE	...	2.0	2.0	3.0	3.0	3.0	3.0		Excel says: #DIV/0!
640	!FE	=FTEST( C640, D640:H640 )	2.2	2.0	3.0	4.0	5.0	6.0		Excel says: #DIV/0!
641	0.1606255430235463	=FTEST( C641:D641, E641:H641 )	2.2	2.0	3.0	4.0	5.0	6.0
642	0.6263943592109936	=FTEST( C642:E642, F642:G642 )	2.2	2.0	3.0	4.0	5.0

STANDARDIZE

	A	B	C	D	E
644	1.3333333333333333	=STANDARDIZE( C644, D644, E644 )	42.0	40.0	1.5
645	-1.04	...	1.2	3.8	2.5
646	0.8103727714748784	...	3000.0	2000.0	1234.0
647	0.0	...	0.0	0.0	1.0
648	-1.3333333333333333	...	-1.0	3.0	3.0
649	!FE	...	42.0	40.0	0.0		Excel says: #NUM!
650	!FE	...	42.0	40.0	-1.0		Excel says: #NUM!

GAMMALN

	A	B	C
652	1.524063822508502	=GAMMALN( C652 )	0.2
653	-0.049872441306312076	...	1.1
654	-4.171596401647548E-11	...	1.0
655	0.005854806806903181	...	0.99
656	!FE	...	-1.0		Excel says: #NUM!
657	!FE	...	0.0		Excel says: #NUM!

EXPONDIST

	A	B	C	D	E
659	0.8646647167633873	=EXPONDIST( C659, D659, E659 )	1.0	2.0	true
660	0.2706705664732254	...	1.0	2.0	false
661	0.81362602396059	...	14.0	0.12	true
662	0.022364877124729197	...	14.0	0.12	false
663	0.9901767180337184	...	1.34	3.45	true
664	0.03389032278367159	...	1.34	3.45	false
665	0.7695220309333644	...	1223.0	0.0012	true
666	2.765735628799628E-4	...	1223.0	0.0012	false
667	0.19562755841064988	...	1.1	2.2	false
668	!FE	...	-0.01	2.2	false		Excel says: #NUM!
669	!FE	...	1.1	0.0	false		Excel says: #NUM!

WEIBULL

	A	B	C	D	E	F
671	0.6321205588285577	=WEIBULL( C671, D671, E671, F671 )	1.0	1.0	1.0	true
672	0.0	...	0.0	21.0	321.0	false
673	0.10516068318563021	...	1.0	2.0	3.0	true
674	0.1293998029923359	...	1.1	2.2	3.7	false
675	0.10516068318563021	...	1.0	2.0	3.0	true
676	0.1293998029923359	...	1.1	2.2	3.7	false
677	0.929581390069277	...	105.0	20.0	100.0	true
678	!FE	...	102.0	0.0	100.0	false		Excel says: #NUM!
679	!FE	...	105.0	20.0	-1.0	true		Excel says: #NUM!
680	!FE	...	-0.01	30.0	100.0	false		Excel says: #NUM!

FISHER

	A	B	C
682	0.8673005276940532	=FISHER( C682 )	0.7
683	0.0	...	0.0
684	3.8002011672502	...	0.999
685	0.010000333353334718	...	0.01
686	0.5493061443340549	...	0.5
687	-0.5493061443340549	...	-0.5
688	0.2384170173623709	...	0.234
689	!FE	...	1.0		Excel says: #NUM!
690	!FE	...	1.2		Excel says: #NUM!
691	!FE	...	-1.0		Excel says: #NUM!

SUMX2MY2

	A	B	C	D	E	F	G	H
693	12.0	=SUMX2MY2( C693:E693, F693:H693 )	2.0	3.0	4.0	2.0	2.0	3.0
694	9.96	...	2.2	-3.4	4.0	2.0	2.0	3.8
696	!NA	=SUMX2MY2( C696:E696, F696:G696 )	2.0	3.0	4.0	2.0	2.0		Excel says: #N/A

SUMX2PY2

	A	B	C	D	E	F	G	H
698	46.0	=SUMX2PY2( C698:E698, F698:H698 )	2.0	3.0	4.0	2.0	2.0	3.0
699	54.84	...	2.2	-3.4	4.0	2.0	2.0	3.8
701	!NA	=SUMX2PY2( C701:E701, F701:G701 )	2.0	3.0	4.0	2.0	2.0		Excel says: #N/A

SUMXMY2

	A	B	C	D	E	F	G	H
703	2.0	=SUMXMY2( C703:E703, F703:H703 )	2.0	3.0	4.0	2.0	2.0	3.0
704	29.24	...	2.2	-3.4	4.0	2.0	2.0	3.8
706	!NA	=SUMXMY2( C706:E706, F706:G706 )	2.0	3.0	4.0	2.0	2.0		Excel says: #N/A

STDEVPA

	A	B	C	D	E	F	G	H
708	0.0	=STDEVPA( C708 )	2.3
710	1.4142135623730951	=STDEVPA( C710:F710 )	2.0	2.0	0.0	4.0
711	0.0	...	0.0	0.0	0.0	0.0
712	2.5664907948403006	...	-2.3	3.4	0.0	4.0
714	1.3844373104863459	=STDEVPA( C714:H714 )	2.0	3.0	0.0	4.0	2.0	4.0
715	1.4907119849998598	...	2.0	3.0	false	4.0	true	4.0

STEYX

	A	B	C	D	E	F	G	H	I
717	0.46291004988627565	=STEYX( C717:E717, F717:H717 )	4.0	5.0	3.0	4.0	3.0	8.0
718	2.5495097567963927	...	1.0	2.0	5.0	6.0	2.0	3.0
719	0.5715476066494084	...	4.0	4.2	3.0	0.0	3.0	6.0
720	5.637745352698231	...	3.0	2.0	-5.0	6.0	2.1	3.0
721	0.8819620983110001	...	4.1	3.0	3.0	4.0	3.0	6.0
722	1.683745824048273	...	4.1	3.0	0.0	4.0	3.0	6.0
723	4.439209645700573	...	4.1	-3.4	3.0	3.9	3.0	6.0
724	!NaN/AE	...	4.1	3.0	3.0	4.0	4.0	4.0		Excel says: #DIV/0!
725	0.0	...	3.0	3.0	3.0	4.0	3.0	6.0
727	!NA	=STEYX( C727:E727, F727:G727 )	4.1	3.0	3.0	4.0	3.0		Excel says: #N/A
728	!FE	=STEYX( C728, D728 )	4.1	3.0		Excel says: #DIV/0!
730	3.305718950210041	=STEYX( C730:I730, C731:I731 )	2.0	3.0	9.0	1.0	8.0	7.0	5.0	7.0
731	3.81051177665153	=STEYX( C730:E731, F730:H731 )	6.0	5.0	11.0	7.0	5.0	4.0	4.0	7.0

CORREL

	A	B	C	D	E	F	G	H	I
734	-0.9449111825230679	=CORREL( C734:E734, F734:H734 )	4.0	5.0	3.0	4.0	3.0	8.0
735	0.05241424183609594	...	3.0	2.0	5.0	6.0	2.0	3.0
736	-0.7777137710478189	...	4.0	4.2	3.0	0.0	3.0	6.0
737	0.4044433256155759	...	3.0	2.0	-5.0	6.0	2.1	3.0
738	-0.18898223650461365	...	4.1	3.0	3.0	4.0	3.0	6.0
739	-0.8277881133609988	...	4.1	3.0	0.0	4.0	3.0	6.0
740	0.6319111138501405	...	4.1	-3.4	3.0	3.9	3.0	6.0
741	!NaN/AE	...	4.1	3.0	3.0	4.0	4.0	4.0		Excel says: #DIV/0!
742	!NaN/AE	...	3.0	3.0	3.0	4.0	3.0	6.0		Excel says: #DIV/0!
744	!NA	=CORREL( C744:E744, F744:G744 )	4.1	3.0	3.0	4.0	3.0		Excel says: #N/A
745	!NaN/AE	=CORREL( C745, D745 )	4.1	3.0		Excel says: #DIV/0!
747	0.24072846024282468	=CORREL( C747:I747, C748:I748 )	2.0	3.0	9.0	1.0	8.0	7.0	5.0	7.0
748	0.1788854381999832	=CORREL( C747:E748, F747:H748 )	6.0	5.0	11.0	7.0	5.0	4.0	4.0	7.0

INTERCEPT

	A	B	C	D	E	F	G	H	I
750	5.4	=INTERCEPT( C750:E750, F750:H750 )	4.0	5.0	3.0	3.0	3.0	8.0
751	-3.1942446043165464	...	3.0	2.0	-5.0	6.0	2.1	3.0
752	3.7071428571428573	...	4.1	3.0	3.0	4.0	3.0	6.0
753	7.35	...	4.1	3.0	0.0	4.0	3.0	6.0
754	-5.91518987341772	...	4.1	-3.4	3.0	3.9	3.0	6.0
755	!NaN/AE	...	4.1	3.0	3.0	4.0	4.0	4.0		Excel says: #DIV/0!
756	3.0	...	3.0	3.0	3.0	4.0	3.0	6.0
758	!NA	=INTERCEPT( C758:E758, F758:G758 )	4.1	3.0	3.0	4.0	3.0		Excel says: #N/A
759	!NaN/AE	=INTERCEPT( C759, D759 )	4.1	3.0		Excel says: #DIV/0!
761	3.1666666666666665	=INTERCEPT( C761:I761, C762:I762 )	2.0	3.0	9.0	1.0	8.0	7.0	5.0	7.0
762	4.72	=INTERCEPT( C761:E762, F761:H762 )	6.0	5.0	11.0	7.0	5.0	4.0	4.0	7.0

SLOPE

	A	B	C	D	E	F	G	H	I
764	-0.3	=SLOPE( C764:E764, F764:H764 )	4.0	5.0	3.0	3.0	3.0	8.0
765	0.8633093525179856	...	3.0	2.0	-5.0	6.0	2.1	3.0
766	-0.07857142857142857	...	4.1	3.0	3.0	4.0	3.0	6.0
767	-1.15	...	4.1	3.0	0.0	4.0	3.0	6.0
768	1.662447257383966	...	4.1	-3.4	3.0	3.9	3.0	6.0
769	!NaN/AE	...	4.1	3.0	3.0	4.0	4.0	4.0		Excel says: #DIV/0!
770	0.0	...	3.0	3.0	3.0	4.0	3.0	6.0
772	!NA	=SLOPE( C772:E772, F772:G772 )	4.1	3.0	3.0	4.0	3.0		Excel says: #N/A
774	0.3055555555555556	=SLOPE( C774:I774, C775:I775 )	2.0	3.0	9.0	1.0	8.0	7.0	5.0	7.0
775	0.24	=SLOPE( C774:E775, F774:H775 )	6.0	5.0	11.0	7.0	5.0	4.0	4.0	7.0

PROB

	A	B	C	D	E	F	G	H
777	1.0	=PROB( C777:D777, E777:F777, G777, H777 )	2.0	3.0	0.3	0.7	2.0	3.0
778	0.2	...	3.0	2.0	0.2	0.8	2.1	3.0
779	0.0	...	3.0	2.0	0.2	0.8	3.0	2.0
780	0.25	...	3.0	2.0	0.25	0.75	2.1	3.0
781	0.2	...	3.0	2.0	0.2	0.8	3.0	7.0
782	0.2	...	-2.3	5.6	0.2	0.8	-10.0	3.0
783	1.0	...	4.1	3.0	0.4	0.6	3.0	6.0
784	-0.2	...	2.0	3.0	1.2	-0.2	3.0	6.0
785	!FE	...	4.1	3.0	0.5	0.6	3.0	6.0		Excel says: #NUM!
787	0.1	=PROB( C787:D788, E787:F788, G787 )	0.0	1.0	0.2	0.3	2.0
788	!NA	=PROB( C788:D788, E787:F788, G788, H788 )	2.0	3.0	0.1	0.4	1.0	3.0		Excel says: #N/A

CRITBINOM

	A	B	C	D	E
790	0.0	=CRITBINOM( C790, D790, E790 )	0.0	0.3	0.75
791	1.0	...	1.0	0.3	0.75
792	1.0	...	3.0	0.3	0.75
793	1.0	...	3.9	0.3	0.75
794	2.0	...	4.0	0.3	0.75
795	310.0	...	1000.0	0.3	0.75
796	0.0	...	10.0	0.0010	0.75
797	10.0	...	10.0	0.999	0.75
798	0.0	...	10.0	0.3	0.0010
799	8.0	...	10.0	0.3	0.999
800	0.0	...	10.0	0.0	0.75		Excel says: #NUM!
801	10.0	...	10.0	1.0	0.75		Excel says: #NUM!
802	!FE	...	10.0	0.3	0.0		Excel says: #NUM!
803	!FE	...	10.0	0.3	1.0		Excel says: #NUM!
804	!FE	...	10.0	-0.0010	0.75		Excel says: #NUM!
805	!FE	...	10.0	1.001	0.75		Excel says: #NUM!
806	!FE	...	-1.0	0.3	0.75		Excel says: #NUM!
807	!FE	...	1.0E10	0.3	0.75		Excel says: #NUM!

PERCENTRANK

	A	B	C	D	E	F	G	H	I
809	0.5	=PERCENTRANK( C809:E809, F809 )	1.0	2.0	4.0	2.0
810	0.0	...	1.0	2.0	6.0	1.0
811	0.5	...	1.0	2.2	6.23	2.2
812	1.0	...	1.0	2.0	6.0	6.0
813	0.75	...	1.0	2.0	4.0	3.0
814	0.625	...	1.0	2.0	6.0	3.0
815	0.821	...	-2.4	-3.4	6.0	3.0
816	!NA	...	1.0	2.0	6.0	7.0		Excel says: #N/A
817	!NA	...	1.0	2.0	6.0	0.0		Excel says: #N/A
819	0.821	=PERCENTRANK( C819:E819, F819, G819 )	-2.4	-3.4	6.0	3.0	3.0
820	0.82142	...	-2.4	-3.4	6.0	3.0	5.0
821	0.821428	...	-2.4	-3.4	6.0	3.0	6.0
822	!FE	...	-2.4	-3.4	6.0	3.0	0.99		Excel says: #NUM!
824	0.4	=PERCENTRANK( C824:H824, I824 )	1.0	2.0	3.0	4.0	5.0	6.0	3.0	7.0
825	0.4	...	1.0	1.0	4.0	4.0	2.0	2.0	2.0	7.0
826	0.8	...	1.0	1.0	4.0	4.0	2.0	2.0	4.0	7.0
827	0.7	...	1.0	1.0	4.0	4.0	2.0	2.0	3.0	7.0
829	1.0	=PERCENTRANK( C829, D829 )	2.0	2.0
830	!NA	...	2.0	3.0		Excel says: #N/A

MODE

	A	B	C	D	E	F	G	H	I
832	2.0	=MODE( C832:G832 )	1.0	2.0	2.0	4.0	5.0
833	5.0	...	2.0	5.0	3.0	4.0	5.0
834	2.0	...	2.0	2.0	1.0	1.0	4.0
836	2.0	=MODE( C836:I836 )	1.0	1.0	4.0	4.0	2.0	2.0	2.0	7.0
837	3.0	...	2.0	2.0	4.0	3.0	3.0	3.0	4.0	7.0
838	5.0	...	1.0	5.0	3.0	4.0	5.0	2.0	3.0	7.0
839	2.0	...	1.0	7.0	3.0	4.0	5.0	2.0	2.0	7.0
840	!NA	...	1.0	2.0	3.0	4.0	5.0	6.0	7.0	7.0	Excel says: #N/A
842	!NA	=MODE( C842 )	2.0		Excel says: #N/A

TRIMMEAN

	A	B	C	D	E	F	G	H	I
844	3.0	=TRIMMEAN( C844:G844, H844 )	1.0	2.0	3.0	4.0	5.0	0.5
845	4.0	...	5.0	2.0	3.0	4.0	5.0	0.5
846	3.0	...	1.0	2.0	3.0	4.0	5.0	0.2
847	3.0	...	1.0	2.0	3.0	4.0	5.0	0.0
848	3.0	...	1.0	2.0	3.0	4.0	5.0	0.4
850	2.433333333333333	=TRIMMEAN( C850:H850, I850 )	2.2	-1.0	3.4	5.0	4.0	1.0	0.1	7.0
851	2.65	...	2.2	-1.0	3.4	5.0	4.0	1.0	0.6	7.0
852	!FE	...	2.2	-1.0	3.4	5.0	4.0	1.0	1.0	7.0	Excel says: #NUM!
853	!FE	...	2.2	-1.0	3.4	5.0	4.0	1.0	-0.01	7.0	Excel says: #NUM!
855	1.0	=TRIMMEAN( C855, D855 )	1.0	0.5

QUARTILE

	A	B	C	D	E	F	G	H	I
857	1.0	=QUARTILE( C857:G857, H857 )	1.0	2.0	3.0	4.0	5.0	0.0
858	3.0	...	5.0	2.0	3.0	4.0	5.0	1.0
859	3.0	...	1.0	2.0	3.0	4.0	5.0	2.0
860	5.0	...	1.0	2.0	3.0	4.0	5.0	4.5
861	!FE	...	1.0	2.0	3.0	4.0	5.0	5.0		Excel says: #NUM!
862	!FE	...	1.0	2.0	3.0	4.0	5.0	-0.01		Excel says: #NUM!
864	1.3	=QUARTILE( C864:H864, I864 )	2.2	-1.0	3.4	5.0	4.0	1.0	1.0	7.0
865	2.8	...	2.2	-1.0	3.4	5.0	4.0	1.0	2.0	7.0

PERCENTILE

	A	B	C	D	E	F	G	H
867	3.0	=PERCENTILE( C867:G867, H867 )	1.0	2.0	3.0	4.0	5.0	0.5
868	4.0	...	5.0	2.0	3.0	4.0	5.0	0.5
869	1.8	...	1.0	2.0	3.0	4.0	5.0	0.2
870	1.0	...	1.0	2.0	3.0	4.0	5.0	0.0
871	5.0	...	1.0	2.0	3.0	4.0	5.0	1.0
872	2.2	...	2.2	-1.0	3.4	5.0	4.0	0.25
873	!FE	...	2.2	-1.0	3.4	5.0	4.0	-0.01		Excel says: #NUM!
874	!FE	...	2.2	-1.0	3.4	5.0	4.0	1.1		Excel says: #NUM!

MEDIAN

	A	B	C	D	E	F	G	H
876	3.0	=MEDIAN( C876:G876 )	1.0	2.0	3.0	4.0	5.0
877	4.0	...	5.0	2.0	3.0	4.0	5.0
878	3.0	...	2.0	1.0	3.0	5.0	4.0
880	2.0	=MEDIAN( C880 )	2.0
882	2.7	=MEDIAN( C882:H882 )	2.0	1.1	3.4	5.0	4.0	2.0
883	3.5	...	5.0	2.0	3.0	4.0	5.0	1.0
884	3.5	...	5.0	2.0	3.0	4.0	5.0	2.0
885	0.5	...	-5.0	-2.0	-4.0	4.0	5.0	3.0
886	0.0	...	-5.0	-2.0	-4.0	4.0	5.0	2.0

SMALL

	A	B	C	D	E	F	G	H
888	5.0	=SMALL( C888:G888, H888 )	5.0	2.0	3.0	4.0	5.0	4.0
889	5.0	...	1.0	2.0	3.0	4.0	5.0	5.0
890	1.0	...	2.0	1.0	3.0	5.0	4.0	1.0
891	2.0	...	2.0	1.0	3.0	5.0	4.0	2.0
892	2.0	...	5.0	2.0	3.0	4.0	5.0	1.0
893	3.0	...	5.0	2.0	3.0	4.0	5.0	2.0
894	4.0	...	5.0	2.0	4.0	4.0	5.0	3.0
895	4.0	...	5.0	2.0	4.0	4.0	5.0	2.0
897	2.2	=SMALL( C897:F897, G897 )	5.0	2.2	4.0	4.0	1.0
898	!FE	...	5.0	2.0	4.0	4.0	0.0		Excel says: #NUM!
900	-2.0	=SMALL( C900:E900, F900 )	5.0	-2.0	-4.0	2.0
901	!FE	...	5.0	2.0	4.0	4.0		Excel says: #NUM!
903	5.0	=SMALL( C903, D903 )	5.0	1.0

LARGE

	A	B	C	D	E	F	G	H
905	5.0	=LARGE( C905:G905, H905 )	5.0	2.0	3.0	4.0	5.0	2.0
906	5.0	...	1.0	2.0	3.0	4.0	5.0	1.0
907	5.0	...	2.0	1.0	3.0	5.0	4.0	1.0
908	4.0	...	2.0	1.0	3.0	5.0	4.0	2.0
909	5.0	...	5.0	2.0	3.0	4.0	5.0	1.0
910	5.0	...	5.0	2.0	3.0	4.0	5.0	2.0
911	4.0	...	5.0	2.0	4.0	4.0	5.0	3.0
912	4.0	...	5.0	2.0	4.0	4.0	5.0	4.0
914	2.2	=LARGE( C914:F914, G914 )	5.0	2.2	4.0	4.0	4.0
915	!FE	...	5.0	2.0	4.0	4.0	0.0		Excel says: #NUM!
917	-2.0	=LARGE( C917:E917, F917 )	5.0	-2.0	-4.0	2.0
918	!FE	...	5.0	2.0	4.0	4.0		Excel says: #NUM!

FORECAST

	A	B	C	D	E	F	G	H	I
920	1.0	=FORECAST( C920, D920:F920, G920:I920 )	3.0	1.0	1.0	1.0	3.0	8.0	9.0	7.0
921	2.0	...	2.0	1.0	2.0	3.0	1.0	2.0	3.0	7.0
922	5.0	...	5.0	1.0	2.0	3.0	1.0	2.0	3.0	7.0
923	4.0	...	2.0	2.0	4.0	6.0	1.0	2.0	3.0	7.0
924	-5.9	...	-2.0	2.3	4.0	6.0	1.5	2.0	3.0	7.0
925	4.5769230769230775	...	2.0	1.0	4.3	6.0	-1.0	2.0	3.0	7.0
926	8.354838709677422	...	1.0	7.0	3.0	3.0	3.0	8.0	9.0	7.0
927	5.322580645161291	...	2.0	5.0	3.0	3.0	3.0	8.0	9.0	7.0
928	-4.250830564784051	...	3.0	2.0	-5.0	6.0	2.1	3.0	1.0	7.0
929	-0.105	...	4.1	3.0	-3.3	4.0	3.0	6.0	0.0	7.0
931	7.0	=FORECAST( C931, D931:E931, F931:G931 )	2.0	5.0	3.0	3.0	4.0
932	!NaN/AE	...	2.0	5.0	3.0	3.0	3.0		Excel says: #DIV/0!
933	!NA	=FORECAST( C933, D933:E933, F933:H933 )	2.0	5.0	3.0	3.0	4.0	4.0		Excel says: #N/A

VARA

	A	B	C	D	E	F	G	H	I
935	0.5	=VARA( C935, D935 )	1.0	2.0
936	46.08	...	4.3	-5.3
938	!NaN/AE	=VARA( C938 )	4.3		Excel says: #DIV/0!
940	8.5	=VARA( C940:E940, G940, I940 )	1.0	2.0	0.0	100.0	5.0	200.0	7.0	7.0
941	8.5	...	true	2.0	false	100.0	5.0	200.0	7.0	7.0