Difference between revisions of "Documentation/How Tos/Calc: SUMX2MY2 function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
(13 intermediate revisions by 7 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:SUMX2MY2 function}} |
+ | {{Documentation/CalcFunc ArraysTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_SUMPRODUCT_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_SUMX2PY2_function | ||
+ | }}__NOTOC__ | ||
== SUMX2MY2 == | == SUMX2MY2 == | ||
Line 6: | Line 11: | ||
=== Syntax: === | === Syntax: === | ||
<tt>'''SUMX2MY2(x; y)'''</tt> | <tt>'''SUMX2MY2(x; y)'''</tt> | ||
− | : <tt>'''x'''</tt> and <tt>'''y'''</tt> are arrays or ranges of the same size. <tt>'''SUMX2MY2'''</tt> calculates [[Image:Calc_sumx2my2_equation.png]] for the <i>i</i> elements in the arrays. | + | : <tt>'''x'''</tt> and <tt>'''y'''</tt> are arrays or ranges of the same size. <tt>'''SUMX2MY2'''</tt> calculates [[Image:Calc_sumx2my2_equation.png]] for the <i>i</i> elements in the arrays. |
+ | |||
+ | :<i>Advanced topic:</i> | ||
+ | |||
+ | :<tt>'''SUMX2MY2'''</tt> evaluates its parameters <tt>'''x'''</tt> and <tt>'''y'''</tt> as [[Documentation/How_Tos/Using Arrays|array formulas]] but does not need to be entered as an array formula. In other words, it can be entered with the {{key|Enter}} key, rather than {{key|Cntrl|Shift|Enter}}. See the example below. | ||
=== Example: === | === Example: === | ||
Line 12: | Line 21: | ||
:where cells A1 and A2 contain <tt>'''4'''</tt> and <tt>'''3'''</tt> respectively, returns (4<sup>2</sup>-2<sup>2</sup>) + (3<sup>2</sup>-1<sup>2</sup>) = <tt>'''20'''</tt>. | :where cells A1 and A2 contain <tt>'''4'''</tt> and <tt>'''3'''</tt> respectively, returns (4<sup>2</sup>-2<sup>2</sup>) + (3<sup>2</sup>-1<sup>2</sup>) = <tt>'''20'''</tt>. | ||
− | + | <i>Advanced topic:</i> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | + | ||
− | [[Documentation/How_Tos/Using Arrays|''' | + | <tt>'''SUMX2MY2(A1:A2+1; {2|1})'''</tt> |
+ | :when entered 'normally' (not as an [[Documentation/How_Tos/Using Arrays|array formula]]), and where cells A1 and A2 contain <tt>'''3'''</tt> and <tt>'''2'''</tt> respectively, returns ((3+1)<sup>2</sup>-2<sup>2</sup>) + ((2+1)<sup>2</sup>-1<sup>2</sup>) = <tt>'''20'''</tt>. <tt>'''SUMX2MY2'''</tt> forces <tt>'''(A1:A2+1)'''</tt> to be evaluated as an [[Documentation/How_Tos/Using Arrays|array formula]] (internally returning the array {4|3}). | ||
− | [[Documentation/How_Tos/Calc: Array functions| | + | {{SeeAlso|EN| |
+ | * [[Documentation/How_Tos/Calc: SUM function|SUM]] | ||
+ | * [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]] | ||
+ | * [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]] | ||
+ | * [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]] | ||
+ | * [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]] | ||
+ | * [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]] | ||
+ | * [[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]] | ||
+ | * [[Documentation/How_Tos/Using Arrays|How To Use Arrays in Calc]] | ||
+ | * [[Documentation/How_Tos/Calc: Array functions|Array functions]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Array functions]] |
Latest revision as of 10:53, 30 January 2024
SUMX2MY2
Returns the sum of the differences between corresponding squared elements of two matrices.
Syntax:
SUMX2MY2(x; y)
- x and y are arrays or ranges of the same size. SUMX2MY2 calculates for the i elements in the arrays.
- Advanced topic:
- SUMX2MY2 evaluates its parameters x and y as array formulas but does not need to be entered as an array formula. In other words, it can be entered with the ↵ Enter key, rather than Cntrl + ⇧ Shift + ↵ Enter . See the example below.
Example:
SUMX2MY2(A1:A2; {2|1})
- where cells A1 and A2 contain 4 and 3 respectively, returns (42-22) + (32-12) = 20.
Advanced topic:
SUMX2MY2(A1:A2+1; {2|1})
- when entered 'normally' (not as an array formula), and where cells A1 and A2 contain 3 and 2 respectively, returns ((3+1)2-22) + ((2+1)2-12) = 20. SUMX2MY2 forces (A1:A2+1) to be evaluated as an array formula (internally returning the array {4|3}).
See Also