Wales pubs
Download the Excel workbook at bit.ly/wales_pubs_wb.

It shows the number of pubs in Wales by local authority from 2001 to 2018.

Answer the questions below.
Sign in to Google to save your progress. Learn more
1. What has the change been between 2001 and 2018 in the Isle of Anglesey?
Clear selection
2. How many pubs in total were there in 2001?
Clear selection
3. What was the average number of pubs per area in 2001?
Clear selection
4. Cells C2 to T23 contain all the pub numbers. Use the =MIN() formula to find the smallest number of pubs in a single area in a single year.
Clear selection
5. The biggest number of pubs, in a single area in a given year, is 245. Use CTRL + F to find where and when
Clear selection
6. The first question above asked for the difference in pub numbers in Anglesey between 2001 and 2018. Here you can see a solution: use the calculation =T2-C2. Now drag the tiny square in the bottom right of the cell all the way down column U to the last row (Merthyr Tydfil). Which area had the same number of pubs in 2018 as in 2001?
Captionless Image
Clear selection
7. Some areas have "lots" of pubs. Others don't have many. But some areas are highly populated so a comparison isn't necessarily effective. Use the 2018 population data in the second sheet ('population') to find the area with the most pubs per 10,000 people in 2018. (Stuck? Get help here: bit.ly/helpanswers)
Clear selection
Submit
Clear form
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms