Use the HotelPrice data set (see below)

1. What was the average price of a room at two-star, three-star and four-star hotels around the world during the first half of 2013? The attached file containsthe prices in English pounds.
2. Complete the following for the two-star, three-star and four-star hotels.

a. Construct a frequency distribution and a percentage distribution.

b. Construct a histogram

c. Construct a cumulative percentage distribution

d. What conclusions can you reach about the cost of two-star, three-star and four-star hotels?

e. Construct separate scatterplots of the cost of two-star hotels versus three-star hotels, two-star hotels versus four-star hotels and three-star hotels versus four-star hotels.

f. What conclusions can you reach about the relationship of price of two-star, three-star and four-star hotels?

For questions (b) and (e), you are required to do graphs in Excel. These graphs are to be copied/pasted in a Word documents. You will need to write at least a 3 sentence explanation each for parts (d) and (f)of each question.

For this week's assignment, please use the following information to construct your frequency and percent distributions.

For two star hotels, yourupper class boundaries should be 29, 39, 49 and so.

For three-star hotels, your upper boundaries should be 44, 59, 74, 89 and so on

For four-star hotels, your upper boundaries should be 79, 94, 109 and so on

City	Two-Star	Three-Star	Four-Star
Amsterdam	74	88	116
Bangkok	23	35	72
Barcelona	65	90	106
Beijing	35	50	79
Berlin	63	58	76
Boston	102	132	179
Brussels	66	85	98
Cancun	42	85	205
Chicago	66	115	142
Dubai	84	67	111
Dublin	48	66	87
Edinburgh	72	82	104
Frankfurt	70	82	107
Hong Kong	42	87	131
Istanbul	47	77	91
Las Vegas	41	47	85
Lisbon	36	56	74
London	74	90	135
Los Angeles	80	118	200
Madrid	47	66	79
Miami	84	124	202
Montreal	76	113	148
Mumbai	41	72	90
Munich	79	97	115
New York	116	161	206
Nice	69	87	133
Orlando	45	78	120
Paris	76	104	150
Rome	75	82	108
San Francisco	92	137	176
Seattle	95	120	166
Shanghai	22	49	79
Singapore	58	104	150
Tokyo	50	82	150
Toronto	72	92	149
Vancouver	74	105	146
Venice	87	99	131
Washington	85	128	158