Manuals/calci/KURT

From ZCubes Wiki
Revision as of 20:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''KURT'''(N'''1''',N2,...) '''Where N1,N2,.... '''are the arguments to calculate the kurtosis. </div> ---- <...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

KURT(N1,N2,...)

Where N1,N2,.... are the arguments to calculate the kurtosis.


This function calculates the relative peakedness or flatness of a distribution compared with the normal distribution.


·          Arguments can be numbers or names, arrays, or references.

·          Logical values and text representations of numbers are calculated.

·        KURT shows the error value, when there are fewer than four data points, or the SD of the sample equals zero.

Formulas:-

·          Kurtosis is defined as:

where s is the sample standard deviation.


KURT


Lets see an example,

KURT(N1,N2,....)

B

8

9

10

4

5

3

10

=KURT(B2:B8) is -2.0947


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 8 -2.094675
Row2 9
Row3 10
Row4 4
Row5 5
Row6 3
Row7 10