Semester 1 Data Analysis Project: Agency Data Insights

Desklib provides solved assignments and past papers to help students succeed.

Introduction
• Data analysis is an integral part of any type of research. It
takes place after the successful collection of data. The main
purpose of data analysis done on any sort of data is to derive
and successfully relevant information therefrom.
• For the purpose of data analysis, several statistical tools and
techniques are applied and used on the collected data as per
the nature and type of data.

VISUALISATION
DATA

Nature of given data and
tools used
The given data belongs to the various types of agencies. It
can be stated that the given data has both qualitative and
qualitative variables. To get desired output, it is very
crucial to apply statistical tools on some variables at a
single point of time.
Different visualizations has been used in this report. These
primarily include varied charts, descriptive statistics,
along with regression analysis.

Table representing the ‘state’ and ‘Y
region’
Count of
State
Column
Labels
Row
Labels
East West (blank) Grand
Total
North 444 11 455
South 2 2
(blank) 10 10
Grand
Total
446 11 10 467
North South (blank)
0
50
100
150
200
250
300
350
400
450
500
444
2
11 10
East
West
(blank)

Purpose and metro/country
Row Labels Count of Metro /
Country
Agency
communications
9
Boardroom 1
Classes & Meetings 151
Conference Room 3
Courtroom 42
Lecture Theatre 1
Meeting Room 4
Meetings 30
Mobile 5
Prisoner Suite 9
Support 2
Training Room 1
(blank) 181
Grand Total 439
Agency communications
Boardroom
Classes & Meetings
Conference Room
Courtroom
Lecture Theatre
Meeting Room
Meetings
Mobile
Prisoner Suite
Support
Training Room
(blank)
0
20
40
60
80
100
120
140
160
180
200
Total

Descriptive statistics
E.164
Mean 50329.29
Standard Error 32.69
Median 50283.00
Mode 50253.00
Standard Deviation 325.29
Sample Variance 105811.68
Kurtosis 48.64
Skewness 6.81
Range 2698.00
Minimum 50202.00
Maximum 52900.00
Sum 4982600.00
Count 99.00
E.164
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
0.00
1000000.00
2000000.00
3000000.00
4000000.00
5000000.00
6000000.00
Chart Title

DECS DECS DECS HEALTH HEALTH HEALTH HEALTH JUSTICE (CAA) PIRSA TAFE TAFE
0
1000
2000
3000
4000
5000
6000
7000
Post Code

Great Circle Distance
0 2000 4000 6000 8000 10000 12000 14000 16000
0
2000
4000
6000
8000
10000
12000
14000
16000

Longitude and latitude
125 130 135 140 145 150 155
-40
-35
-30
-25
-20
-15
-10
-5
0
Latitude

References
• Brief, R.P., and Peasnell, K.V., 2013. Clean Surplus: A link
between accounting and finance. Routledge.
• Collier, P.M., 2015. Accounting for managers: Interpreting
accounting information for decision making. John Wiley &
Sons.
• Gillett, P.R., 2016. Accounting Information Systems. John
Wiley & Sons, Incorporated.