Using and managing Data and Information

Using and managing Data and Information

TABLE OF CONTENTS
TASK 1............................................................................................................................................2
1. Label the codes for categories.................................................................................................2
2. Producing frequency and percentage frequency tables using Pivot tables..............................3
3. Graphical representation for each variable..............................................................................4
4. Descriptive statistic of Spending £..........................................................................................5
TASK 2............................................................................................................................................6
1. Presenting the network diagram of the sequence of activities..............................................6
2. Determining how long it will take to complete job through forward pass..............................7
3. Through backward pass, determine the critical path and non-critical path.............................7
TASK 3............................................................................................................................................7
1. Line graph to represent the sales figure...................................................................................8
2. Formula and calculate the moving average.............................................................................8
3. Formula and centre moving average........................................................................................8
4. Presenting original sales data and trend of sales.....................................................................9
TASK 4............................................................................................................................................9
Presenting the tree diagram to show the probabilities of being selected a salesperson.............9
TASK 5..........................................................................................................................................11
Using linear programming solving the problems......................................................................11

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. Producing frequency and percentage frequency tables using 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 for each variable
Education