Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

China's Water Pollution Problems

Authors: Claudio O Delang

1st Edition

1317209257, 9781317209256

More Books

Students also viewed these Economics questions

Question

2. Develop a good and lasting relationship

Answered: 1 week ago

Question

1. Avoid conflicts in the relationship

Answered: 1 week ago