Difference between revisions of "Manuals/calci/SUMSQ"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''SUMSQ(n1,n2,n3,…)'''</div><br/> | <div style="font-size:30px">'''SUMSQ(n1,n2,n3,…)'''</div><br/> | ||
*<math>n1,n2,n3... </math> are numbers. | *<math>n1,n2,n3... </math> are numbers. | ||
| − | |||
==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(n1,n2,n3, | + | *In <math> SUMSQ(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, 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>. | ||
| − | *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== | ==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") = Null |
| − | #SUMSQ(2+3I,4+5I)=106 | + | #=SUMSQ(2+3I,4+5I) = 106 |
| − | |||
==See Also== | ==See Also== | ||
*[[Manuals/calci/SUM | SUM]] | *[[Manuals/calci/SUM | SUM]] | ||
*[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | ||
| − | |||
| − | |||
==References== | ==References== | ||
Revision as of 04:59, 30 January 2014
SUMSQ(n1,n2,n3,…)
- are numbers.
are numbers.Description
- This function gives the sum of the squares of the arguments.
- In , , 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: .
- 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") = Null
- =SUMSQ(2+3I,4+5I) = 106