Business Statistic Assignment

| Merola Resort Properties | | | Group 2Team 2 | Statistic Assignment - Lecturer: Sienney Liu | | Team members: Nguyen Ngoc Bao Chau s3408641Dinh Bach Nga s3410233Huynh Minh Khoa s3409594 |

QUESTION 1:
Use Excel to create a histogram which displays the frequencies of different satisfaction levels collected from the guests in each of the two hotels. Be sure to include the two Frequency Distribution tables with your two histograms.

Bin | Frequency | 0 | 1 | 2 | 22 | 4 | 24 | 6 | 16 | 8 | 23 | 10 | 14 | More | 0 |

Bin | Frequency | 0 | 0 | 2 | 15 | 4 | 18 | 6 | 35 | 8 | 15 | 10 | 17 | More | 0 |
Satisfaction levels collected from the guests in
Happy Hotel

Distribution table
Happy Hotel

Satisfaction levels collected from the guests in
Lucky Hotel

Distribution table
Lucky Hotel

QUESTION 2:
Use Excel to get the mode, mean, median and comment on the customer satisfaction levels on the two hotels (including a comparison of the two levels of satisfaction) based on these central tendency data Happy Hotel | | | Mean | 4.723 | Median | 4.5 | Mode | 2.8 | Lucky Hotel | | | Mean | 5.031 | Median | 5.2 | Mode | 5.2 |

Central tendency data of the customers’ satisfaction levels on the two hotels

Mean
In...(text book page 58), “mean” is defined as “the average of a group of numbers”. In application for this case, the mean of each hotel represent the average satisfaction level among its customers. To be more specific, there is a slight difference between the two hotels: the mean of Happy Hotel is 4.723 while Lucky Hotel’s mean is 5.031. In comparision, these two numbers show that the customer’s average satisfaction of Lucky hotel is 0.3 times higher than Happy hotel. Thus, it leads to a reasonable conclude that customers averagelly seem more satisfied with Lucky Hotel than Happy Hotel.
Median
According to Emerging Technologies Team of Fischler School