$4.$ The data in $"$A$3-$ MicroBreweries" is based on that in an economic study of the microbrewing industry in Ireland in $\backslash (2016^\{2\}\backslash ).$ It has counts of microbreweries per county, with the counties then classified into $4$ economic regions $($a simplified classification based on the NUTS system$).$ For each of the following graphs$/$charts choose a suitable colour scheme, Title, Axes, Legend, and any other appropriate graphical aesthetics.

$($a$)$ Create a geographic map $($a "choropleth" map, to be precise$)$ in Excel, showing the number of microbreweries per county.

$($b$)$ Create a Tree Map, showing the subdivision into Regions and Counties. Include data labels showing the actual counts of microbreweries.

$($c$)$ Create a Clustered Column Chart with again counts by Region, and by County within Region. Sort the clusters and columns in the chart so that the largest of each come first $($i$.$e$.,$ leftmost$)$ in the chart$^3.$

$($d$)$ For each of the above charts $($a$)$ to $($c$),$ state one question and answer for which that chart would be a good choice of evidence to support that answer. Take care to include suitable Guides $($e$.$g$.$ axis titles and labels, chart title, legend, datasource annotation, etc.$)$ as appropriate.

HINTS:

Example Charts for Q$4$

As we've seen there are many choices with charts and there's no one correct or even "best" answer. These are suggestions that may help you understand what's being asked for, but they aren't perfect answers!

Figure $2$ Q$4$b

Figure $3$ Q$4$C $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|\}$

$\backslash$hline Region & County & Number of Microbreweries $(2016)\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Cavan & $2\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Donegal & $4\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Galway & $5\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Laois & $0\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Leitrim & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Longford & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Mayo & $3\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Monaghan & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Offaly & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Roscommon & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Sligo & $1\backslash \backslash$

$\backslash$hline BorderMidlandsWest & Westmeath & $0\backslash \backslash$

$\backslash$hline Dublin & Dublin & $6\backslash \backslash$

$\backslash$hline East & Carlow & $1\backslash \backslash$

$\backslash$hline East & Kildare & $3\backslash \backslash$

$\backslash$hline East & Kilkenny & $0\backslash \backslash$

$\backslash$hline East & Louth & $1\backslash \backslash$

$\backslash$hline East & Meath & $3\backslash \backslash$

$\backslash$hline East & Wexford & $4\backslash \backslash$

$\backslash$hline East & Wicklow & $4\backslash \backslash$

$\backslash$hline South & Clare & $2\backslash \backslash$

$\backslash$hline South & Cork & $9\backslash \backslash$

$\backslash$hline South & Kerry & $4\backslash \backslash$

$\backslash$hline South & Limerick & $2\backslash \backslash$

$\backslash$hline South & Tipperary & $1\backslash \backslash$

$\backslash$hline South & Waterford & $2\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$