Methodology
To find the average hotel star rating, we multiplied each hotel count with its rating to obtain the total number of stars. We then divided this by the total number of hotels. Using this calculation, we determined the average star rating.
(Total star count)/(total number of hotels)=average star rating
Average Hotel Star Rating
Leicester
- 27 hotels found in booking.com for a Friday night stay in March 2020
- Prices found in USD: 41+49+50+52+53+51,31+61+64+70+70+75+77+78+78+79+81+84+87+87+90+98+98+98+111+129+129+130=$2,130.31
- Average rating = 2,130.31/27=$80,38
Edinburgh
- 117 hotels found in booking.com for a Friday night stay in March 2020
- Prices found in USD: 89+91+127+107.86+110+89+139+82+72+77+81.56+90+55+104+67+128+86.8+87+75+105.59+81.47+124+103+133+104+64+96+83+120+94+63+146.04+99+77+97+107+115+132+160+105+61+85133+142+249+122.87+78+88.79+96+176+89+77+73+109+87+86.72+151+224.82+91+157.49+126+168+115+105+152+159+169+202+150323+89+258+112+111+137+129+253+201+342+109+99.63+165+171+94+191+117+129+182+168+82+77+187+70.54+120+159+123+157.36+90+125.56+143+111+240+60.57+130+135+160+254+400+192.76+153+111+143140+78+182+175.12+185.14=15,148.83
- Average rating= 15,148.83/117=$129,48
Leeds
- 49 hotels found in booking.com for a Friday night stay in March 2020
- Prices found in USD: 38+53+55+56+59+62+62+65+68+68+70+71+56.92+74+81+84+81+81+86+88+89+90+94+96+98+98+98+98+100+103+103+109+113+116+117+117+114.16+120+128+128+134+136+147+154+194+195+199+229+351=5,227.08
- Average rating=5,227.08/49=$106,67
Cardiff
- 41 hotels found in booking.com for a Friday night stay in March 2020
- Prices found in USD: 46+42.3+65+69+72+73+75+77+78+84+85+89+90+92+100+103+106+108+110+111+111+113+113+116+107.76+118+126+135+142+148+150+151+154+155+155+156+168+205+217+232+467=5,115.06
- Average rating=5,115.06/41=$124.75
Stoke-On-Trent
- 11 hotels found in booking.com for a Friday night stay in March 2020
- Prices found in USD: 49+52+56+59+70+78+81+96+108+110+137=896
- Average rating=896/11=$81.45