Create Diagrams based on the excel File

  • Create a chart from Excel that shows the Top 5 Industries for each region (e.g., US, Greece, EU).
    Practically:
    • Use your FILTER_COUNTS_RAW or equivalent sheet
    • Group data by Region + Industry
    • Select the top 5 industries based on frequency/count per region
    • Display them (e.g., bar chart per region or grouped bar chart)
  • Figure 4.1 (Regions):
    Create a chart that includes both raw numbers AND normalized values (percentages) per region.
    Practically:
    • Use total results per region (from your base search)
    • Calculate: percentage = (count / total results per region)
    • Show either:
      • a chart with percentages, or
      • a combined chart (counts + percentages)
  • WRITE MY PAPER

    Comments

    Leave a Reply