Statistical Analysis of Australian Export Trends (2004-2015)

Desklib provides past papers and solved assignments for students. This report analyzes Australian export and retail data using statistical methods.

Statistics and Research Methods for Business Decision Making
1

Table of Contents
Question 1........................................................................................................................3
(a)................................................................................................................................. 3
(b)................................................................................................................................. 4
(c)................................................................................................................................. 4
Question 2........................................................................................................................6
(a)................................................................................................................................. 6
(b)................................................................................................................................. 6
(c)................................................................................................................................. 7
(d)................................................................................................................................. 8
(e)................................................................................................................................. 8
(f).................................................................................................................................. 9
Question 3......................................................................................................................10
(a)............................................................................................................................... 10
(b)............................................................................................................................... 10
(c)............................................................................................................................... 10
(d)............................................................................................................................... 12
(e)............................................................................................................................... 12
(f)................................................................................................................................ 14
(g)............................................................................................................................... 14
(h)............................................................................................................................... 15
References.....................................................................................................................16
2

Question 1
Australia: Direction of exports
Top 8 export markets for goods and
services
S.N
O
Country A$ bn Chang
e in
Value
of
Export
Change
in
Export
(%)2004-
05
2014-
15
1 China 15.9 90.3 -74.4 -
467.92
%
2 Japan 28.2 46.6 -18.4 -
65.25%
3 United States 13.9 20.5 -6.6 -
47.48%
4 Republic of Korea 11 20.5 -9.5 -
86.36%
5 India 7.1 12.7 -5.6 -
78.87%
6 New Zealand 12.2 12.3 -0.1 -0.82%
7 Singapore 5.8 12 -6.2 -
106.90
%
8 United Kingdom 9.2 8.6 0.6 6.52%
3

Subtotal 103.3 223.5 -120.2 -
116.36
%
As per the above calculations is study on the exports of the Australia with the different
countries and in the 2004-05 the most exports with the Japan, China, and Unites states.
The highest export with the japan with the percentage of 28.2 in 2004-05, and in the
2014-15 the highest ratio has export in the china with the percentage of 90.3.
(a)
1 2 3 4 5 6 7 8
-80
-70
-60
-50
-40
-30
-20
-10
0
10 f(x) = 7.25476190476191 x − 47.6714285714286
Change in Value of Export
Change in Value of Export
Linear (Change in Value of
Export)
In the graph has shown that, change in value of export, which means there is having
changes as in 2004-05 and 2014-15 with thy different countries has doing export. There
is having most changes in value of export are china. There is having change in 2004-05
to 2014-15 with the 120.20 (Mathsisfun, 2019). This is the large difference in the two
years. The change in value of export is going positively and they will gate the more
returns in exports.
4

(b)
1 2 3 4 5 6 7 8
-500.00%
-400.00%
-300.00%
-200.00%
-100.00%
0.00%
100.00%
Change in Export ( %)
Change in Export ( %)
As per the above chat is shown the change in export with the respective years, 2004-05
with the 2014-15, the export is running forward with the more returns. The export is
changes with the requirement of the country, the most export with the china and that is
good for the country’s economy. The change in export in china has become the 467.30,
the export has also going effectively to maintain the economy flexible and more returns.
(c)
As per the graph of change in value of exports and change in exports percentage that
both of the graph is going positively, it is helpful for the organisations, as well as
economy of the country to get the return from the different country. In 2004-05 is most
having exports with the Japan, and in the 2014-15 the most difference in exports is with
the China. The ratio is also increased and it has become double with the year. The most
changes in the percentage is China because of more earning, and good relationship
with the country.
5

Question 2
(a)
Classes Bin Frequency Relative Frequency
30-40 35.00 2.00 0.05
40-50 45.00 4.00 0.10
50-60 55.00 8.00 0.20
60-70 65.00 11.00 0.28
70-80 75.00 8.00 0.20
80-90 85.00 5.00 0.13
90-100 95.00 2.00 0.05
As per the above table the is shown the frequency distribution and relative frequency
distribution of the Umbrella sales with the class of the different in the given table. There
is having class with the sale in 40 days of the one store. Frequency is calculated from
the given data of the sales and they will gives the proper sales in the in the week or they
will defines the proper data of the sales in the class.
(b)
Class
es
Bin Frequen
cy
Relative
Frequency
Cumulative
Frequency
Cumulative
Relative
Frequency
30-40 35.
00
2.00 0.0
5
2.0
0 0.05
40-50 45. 4.00 0.1 6.0
6

