Apple iWork '09 Bedienungsanleitung Seite 202
- Seite / 372
- Inhaltsverzeichnis
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
SUMX2MY2
The SUMX2MY2 function returns the sum of the dierence of the squares of
corresponding values in two collections.
SUMX2MY2(set-1-values, set-2-values)
 set-1-values: The rst collection of values. set-1-values is a collection containing
number values.
 set-2-values: The second collection of values. set-2-values is a collection containing
number values.
Example
Given the following table:
=SUMX2MY2(A1:A6,B1:B6) returns –158, the sum of the dierences of the squares of the values in
column A and the squares of the values in column B. The formula for the rst such dierence is A1
2
–
B1
2
.
Related Topics
For related functions and additional information, see:
“Listing of Numeric Functions” on page 167
“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
202 Chapter 8 Numeric Functions
- 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
Verwandte Produkte und Handbücher für Software Apple iWork '09
Software Apple Keynote '08 Bedienungsanleitung
(230 Seiten)
(230 Seiten)
Software Apple DVD Studio Pro 4 Bedienungsanleitung
(777 Seiten)
(777 Seiten)
Software Apple LiveType 2 Bedienungsanleitung
(157 Seiten)
(157 Seiten)
Software Apple Pages '09 Bedienungsanleitung
(324 Seiten)
(324 Seiten)
Software Apple Mac OS X 10.2 Bedienungsanleitung
(21 Seiten)
(21 Seiten)
Software Apple iDVD '08 Bedienungsanleitung
(36 Seiten)
(36 Seiten)
(14 Seiten)
(15 Seiten)
Software Apple Logic Express 7 Bedienungsanleitung
(522 Seiten)
(522 Seiten)
© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.056 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern