Apple iWork '09 Manual de usuario Pagina 251
- Pagina / 372
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 10 Statistical Functions 251
Example
In this example, the COVAR function is used to determine how closely related the price of heating oil
(column A) is to the temperature that this hypothetical homeowner has set on the thermostat.
=COVAR(A2:A11, B2:B11) evaluates to approximately -1.6202, indicating a correlation (as prices rose,
the thermostat was lowered).
Related Topics
For related functions and additional information, see:
“CORREL” on page 242
“Survey Results Example” on page 362
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
- Formulas and 1
- Functions User Guide 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- Chapter 8: Numeric Functions 6
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- Chapter 11: Text Functions 10
- Contents 11 11
- Functions 13
- Using Formulas in Tables 15
- Creating Your Own Formulas 19
- Adding Functions to Formulas 21
- Removing Formulas 24
- Using Operators in Formulas 28
- The Comparison Operators 29
- An Introduction to Functions 33
- Information About Functions 34
- Value Types 36
- Pasting from Examples in Help 41
- Date and Time Functions 42
- DATEVALUE 47
- MONTHNAME 54
- NETWORKDAYS 54
- TIMEVALUE 57
- YEARFRAC 63
- Duration Functions 64
- DUR2DAYS 65
- DUR2HOURS 65
- DUR2MILLISECONDS 66
- DUR2MINUTES 67
- DUR2SECONDS 68
- DUR2WEEKS 69
- DURATION 70
- STRIPDURATION 71
- Engineering Functions 72
- BASETONUM 73
- =BIN2DEC(”1001”) returns 9 76
- =BIN2DEC(101101) returns 45 76
- =BIN2HEX(101101) returns 2D 77
- =BIN2OCT(”10011”) returns 23 78
- Supported Conversion Units 80
- Pressure 81
- Magnetism 82
- Temperature 82
- Metricprexes 83
- =DEC2OCT(100) returns 144 85
- =HEX2DEC(”F”, 3) returns 015 90
- =HEX2DEC(“3F”) returns 63 90
- =HEX2OCT(”F”, 3) returns 017 91
- =HEX2OCT(“4E”) returns 116 91
- NUMTOBASE 92
- =OCT2BIN(15) returns 01101 93
- =OCT2DEC(127,4) returns 0087 94
- =OCT2DEC(15) returns 13 94
- =OCT2HEX(127,4) returns 0057 95
- =OCT2HEX(15) returns 0D 95
- Financial Functions 96
- ACCRINTM 101
- BONDDURATION 103
- BONDMDURATION 104
- COUPDAYBS 105
- COUPDAYS 107
- COUPDAYSNC 108
- CUMPRINC 112
- =NPER(B2, C2, D2 132
- =0.07/12 -1500 170000 0 1 132
- PRICEDISC 138
- PRICEMAT 140
- RECEIVED 146
- YIELDDISC 152
- YIELDMAT 153
- Examples 157
- =ISEVEN(2) returns TRUE 162
- =ISEVEN(2.75) returns TRUE 162
- =ISEVEN(3) returns FALSE 162
- =ISODD(3) returns TRUE 163
- =ISODD(3.75) returns TRUE 163
- =ISODD(2) returns FALSE 163
- Numeric Functions 167
- FACTDOUBLE 175
- =GCD(8, 10) returns 2 177
- =GCD(99, 102, 105) returns 3 177
- =GCD(34, 51) returns 17 177
- MULTINOMIAL 184
- QUOTIENT 188
- RANDBETWEEN 189
- ROUNDDOWN 192
- SUMPRODUCT 200
- SUMX2MY2 202
- SUMX2PY2 203
- Reference Functions 206
- HYPERLINK 213
- Â row-index can’t be 215
- INDIRECT 216
- TRANSPOSE 222
- Statistical Functions 225
- AVERAGEA 232
- AVERAGEIF 233
- AVERAGEIFS 234
- BETADIST 236
- BINOMDIST 238
- CONFIDENCE 242
- COUNTBLANK 246
- COUNTIFS 248
- CRITBINOM 252
- EXPONDIST 253
- FORECAST 256
- FREQUENCY 257
- GAMMADIST 259
- GAMMAINV 260
- INTERCEPT 262
- Additional Statistics 267
- LOGNORMDIST 269
- =MAXA(1, 2, 3, 4) returns 4 271
- =MINA(1, 2, 3, 4) returns 1 273
- NEGBINOMDIST 275
- NORMDIST 276
- NORMSDIST 277
- NORMSINV 278
- PERCENTILE 279
- PERCENTRANK 280
- =PERMUT(10, 3) returns 720 281
- =PERMUT(5, 2) returns 20 281
- QUARTILE 284
- STANDARDIZE 289
- Text Functions 306
- =CODE(”b”) returns 98 308
- CONCATENATE 310
- “n” in “on”) 313
- =LEN(”12345”) returns 5 315
- SUBSTITUTE 322
- Trigonometric Functions 326
- =ACOSH(COSH(5)) returns 5 328
- =ATANH(TANH(2)) returns 2 332
- =TAN(3*PI()/4) returns -1 338
- Questions? 351
- More on Rounding 355
- Trapping Division by Zero 360
- Survey Results Example 362
- 366 Index 366
- Index 367 367
- 368 Index 368
- Index 369 369
- 370 Index 370
- Index 371 371
- 372 Index 372
Relacionado con productos y manuales para Software Apple iWork '09
Software Apple Macintosh System 7.5 Manual de usuario
(114 paginas)
(114 paginas)
Software Apple Keynote '08 Manual de usuario
(230 paginas)
(230 paginas)
Software Apple DVD Studio Pro 4 Manual de usuario
(777 paginas)
(777 paginas)
Software Apple LiveType 2 Manual de usuario
(157 paginas)
(157 paginas)
Software Apple Pages '09 Manual de usuario
(324 paginas)
(324 paginas)
Software Apple Mac OS X 10.2 Manual de usuario
(21 paginas)
(21 paginas)
Software Apple iDVD '08 Manual de usuario
(36 paginas)
(36 paginas)
(14 paginas)
(15 paginas)
Software Apple Logic Express 7 Manual de usuario
(522 paginas)
(522 paginas)
Software Apple Motion 2 Tutorials Manual de usuario
(235 paginas)
(235 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.058 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales