Scribd
Upload
2 views18 pages

Exploring Data

The document provides an overview of pivot tables, illustrating data related to student preferences for a German class and sales figures for various products across different regions. It includes gender-based analysis of students' performance and their classification as above or below average. Additionally, it presents a breakdown of sales by product and region, highlighting total sales figures.

Uploaded by

Sudhakar Ramasamy
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
2 views18 pages

Exploring Data

The document provides an overview of pivot tables, illustrating data related to student preferences for a German class and sales figures for various products across different regions. It includes gender-based analysis of students' performance and their classification as above or below average. Additionally, it presents a breakdown of sales by product and region, highlighting total sales figures.

Uploaded by

Sudhakar Ramasamy
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

The

Anatomy of
a Pivot Table
Report Filter Area
Column Area Value Area
Row Area

10th Exam Status (All)

Count of Preference
to German Class
Preference to German Class Row
Grand
Total
Gender No Yes

Female 70 205 275

Male 120 105 225

Column Grand Total 190 310 500


Sales Rep (All) Report Filter Area
Column Area Value Area
Row Area

Total Sales Region

Product Central East West [Link] Total

Binder 1202.59 1831.33 703.59 3737.51

Desk 1925 825 2750

Pen 348.25 151.24 499.49

Pen Set 728.54 1242.51 1971.05

Pencil 1094.34 451.49 595.01 2140.84

[Link] Total 4950.47 3873.58 2274.84 11098.89


Section A,
Section D, 3.08%
7.82% Section B,
3.21%

Section C,
8.59%
250 74.18%, No of
Students - Above
Average, 204
200

150 53.33%, No of
46.67%, No of Students - Below
No of Students

Students - Above Average, 120


Average, 105
100 25.82%, No of
Students - Below
Average, 71
50

0
Female Male
Gender
87%
90% 82%
78%
80%
67%
70%
60%
50%
40% 33%
30% 22%
18%
20% 13%
10%
0%
Day-scholar Hostler Day-scholar Hostler
Female Male
Above Average Below Average

You might also like