Owner manual

Index 371
COVAR 250, 364
CRITBINOM 252
DEVSQ 253
EXPONDIST 253
FDIST 254
FINV 255
FORECAST 256
FREQUENCY 257
GAMMADIST 259
GAMMAINV 260
GAMMALN 260
GEOMEAN 261
HARMEAN 262
INTERCEPT 262
LARGE 264
LINEST 265
LOGINV 268
LOGNORMDIST 269
MAX 270
MAXA 270
MEDIAN 271
MIN 272
MINA 273
MODE 274
NEGBINOMDIST 275
NORMDIST 276
NORMINV 277
NORMSDIST 277
NORMSINV 278
PERCENTILE 279
PERCENTRANK 280
PERMUT 281
POISSON 282
PROB 282
QUARTILE 284
RANK 285
SLOPE 287
SMALL 288
STANDARDIZE 289
STDEV 290, 364
STDEVA 291
STDEVP 293, 364
STDEVPA 294
TDIST 296
TINV 297
TTEST 297
VAR 298, 364
VARA 300
VARP 302, 364
VARPA 303
ZTEST 305
STDEV statistical function 290, 364
STDEVA statistical function 291
STDEVP statistical function 293, 364
STDEVPA statistical function 294
string operator 30
string value type 39
STRIPDURATION duration function 71
SUBSTITUTE text function 322
SUM numeric function 19 6
SUMIF mathematical function 360
SUMIF numeric function 197, 361
SUMIFS numeric function 19 8, 360
SUMPRODUCT numeric function 200
SUMSQ numeric function 201
SUMX2MY2 numeric function 202
SUMX2PY2 numeric function 203
SUMXMY2 numeric function 204
survey results example 362
SYD nancial function 148, 352
syntax elements used in function denitions 34
T
T text function 323
table spanning formulas 39
TAN trigonometric function 338
TANH trigonometric function 339
TDIST statistical function 296
temperature conversion units 82
text function
CHAR 308
CLEAN 308
CODE 309
CONCATENATE 310
DOLLAR 311
EXACT 312
FIND 312
FIXED 313
LEFT 314
LEN 315
LOWER 316
MID 316
PROPER 317
REPLACE 318
REPT 319
RIGHT 319
SEARCH 320
SUBSTITUTE 322
T 323
TRIM 323
UPPER 324
VALUE 325
tilde wildcard escape character 30, 361
TIME date and time function 56
TIMEVALUE date and time function 57
TINV statistical function 297
TODAY date and time function 58
TRANSPOSE reference function 222
trapping division by zero 360
trigonometric function
ACOS 327
ACOSH 328