Difference between revisions of "Manuals/calci/SUMSQ"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''SUMSQ(n1,n2,n3,…)'''</div><br/> |
| + | *<math>n1,n2,n3... </math> are numbers. | ||
| − | |||
| − | < | + | ==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. |
| + | *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 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. | ||
| + | *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 nonnumeric 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 | ||
| − | |||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/SUM | SUM]] | |
| − | + | *[[Manuals/calci/SUMPRODUCT | SUMPRODUCT ]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 22:34, 26 January 2014
SUMSQ(n1,n2,n3,…)
- are numbers.
are numbers.
Description
- This function gives the sum of the squares of the arguments.
- In Failed to parse (syntax error): {\displaystyle SUMSQ(n1,n2,n3,…) n1,n2,n3,…} , are the 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 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 nonnumeric 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
See Also