Difference between revisions of "Manuals/calci/SUMSQ"

Latest revision as of 13:35, 9 July 2018

SUMSQ()

Parameters are any set of numbers.
- SUMSQ(), returns the sum of the squares of the arguments.

Description

This function gives the sum of the squares of the arguments.
In $SUMSQ()$ , Parameters are any real numbers.
This function is finding the squares of the numbers and it is adding all the numbers together. Instead of numbers, we can use the single array or a reference to an array.
This function is calculated by: $n_{1}^{2}+n_{2}^{2}+n_{3}^{2}+....$ ,where $n_{1},n_{2},n_{3}...$ are set of parameters.
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.
Also numbers,logical values and text representations of numbers when we entering directly in to the list of the arguments then it is countable.
This function will give the result as error when

   1. Any one of the argument is non-numeric or not a real number. 
   2. The arguments containing the error values or text that cannot be translated in to numbers.

Examples

=SUMSQ(5,10) = 125
=SUMSQ(2,7,11) = 174
=SUMSQ(44) = 1936
=SUMSQ(0,10,20,30,40) = 3000
=SUMSQ(-1,-2,-3,-4,-5) = 55
=SUMSQ("2+3i","4+5i") = 0
=SUMSQ(2+3I,4+5I) = 106

References

Sum of Squares

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''SUMSQ(n1,n2,n3,…)'''</div><br/>
+<div style="font-size:30px">'''SUMSQ()'''</div><br/>
-*<math>n1,n2,n3... </math>  are numbers.
+*Parameters are any set of numbers.
+**SUMSQ(), returns the sum of the squares of the arguments.
 ==Description==
 *This function gives the sum of the squares of the arguments.
-*In <math> SUMSQ(n1,n2,n3,…) n1,n2,n3,…</math>, are  the any real numbers.
+*In <math> SUMSQ()</math>, Parameters are any real numbers.
-*This function is finding the squres of the numbers and it is adding all the numbers together. Instead of numbers we can use the single array or a reference to an array.
+*This function is finding the squares of the numbers and it is adding all the numbers together. Instead of numbers, we can use the single array or a reference to an array.
-*This function is calculated by:  <math> n_1^2+n_2^2+n_3^2+....</math>.
+*This function is calculated by:  <math> n_1^2+n_2^2+n_3^2+....</math>,where <math>n_1,n_2,n_3...</math> are set of parameters.
-*The arguments can be be either numbers or names, array,constants or references that contain numbers.
+*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.
 *Also numbers,logical values and text representations of numbers when we entering directly in to the list of the arguments then it is countable.
 *This function will give the result as error when
-. Any one of the argument is nonnumeric or not a real number.
+. Any one of the argument is non-numeric or not a real number.
 . The arguments containing the error values or text that cannot be translated in to numbers.
 ==Examples==
-#SUMSQ(5,10)=125
+#=SUMSQ(5,10) = 125
-#SUMSQ(2,7,11)=174
+#=SUMSQ(2,7,11) = 174
-#SUMSQ(44)=1936
+#=SUMSQ(44) = 1936
-#SUMSQ(0,10,20,30,40)=3000
+#=SUMSQ(0,10,20,30,40) = 3000
-#SUMSQ(-1,-2,-3,-4,-5)=55
+#=SUMSQ(-1,-2,-3,-4,-5) = 55
-#SUMSQ("2+3i","4+5i")=Null
+#=SUMSQ("2+3i","4+5i") = 0
-#SUMSQ(2+3I,4+5I)=106
+#=SUMSQ(2+3I,4+5I) = 106
+==Related Videos==
+{{#ev:youtube|Gtr3va10W5M|280|center|SUMSQ}}
 ==See Also==
 *[[Manuals/calci/SUM | SUM]]
 *[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
+==References==
+*[http://www.excelfunctions.net/Excel-Sumsq-Function.html Sum of Squares]
-==References==
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]

Difference between revisions of "Manuals/calci/SUMSQ"

Latest revision as of 13:35, 9 July 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search