Difference between revisions of "Manuals/calci/SUMSQ"

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 $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 id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
+<div style="font-size:30px">'''SUMSQ()'''</div><br/>
+*Parameters are any set of numbers.
+**SUMSQ(), returns the sum of the squares of the arguments.
-Syntax
-</div></div>
+==Description==
-----
+*This function gives the sum of the squares of the arguments.
-<div id="4SpaceContent" align="left"><div class="ZEditBox" align="justify">
+*In <math> SUMSQ()</math>, 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:  <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.
+*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 non-numeric or not a real number.
+. The arguments containing the error values or text that cannot be translated in to numbers.
-Remarks
+==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
-</div></div>
+==Related Videos==
-----
-<div id="2SpaceContent" align="left"><div class="ZEditBox" align="justify">
-Examples
+{{#ev:youtube|Gtr3va10W5M|280|center|SUMSQ}}
-</div></div>
+==See Also==
-----
+*[[Manuals/calci/SUM | SUM]]
-<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
+*[[Manuals/calci/SUMPRODUCT  | SUMPRODUCT ]]
-----
-<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
-<font size="5">Description</font>
+==References==
+*[http://www.excelfunctions.net/Excel-Sumsq-Function.html Sum of Squares]
-</div></div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUMSQ</font> </font>'''</div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>
-'''SUMSQ''' (n1, n2 ...)
-Where n1, n2 ...   are the arguments to calculate the sum of the squares.
-</div></div>
+*[[Z_API_Functions | List of Main Z Functions]]
-----
-<div id="13SpaceContent" class="zcontent" align="left"><br /><br /><div id="1Space" class="gamizbox" title="1Space"><div id="1SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="1SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="1SpaceRollupContent" align="center"></span></span></div><div id="1SpaceCover"><div id="1SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
-Arguments can numbers or names, arrays, or references.
+*[[ Z3 |   Z3 home ]]
-Numbers, logical values, and text representations are counted.
-</font>
-<font face="Times New Roman"> </font>
-</font></div></div>
-----
-<div id="14SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="5Space" class="gamizbox" title="5Space"><div id="5SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="5SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="5SpaceRollupContent" align="center"></span></span></div><div id="5SpaceCover"><div id="5SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">
-It calculates the sum of the squares of the arguments.
-</div></div>
-----
-<div id="12SpaceContent" class="zcontent" align="left"><br /><br /><br /><div id="9Space" class="gamizbox" title="9Space"><div id="9SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="9SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="9SpaceRollupContent" align="center"></span></span></div><div id="9SpaceCover"><div id="9SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3"><font face="Times New Roman">
-Lets see an example in (Column1 Row 1)
-SUMSQ
-SUMSQ (C1R1, C2R1)
-i.e. =SUMSQ (6,5) is 61
-</font></font></div></div>
-----
-<div id="6SpaceContent" class="zcontent" align="left">
-{| id="TABLE3" class="SpreadSheet blue"
-|- class="even"
-| class="   " |
-<div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| Column1
-| class="  " | Column2
-| class="  " | Column3
-| class="  " | Column4
-|- class="odd"
-| class=" " | Row1
-| class=" " | 6
-| class="sshl_f " | 5
-| class="sshl_f" | 61
-| class="sshl_f" |
-|- class="even"
-| class="  " | Row2
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f SelectTD SelectTD" |
-<div id="6Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="6Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
-| class="sshl_f" |
-|- class="odd"
-| Row3
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="even"
-| Row4
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="odd"
-| class=" " | Row5
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="even"
-| Row6
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|}
-<div align="left">[[Image:calci1.gif]]</div></div>
-----
-</div></div></div></div></div></div></div></div></div></div></div></div>

Difference between revisions of "Manuals/calci/SUMSQ"

Latest revision as of 12:35, 9 July 2018

Contents

Description

Examples

Related Videos

See Also

References

Navigation menu

Search