Statistics For Managerial Decision - Assignment

Statistics For Managerial
Decision
Assignment -II
[Pick the date]
Student Name

Question 1
(a) The opening prices (quarterly) for Macquarie Group Limited and Perpetual Limited is
highlighted below:
The stem and leaf plot for opening prices (quarterly) for Macquarie Group Limited and Perpetual
Limited is highlighted below
(b) The relative frequency histogram (Macquarie Group Limited) and frequency polygon
(Perpetual Limited) is highlighted below
1

(c) The bar chart highlighted below is the indication of the market capitals or total assets of 6
companies listed in ASX for the year 2017.
2

(d) The analyst recommendation on MQG stock as obtained from Reuters is indicated below.
There is a clear improvement in the recent past which no analyst recommending a sell on the
stock with only buy and hold calls.
The above needs to be compared with the corresponding analyst recommendation for PPT stock
as highlighted below.
3

The above is quite contradictory to that observed for MQG. It is apparent that the ratings have
deteriorated for the company in the recent times and only 1 analyst recommends a buy while the
other 2 clearly recommend sell and underperformance to continue.
Based on the above analysis, it is apparent that one should invest in MQG stock and not in PPT
stock based on the analyst consensus.
Source: https://www.reuters.com/finance/stocks/analyst/PPT.AX
https://www.reuters.com/finance/stocks/analyst/MQG.AX
Question 2
The average price earnings ratio for TLX, SPK, TPM, CNU and VOC is highlighted below:
4

(a) The mean, first and third quartile and median are highlighted below:
(b) The mean absolute deviation, standard deviation and range are highlighted below:
(c) The box plot for the four companies is highlighted below:
5