Question
This is an individual assessment. In this assessment, students are provided data of stock prices of 3 Australian companies listed in the ASX. The main
This is an individual assessment. In this assessment, students are provided data of stock prices of 3 Australian companies listed in the ASX. The main tasks include estimating descriptive statistics and analyzing the data.learning management system.
Purpose of the assessment:
a)To attain the knowledge of descriptive statistics.
b)To use graphical tools to present data.
c)To analyze data and take business decisions.
You are working as an investment analyst. You will apply descriptive statistics in analyzing the performance of the companies and recommend the best performing company based on your analysis. You will analyze the performance of stock prices of Commonwealth Bank of Australia, Westpac and ANZ. You can collect data from Yahoo Finance. The assessment includes data of last five years. The frequency of data is monthly. The presentation of the report should maintain professional standard.
The a needs to be submitted in a report format. In the report, need to provide:
a)Introduction: Indentify the purpose of the report
b)Description of the data using mean, mode, median, standard deviation, and range.
c)Graphical presentation of the data: Time series graph, comparison of mean stock price using bar diagram.
d)Analysis of the data
e)Calculate the confidence interval of mean stock return of stock prices and interpret the results( use ur own confedentional level and z score .
f)Recommendation and conclusion
Data:
Data is collected from the following source:
https://au.finance.yahoo.com/
Date
CBA
WBC
ANZ
1/10/2015
59.17163
23.70431
20.49464
1/11/2015
61.25379
24.28597
20.44945
1/12/2015
65.9579
26.14647
21.81457
1/01/2016
60.6677
24.03512
18.88566
1/02/2016
54.08964
22.39901
17.4954
1/03/2016
59.35762
23.64557
18.3233
1/04/2016
58.54158
24.19094
18.95595
1/05/2016
61.34626
23.91825
19.90101
1/06/2016
58.92187
23.61439
19.45799
1/07/2016
61.28286
24.97181
20.84553
1/08/2016
56.89363
23.66258
21.70065
1/09/2016
59.08704
23.70274
22.28955
1/10/2016
59.895
24.47382
22.46703
1/11/2016
64.1878
25.11639
22.91879
1/12/2016
67.25639
26.73114
25.25419
1/01/2017
66.64432
26.24286
24.31609
1/02/2017
67.18295
27.88977
25.65268
1/03/2017
71.77481
29.01529
26.41645
1/04/2017
73.01965
29.01529
27.19682
1/05/2017
66.54481
25.24148
23.25345
1/06/2017
69.18487
26.01
24.48188
1/07/2017
69.9535
27.12678
25.2576
1/08/2017
63.32826
26.6579
25.06154
1/09/2017
64.70026
27.21203
25.23202
1/10/2017
66.7466
28.12422
25.5048
1/11/2017
68.29424
26.82841
24.26025
1/12/2017
69.07667
27.50389
25.16263
1/01/2018
67.81275
27.16174
25.02255
1/02/2018
65.68044
26.99505
25.43405
1/03/2018
63.84598
25.10882
23.51664
1/04/2018
63.41335
25.12636
23.49913
1/05/2018
61.18832
24.43328
23.82308
1/06/2018
64.34045
26.53092
25.44808
1/07/2018
66.03571
26.67579
26.40329
1/08/2018
62.90123
25.84274
26.58352
1/09/2018
65.03161
25.29039
25.39402
1/10/2018
63.04633
24.31246
23.36646
1/11/2018
64.86768
23.51563
24.15045
1/12/2018
65.92408
23.46878
22.7115
1/01/2019
63.66559
23.00953
23.24076
1/02/2019
67.34473
25.26831
25.99845
1/03/2019
66.13413
24.29357
24.16927
1/04/2019
69.76662
25.7838
25.25563
1/05/2019
73.50213
25.71819
25.88702
1/06/2019
77.49975
27.5433
26.97825
1/07/2019
77.05037
27.82495
26.69136
1/08/2019
74.00768
27.40733
25.57244
1/09/2019
77.93995
28.78644
27.27472
1/10/2019
75.84754
27.39762
25.57244
1/11/2019
77.93031
23.81388
23.7554
1/12/2019
77.0432
24.23
24.29499
1/01/2020
82.21156
25.12
25.39976
1/02/2020
78.85597
23.64
24.49227
1/03/2020
60.96042
16.5
16.72932
1/04/2020
61.81832
16.28
16.67013
1/05/2020
62.86358
17.22
17.64667
1/06/2020
68.45474
17.95
18.38646
1/07/2020
70.20998
17.09
17.71571
1/08/2020
67.33059
17.54
18.03136
1/09/2020
66.73
17.06
17.81
7/09/2020
67.23
17.35
18.075
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started