Statistical Analysis of Export Values: A Case Study

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

Statistics
1

Table of Contents
Question 1.......................................................................................................................................3
Question 2.......................................................................................................................................4
Question 3.......................................................................................................................................7
References.....................................................................................................................................12
2

Question 1
(a)
A$ bn
Sr. No. Country
2004-
05
2014-
15
1 China 15.9 90.3
2 Japan 28.2 46.6
3 United States 13.9 20.5
4 Republic of Korea 11 20.5
5 India 7.1 12.7
6 New Zealand 12.2 12.3
7 Singapore 5.8 12
8 United Kingdom 9.2 8.6
Subtotal 103.3 223.5
(b)
% %
Sr. No. Country 2004-05 2014-15
1 China 15.39% 40.40%
2 Japan 27.30% 20.85%
3 United States 13.46% 9.17%
4 Republic of Korea 10.65% 9.17%
5 India 6.87% 5.68%
6 New Zealand 11.81% 5.50%
7 Singapore 5.61% 5.37%
8 United Kingdom 8.91% 3.85%
Subtotal 100.00% 100.00%
(c)
It can be clearly observed that the China has the highest export value (both in terms of value and
$) followed by Japan.
3

Question 2
(a)
Class Frequency Relative
frequency
30-40 2 0.05
40-50 4 0.1
50-60 8 0.2
60-70 11 0.275
70-80 8 0.2
80-90 7 0.175
90-100 0 0
Sum 40
(b)
Class Frequency Relative
frequency
Cumulativ
e frequency
Cumulative
relative
frequency
30-40 2 0.05 0.05 0.05
40-50 4 0.1 0.15 0.15
50-60 8 0.2 0.35 0.35
60-70 11 0.275 0.625 0.625
70-80 8 0.2 0.825 0.825
80-90 7 0.175 1 1
90-100 0 0
Sum 40
4

(c)
1 2 3 4 5 6 7
0
0.05
0.1
0.15
0.2
0.25
0.3
Relative frequency
Relative frequency
Bin Frequency Cumulative
%
0 1 14.29%
2 6 100.00%
4 0 100.00%
7 0 100.00%
8 0 100.00%
8 0 100.00%
11 0 100.00%
More 0 100.00%
5

(d)
0
2
4
7
8
8
11
More
0
1
2
3
4
5
6
7
0.00%
20.00%
40.00%
60.00%
80.00%
100.00%
120.00%
Histogram
Frequency
Cumulative %
Bin
Frequency
(e)
35%
(f)
37.5%
6

Question 3
(a)
Particulars Retail turnover
per capita - Chain
Volume Measures;
Total (State) ;
FINAL
CONSUMPTIO
N
EXPENDITUR
E: Chain volume
measures;
Unit $ $ Millions
Year
1983 2915.5 164299.0
1984 5874.3 329825.0
1985 6027.5 342775.0
1986 6096.7 354662.0
1987 6157.2 363099.0
1988 6317.9 377209.0
1989 6496.8 396805.0
1990 6502.9 407148.0
1991 6530.1 411462.0
1992 6720.9 422245.0
1993 6789.1 429485.0
1994 7120.5 445580.0
1995 7477.8 463800.0
1996 7672.3 477293.0
1997 7895.9 496916.0
1998 8112.2 521346.0
1999 8576.1 548712.0
2000 8746.2 567597.0
2001 9022.9 584382.0
2002 9466.3 608795.0
2003 9967.3 633223.0
2004 10575.6 669123.0
2005 10625.8 691564.0
2006 10870.9 717213.0
2007 11254.6 757329.0
7

2008 11211.9 773237.0
2009 11240.8 780413.0
2010 11396.5 806177.0
2011 11366.1 832459.0
2012 11517.5 850443.0
2013 11591.9 865809.0
2014 11805.9 889948.0
2015 11996.3 915080.0
2016 3014.6 233148.0
(b)
SUMMARY
OUTPUT
Regression Statistics
Multiple R 0.99
R Square 0.98
Adjusted R
Square 0.98
Standard
Error 85.27
Observatio
ns 131
ANOVA
df SS MS F
Significa
nce F
Regression 1
3741973
2.5
374197
32.5
5146.1
28864
7.9451E
-106
Residual 129
938014.8
886
7271.4
33245
Total 130
3835774
7.39
Coeffic
ients
Standard
Error t Stat P-value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 535.53 24.45 21.91 0.00 487.16 583.89 487.16 583.89
X Variable
1 0.01 0.00 71.74 0.00 0.01 0.01 0.01 0.01
8

(c)
Descriptive statistics of retail turnover
Mean 2205.76
Standard Error 47.46
Median 2180.20
Mode 2852.80
Standard Deviation 543.19
Sample Variance 295059.60
Kurtosis -1.61
Skewness 0.07
Range 1558.70
Minimum 1455.90
Maximum 3014.60
Sum 288954.80
Count 131.00
Descriptive statistics of final consumption
expenditure
Mean 146019.85
Standard Error 4098.05
Median 139137.00
Mode #N/A
Standard Deviation 46904.33
Sample Variance 2200016261.88
Kurtosis -1.30
Skewness 0.31
Range 151259.00
Minimum 81889.00
Maximum 233148.00
Sum 19128601.00
Count 131.00
9

(d)
Correlation between retail
turnover and consumption
expenditure
0.988
(e)
1200.0 1400.0 1600.0 1800.0 2000.0 2200.0 2400.0 2600.0 2800.0 3000.0 3200.0
0
50000
100000
150000
200000
250000
f(x) = 85.2868091205818 x − 42102.5333746251
R² = 0.975545621096024
Series2
Linear (Series2)
(f)
R 0.99
Coefficient of
determination 0.98
(g)
SUMMARY
OUTPUT
Regression Statistics
Multiple R 0.99
R Square 0.98
10

Adjusted R
Square 0.98
Standard
Error 85.27
Observatio
ns 131
ANOVA
df SS MS F
Significa
nce F
Regression 1.00
3741973
2.50
374197
32.50
5146
.13 0.00
Residual 129.00
938014.8
9 7271.43
Total 130.00
3835774
7.39
Coeffic
ients
Standard
Error t Stat
P-
valu
e
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 535.53 24.45 21.91 0.00 487.16 583.89 487.16 583.89
X Variable
1 0.01 0.00 71.74 0.00 0.01 0.01 0.01 0.01
(h)
Standard error
of estimate 4898.35
11

References
 Harding, B., Tremblay, C., Cousineau, D., (2014) Standard Errors. School of Psychology,
Universitéd’Ottawa, vol. 10, no. 2, 1-17.
 Pardoe, I. (2019). Statistics.com - Regression Analysis. [online] Statistics.com. Available at:
https://www.statistics.com/regression-analysis/ [Accessed on: 1st May, 2019].
 Stat Pac. (2017). Survey Sampling Method. [Online] Stat Pac. Available at:
https://www.statpac.com/surveys/sampling.htm [Accessed on: 1st May, 2019]
 Survey Any Place. (2018). 9 Types of Survey You Should Start Using Today. [Online] Survey
Any Place. Available at: https://surveyanyplace.com/types-of-surveys/ [Accessed on: 1st May,
2019].
12