Understanding and Managing Data

This document provides insights on understanding and managing data. It covers topics such as data labeling, frequency tables, graphical representation, network diagrams, line graphs, and profit analysis. The content includes solved assignments, essays, and dissertations.

Understanding and
Managing data

Contents
TASK 1............................................................................................................................................3
TASK 2............................................................................................................................................8
TASK 3............................................................................................................................................8
TASK 4..........................................................................................................................................12

TASK 1
1. Label the codes for categories:
 Gender:
1. Male? 2. Female? 3. Prefer not to say
 Age:
1. Less than 21 2. 21 to 34 3. 35 to 47 4. 48 to 60 5. 61 and over
 Education:
1. GCSE or below 2. A’ level or Diploma 3. Degree or further
 Are you a regular user of self-checkout user:
1. Yes 2. No
2. Frequency and percentage frequency tables:
Gender
Frequency Percentage
Male 94 47.47%
Female 102 51.51%
Prefer not to
say
2 1.01%
Total 198 100%
Age Frequency Percentage
Less than
21
18 9.09%
21 to 34 17 8.58%
35 to 47 32 16.16%
48 to 60 94 47.47%
61 and
over
37 18.68%
Total 198 100
Education Frequency Percentage

GCSE or below 67 33.83838
A’ level or
Diploma
72 36.36364
Degree or further 59 29.79798
Total 198 100
SSC
User
Frequency Percentage
Yes 69 34.84848
No 129 65.15152
Total 198 100
Spending Frequency Percentage
<100 10 5.050505
100-109 28 14.14141
110-119 71 35.85859
120-129 79 39.89899
130-140 9 4.545455
>140 1 0.505051
Total 198 100
3. Graphical representation:

4. Spending
Minimum Mean: 92

Maximum Mean: 149
Median: 198/2 = 99th value i.e. 106
Quartiles:
Q1: ¼ (198) th value = 49.5th value = (113+122)/2 = 117.5
Q2.: 2/4(198) th value = 99th value = 106
Q3: ¾ (198) th value = (126+121)/2 = 123.5
Mean and Standard Deviation:
Spending
range
Frequencies
<100 10
100-109 28
110-119 71
120-129 79
130-140 9
>140 1
Total 198
Mean = 198 / 6 = 33
Sd:
Spending
range
Frequencies (x-
mean)2
<100 10 529
100-109 28 25
110-119 71 1444
120-129 79 2116
130-140 9 576
>140 1 1024
Total 198 5714
Sd: 30.86
5. Cross Table:
Gender Yes No
Male 34 60

Female 33 69
Prefer not to
say
2 nil
Age Yes No
Less than
21
18 nil
21 to 34 17 nil
35 to 47 17 15
48 to 60 17 77
61 and
over
nil 37
6. Scatter Diagram:

TASK 2
1. Network Diagram: To build an interactive drawing of a system, network diagram is being
used in computer communications. In gathering comprehensive network information, this
form of graph is especially handy for network developers and programmers.
Normally, network diagram typically comprises of network formed of classes or
structures that are intertwined.
2. Total Duration: 3+2+3+2+1+2+2+1 = 16
3. Critical path:
TASK 3
1. Line Graph:

Moving Average:
Year Quarter Sales Average Moving
Average
2015 1 139 119.5 126.0625
2 135
3 91
4 113
2016 1 145 123.75
2 137
3 95
4 118
2017 1 150 127.25
2 141
3 99
4 119
2018 1 156 133.75
2 149
3 105
4 125
Line Graph:

TASK 4
1.
Packet Brie Gouda
Quantity 0 0 Total Porfit
Unit
Profit
2.8 2 = 2.8 *
2 = 5.6
Used Symbol Max
Milk 2 2 = 2 * 2
= 4
Salt 3 2 = 3 *2 =
6
2.
3.
Salt cheese here in comparively would give maximum profits with greater profits.