Assignment:
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.)
|
Average price-earnings ratio
|
|
|
Year
|
TLS
|
SPK
|
TPM
|
CNU
|
VOC
|
|
2007-08
|
15.3
|
11.9
|
|
|
39.6
|
|
2008-09
|
11.5
|
10.3
|
8.6
|
|
27.1
|
|
2009-10
|
10.4
|
11.8
|
21.5
|
|
3
|
|
2010-11
|
11
|
10.6
|
15.8
|
|
10.6
|
|
2011-12
|
10.3
|
16.5
|
13.6
|
13.6
|
13.3
|
|
2012-13
|
14.1
|
12.4
|
14.8
|
6.7
|
16.2
|
|
2013-14
|
13.4
|
13.3
|
23.4
|
6.7
|
20.8
|
|
2014-15
|
17.1
|
15.5
|
27.2
|
8.3
|
24.8
|
|
2015-16
|
16
|
15.3
|
27.8
|
17.3
|
23.7
|
|
2016-17
|
14.6
|
15.7
|
15.2
|
18
|
34.3
|
(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.
Compute the standard deviation, mean absolute deviation and range for each company.