What was the average price of a room at two-star, three-star and four-star hotelsaround the world during the first half of 2014? The accompanying Excel documentcontains the average prices in

British pounds. Do the following: a) Construct a frequency, a percentage and a cumulative percentage distributiontable for the average room price of two-star hotels. [3 marks] b) Construct a histogram, a percentage polygon and a cumulative percentage polygon (o give) for the average room price of two-star hotels. [3 marks] c) Construct separate scatter plots of the room prices of three-star hotels (X-axis)versus two-star hotels (Y-axis), four-star hotels (X-axis) versus two-star hotels(Y-axis), and three-star hotels (X-axis) versus four-star hotels (Y-axis). What conclusions can you reach about the relationship of the average room price of two-star, three-star, and four-star hotels? Briefly explain. [4 marks] d) Compute the following statistics for the average room price of two-star, three-star, and four-star hotels: number of observations, mean, median, mode, range,variance, standard deviation, coefficient of variation, first quartile, third quartile and the interquartile range. Briefly interpret the results obtained. [5 marks] e) Construct a box plot for the average room price of two-star, three-star, and four-star hotels. Are the data skewed? Briefly explain. [2 marks] f) Compute the covariance and coefficient of correlation between the average room price at two-star, three-star and four-star hotels. What conclusions can you reach about the relationship between the average room price at the different hotels? Briefly explain. [3 marks]