United Kingdom Cities

Goals

To find all missing data points in the attached spreadsheet.

Early Findings

We were able to find all missing data points in the attached spreadsheet during this hour of research. Hotel star ratings are rounded to the nearest tenth. We cited our sources in column J.

Bristol

  • There are 1,263 restaurants in Bristol.
  • We calculated this number using data pulled from TripAdvisor.

Leicester

  • The average hotel rating in Leicester is 3.1 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 5 + 12(4) + 26(3) + 10(2) = 151/49 = 3.1 stars

Edinburgh

  • The average hotel rating in Edinburgh is 3.4 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 5(18) + 130(4) + 140(3) + 32(2) = 1,094/320 = 3.4 stars

Leeds

  • The average hotel rating in Leeds is 3.2 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 2(5) + 25(4) + 44(3) + 11(2) = 264/82 = 3.2 stars

Cardiff

  • The average hotel rating in Cardiff is 3.2 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 2(5) + 19(4) + 29(3) + 11(2) = 195/61 = 3.2 stars

Manchester

  • The average hotel rating in Manchester is 3.3 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 3(5) + 46(4) + 58(3) + 15(2) = 403/122 = 3.3 stars

Stoke-on-Trent

  • The average hotel rating in Stoke-on-Trent is 3 stars.
  • This was calculated as follows based on data pulled from TripAdvisor: 2(4) + 10(3) + 2(2) = 42/14 = 3 stars

Proposed next steps:

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