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
- Please help..... Draw the flow chart and pseudo code for a program needed by Hometown Bank. The program determines a monthly checking account fee. Input
- The best estimate of each (identical) homeowner’s willingness-to-pay (marginal benefit) function is Ph= 50 – (0.5)L where L is number of units of land
- The amounts (in dollars) spent by 20 families for dinner at a restaurant are given on the right.