Difference between revisions of "Manuals/calci/SUMSQ"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
*In <math> SUMSQ(n1,n2,n3,…) n1,n2,n3,…</math>, are the any real numbers. | *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 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>. | + | *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. | ||
| Line 14: | Line 14: | ||
1. Any one of the argument is nonnumeric or not a real number. | 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. | 2. The arguments containing the error values or text that cannot be translated in to numbers. | ||
| − | |||
==Examples== | ==Examples== | ||
Revision as of 22:35, 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