Question 1 4 Marks
Visit the Australian Stock Exchange website, www.asx.com.au and from “Prices and research” drop-down menu, select “Company information”. Type in the ASX code “COH” (Cochlear Limited), and find out details about the company. Also, type in the ASX code “RHC” (Ramsay Health Care Limited), and find out the details about that company. Both these companies trade in healthcare sector. 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 COH and RHC shares for every quarter from January 2006 to December 2016 (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 2006 to 2016. To provide you with some guidance as to what the unadjusted prices look like, two charts accompany this question obtained from ANZ Share Investing, Australia. After you have researched share prices and healthcare sector, answer the following questions:
(a) List all the quarterly opening price values in two tables, one for COH and the other for RHC. Then construct a stem-and-leaf display with one stem value in the middle, and COH leaves on the right side and RHC leaves on the left side. (Must use EXCEL or similar for the plot.) 1 mark
(b) Construct a relative frequency histogram for COH and a frequency polygon for RHC on the same graph with equal class widths, the first class being “$0 to less than $10”. Use two different colours for COH and RHC. Graph must be done in EXCEL or similar software. 1 mark
(c) For sector comparisons, draw a bar chart of annual dividends in 2016 (in Australian cents) of the following companies in healthcare sector listed in ASX: COH, RHC, SHL, RMD, SRX, ANN and CSL. Graphing must be done in EXCEL or with similar software. 1 mark
(d) What proportion of stock prices (quarterly opening values) were above $60 for each of COH and RHC?
Question 2 4 Marks
There are four major supermarkets and grocery chains in Australia, which are Woolworths Ltd with a market share of 33.6% and brand names Woolworths, Safeway and Thomas Dux; Wesfarmers Ltd with a market share of 29.3% and brand names Coles and Bi-Lo; ALDI Stores Supermarket Pty Ltd with a market share of 8.9% and brand name ALDI; and Metcash Ltd with a market share of 7.1% and brand names IGA and Foodland. Details about these companies can be found in the Website http://clients1.ibisworld.com.au/reports/au/industry/majorcompanies.aspx?entid=1834. The following table provides the percent changes in sales revenue for each of these companies from the previous financial year. From the data answer the questions below for the supermarkets. (Website accessed on 22 February 2017.
(a) Compute the mean, median, first quartile, and third quartile of revenue changes for each supermarket (with only the data provided in the table, do not add or change anything in the table) using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile. 1 mark
4 of 11
(b) Compute the standard deviation, range and coefficient of variation from the data in the table for each supermarket. 1 mark
(c) Draw a box and whisker plot for the percent changes of each supermarket and put them side by side on one graph with the same scale so that the percent changes can be compared. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.) 1mark
(d) Visit the IBISworld website and identify at least three other supermarket and grocery chains in Australia and quote the market share of each. 1 mark
Question 3 4 Marks
The Table below is taken from the Australian Government’s Department of Health. It provides data on mental health workforce distribution in Australia by States and Profession. The data is taken from the website http://www.health.gov.au/internet/publications/publishing.nsf/Content/mental-pubs-m-mhsrraev-toc~mental-pubs-m-mhsrraev-8~mental-pubs-m-mhsrraev-8-3#st1. In the table FTE stands for full-time equivalent, MHN for mental health nurse, OT for occupational therapist, MHW for mental health worker and HW for health worker.
Based on the information available in the table above and the fact that total number of mental health workers in WA, VIC, TAS, QLD, SA, NT and NSW were at the time 28 000, 66 000, 7 500, 51 000, 21 000, 2 000 and 76 000, respectively, answer the questions below:
(a) If a mental health worker is randomly selected in Australia, what is the probability that she or he is a social worker? 1 mark
(b) If a mental health worker is randomly selected in Australia, what is the probability that she or he is a clinical psychologist and located in Tasmania? 1 mark
(c) Given that the mental health worker is located in South Australia, what is the probability that she or he is an occupational therapist? 1 mark
(d) What percentage of psychologists live in either New South Wales or Victoria? 1 mark