Question 1 4 Marks

Visit the Australian Stock Exchange website, https://www2.asx.com.au. Type in the ASX code COL (Coles Group Limited), and find out details about the company. Also, type in the ASX code WOW (Woolworths Group Limited), and find out the details about that company. Information available in the ASX website will be inadequate for your purpose, you will need to search the internet for more information. Your task will be to get the opening prices of COL and WOW shares for every quarter from January 2013 to December 2021 (unadjusted prices). If you are retrieving the monthly prices, read the values in the beginning of every Quarter (January, April, July, October) for every year from 2013 to 2021 (Total 36 observations). After you have researched share prices, answer the following questions:

(a) List all the quarterly opening price values in two tables, one for COL and the other for WOW. Then construct a stem-and-leaf display with one stem value in the middle, and COL leaves on the right side and WOW leaves on the left side. (Must use EXCEL or similar for the plot.) 1 mark

(b) Construct a relative frequency histogram for COL and a frequency polygon for WOW on the same graph with equal class widths. Use two different colours for COL and WOW. Graph must be done in EXCEL or similar software. 1 mark

(c) Draw a bar chart of market capitals (or total assets) in 2021 (in million Australian dollars) of 5 companies listed in ASX that trade in similar products or do similar business as COL or WOW with at least AUD500 million in market capital. Graphs must be done in EXCEL or with similar software. 1 mark

(d) If one wishes to invest in COL or WOW, what is the market recommendation (for example, from Morningstar, Fatprophets, InvestSmart, etc.)? If you cannot find the information, what would be your recommendation based on your research of these two companies (trend, P/E ratio, dividend yield, debt and Beta)? 1 mark