Use the HotelPrice data set (attached) and answer the following questions: What was the average...

Question

Use the HotelPrice 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 attached file contains the prices in English pounds.

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, your upper class boundaries should be 29, 39, 49 and so.For three-star hotels, your upper boundaries should be 44, 59, 74, 89 and so onFor four-star hotels, your upper boundaries should be 79, 94, 109 and so on.

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

utf-8hotelprices-3qi15k2p.xlsx

S · Accepted Answer

1. Average of  Two-Star  = 65.079 pounds
Average of Three-Star = 89.737 pounds
Average of Four-Star = 127.737 pounds
2. For Two-Star
a) 
	Frequency Table
	Upper Limits
	Frequency
	29
	2
	39
	2
	49
	8
	59
	2
	69
	5
	79
	10
	89
	5
	99
	2
	119
	2
	Percentage Distribution
	Upper Limits
	Frequency
	Percentage 
	29
	2
	5%
	39
	2
	5%
	49
	8
	21%
	59
	2
	5%
	69
	5
	13%
	79
	10
	26%
	89
	5
	13%
	99
	2
	5%
	119
	2
	5%
	
	38
	
For Three-Star
	Frequency Table
	Upper Limits
	Frequency
	44
	1
	59
	5
	74
	4
	89
	11
	104
	7
	119
	4
	134
	4
	149
	1
	164
	1
	Percentage Distribution
	Upper Limits
	Frequency
	Percentage 
	44
	1
	3%
	59
	5
	13%
	74
	4
	11%
	89
	11
	29%
	104
	7
	18%
	119
	4
	11%
	134
	4
	11%
	149
	1
	3%
	164
	1
	3%
	
	38
	
For Four-Star
	Frequency Table
	Upper Limits
	Frequency
	79
	6
	94
	4
	109
	5
	124
	4
	139
	4
	154
	7
	169
	2
	184
	2
	199
	0
	214
	4
	Percentage Distribution
	Upper Limits
	Frequency
	 Percentage
	79
	6
	16%
	94
	4
	11%
	109
	5
	13%
	124
	4
	11%
	139
	4
	11%
	154
	7
	18%
	169
	2
	5%
	184
	2
	5%
	199
	0
	0%
	214
	4
	11%
	
	38
	
b) For Two-Star
For Three-Star
For Four-Star
c) 
For Two-Star
	Cumulative Percentage Distribution
	Upper Limits
	Frequency
	Cumulative Percentage
	29
	2
	5.26%
	39
	2
	10.53%
	49
	8
	31.58%
	59
	2
	36.84%
	69
	5
	50.00%
	79
	10
	76.

Use the HotelPrice 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...

Answer To: Use the HotelPrice data set (attached) and answer the following questions: What was the average...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment