Home | Quick Start | Documentation | Download | Support | Contribute

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

 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!

 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!

 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