Statistical Analysis Report: Business Decision Making

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

Statistics and Research Methods for Business Decision Making
1

Contents
Answer 1.............................................................................................................................. 3
Answer 2.............................................................................................................................. 5
Answer 3.............................................................................................................................. 7
References......................................................................................................................... 15
2

Answer 1
2004-05 2014-15
Country A$ bn
Share
(%) A$ bn
Share
(%)
China
$
15.90 15%
$
90.30 40%
Japan
$
28.20 27%
$
46.60 21%
United States
$
13.90 13%
$
20.50 9%
Republic of
Korea
$
11.00 11%
$
20.50 9%
India
$
7.10 7%
$
12.70 6%
New Zealand
$
12.20 12%
$
12.30 6%
Singapore
$
5.80 6%
$
12.00 5%
United
Kingdom
$
9.20 9%
$
8.60 4%
Subtotal
$
103.30 100%
$
223.50 100%
(a)
(b)
3
China
Japan
United States
Republic of Korea
India
New Zealand
Singapore
United Kingdom
$- $20.00 $40.00 $60.00 $80.00 $100.00
Top 8 export markets for goods and services
2014-15 2004-05

(c)
From year 2004-05 to year 2014-15, total export has grown to a scale of $223.50 from
$103.30. China continued to be Australia’s largest export market for both goods and
services in both 2004-05 and 2014-15. Change in market share for both goods and
services have changed for almost all the markets. Exports to China continued to grow
strong, rising to almost 40% market share.
4
China
Japan
United States
Republic of Korea
India
New Zealand
Singapore
United Kingdom
0% 5% 10% 15% 20% 25% 30% 35% 40% 45%
Top 8 export markets for goods and services
2014-15 2004-05
China
Japan
United States
Republic of Korea
India
New Zealand
Singapore
United Kingdom
-10% -5% 0% 5% 10% 15% 20% 25% 30%
Change in export market

Answer 2
(a) Frequency distribution:
Lower upper
midpoin
t width
frequenc
y percent
20 < 30 25 10 0 0.0
30 < 40 35 10 2 5.0
40 < 50 45 10 4 10.0
50 < 60 55 10 8 20.0
60 < 70 65 10 11 27.5
70 < 80 75 10 8 20.0
80 < 90 85 10 5 12.5
90  100 95 10 2 5.0
Total 40 100.0
Relative frequency distribution:
lower upper midpoint width
Relative
Frequency percent
20 < 30 25 10 0.000 0.0
30 < 40 35 10 0.050 5.0
40 < 50 45 10 0.100 10.0
50 < 60 55 10 0.200 20.0
60 < 70 65 10 0.275 27.5
70 < 80 75 10 0.200 20.0
80 < 90 85 10 0.125 12.5
90  100 95 10 0.050 5.0
(b)Cumulative frequency distribution:
cumulative
lower upper Midpoint width frequency percent
20 < 30 25 10 0 0.0
30 < 40 35 10 2 5.0
40 < 50 45 10 6 15.0
50 < 60 55 10 14 35.0
60 < 70 65 10 25 62.5
70 < 80 75 10 33 82.5
80 < 90 85 10 38 95.0
90  100 95 10 40 100.0
Relative Cumulative frequency distribution:
cumulative
lower upper
midpoin
t width
relative
frequency
percen
t
20 < 30 25 10 0.00 0.0
30 < 40 35 10 0.05 5.0
40 < 50 45 10 0.15 15.0
5

50 < 60 55 10 0.35 35.0
60 < 70 65 10 0.63 62.5
70 < 80 75 10 0.83 82.5
80 < 90 85 10 0.95 95.0
90  100 95 10 1.00 100.0
(c)
30-39.9
40-49.9
50-59.9
60-69.9
70-79.9
80-89.9
90-100
0.000
0.050
0.100
0.150
0.200
0.250
0.300
Histogram
Data
(d)
20 30 40 50 60 70 80 90
0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
Ogive
(e)Using cumulative frequency data, 35% proportion of the grades is less than 60.
(f) Using cumulative frequency data, 62.5% proportion of the grades is less than 70.
6

