Scribd
Upload
2 views2 pages

Statistical Operations Guide: Mean to Kurtosis

Uploaded by

V Revathi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views2 pages

Statistical Operations Guide: Mean to Kurtosis

Uploaded by

V Revathi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

RESULT:

Thus, we got the input from user and numerical operations (MAX, MIN,
AVG, SUM, SQRT, ROUND) performed successfully.
3. STATISTICAL OPERATIONS (MEAN, MEDIAN, MODE AND
STANDARD DEVIATION, VARIANCE, SKEWNESS, KURTOSIS).

Aim:
To Perform statistical operations (Mean, Median, Mode and
Standard deviation, Variance, Skewness, Kurtosis).
Algorithm:
[Link]: We can calculate the mean (average) of a range of cells using
the AVERAGE function.
[Link]: We calculate the median of a range of cells, use the
MEDIAN function.
3. Mode: To find the mode (most frequently occurring value) in a
range, use the [Link] function (for a single mode) or
[Link] function (for multiple modes).
4. Standard Deviation: To calculate the standard deviation of a
sample, use the STDEV.S function.
5. Variance: To calculate the variance of a sample, use the VAR.S
function.
6. Skewness: To calculate skewness (a measure of the asymmetry of a
probability distribution), use the SKEW function.
7. Kurtosis: To calculate kurtosis (a measure of the "tailedness" of the
probability distribution), use the KURT function.

You might also like