Using and Managing Data and Information

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