The Excel file includes "roll up" sheets which allow the user to generate the rankings we created in Chapter 3 of the report, as well as additional information on where to find the source for each field. That source information is reproduced below.

In the benchmarking chapter (3) of Next Generation Connectivity, we set out three different areas of metrics to focus on: penetration, speed, and price. Here, we've included the raw data that went into each of those rankings in the "Penetration Speed Price Metrics by Country" file. We have also included some other factors that may not have been included in our overall weighting (like urbanicity). There are some graphs in the report whose data was taken directly from the source with no analysis run on it. Many of these data sources are not reproduced here.

All of the following were generated from a data set shared with us from Speedtest.net consisting of ~40 million data points. The Berkman Center crunched this data into its current form.

Average download speedtest.net (kbps)

Standard deviation download, speedtest.net

Average upload speedtest.net (kbps)

Standard deviation upload, speedtest.net

Average latency speedtest.net

Standard deviation latency, speedtest.net

Median download, speedtest.net (kbps)

Median upload, speedtest.net (kbps)

Median latency, speedtest.net

90p. Download, speedtest.net (kbps)

90p. Upload, speedtest.net (kbps)

10p. Latency, speedtest.net

All of the following are from Point Topic’s stand alone data set, accessed in Nov 2009, which includes data collected during Q2 and Q3 2009. Note: for providers that only offer bundled broadband, we manually added these offers to this set.

Prices for low speeds, PT

Prices for mid speeds, PT

Prices for high speeds, PT

Prices for low speeds, PT

The following fields were taken from various sources, listed with each field.