Sample data

• Available at: http://www.postel.go.id/webupdate/ict-indicators/other-Mat.asp

•Three Excel files (for 3 operators)

For Friday: Hands-On session

• Not compulsary• Only for those who wants to participate

Note :10x3 - data in thousands10x6 - data in millions% - data in percentBlank - data in units

Instructions:

• Compute country data based on the data provided for three operators

• Pay attention to the units used• Use « notes » if necessary.• Your results should be in saved in a new file,

filename: country.xls

Compute (for country):• Total main (fixed) telephone lines• % residential telephone lines• Total capacity of local telephone exchanges• Total mobile cellular subscribers– Total Prepaid subscribers

• % mobile population coverage • Mobile and Fixed telephone tariffs (for all

categories)• Total telecommunication revenue• Total fixed telephone, total mobile revenue• Total telecom investment

• Total estimated internet users• Total internet subscribers– Broadband subscribers• DSL• Cable• Other

Compute (for country):

Other:

• Compile any questions you have while doing the aggregation of data, to be discussed on Friday.

• Comments