Difference between revisions of "Manuals/calci/SUMSQ"
Jump to navigation
Jump to search
| (7 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''SUMSQ( | + | <div style="font-size:30px">'''SUMSQ()'''</div><br/> |
| − | * | + | *Parameters are any set of numbers. |
| + | **SUMSQ(), returns the sum of the squares of the arguments. | ||
==Description== | ==Description== | ||
*This function gives the sum of the squares of the arguments. | *This function gives the sum of the squares of the arguments. | ||
| − | *In <math> SUMSQ( | + | *In <math> SUMSQ()</math>, Parameters are any real numbers. |
| − | *This function is finding the | + | *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. | *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. | *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 | *This function will give the result as error when | ||
| − | 1. Any one of the argument is | + | 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. | 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 | ||
| − | == | + | ==Related Videos== |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | {{#ev:youtube|Gtr3va10W5M|280|center|SUMSQ}} | ||
==See Also== | ==See Also== | ||
*[[Manuals/calci/SUM | SUM]] | *[[Manuals/calci/SUM | SUM]] | ||
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | ||
| + | |||
| + | ==References== | ||
| + | *[http://www.excelfunctions.net/Excel-Sumsq-Function.html Sum of Squares] | ||
| − | + | ||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 12: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 , 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: ,where 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
, Parameters are any real numbers.
,where 
are set of parameters.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
Related Videos
See Also
References