Several news agencies have recently reported on our calculation of bottom US cities by broadband value which gives North Carolina the dubious distinction of having seven out of those ten worst cities.
Bottom cities by Value
|1. Anchorage, AK||$65.50 per mbps|
|2. Greensboro, NC||$62.03 per mbps|
|3. Winston Salem, NC||$61.86 per mbps|
|4. Columbia, SC||$61.35 per mbps|
|5. Raleigh, NC||$60.98 per mbps|
|6. Cary, NC||$59.53 per mbps|
|7. Durham, NC||$59.18 per mbps|
|8. Wilmington, NC||$56.83 per mbps|
|9. Charlotte, NC||$52.73 per mbps|
|10. Shreveport, LA||$52.72 per mbps|
Let’s take a closer look at the data and how we calculate out that value.
Value is simply defined as cost / speed. The North Carolina cities that made the list have poor upload speed, paired with relatively high Internet prices. Upload and download speeds factor equally in our calculations.
We determine value as the cost of the Internet connection divided by its aggregate speed.
NetIndex gives us upload and download speeds per city per day as well as the number of speedtests.
- We multiply the number of tests times the value.
- We sum that up for the month.
- We divide that back out by the number of tests in the month. That gives us an average value for both upload and download speed per city for the month. To get a single average speed for a city we just average upload and download speed. (As noted, this is where NC cities start to look bad.)