COMPARISON OF THE RESULTS OF THE ANALYSIS OF EACH HOTEL
Comparison of the frequency distribution of ages of the hotel guests in the 4 hotels.
Bin
Frequency
Bern
Zurich
Geneva
Basel
1
19
3
4
21
2
10
7
14
10
3
7
9
15
6
4
4
21
7
3
More
0
0
0
0
Table 1: Frequency table: Age distribution of the hotel guests
Age ranges of the hotel guests
LABELS
“1” -18-27
“2” -28-47
“3” -48-67
“4” -68 And Above
Table 2: Table of labels: Age ranges of the hotel guests
Hotel located in Basel has the highest number of guests whose ages range between 18 years and 27 years. The guests in this age bracket also have a high frequency in a hotel located in Bern city. These two hotels collect huge incomes and thus high profits from young people seeking hospitality services in these hotels as compared to the other two hotels in Geneva and Zurich. The hotel in Geneva city has the highest number of 14 guests in the age bracket 28-47 years. The hotels in Basel and Bern have the same frequency of 10 guests in this age bracket. Generally, not all the hotels have a huge variation in terms of frequency in this age range. They, therefore, have a high chance of accruing almost the same amount of income and profits holding all other factors constant. It can be concluded that there is almost the same frequency as middle-aged guests. The hotel located in Geneva city has the highest frequency of guests in the age bracket 48-67 years. It has a frequency of 15 guests. The hotel collects a huge amount of income from this age bracket as compared to other hotels. The other three hotels in Bern, Zurich, and Basel do not have a big difference in the number of hotel guests the get from this age bracket. The hotel located in Zurich had the highest frequency of old-aged hotel guests when compared to the other three hotels. The frequency in this age range is 21 guests for the hotel located in Zurich. It can be concluded that this hotel has facilities, which suit guests who are old. The hotel, therefore, acquires a higher level of income and profits as compared to the other hotels. The hotels in Bern, Geneva, and Basel do not have a great variation of frequency of guests who seek accommodation from the hotels. They have almost the same income and the same profits from this age bracket.
Comparison of the measures of central tendency of ages of the hotel guests
Measure of location/ Central tendency
Bern
Zurich
Geneva
Basel
mean
37.88
61.88
50.5
35.625
median
37.5
37.5
37.5
27.024
modal class
28-47
28-47
28-47
18-27
Table 3: Measures of central tendency: Ages of the hotel guests
The hotel based in Basel has the lowest mean age of approximately 35 years of the hotel guests as compared to the other three hotels. The hotel located in Zurich has the highest mean age of about 62 years of the hotel guests as compared to the other hotels. The hotel in Basel reaps a lot in term if income and profits from the young people while the hotel in Zurich reaps more from old people who seek accommodation from these hotels. The hotels in Bern, Zurich, and Geneva have the same median age of about 38 years of the hotel guests. The hotel located in Basel has the least of all median of around 27 years of the hotel guests. The three hotels also have the same modal class of 28-47 years while the hotel in Basel has a different model class of 18-27 years. In summary, the hotel in Basel, attract more young guests as compared to the rest hotels.
Comparison of measures of the spread of ages of the hotel guests
Measure of Spread
Bern
Zurich
Geneva
Basel
Minimum/1st lower limit
18
18
18
18
Maximum/last upper limit
87
87
87
87
Range
69
69
69
69
Sample Variance
282.41
163.5
161.38
334.71
Sample std. deviation
16.81
12.79
12.7
18.29
Covariance CV
44%
21%
25%
51%
Table 4: Measures of spread: Ages of the hotel guests
Measures of spread give us how the data provided of the ages of the hotel guests are distributed around the population mean. From our analysis of the Suisse hotel group data, all the hotels have a similar lower value of age (18), a maximum value of age (87) and the range (69). This because the datasets had the same class limits. From the datasets, the hotel based in Geneva has the lowest sample variance as compared to the other hotels. This means that the population means the age of the hotel guests is not much different from what the sample data depicts. The hotel located in Basel has the highest sample variance of 334.71, which simply means the data can be misleading if used to make inferences. This is because the mean age depicted by the sample dataset is much different from the mean age of the hotel guests who usually seek hospitality services in the hotel. The hotel in Geneva had the lowest sample standard deviation as compared to the rest of the hotels while the hotel based in Basel has the highest sample standard deviation. The explanation is similar to that of sample variance. There is the highest covariance of 51% in the hostel based in Basel as compared to the other three hotels. The covariance gives the extent of the expected values of the variable being considered. In our case, the expected value of the age of the hotel guests in the hotel based in Basel can be much different from what the data gives. The hotel located in Zurich has the lowest covariance of 21% as compared to the other hotels. It means when the values of the ages of the hotel guests are not much different from what the data gives.
Comparison of measures of central tendency and measures of the spread of the number of nights spent in the hotels
Measures of Central Tendency
Bern
Zurich
Geneva
Basel
Mean
5.1
2.9
4.53
10.6
Median
5
2
3
12
Mode
3
2
2
12
Measures of Spread
Maximum
9
6
14
14
Minimum
1
1
1
2
Range
8
5
13
12
Sample Variance
6.46
2.46
10.31
8.3
Std. Dev.
2.54
1.57
3.21
2.88
Covariance
50%
54%
71%
27%
Table 5: Measures of central tendency and measures of spread: number of nights spent in the hotels.
The hotel based in Zurich has the lowest mean number of nights spent by the hotel guests as compared to the other three hotels. This means that the hotel may fail to accumulate high profits since the amount charged depends on the number of nights spent in the hotels. The hotel located in Basel has the highest mean nights spent by the hotel guests of about 11 nights. This means that the hotel has the highest opportunity of making a lot of income and profits from the hotels services they give. The median value of the nights spent in the hotel based in Bern, Zurich, Geneva and Basel are 5, 2, 3, and 12 respectively. The median value the nights spent in the hotels is highest in the hotel located in Basel while it is lowest in the one located in Zurich. The guests who visit hotel based in Basel usually stay for 12 nights in the hotel, which is the highest mode as compared to the other hotels. The guests stay for the least number of nights of 2 nights in the hotel located in Zurich and Geneva. Since the guests stay for long in the hotel in Basel, the hotel has the highest possibility of making many profits due to so much income. The hotels in Zurich and Geneva acquire little profits. The guests stay for a maximum of 14 days in the hotels based in Basel and Geneva. Both hotels have the highest number of nights, which the guests stay in the hotels. The minimum number of nights stayed by the hotel guests is 1 night in hotels Bern, Zurich, and Geneva. Hotel in Basel has the highest minimum number of 2 nights. The hotel located in Zurich has the lowest sample variance of 2.46 nights. This means the sample data depicts what is likely to be true population mean night stayed by the guests in the hotel. The hotel located in Geneva has the highest sample variance of 10.31 nights. This indicates the data gives a large difference between the real number of guests who usually go for the services in the hotel and what the data gives. The sample standard deviation is the smallest in the data for Zurich as compared to the other three hotels. The data for the hotel based in Basel has the biggest sample standard deviation. This means that the data for Geneva cannot be depended on for making inferences and recommendations. There is a large difference between the predicted values and the real values of the number of nights spent by the guests in the hotel located in Geneva. This is showed by the largest covariance value of 71%.
Comparison of measures of quartiles, outliers, and boxplot of the number of nights spent in the hotels.
Quartiles, Outliers and Boxplot
Quartiles
Bern
Zurich
Geneva
Basel
Q1
3
2
2
9
Q2(MEDIAN)
5
2
3
12
Q3
7
4
6
13
IQR
4
2
4
4
Outliers
Outliner < Q1-1.5 *(Q3-Q1)
-3
-1
-4
24
outliner> Q3+1.5* (Q3-Q1)
13
7
12
-8
Boxplot
Min
1
2
1
2
Q1
3
9
2
9
Q2
5
12
3
12
Q3
7
13
6
13
Max
9
14
9
14
Outliner
NO
NO
13,14
NO
Table 6: Quartiles, outliers and boxplot table: number of nights spent in the hotels.
Basel hotel has the highest lower quartile of 9 nights as compared to the other three hotels. The hotels based in Zurich and Geneva have the lowest lower quartiles of 2 nights each. The Basel hotel has the highest upper quartile value of the number of nights spent by the guests in the hotel while Zurich hotel has the least upper quartile value of the number of nights. Outliers are extreme values in any dataset given. They are termed as outliers. In our analysis, there are no outliers in datasets for Bern, Zurich, and Basel. There are, however, 14 and 13 nights in the hotel based in Geneva as extreme values.
Comparison of correlation analysis
Correlation Analysis
Bern
Zurich
Geneva
Basel
0.625
0.755
0.885
0.5375
Table 7: correlation analysis table: number of nights spent in the hotels and the amount spent in the hotels
The dataset given about the number of nights spent by the guests and the amount they pay is used to give us their degree and direction of their association. There is a moderate positive association between the number of nights spent by guests and the amount they pay in both Bern and Basel datasets. There is a strong positive correlation between the number of nights spent by the guests and the amount they pay for their stay in Zurich and Geneva hotels.
Comparison of Regression analysis
Regression Analysis
Bern
Zurich
Geneva
Basel
0.391
0.5702
0.7294
0.2702
Table 8: Regression analysis table: number of nights spent in the hotels and the amount spent in the hotels
In the hotel-based Basel, the number of nights stayed in the hotel explains the least as compared to the other three hotels of all variations that arise in the amount paid to the hotel. The number of nights stayed in the hotel explains about 27% of all changes in the amount paid to the hotel. This means that there are some other factors not included in our model, which greatly influence changes in the amount to be paid to the hotel in Basel. The number of nights stayed in the hotel explains the largest percentage of approximately 73% of all variations in the amount paid to the hotel based in Geneva. This percentage is the largest as compared to the other three hotels. This means the main determinant of the amount to be paid to the hotel in Geneva is the number of nights spent in the hotel.