United Kingdom Cities
Delivered March 5, 2020. Contributor: Katieanne G.
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.