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, and Westpac. You can collect data from Yahoo Finance. The assessment includes data of five years. The frequency of data is monthly.

Data (You can copy the data and put into Excel file)

Data is collected from the following source:

https://au.finance.yahoo.com/

Date

CBA

WBC

1/10/2015

59.17163

23.70431

1/11/2015

61.25379

24.28597

1/12/2015

65.9579

26.14647

1/01/2016

60.6677

24.03512

1/02/2016

54.08964

22.39901

1/03/2016

59.35762

23.64557

1/04/2016

58.54158

24.19094

1/05/2016

61.34626

23.91825

1/06/2016

58.92187

23.61439

1/07/2016

61.28286

24.97181

1/08/2016

56.89363

23.66258

1/09/2016

59.08704

23.70274

1/10/2016

59.895

24.47382

1/11/2016

64.1878

25.11639

1/12/2016

67.25639

26.73114

1/01/2017

66.64432

26.24286

1/02/2017

67.18295

27.88977

1/03/2017

71.77481

29.01529

1/04/2017

73.01965

29.01529

1/05/2017

66.54481

25.24148

1/06/2017

69.18487

26.01

1/07/2017

69.9535

27.12678

1/08/2017

63.32826

26.6579

1/09/2017

64.70026

27.21203

1/10/2017

66.7466

28.12422

1/11/2017

68.29424

26.82841

1/12/2017

69.07667

27.50389

1/01/2018

67.81275

27.16174

1/02/2018

65.68044

26.99505

1/03/2018

63.84598

25.10882

1/04/2018

63.41335

25.12636

1/05/2018

61.18832

24.43328

1/06/2018

64.34045

26.53092

1/07/2018

66.03571

26.67579

1/08/2018

62.90123

25.84274

1/09/2018

65.03161

25.29039

1/10/2018

63.04633

24.31246

1/11/2018

64.86768

23.51563

1/12/2018

65.92408

23.46878

1/01/2019

63.66559

23.00953

1/02/2019

67.34473

25.26831

1/03/2019

66.13413

24.29357

1/04/2019

69.76662

25.7838

1/05/2019

73.50213

25.71819

1/06/2019

77.49975

27.5433

1/07/2019

77.05037

27.82495

1/08/2019

74.00768

27.40733

1/09/2019

77.93995

28.78644

1/10/2019

75.84754

27.39762

1/11/2019

77.93031

23.81388

1/12/2019

77.0432

24.23

1/01/2020

82.21156

25.12

1/02/2020

78.85597

23.64

1/03/2020

60.96042

16.5

1/04/2020

61.81832

16.28

1/05/2020

62.86358

17.22

1/06/2020

68.45474

17.95

1/07/2020

70.20998

17.09

1/08/2020

67.33059

17.54

1/09/2020

66.73

17.06

7/09/2020

67.23

17.35

Assessment criteria

a)Calculate mean, mode, median, standard deviation, range, 1^stquartile and 3^rdquartile of the stock prices.

b)Provide recommendation