Insightful Analytics

DATA INTERPRETATION
By :
Anubhav Dipta, AAO
PCDA (P), Prayagraj
DATA TABLES
Data on enrollment of Students in a University
Gender No. of Undergraduate No. of Postgraduate
Students Students
Male 820 200
Female 290 90
Subjects No. of Undergraduate No. of Postgraduate

Students Students
Physics 82 46
Chemistry 620 128
Botany 134 70
Zoology 94 46
DATA TABLES
Questions
1. Percentage of students studying Chemistry in Post
graduation ________.
2. If 20 Females undergraduate students leaves 50 Males
undergraduate students join in under student
exchange programs, percentage of female
undergraduate students would be ________.
3. Among the students studying either Physics or
Chemistry, the ratio of the number of postgraduate
students to the number of undergraduate students is
_______.
PIE CHART
Sales in Lakhs
Computer =
129
Cartridges =
51
UPS = 30
Printer = 90
PIE CHARTS
Questions
1. If profit margin on Computers is 20 %,
on cartridges it is 30 % whereas the
remaining 2 items its 15%. Total profit in
Lakhs is ______.
2. If the sales of computer decreases to 80%
and Printer sales increases to 120%, Total
sales in lakh would be ______.
3. Profit percentage of UPS out of total sales is
______.
TWO DIMENSIONAL GRAPH
Expenditure trend of Firm ‘X’ (in
60
Lakhs)
50
40
IT Establishment
30 Stationery
Gen Establishment
20
10
0
2019 2020 2021 2022
TWO DIMENSIONAL GRAPH
Question
1. An upward expenditure trend is seen in
______.
2. What was the share of Stationery items in
total Office Expenditure in the year 2021?
3. Which year witnessed a decrease in IT
Establishment Expenditure and by what
percentage?
BAR GRAPHS (TYPE I)
Category 4
Category 3
Series 1
Series 2
Category 2 Series 3
Category 1
0 2 4 6 8 10 12 14
BAR GRAPHS (TYPE II)
Category 4
Category 3
Series 3
Series 2
Category 2 Series 1
Category 1
0 1 2 3 4 5 6
VENN DIAGRAMS (TYPE I)
Chemistr
y
Biology Physics
VENN DIAGRAMS (TYPE II)
A
GEOMETRICAL DIAGRAM
The above diagram shows the percentage of students in six

schools – A, B, C, D, E and F and whose favorite subject is
Chemistry, Physics or Maths. The total number of students in these
schools are A – 160, B – 192, C – 240, D – 200, E – 160 and F – 240.
GEOMETRICAL DIAGRAM
1. Find the number of students in schools C and D
together whose favorite subject is Chemistry?
2. How many more students in school B had
Maths as their favourite subject when
compared to the number of students in school
A whose favourite subject is Physics?
3. The number of students in school B whose
favourite subject is Chemistry formed what
percentage of the students in school C whose
favourite subject is Physics?
4. Find the total number of students in the given
six schools whose favourite subject is Physics.
PERT CHARTS (PROGRAM EVALUATION
REVIEW TECHNIQUE)
 The progress of any project is monitored and
the execution of various activities is
scheduled keeping in mind resource
constraints (like labour) and time constraints.
For the purpose of data interpretation
questions, the data may be given in the form
of a table or a chart.
REVIEW TECHNIQUE)
Activity Optimistic Time Realistic Time Pessimistic
(to) (tm) Time (tp)
1-2 6 9 12
1-3 3 4 11
2-4 2 5 14
3-4 4 6 8
3-5 1 1.5 5
2-6 5 6 7
4-6 7 8 15
5-6 1 2 3
1. Critical path using PERT.

2. Calculate variance and standard deviation for each activity.
3. Calculate the probability of completing the project in 26 days.
REVIEW TECHNIQUE)
REVIEW TECHNIQUE)
REVIEW TECHNIQUE)
Activity (to (tm (tp) Expected Time Variance
) )
1-2 6 9 12 9 1.0
1-3 3 4 11 5 1.778
2-4 2 5 14 6 4.0
3-4 4 6 8 6 0.444
3-5 1 1.5 5 2 0.444
2-6 5 6 7 6 0.111
4-6 7 8 15 9 1.778
5-6 1 2 3 2 0.111
PERT CHARTS
(PROGRAM EVALUATION REVIEW TECHNIQUE)
Activit Duration EST EFT LST LFT Total
y (Exp Time) Float
1-2 9 0 9 0 9 0
1-3 5 0 5 4 9 4
2-4 6 9 15 9 15 0
3-4 6 5 11 9 15 4
3-5 2 5 7 20 22 15
2-6 6 9 15 18 24 9
4-6 9 17 24 15 24 0
5-6 2 7 9 22 24 15
EST : Earliest Start Time

EFT : Earliest Finish Time
LST : Last Start Time
LFT : Last Finish Time
PERT CHARTS
(PROGRAM EVALUATION REVIEW TECHNIQUE)
Here the critical path is along the activities 1-2, 2-

4, 4-6. So the critical path is 1-2-4-6.
PERT CHARTS (PROGRAM EVALUATION RE
VIEW TECHNIQUE)
THANKS AND REGARDS

Insightful Analytics

Uploaded by

Copyright:

Available Formats

Insightful Analytics

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Insightful Analytics

Uploaded by

Copyright:

Available Formats

DATA INTERPRETATION

Subjects No. of Undergraduate No. of Postgraduate

The above diagram shows the percentage of students in six

1. Critical path using PERT.

EST : Earliest Start Time

Here the critical path is along the activities 1-2, 2-

You might also like