a)Calculate the mean, standard deviation, variance and correlation coefficient for and separately (for two sub-period in a table-see next page) and comment on the result.

NOTE: I HAVE ALREADY DONE THE MEAN STANDARD DEVIATION ,VARIANCE AND CORRELATION COEFFICIENT IN THE EXCEL BELOW , JUST COMMENT ON THE RESULTS PLEASES.

b)Estimate beta for your selected company for the two sub-periods.

c)Explain the value of beta that you have calculated.

d)Provide a brief description of the selected company.

Why the estimated value of beta is different for two sub-periods

RESOURCE:

ALL ORDINARIES (^AORD)

https://au.finance.yahoo.com/quote/%5EAORD/history?period1=1538352000&period2=1632355200&interval=1mo&filter=history&frequency=1mo&includeAdjustedClose=true

Accent Group Limited (AX1.AX)

https://au.finance.yahoo.com/quote/AX1.AX/history?period1=1538352000&period2=1632268800&interval=1mo&filter=history&frequency=1mo&includeAdjustedClose=true

THATS THE TWO COMPANIES THAT I PICKED FROM YAHOO FINANCE.

AND THE ATTACHMENT BELOW IS MY WORK OF EXCEL FOR THE TWO COMPANIES JUST HELP ME ANSWER THE FOLLOWING QUESTIONS FROM THE EXCEL AND THE COMPANIES

THANK YOU.