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.

Early Findings

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











Proposed next steps:

You need to be the project owner to select a next step.