Data Analysis and Visualization: Frequency Tables, Network, and Trends

This assignment focuses on using and managing data through various analytical techniques. It includes creating frequency tables for variables like gender, age, and education, alongside graphical representations such as bar charts and box-and-whisker plots to visualize spending patterns. The assignment also involves calculating descriptive statistics (min, max, median, mean) and analyzing user spending habits. Furthermore, it explores network diagrams for project management and time series analysis using moving averages to identify trends in sales data. The document is contributed by a student and available on Desklib, which provides a wide array of study tools and resources for students.

Using and managing data
1

Table of Contents
TASK 1............................................................................................................................................3
TASK 2............................................................................................................................................3
TASK 3............................................................................................................................................4
REFERENCES................................................................................................................................8
2

TASK 1
1) Label codes for categories of following variables
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
Regular user or self check out
1. Yes 2. No
2) Frequency table
Gender
Row Labels
Count of
Gender
Percentage
1 94 21%
2 102 51%
3 2 4%
Grand Total 198
3

Education
Row Labels
Count of
Education
Percentage
1 67 33%
2 72 36%
3 59 29%
Grand Total 198
4

Age
Row Labels
Count of
Age
Percentage
1 18 9%
2 17 8%
3 32 16.%
4 94 47.%
5 37 18.%
Grand Total 198
SCC user
Row Labels
Count of
SCC_user
Percentage
1 69 34%
2 129 65%
Grand Total 198
5

Spending
3) Graphical representation
Education
6

Age
Spending
7

Spending box and whisker graph
4) Calculate min, max, media, quartile and mean
8

min 92
q1 112
median 118
q3 118
max 149
Mean 17.33
Mean and SD of users and non users
User
Mean 1
SD 0
Non user
Mean 2
SD 0
5) Cross table between two variables in it
Are you regular or self user and gender
9

Are you regular user or self check out and age
Scatter diagram and calculate correlation of spending against reliability
Correlation of spending against reliability is 0.41
10

TASK 2
1) Network diagram
Task Name Duration Start Finish Predecessors
A 1 day Fri 12/11/20 Fri 12/11/20
B 2 days Fri 12/11/20 Mon 12/14/20
C 3 days Tue 12/15/20 Thu 12/17/20 1,2
D 1 day Fri 12/11/20 Fri 12/11/20
E 2 days Fri 12/18/20 Mon 12/21/20 1,3
F 4 days Tue 12/22/20 Fri 12/25/20 5
G 3 days Mon 12/14/20 Wed 12/16/20 4
H 2 days Mon 12/28/20 Tue 12/29/20 6
I 1 day Wed 12/30/20 Wed 12/30/20 8
J 1 day Thu 12/31/20 Thu 12/31/20 7,9
11

Backward pass
Forward pass
12