Manuals/calci/SUMX2PY2

SUMX2PY2(x,y)

• $x$ and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } are the array of values.

Description

• This function gives the sum of the sum of squares of corresponding values in Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } .
• In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUMX2PY2(x,y)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } is the first array of real values and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y } is the second array of real values.
• It is mostly common term in statistical calculations.
• This function is defined by :

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUMX2PY2= \sum (x^2+y^2) } .

• The arguments can be be either numbers or names, array,constants or references that contain numbers.
• Suppose the array contains text,logical values or empty cells, like that values are not considered.
• This function will give the result as error when

      1. Any one of the argument is nonnumeric or not a real number. 
      2. The arguments containing the error values or text that cannot be translated in to numbers.
      3. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x}
 and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle y}
 are having different number of values.

Examples

Spreadsheet

	A	B	C	D	E
1	25.5	34.2	67.9	12	10
2	12.56	40.45	12.98	15	17
3	0	5	7	9	18
4	12	22	31	16	26

1. =SUMX2PY2(A1:C1,A2:C2) = 8392.736500000003
2. =SUMX2PY2(A3:E3,A4:E4) = 3000
3. =SUMX2PY2([10,20,30],[5,15,25]) = 2275

Related Videos

SUMPRODUCT

See Also

• SUMX2MY2
• SUMXMY2
• SUMPRODUCT

References

• sum of the sum of squares