Using and Managing Data and Information

Using and Managing Data and Information

TABLE OF CONTENTS
TASK 1............................................................................................................................................3
1. Label the codes for the categories...........................................................................................3
2. Producing frequency and % frequency of tables.....................................................................4
3. Drawing the graphical presentation for each variable.............................................................5
4. Calculating descriptive statistics..............................................................................................6
TASK 2............................................................................................................................................6
1. Drawing a network diagram by representing the sequence of activities.................................6
2. Assesing the time period within which concerned job will be completed..............................7
3. Identifying the critical path and the noncritical path through using the backward pass..........7
TASK 3............................................................................................................................................7
1. Drawing a line graph to represent sales figures.......................................................................7
2. Calculating the moving average..............................................................................................8
3. Calculating the centre moving averages..................................................................................9
4. Presenting the original sales data and the trend of sales figures............................................10
TASK 4..........................................................................................................................................10
Building a tree diagram to show the probabilities of a Salesperson being selected..................10
TASK 5..........................................................................................................................................11
Applying linear programming for solving concerned problem.................................................11

TASK 1
1. Codes for the categories labels
Gender
Particulars Labels
1 Male
2 Female
3 Prefer not to say
Age
Particulars Labels
1 Less than 21
2 21 to 34
3 35 to 47
4 48 to 60
5 61 and over
Education
Particulars Labels
1 GCSE or below
2 A’ level or Diploma
3 Degree or further

Are you a regular self-checkout user?
Particulars Labels
1 Yes
2 No
2. Frequency and % frequency
Gender
Particulars Frequency % of Frequency
Female 29 58%
Male 20 40%
Prefer not to say 1 2%
Total 50 100%
Education
Particulars Frequency % of Frequency
GCSE or below 13 26%
A’ level or Diploma 18 36%
Degree or further 19 38%
Total 50 100%
Age
Particulars Frequency % of Frequency
Less to 21 4 8%
21 to 34 3 6%
35 to 47 6 12%
48 to 60 23 46%
61 and more 14 28%
Total 50 100%