Use the HotelPrice data set (attached) and answer the following questions:

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.