00 0 0 0.15
50-60 55.
00
8.00 0.2
0
14.0
0 0.35
60-70 65.
00
11.00 0.2
8
25.0
0 0.63
70-80 75.
00
8.00 0.2
0
33.0
0 0.83
80-90 85.
00
5.00 0.1
3
38.0
0 0.95
90-
100
95.
00
2.00 0.0
5
40.0
0 1.00
As per the above table, it has shown the cumulative frequency and commutative relative
frequency. Cumulative frequency is the total frequencies; the frequency is set of the
elements it has calculated in the set. The most cumulative frequency is having more in
the class of 60-70 in the difference is having the 11 days and that is the average of the
number or they are doing the average sale in a day that is 60-70.
(c)
30-40 40-50 50-60 60-70 70-80 80-90 90-100
-
0.05
0.10
0.15
0.20
0.25
0.30
Histogram
Relative Frequency
7

The above histogram is shown for the relative frequency, and the above histogram is
shown the clear, in the class of sale is gone highest and lowest. There is having
different days with the different sales in the 40 days. The maximum sale is in class of
60-70, it has done the maximum sales. The histogram is showing clearly with the
different sales in the days. The lowest sale in lower time is categorised in 30-40 and 40-
50 and they both of the class has earn the minimum profit or minimum sales in the days.
This ratio is bad for the business, and the the class of 70-80, 80-90, and 90-100 is good,
it can also improve more times.
(d)
0 1 2 3 4 5 6 7 8
-
0.05
0.10
0.15
0.20
0.25
0.30
Relative Frequency
The above Ogive diagram is shown the relative frequency to show the fluency of the
sale with the different sale. As per the diagram, it is showing that the business is not
having the continuity in the market, and they will gate recession in anytime, that is the
biggest problem in the market. The fluency of the sale is not fix in the market, the value
of the circumstances is not having the proper clearance is the sale. The relative
frequency is showing the maximum constant in the day is 60-70 sales in a day. In this
diagram that showing the various sales, there can succeed with the help of market
needs with the proper advertisement of the product.
8

(e)
The proportion of the grades is less than 60 are 19.5 days, this less than then second
half. The proportion is shown in the 19.5 days that is having fewer figures to shows in
the sales. the sales is less than 60 is having the 19.5 days and after that they will work
and they will gate the good sales after more than 70.
(f)
The proportion of the grades is more than 70 are 21.5 days. In the 40 days of count, in
which the 21.5 days will gates the sale of above 70 and then the business will earn
maximum return as compare to the previous days. The previous days is also affecting
the whole sales of the business and that will also decreases the sales of the business.
the business is not have the consistency, any of the business is need to being the
constant or upper level of the sale is required to make more return in the business from
the market.
9

Question 3
(a)
There are two variables is showing the per capita retail turnover in Australia is a good
predictor of the final consumption expenditure of the country, it has shown in below:
Per capita retail turnover
The per capita retail turnover is the turnover of the retail counter in the country for the
individual; the data has shown from the given data, they are the good predictor of the
final consumption expenditure of the country.
Final consumption expenditure
The final consumption expenditure is the expenditure is done by the individual person to
purchase from the retail counter in the given data as per the data they both of the
variable is very consecutive with the other.
(b)
There is having relationship with the per capita retail turnover and final consumption
expenditure from the one or more, such the most relation of this two is they are not
complete for one another. The relation of the per capita retail turnover is making the
study of the turnover from the individual of the person, and they will make earn from the
final consumption expenditure. The both of the variable is the cycle is done for the one
other (Mathsisfun, 2019). The relation is needed because the per capita retail turnover
is earn the profit from the final consumption expenditure and they will earn more and
they will do more expenses in the market.
(c)
Retail Turnover
Particular Amount
Mean 2205.761832
Standard Error 47.45906998
Median 2180.2
10

Mode 2852.8
Standard Deviation 543.1938837
Sample Variance 295059.5953
Kurtosis -1.611990019
Skewness 0.074657645
Range 1558.7
Minimum 1455.9
Maximum 3014.6
Sum 288954.8
Count 131
Largest(1) 3014.6
Smallest(1) 1455.9
Confidence Level (95.0%) 93.8920941
Final Consumption
Particular Amount
11

Mean 146019.855
Standard Error 4098.05042
Median 139137
Mode #N/A
Standard Deviation 46904.331
Sample Variance 2200016262
Kurtosis -1.2960945
Skewness 0.30683061
Range 151259
Minimum 81889
Maximum 233148
Sum 19128601
Count 131
Largest(1) 233148
Smallest(1) 81889
Confidence Level (95.0%) 8107.50266
12