Answer 3
(a)
Feb-1982 Aug-1987 Jan-1993 Jul-1998 Jan-2004 Jul-2009 Dec-2014 Jun-2020
0.0
50000.0
100000.0
150000.0
200000.0
250000.0
Time series data
Retail turnover per capita - Chain Volume Measures ; Total (State) ;
FINAL CONSUMPTION EXPENDITURE: Chain volume measures ;
(b)
7

70000 90000 110000 130000 150000 170000 190000 210000 230000 250000
0.0
500.0
1000.0
1500.0
2000.0
2500.0
3000.0
3500.0
Final Consumption Expenditure
Retail turnover per capita
x-axes: Final consumption expenditure
y-axes: Retail turnover per capita
These axes were chosen as with increase in retail turnover per capita, final consumption
expenditure is increasing significantly and also standard error of the estimate will be very
less in these chosen axes.
(c)
Retail turnover
per capita - Chain
Volume
Measures; Total
(State)
FINAL
CONSUMPTION
EXPENDITURE:
Chain volume
measures
Unit $ $ Millions
Mean 2205.76 146019.85
Median 2180.2 139137
Standard
Deviation 543.19 46904.33
Sample
Variance 295059.5953 2200016262
Range 1558.7 151259
Minimum 1455.9 81889
Maximum 3014.6 233148
Sum 288954.8 19128601
First quantile 1652.95 103558.5
Second
quantile 2180.2 139137
Third quartile 2793.4 192800.5
8

(d)
Retail
turnover per
capita
(x)
FINAL
CONSUMPTI
ON
EXPENDITUR
E
(Y)
X2 Y2 XY
1455.9 81889 211964
5
670580832
1
142139318044625
00
1459.6 82410 213043
2
679140810
0
144686342279245
00
1462.5 82711 213890
6
684110952
1
146324919114014
00
1465.7 82461 214827
6
679981652
1
146078859683779
00
1470.1 82200 216119
4
675684000
0
146028421345284
00
1476.0 82453 217857
6
679849720
9
148110428555944
00
1485.0 83559 220522
5
698210648
1
153971157645632
00
1500.8 85247 225240
1
726705100
9
163683103435842
00
1515.7 86605 229734
6
750042602
5
172310774020384
00
1526.0 87364 232867
6
763246849
6
177735462073913
00
1531.1 87880 234426
7
772289440
0
181045281082126
00
1530.4 88410 234212
4
781632810
0
183068108854969
00
1522.9 89018 231922
4
792420432
4
183780080980484
00
1512.3 89354 228705
1
798413731
6
182601315480949
00
1512.0 89528 228614
4
801526278
4
183240449220649
00
1530.9 90165 234365
5
812972722
5
190532743148592
00
1551.4 91216 240684
2
832035865
6
200257883355100
00
1562.9 92190 244265
6
849899610
0
207601273022300
00
1565.5 92900 245079
0
863041000
0
211513246815025
00
1568.7 93543 246082
0
875029284
9
215328929360854
00
1582.8 94623 250525 895351212 224308385496881
9

6 9 00
1600.9 96143 256288
1
924347644
9
236899284088290
00
1614.3 97695 260596
4
954431302
5
248721408245945
00
1622.2 98848 263153
3
977092710
4
257125155514221
00
1627.2 99721 264778
0
994427784
1
263302583907585
00
1633.1 100541 266701
6
101084926
81
269595077737977
00
1637.3 101400 268075
1
102819600
00
275633775337284
00
1632.7 101929 266570
9
103895210
41
276954427576442
00
1623.0 102007 263412
9
104054280
49
274092397812843
00
1609.9 101812 259177
8
103656833
44
268655501496025
00
1605.7 101910 257827
2
103856481
00
267770307870508
00
1618.5 102435 261954
2
104929292
25
274866714311473
00
1641.8 103169 269550
7
106438425
61
286905546845956
00
1664.1 103948 276922
9
108051867
04
299220343181457
00
1677.3 104715 281333
5
109652312
25
308488719683024
00
1681.2 105413 282643
3
111119005
69
314070473501766
00
1681.7 105905 282811
5
112158690
25
317197661938923
00
1680.7 106212 282475
2
112809889
44
318660016092265
00
1680.3 106458 282340
8
113333057
64
319985471805212
00
1685.5 106887 284091
0
114248307
69
324569188361675
00
1700.0 107626 289000
0
115833558
76
334758984816400
00
1723.3 108514 296976
3
117752881
96
349698139035358
00
1749.7 109534 306145
0
119976971
56
367303510380289
00
1773.1 110713 314388
4
122573683
69
385357395170315
00
1789.2 111958 320123
7
125345937
64
401262008248323
00
1808.5 113375 327067
2
128538906
25
420408633717227
00
10

