Research Outline

UK Week End Cost

Goals

To find the average price of a week end hotel stay as well as the average rating of free attractions for the remaining cities.

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

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
All the information has been added to the shared document.