Top five telecommunication companies listed in the Australian Stock Exchange in terms of market capital are Telstra Corporation Limited (TLS), Spark New Zealand Limited (SPK), TPG Telecom Limited (TPM), Chorus Limited (CNU) and Vocus Group Limited (VOC). The accompanying table provides the average price-earnings ratio (P/E) for these companies for different years. From the data answer the questions below for these companies. (Work only with the data provided. Missing values indicate data not available for those companies during those years.)
(a) Compute the mean, median, first quartile, and third quartile of average price-earnings ratio for each company using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile.
(b) Compute the standard deviation, mean absolute deviation and range for each company.
(c) Draw a box and whisker plot for the average price-earnings ratio of each company and put them side by side on one graph with the same scale so that the P/Es can be compared. (This graph must be done in EXCEL or similar software and cannot be hand-drawn.)
(d) Write paragraph on price-earnings ratio values related to it being indicative of a share being a good investment or a poor investment.
Recently Asked Questions
- 17 . The lattice energy of MgCl 2 is related to which one of the following processes ?
- When a client code programmer uses a class whose implementation is in a separate file from its interface , that implementation code is merged with the client
- What is the gain from change in FV of biological asset that should be reported in the 2014 income statement ?