Scribd
Upload
8 views4 pages

Exercise 002

The document outlines a series of exercises involving the analysis of sales data using MS Excel. It includes creating Pivot Tables to summarize sales by product category and region, identifying top performers, and calculating summary statistics for quantities sold. The analysis concludes that the distribution of quantities ordered is symmetric, making the mean a suitable measure of central tendency.

Uploaded by

gemrimsha
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
8 views4 pages

Exercise 002

The document outlines a series of exercises involving the analysis of sales data using MS Excel. It includes creating Pivot Tables to summarize sales by product category and region, identifying top performers, and calculating summary statistics for quantities sold. The analysis concludes that the distribution of quantities ordered is symmetric, making the mean a suitable measure of central tendency.

Uploaded by

gemrimsha
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

EXERCISE-02

[Link] and open the Sales Orders file in MS Excel.


[Link] Sales by Product Category
I. Create a Pivot Table showing total sales amount (Quantity × Unit Price) by Product Category.
II. Highlight the category with the highest sales.
[Link] Sales by Region and Salesperson
I. Create a Pivot Table showing total sales per region, broken down by Salesperson.

II. Identify the top-performing region.

Descriptive Statistical Analysis:


[Link] the summary statistics of Quantity sold.
5-COMMENT:
The skewness (0.0026) is almost zero, the distribution of quantities ordered is symmetric. Hence,
Mean is an appropriate measure of central tendency (though the Median would give almost the
same result).

You might also like