Wonder
Log in
Research Outline
Prepared for Robyn | Delivered March 5, 2020
United Kingdom Cities
Review your project details
Goals
To find all missing data points in the attached
spreadsheet
.
View less
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
.
T
h
i
s
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
.
T
h
i
s
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
.
T
h
i
s
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
.
T
h
i
s
was calculated as follows based on data pulled from TripAdvisor: 2(4) + 10(3) + 2(2) = 42/14 = 3 stars
View less