1832.7 114573 335878
9
131269723
29
440907340687716
00
1859.5 115502 345774
0
133407120
04
461287168598890
00
1884.3 116397 355058
6
135482616
09
481042746319011
00
1901.3 117328 361494
2
137658595
84
497627797088877
00
1912.9 118275 365918
6
139889756
25
511882694968213
00
1917.2 119047 367565
6
141721882
09
520920863559900
00
1918.5 119597 368064
2
143034424
09
526458544510072
00
1923.7 120374 370062
2
144898998
76
536216377670539
00
1938.6 121686 375817
0
148074825
96
556490362755100
00
1963.7 123509 385611
8
152544730
81
588230434992729
00
1988.8 125225 395532
5
156813006
25
620246472943504
00
2004.8 126496 401922
3
160012380
16
643125445024311
00
2013.7 127686 405498
8
163037145
96
661113619880533
00
2015.8 129205 406345
0
166939320
25
678349520771707
00
2027.7 131188 411156
7
172102913
44
707612709413605
00
2055.0 133267 422302
5
177600932
89
750013179617792
00
2091.8 134997 437562
7
182241900
09
797422622303163
00
2133.5 136580 455182
2
186540964
00
849101310471649
00
2167.0 137998 469588
9
190434480
04
894259180040556
00
2183.8 139137 476898
2
193591047
69
923232306974813
00
2186.3 140239 477990
8
196669771
21
940063351797220
00
2180.2 141288 475327
2
199622989
44
948862374246367
00
2181.5 142416 475894
2
202823170
56
965223755656940
00
2198.2 143654 483208
3
206364717
16
997171491116176
00
2221.2 144742 493372
9
209502465
64
103362848248066
000
2244.1 145635 503598 212095532 106810987867986
11

5 25 000
2264.9 146449 512977
2
214473096
01
110019808481014
000
2292.7 147556 525647
3
217727731
36
114448000438614
000
2327.1 149395 541539
4
223188660
25
120865462309324
000
2360.4 151593 557148
8
229804376
49
128035236273022
000
2382.6 153353 567678
3
235171426
09
133501709727233
000
2396.2 154454 574177
4
238560381
16
136975989894115
000
2416.3 155335 583850
6
241289622
25
140877083244458
000
2458.7 156808 604520
6
245887488
64
148644044542634
000
2517.6 159178 633831
0
253376356
84
160597783551221
000
2574.7 161902 662908
0
262122576
04
173763154996627
000
2616.9 164435 684816
6
270388692
25
185166654359932
000
2643.2 166648 698650
6
277715559
04
194026148617805
000
2656.8 168338 705858
6
283376822
44
200023973960991
000
2658.7 169702 706868
6
287987688
04
203569444934453
000
2654.4 170947 704583
9
292228768
09
205899695633283
000
2651.8 172211 703204
3
296566285
21
208546694112289
000
2654.2 173534 704477
8
301140491
56
212146780144050
000
2665.4 174872 710435
7
305802163
84
217252779222020
000
2686.0 176281 721459
6
310749909
61
224193505487267
000
2706.4 177986 732460
1
316790161
96
232036152441077
000
2728.6 180171 744525
8
324615892
41
241684905690806
000
2749.9 182775 756195
0
334067006
25
252619800125286
000
2774.4 185510 769729
5
344139601
00
264894415396955
000
2804.2 188216 786353
8
354252626
56
278567886302342
000
2831.2 190775 801569
3
363951006
25
291731969327952
000
12