Scribd
Upload
3 views3 pages

Skewness Kurtosis Excel Lab

The document outlines a practical lab exercise focused on computing skewness and kurtosis using Microsoft Excel. It includes instructions for entering datasets, performing calculations, creating histograms, and answering interpretation questions related to the data distributions. The lab aims to enhance understanding of distribution shapes and their implications in IT-related scenarios.

Uploaded by

memcankiprono439
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
3 views3 pages

Skewness Kurtosis Excel Lab

The document outlines a practical lab exercise focused on computing skewness and kurtosis using Microsoft Excel. It includes instructions for entering datasets, performing calculations, creating histograms, and answering interpretation questions related to the data distributions. The lab aims to enhance understanding of distribution shapes and their implications in IT-related scenarios.

Uploaded by

memcankiprono439
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

Practical Lab: Skewness and Kurtosis Using Excel

Learning Objectives
1 Compute skewness and kurtosis using Microsoft Excel
2 Visualize data distributions using histograms
3 Interpret skewness and kurtosis values
4 Compare distributions with different shapes
5 Relate distribution shape to IT-related scenarios

General Instructions
1 Use Microsoft Excel for all computations and charts.
2 Enter each dataset in a separate column.
3 Show all formulas used.
4 Insert histograms and label them clearly.
5 Answer all interpretation questions.

Datasets
Dataset 1 — Nearly Symmetric (Exam Scores)
Scores
55
60
62
65
67
68
70
72
73
75
76
78
80
82
83
85
87
88
90
92
Dataset 2 — Positively Skewed (Response Time ms)
Time
5
6
7
7
8
8
9
9
10
10
11
12
13
15
18
22
28
35
50
75

Dataset 3 — Heavy Tails (Network Traffic)


Traffic
12
13
13
14
14
15
15
15
16
16
16
17
17
18
18
19
20
25
40
65

Tasks
1 Enter Dataset 1 in Column A, Dataset 2 in Column B, Dataset 3 in Column C.
2 Compute Mean using =AVERAGE(range).
3 Compute Standard Deviation using =STDEV.S(range).
4 Compute Skewness using =SKEW(range).
5 Compute Kurtosis using =KURT(range).
6 Create a histogram for each dataset using Insert → Chart → Histogram.

Questions
1 Compute the skewness for each dataset. Which dataset is closest to symmetric?
2 Which dataset is most positively skewed? Explain using the histogram.
3 Compute the kurtosis for each dataset. Which dataset has the highest kurtosis?
4 Which distribution appears most peaked? Which appears flatter?
5 Compare histogram shapes with skewness signs. Do they agree?
6 If Dataset 2 represents server response time, why is positive skewness expected?
7 If Dataset 3 represents network traffic spikes, why can high kurtosis be risky?
8 Add three extreme values (10, 150, 200) to Dataset 1 and recompute skewness and kurtosis.
What changes do you observe?

Submission Requirements
1 Excel file with calculations and charts.
2 Written answers to all questions.
3 Screenshots of formulas used.

You might also like