Use the HotelPrices data set (attached) and answer the following questions: 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...

Use the HotelPrices data set (attached) and answer the following questions:
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 dataset contains prices in English pounds . Complete the following for the two-star, three-star and four-star hotels.
a. Compute the mean, median, first quartile and third quartile.
b. Compute the range, interquartile range, variance, standard deviation and coefficient of variation.
c. Interpret the measures of central tendency and variation within the context of this problem.
d. Construct a boxplot. Are the data skewed. If so, how?
e. Based on the results of (a) through (c), what conclusions can you reach concerning these variables?


For questions (a) and (b), students are required to do calculations in Excel.
For questions (d), students are to use theboxplot makerfor this assignment.


These graphs are to be copied/pasted in a Word documents. Students are required to write at least a 3 sentence explanation each for parts (c) to (e)



Please input your answers from Excel into the table for this project. This covers parts (a) and (b). Statistic Two-star Three-star Four-star Minimum Maximum Range 1st Quartile Median 3rd Quartile Mean Variance (n-1) Standard Dev (n-1) IQR Coefficient of Variation For part (c), answer the following questions for your analysis. State the average prices of the 2-star, 3-star and 4-star hotels, respectively. State the middle rank prices (median) of the 2-star, 3-star and 4-star hotels, respectively. State the difference in prices between the lowest and highest price hotels of the 2-star, 3-star and 4-star hotels, respectively. State the difference in prices among the middle 50% for the 2-star, 3-star and 4-star hotels, respectively. State the typical distance of the prices around the mean for the 2-star, 3-star and 4-star hotels, respectively. State the average spread around the mean relative to the mean prices of the 2-star, 3-star and 4-star hotels, respectively. Do not forget to add your boxplots for part (d) and your analysis for part (e). Please present your work in a professional manner. It should be nice and neat. DATA CityTwo-StarThree-StarFour-Star Amsterdam7488116 Bangkok233572 Barcelona6590106 Beijing355079 Berlin635876 Boston102132179 Brussels668598 Cancun4285205 Chicago66115142 Dubai8467111 Dublin486687 Edinburgh7282104 Frankfurt7082107 Hong Kong4287131 Istanbul477791 Las Vegas414785 Lisbon365674 London7490135 Los Angeles80118200 Madrid476679 Miami84124202 Montreal76113148 Mumbai417290 Munich7997115 New York116161206 Nice6987133 Orlando4578120 Paris76104150 Rome7582108 San Francisco92137176 Seattle95120166 Shanghai224979 Singapore58104150 Tokyo5082150 Toronto7292149 Vancouver74105146 Venice8799131 Washington85128158