Broadband Affordability Analysis

Type: Choropleth map with ward boundaries
Primary metric: Percentage of premises with affordable broadband options

Affordability Metrics

The visualization shows the proportion of premises in each ward that have access to affordable broadband packages (defined as ≤£30 per month):

affordable_access = (premises_with_affordable_options / total_premises) * 100

Interpretation Guide:

Affordability Levels:

• High (80-100%)

  • Most premises have affordable options
  • Competitive market pricing
  • Good consumer choice

• Moderate (40-80%)

  • Mixed affordability landscape
  • Some price competition
  • Room for market improvement

• Low (0-40%)

  • Limited affordable options
  • Potential market intervention needed
  • Risk of digital exclusion

Design Elements:

• Base map showing ward boundaries within the Local Authority
• Color scale progression:
  • Light Green (0%) → Medium Green (50%) → Dark Green (100%)
• Interactive hover information:
  • Ward name
  • Percentage of premises with affordable options
  • Average number of providers
  • Total premises count

Strategic Applications:

1. Market Analysis

   • Identify areas of high pricing
   • Track affordability trends
   • Assess market competition

2. Social Impact

   • Monitor digital inclusion
   • Identify affordability gaps
   • Target support measures

3. Policy Planning

   • Guide market interventions
   • Support policy decisions
   • Monitor intervention effects

4. Competition Assessment

   • Evaluate pricing patterns
   • Identify market failures
   • Guide competition policy

Note: This visualization focuses on the availability of affordable broadband packages (≤£30/month) rather than actual take-up rates. It indicates where affordable options exist, not necessarily where they are being used.