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
Research proposal:
Only the project owner can select the next research path.