Scribd
Upload
29 views2 pages

Kurtosis

The document outlines a lab experiment using Microsoft Excel to generate a random dataset and analyze its skewness and kurtosis. It provides step-by-step instructions for creating the dataset, calculating descriptive statistics, and visualizing the results. The final output includes key statistical measures such as mean, standard deviation, and kurtosis values for the generated data.

Uploaded by

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

Kurtosis

The document outlines a lab experiment using Microsoft Excel to generate a random dataset and analyze its skewness and kurtosis. It provides step-by-step instructions for creating the dataset, calculating descriptive statistics, and visualizing the results. The final output includes key statistical measures such as mean, standard deviation, and kurtosis values for the generated data.

Uploaded by

akshararajput04
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Analytics (Lab)

150 I/IISem. Dip. Statistics and

EXPERIMENT No. 18

Microsoft Excel Spread Sheet Draw a


Using
Graph and Kurtosis Graph for Randomly
Skewness
Generated Dataset.

Procedure :

Excel ’ File > New.


Step 1: Open MS Office ’ MS

2: To place heading select few columns and few rows of


Step ' > 'Alignment'
cells > right click ’ click 'Format Cells
Type heading.
tab > Tick 'Merge cells' > click 'OK’

Generate the random value using the default relation


Step 3 :
=RANDBETWEEN(1,100)

4: Drag the first value for required number of cells.


Step
> select Descriptive
Step 5: Click 'Data' ’ 'Data analysis'
Statistics'> click 'OK.

Click in input range ’ Select all data values ’ Tick


Step 6 :
'Summary Statistics'> Click 'OK'.
/ISem. Dip. Statistics and Analytics (Lab) 151

Sample Snap Shot of the Worksheet :


Epernerts xls Micosoft Exco

uwwEww999wwwvewwwwwwwwwwwwwwwwvwww.seeve

Using Mierotot Excel spreed sheat drew nSkewness graph and kurtosis graph
for rendomly genereted dataset.
pata v e

Mean
55 Standard Enot 6.TTS574SS7
Medan 25
AOde
Stavidard Devitinn 20.31917927
Sanyie Variatce 99.752e:
Vartosis iR977

2
Maxlmon

Coun

Result :
Column 1
Mean 56.38888889
Standard Error 5.625071613
Median 62
Mode 84
Standard Deviation 23.86515769
Sample Variance 569.5457516
Kurtosis -0.439096693
Skewness -0.604475302
Range 80
Minimum 7
Maximum 87
Sum 1015
Count 18

VCB

You might also like