Hi Guys,

I'm really hoping someone can help me on this, as I've spent quite a while researching to no avail!

The table below (bottom of the post) shows:

1st Column - No. of rooms in accommodation
2nd Column - No. of places (that have that many rooms)
3rd Column - No. of enquiries received

What I am trying to find out is:

Places with how many rooms, receive the most enquiries?

On looking at the table, places with 1 room have had more enquiries than any other but this is potentially because there are more places with only 1 room. How can I work out what no. of rooms potentially has more enquiries and also what % each room'd place has of enquiries, taking out the 'how many we have of each factor?'

Thanks in advance!

No. of Rooms No. of Places Enquiries
1 - 1083 - 15823
2 - 585 - 9098
3 - 527 - 7717
4 - 380 - 5550
5 - 355 - 5080
6 - 178 - 1919
7 - 102 - 1206
8 - 110 - 1484
9 - 69 - 910
10 - 77 - 1153

Total 3466 49940