Wonder

UK Trips

Delivered February 7, 2020. Contributor: Teresa W.

Goals

To understand the number of restaurants, average cost of a meal, and average cost of hotel in London, Birmingham, Manchester, Glasgow, Newcastle, Sheffield, Liverpool, and Leeds.

Early Findings

The number of restaurants, average meal price, and averge hotel price for a weekend in London, Birmingham, Manchester, and Glasgow has been entered into the attached spreadsheet. 
LondonIn London there are approximately 16,820 restaurants and food establishments, according to the latest data from London Office of Statistics. This includes 3,530 public houses and pubs,  7,990 licensed restaurants and cafes, and 5,300 takeout and food stand locations. 
The average cost of a meal in London is around $14 per person. Of course, prices vary by meal, with breakfast being the least expensive. 
The average cost of a hotel room in London is about $236 per night. A weekend stay would cost $472. 
BirminghamThere are approximately 1,635 eating estabishements in Birmingham with 845 restaurants, 323 coffee shops, and 467 pubs. 
The average cost of a meal in Birmingham is around $12 per person. 
The average cost of a hotel room in Birmingham is about $111 per night. A weekend stay would cost $222. 
ManchesterManchester has approximately 1,929 eating establishments including 650 restaurants and 1,279 pubs.
The average cost of a meal in Manchester is $15 per person. 
The average cost of a hotel room in Manchester is $108 per night. The cost for a weekeknd would be $216. 
GlasgowThere are about eating 1,236 establishments in Glasgow incuding 1,053 restaurants and 183 pubs. 
The average cost of a meal in Glasgow is about $17 per person. 
The average cost of a hotel room in Glasgow is about $125 per night. The cost for a weekend would be $250. 

Proposed next steps:

You need to be the project owner to select a next step.

As we were able to complete columns A-E for London, Birmingham, Manchester, and Glasgow in our initial research, we propose further research to identify the number of restaurants, average cost of a meal, and average hotel cost for a weekend in Newcastle, Sheffield, Liverpool, and Leeds.

In addition, we propose further research to identify 3 additional popular tourist cities in the UK. For each, we will complete columns A-I of the attached spreadsheet to include 1) the name, population, number of restaurants, average cost of a meal, average hotel cost for a weekend and 2) the average hotel rating, average cost of a pint of beer, number of free attractions, and average rating of free attractions.