Difference between revisions of "Manuals/calci/SKEW"

Revision as of 04:36, 17 January 2014

SKEW(n1,n2,…)

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

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 $SKEW(n1,n2,...),n1$ is required. $n2,n3,...$ 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 : $Skewness={\frac {3(mean-median)}{s}}$ OR $skewness={\tfrac {\sum (x_{i}-{\bar {x}})^{3}}{(N-1)s^{3}}}$ Where: s is the sample standard deviation, ${\bar {x}}$ 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.

where

SKEW(n1,n2,...)

Where n1, n2 ... are numbers to calculate the skewness.

It calculates the skewness of a distribution.

SKEW

C1R1=13

C2R2=14

C3R3=15

C4R4=12

C5R5=13

C6R6=14

C7R7=9

C8R8=16

C9R9=14

C10R10=17

i.e.SKEW(Column1Row1:Column1Row10)

i.e.= SKEW(C1R1:C1R10) is -0.756

Syntax

Remarks

Examples

Description

@@ Line 16: / Line 16: @@
 *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 :<math> Skewness= \frac{3(mean-median)}{s}</math>  OR <math>skewness= \frac{\sum (xi-\bar{x})^3}{(N-1)s^3}</math>  Where:  s is the sample standard deviation, <math>\bar{x}</math> represents a sample mean.
+*The equation for skewness is defined by :<math> Skewness= \frac{3(mean-median)}{s}</math>  OR <math>skewness= \tfrac{\sum (x_i-\bar{x})^3}{(N-1)s^3}</math>  Where:  s is the sample standard deviation, <math>\bar{x}</math> represents a sample mean.
 *This function will return the result as error when
 . Any one of the argument is nonnumeric.