Using and Managing Data and Information

This study material covers topics such as frequency tables, graphical representation of variables, critical path analysis, moving average method, tree diagrams and linear programming. It is relevant for courses related to data management and information systems.

Using and managing data and information

Table of Contents
TASK 1............................................................................................................................................3
1. Label the codes for categories.................................................................................................3
2. Frequency and % frequency tables through pivot tables.........................................................3
3. Graphical representation of variables......................................................................................4
4. Descriptive statistic..................................................................................................................6
TASK 2............................................................................................................................................6
1. Network diagram.....................................................................................................................6
2. Describing the critical path from gantt chart...........................................................................7
3.Presenting critical and non-critical path...................................................................................7
TASK 3............................................................................................................................................8
1. Line graph................................................................................................................................8
2. Presenting the moving average method...................................................................................9
3. Centre moving average method...............................................................................................9
4. Presenting data related to original sales and trend of sales...................................................10
TASK 4..........................................................................................................................................10
Presenting tree diagram relating to probabilities of being selected a sales person....................10
TASK 5..........................................................................................................................................12
Using linear programming solving the problems......................................................................12

TASK 1
1. Label the codes for categories
Customer Gender Age Education SSC user
1 Male 35 to 47 A' level or
diploma
Yes
2 Female 61 and over Degree or further No
3 Female 35 to 47 GCSE or below Yes
4 Female 61 and over GCSE or below No
5 Female 48 to 60 Degree or further No
2. Frequency and % frequency tables through pivot tables
Gender
Particulars Frequency
%
frequenc
y
Male 20 40%
Female 30 60%
Grand Total 50 100%
Education
Particulars Frequency
%
frequency
GCSE or
below 20 40%
A’ Level or
Diploma 16 32%
Degree or
further 14 28%
Grand Total 50 100%

Age
Particulars Frequency
%
frequency
Less than 21 2 4%
21 to 34 5 10%
35 to 47 10 20%
48 to 60 26 52%
61 and over 7 14%
Grand Total 50 100%
SCC user
Particulars Frequency
%
frequenc
y
Yes 17 34%
No 33 66%
Grand Total 50 100%
Spending
Particulars Frequency
%
frequency
<100 1 10%
100-109 6 12%
110-119 23 46%
120-129 18 36%
130-140 2 4%
>140 0 0%
Grand Total 50 100%
3. Graphical representation of variables
Education

20
16
14
Educati on
GCSE or below A’ Level or Diploma Degree or further
Age
Less than 21
21 to 34
35 to 47
48 to 60
61 and over
0 5 10 15 20 25 30
2
5
10
26
7
Age
Spending

1
-5 0 5 10 15 20 25 30
Spending
4. Descriptive statistic
Particulars Spending (£)
Mean 117.5
Median 118.5
Minimum 92
Maximum 131
Quartile 1 112
Quartile 2 118.5
Quartile 3 122.25
TASK 2
1. Network diagram
Task
Mode Task Name Duration Start Finish Predecessors
1 A 3 days Thu 6/10/21 Mon 6/14/21
2 B 3 days Thu 6/10/21 Mon 6/14/21
3 C 4 days Tue 6/15/21 Fri 6/18/21 1
4 D 8 days Tue 6/15/21 Thu 6/24/21 1
5 E 2 days Mon 6/21/21 Tue 6/22/21 2,3

2. Describing the critical path from gantt chart
Critical path: 1 + 4
= 3 + 8
= 11 days
3.Presenting critical and non-critical path
Critical path: 1 + 4
= 11 days
Non-critical path = 1 + 3 + 5
= 3 + 4 + 2
= 9 days

TASK 3
Quarter Sales
2017
1 139
2 135
3 91
4 113
2018
1 145
2 137
3 85
4 118
2019
1 150
2 141
3 89
4 119
2020
1 156
2 149
3 105
4 125
1. Line graph
2. Presenting the moving average method
Quarter Sales Moving

average
2017
1 139 NA
2 135 NA
3 91 NA
4 113 121.6667
2018
1 145 113
2 137 116.3333
3 85 131.6667
4 118 122.3333
2019
1 150 113.3333
2 141 117.6667
3 89 136.3333
4 119 126.6667
2020
1 156 116.3333
2 149 121.3333
3 105 141.3333
4 125 136.6667
3. Centre moving average method
Quarter Centre
moving
2017
1
2 118.5
3 110
4 127
2018
1 128
2 119.25
3 109.5
4 131.75
2019
1 132.5
2 122.5
3 113.25
4 135.75
2020
1 141.5
2 132
3 83.75
4 62.5

4. Presenting data related to original sales and trend of sales
TASK 4
Presenting tree diagram relating to probabilities of being selected a sales person
Let A= Toni and B = Joe
There are different probabilities of selecting a sales person which are as mentioned below:
 The probability of Toni to select a salesperson = P(A) = 0.5
 The probability of Joe to select a salesperson = P(B) = 0.5
 The probability of salesperson chosen by both = P (A and B) = 0, it is so because only
one manager work in a day
 By applying the formula of probability = P (A or B) = P A) + P (B) – P (A and B)

Salesperson
Toni Joe
P(S)
)
P(NS)
)
P(S)
))
P(NS)
06*05 days
= 0.3
05*0.6
days = 0.3
04*0.4
days = 0.
16
0.4*0.6
days = 0.24
0.5 0.4 0.4 0.6

0.3 + 0.16 = 0.46 which means that probability of selecting a salesperson is 46%
0.3 + 0.24 = 0.54, it means that the possibility of not selecting the salesperson is 54%
(0.3 + 0.3 + 0.16 + 0.24 =1)
As per the above tree diagram, it has been identified that Toni worked for 6 days whereas
Joe worked for 4 days. In the above P(S) denoted as probability of selection whereas P (NS)
used for not selecting a candidate. As per the result generated, it has been identified that
probability of not selecting a salesperson is higher as compared to selection.
TASK 5
Using linear programming solving the problems
Decision
variables
Objective
functions
LHS
constrains
Brie Goude
Total
Profit
Production
quantity 12 0
Unit profits 4.5 3 54
Constrain
ts
Production
Requirements
per Unit Used
Availabl
e
Milk 1.8 1.2 21.6 120
Salt 100 150 1200 1200
Solver
Options
Max Time Unlimited, Iterations Unlimited, Precision
0.000001
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%,

Assume NonNegative
Objective Cell (Max)
Cell Name
Original
Value
Final
Value
$E$4
Unit profits Total
Profit 54 54
Variable Cells
Cell Name
Original
Value
Final
Value Integer
$C$3 Production quantity Brie 12 12 Contin
$D$3
Production quantity
Goude 0 0 Contin
Constraints
Cell Name
Cell
Value Formula Status Slack
$E$7
Milk
Used 21.6 $E$7<=$F$7
Not
Binding 98.4
$E$8
Salt
Used 1200 $E$8<=$F$8 Binding 0