Difference between revisions of "Manuals/calci/SKEW"

From ZCubes Wiki
Jump to navigation Jump to search
Line 22: Line 22:
  
  
 +
==Examples==
  
where 
+
==See Also==
<div id="6SpaceContent" class="zcontent" align="left"> <font face="Arial, sans-serif"><font size="2">'''SKEW'''</font></font><font face="Arial, sans-serif"><font size="2">(</font></font><font face="Arial, sans-serif"><font size="2">'''n1'''</font></font><font face="Arial, sans-serif"><font size="2">,n2,...)</font></font>
 
  
<font face="Arial, sans-serif"><font size="2">'''Where n1, n2 ...'''</font></font><font face="Arial, sans-serif"><font size="2">   are numbers to calculate the skewness. </font></font>
+
==References==
 
 
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">  <font face="Arial, sans-serif"><font size="2">It calculates the skewness of a distribution. </font></font></div>
 
----
 
<div id="7SpaceContent" class="zcontent" align="left"> 
 
 
 
# <font face="Arial, sans-serif"><font size="2">If the data points are less than three,the function displays NaN.</font></font>
 
# <font face="Arial, sans-serif"><font size="2">The equation for skewness is: </font></font>
 
 
 
<br /><br />
 
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
 
SKEW
 
 
 
</div></div>
 
----
 
<div id="8SpaceContent" class="zcontent" align="left"> 
 
 
 
<font face="Arial, sans-serif"><font size="2">C1R1=13</font></font>
 
 
 
<font face="Arial">C2R2=14</font>
 
 
 
<font face="Arial">C3R3=15</font>
 
 
 
<font face="Arial">C4R4=12</font>
 
 
 
<font face="Arial">C5R5=13</font>
 
 
 
<font face="Arial">C6R6=14</font>
 
 
 
<font face="Arial">C7R7=9</font>
 
 
 
<font face="Arial">C8R8=16</font>
 
 
 
<font face="Arial">C9R9=14</font>
 
 
 
<font face="Arial">C10R10=17</font>
 
 
 
<font face="Arial, sans-serif"><font size="2">i.e.SKEW(Column1Row1:Column1Row10)</font></font>
 
 
 
<font face="Arial, sans-serif"><font size="2">i.e.= SKEW(C1R1:C1R10) is -0.756</font></font>
 
 
 
</div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left">
 
 
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| class="  " | Column1
 
| class="    " | Column2
 
| Column3
 
| Column4
 
|- class="odd"
 
| class=" " | Row1
 
| class="sshl_f " | 13
 
| class="sshl_f" | -0.756
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" | 14
 
| class=" SelectTD SelectTD" |
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
|
 
|
 
|- class="odd"
 
| Row3
 
| class="sshl_f" | 15
 
|
 
|
 
|
 
|- class="even"
 
| Row4
 
| class="sshl_f" | 12
 
|
 
|
 
| class="  " |
 
|- class="odd"
 
| class=" " | Row5
 
| class="sshl_f" | 13
 
|
 
|
 
|
 
|- class="even"
 
| class="sshl_f" | Row6
 
| class="sshl_f" | 14
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f  " | Row7
 
| class="sshl_f" | 9
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="sshl_f" | Row8
 
| class="sshl_f" | 16
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f" | Row9
 
| class="sshl_f" | 14
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="even"
 
| class="sshl_f" | Row10
 
| class="sshl_f " | 17
 
|
 
|
 
|
 
|}
 
 
 
<div align="left">[[Image:calci1.gif]]</div></div>
 
----
 

Revision as of 04:38, 17 January 2014

SKEW(n1,n2,…)


  • Failed to parse (syntax error): {\displaystyle n1,n2,…} are numbers to calculate the skewness.


Description

  • This function gives the skewness of a distribution.
  • Skewness is a measure of the degree of asymmetry of a distribution.
  • A distribution(normal ditribution) is symmetry ,it don't have a skewness.
  • In a distribution the left tail is more pronounced than the right tail (towards more negative values) then the function is said to have negative skewness.
  • In a distribution is skewed to the right , the tail on the curve's right-hand side is longer than the tail on the left-hand side (towards more positive values), then the function is said to have a positive skewness.
  • In a left skewed distribution ,its mean<median<mode.
  • In a normal skewed distribution, its mean=median=mode.
  • In a right skewed distribution, its mode<median<mean.
  • In is required. are optional.
  • In calci there is no restriction for giving the number of arguments.
  • The arguments can be be either numbers or names, array,constants or references that contain numbers.
  • Suppose the array contains text,logicl values or empty cells, like that values are not considered.
  • The equation for skewness is defined by : OR Where: s is the sample standard deviation, represents a sample mean.
  • This function will return the result as error when
 1. Any one of the argument is nonnumeric. 
 2. If there are fewer than three data points, or the sample standard deviation is zero.


Examples

See Also

References