Difference between revisions of "Manuals/calci/SKEW"

Latest revision as of 13:40, 18 June 2018

SKEW()

Parameters are any numbers to calculate the skewness.
- SKEW() returns the skewness of a distribution

This function gives the Skewness of a distribution.
Skewness is a measure of the degree of asymmetry of a distribution.
A distribution(normal distribution) 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.
If 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 $SKEW(),Firstparameterisrequired.Fromthesecondparameterareoptional.*Incalcithereisnorestrictionforgivingthenumberofarguments.*Theargumentscanbebeeithernumbersornames,array,constantsorreferencesthatcontainnumbers.*Supposethearraycontainstext,logiclvaluesoremptycells,likethatvaluesarenotconsidered.*TheequationforSkewnessisdefinedby:<math>Skewness={\frac {n}{(n-1)(n-2)}}\sum \left({\frac {x_{i}-{\bar {x}}}{s}}\right)^{3}$

Where, $s$ is the sample standard deviation, ${\bar {x}}$ represents a sample mean.

 1. Any one of the argument is non-numeric. 
 2. If there are fewer than three data points, or the Sample Standard Deviation is zero.

=SKEW(B1:B5) = -0.4369344921493
=SKEW(A1:A6) = -0.21921252920
=SKEW(C1:C4) = -0.715957010
=SKEW(D1:D6) = 0
=SKEW(E1:E6) = 1.16584702768

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''SKEW(n1,n2,…)'''</div><br/>
+<div style="font-size:30px">'''SKEW()'''</div><br/>
-*<math>n_1,n_2,…</math> are numbers to calculate the skewness.
+*Parameters are any numbers to calculate the skewness.
+**SKEW() returns the skewness of a distribution
 ==Description==
@@ Line 11: / Line 12: @@
 *In a Normal Skewed Distribution, its <math>mean=median=mode</math>
 *In a Right Skewed Distribution, its <math>mode<median<mean</math>.
-*In <math>SKEW(n_1,n_2,...), n_1</math> is required.<math>n_2,n_3,...</math> are optional.
+*In <math>SKEW(), First parameter is required.From the second parameter 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.
@@ Line 63: / Line 64: @@
 ==References==
 *[http://en.wikipedia.org/wiki/Skewness Skewness]
+*[[Z_API_Functions | List of Main Z Functions]]
+*[[ Z3 |   Z3 home ]]