StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Issues Using Statistical Techniques of the Hotel Chain in the UK - Statistics Project Example

Cite this document
Summary
The paper 'Issues Using Statistical Techniques of the Hotel Chain in the UK' discusses an overseas hotel chain that is considering branching into the UK. Therefore, the Management wishes to undertake an analysis of existing hotel provision in the three cities of London, Cardiff, and Edinburgh…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.7% of users find it useful
Issues Using Statistical Techniques of the Hotel Chain in the UK
Read Text Preview

Extract of sample "Issues Using Statistical Techniques of the Hotel Chain in the UK"

1st Year Certificate of Higher Education Database Assignment 11 _________________________________________________________________________ IA-706-AU QUANTITATIVE METHODS AND INFORMATION TECHNOLOGY _________________________________________________________________________ Report Title: An Analysis of Existing Hotel Provision in London, Cardiff and Edinburgh Assignment: Database Assignment Group: Group B Student Name: Assignment Due Date: Friday 17 December Table of Contents Introduction (Background) 3 Data Collection Method 3 Analysis and Findings 4 Summary Statistics 4 Statistical Analyses (Inferential Statistics) 6 Hotel’s Star rating based on Cities 6 Prices of Hotel Rooms based on Cities 7 Price of Hotel Rooms based on Star Ratings 8 Proportion of Hotels with Swimming Pools based on Cities 9 Proportion of Hotels with Swimming Pools based on Star Ratings 10 Price of Hotel Rooms based on Hotels with Swimming Pools 10 Influence of Hotel’s Guest Rating and Star Rating on the Price of Hotel Room 11 Recommendations 12 Reference 13 Appendix I: Output using MegaStat (An Excel Add-in) 14 An Analysis of Existing Hotel Provision in London, Cardiff and Edinburgh Introduction (Background) An overseas hotel chain is considering branching into the UK. Therefore, the Management wishes to undertake an analysis of existing hotel provision in the three cities of London, Cardiff and Edinburgh. They are particularly interested in the following issues: The mix of hotels in these cities by star rating, and does this differ between cities? Comparison of the prices of hotel rooms between cities and between hotels with different star ratings. Difference in proportion of hotels with swimming pools between cities and between hotels with different star ratings? Difference in the price of rooms based on swimming pools facility? Any other interesting aspects of hotel provision in the cities. This report will analyze above issues using statistical techniques (descriptive and inferential statistics) and presents finding and recommendation based on it. Data Collection Method Initially, a list of hotels names in the three cities of London, Cardiff and Edinburgh is prepared. Thereafter, around 250 hotels name are randomly selected from the list and a survey is undertaken in these hotels. The data collected in the survey for the location, swimming pools (yes/no), star rating, guest rating, free breakfast (yes/no), and price of the rooms. Total 214 hotels response collected that includes 75 hotels in London, 80 hotels in Edinburgh and 59 hotels in Cardiff. Analysis and Findings Summary Statistics The sample consists of 214 hotels with 35% in London, 37% in Edinburgh, and remaining 28% in Cardiff (figure 1). As shown in figure 2, around 37% hotels are with 3-star ratings and around 34% hotels are with 4-star rating. The hotels with 2-star and 5-star rating are 11%, and 17%, respectively. Only, about one-fourth (26%) of the hotel have swimming pools (figure 3). Most (91%) of the hotels do not provide free breakfast (figure 4). Figure 1: Hotels in the three cities of London, Cardiff and Edinburgh Figure 2: Hotels with different star ratings Figure 3: Hotels with and without swimming pools Figure 4: Hotels providing free breakfast Table 1 shows the characteristics of hotels in the three cities in terms of star rating, room price and guest rating. The average star rating of the hotels in the three cities of London, Cardiff and Edinburgh is about 3.6 and varies from its mean by about 0.9. About half of the hotels have star ratings greater than or equal to 4. The average price of hotel room is about £127 and varies from its mean by about £85. About half of the hotels have room price less than or equal to £90. The range of the room price is £417 with minimum and maximum room price being £33 and £450, respectively. The distribution of the price of rooms is positively skewed. Table 1: Characteristics of the hotel’s star rating, room price and guest rating   Star Rating Price (£) Guest Rating (on scale of 10) Mean 3.57 126.74 8.07 Median 4 99 8.2 Mode 3 60 8.2 Standard Deviation 0.90 84.88 1.02 Kurtosis -0.80 1.90 2.73 Skewness 0.02 1.47 -1.11 Range 3 417 6.8 Minimum 2 33 3.2 Maximum 5 450 10 Count 214 214 206 The average guest rating of hotel room is about 8.07 and varies from its mean by about 1.02. About half of the hotels have guest rating more than or equal to 8.2. The range of the guest rating is 6.8 with minimum and maximum guest rating being 3.2 and 10, respectively. The distribution of guest rating is negatively skewed. Statistical Analyses (Inferential Statistics) Hotel’s Star rating based on Cities The research question examined is: “Is there a difference in hotels star ratings between the three cities of London, Cardiff and Edinburgh?” The hypotheses tested are: H0: µLondon = µCardiff = µEdinburgh H1: The means are not all equal. The results of the ANOVA test are statistically significant, F(2, 211) = 5.17, p = .006 ( Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Issues Using Statistical Techniques of the Hotel Chain in the UK Statistics Project Example | Topics and Well Written Essays - 1500 words, n.d.)
Issues Using Statistical Techniques of the Hotel Chain in the UK Statistics Project Example | Topics and Well Written Essays - 1500 words. https://studentshare.org/business/1747061-quantitative-methods-and-information-technology
(Issues Using Statistical Techniques of the Hotel Chain in the UK Statistics Project Example | Topics and Well Written Essays - 1500 Words)
Issues Using Statistical Techniques of the Hotel Chain in the UK Statistics Project Example | Topics and Well Written Essays - 1500 Words. https://studentshare.org/business/1747061-quantitative-methods-and-information-technology.
“Issues Using Statistical Techniques of the Hotel Chain in the UK Statistics Project Example | Topics and Well Written Essays - 1500 Words”. https://studentshare.org/business/1747061-quantitative-methods-and-information-technology.
  • Cited: 0 times

CHECK THESE SAMPLES OF Issues Using Statistical Techniques of the Hotel Chain in the UK

Sustainability and Strategy - HILTON HOTEL

Recently, the uk government in particular has framed an array of environment sustainability policies so as to preserve the ecological balance.... the uk provides high business freedom (94.... As Wintour, Elliott and Mulholland (2008) point out, the uk Prime Minister Gordon Brown's press releases reflect that the country still has a lot to achieve in ensuring effective waste disposal.... Admittedly, the uk government does not foster business activities which may hurt the long term sustainability of the country....
9 Pages (2250 words) Essay

Labor Turnover in HK's Hospitality Industry

The author of this paper look at the phenomenon of high employee turnover in the Hong Kong hotel industry.... The reasons for employee turnover in the Hong Kong hotel industry, possible solutions, and prediction will be explored in this paper There is no denying that each manager in the hospitality industry wants to control the rate of employee turnover in order to ensure the stability of their organization.... One expert points out:'the hospitality industry is one in which there is a high need to ensure customer loyalty as when a customer experiences good quality service, he tends to visit the same hotel again....
48 Pages (12000 words) Essay

Customer Loyalty at a Catered House in London

Within the uk, the hospitality industry is highly competitive and service levels are a vital factor in ensuring customer satisfaction with the hospitality services they receive.... ravel and tourism are booming today and several studies have already been carried out on the levels of passenger and hotel resident satisfaction across the globe....
37 Pages (9250 words) Essay

MANAGEMENT IN A EUROPEAN CONTEXT

This study assumes significance in the sense that Sol Melia is planning to enter the uk market.... he study aims at studying the hotel and hospitality industry of In order to find out the business environment in the two countries a PEST analysis of UK and Spain have been carried out.... This would help both the companies to analyze the hotel industry from the view of all the stakeholders and competitors.... n order to find out the similarities amongst the markets of uk and Spain a PEST analysis is carried out for both uk and Spain....
12 Pages (3000 words) Essay

Effect of the Recession on the Marriott Hotels

The Government provided loans to the public without enquiring about their credentials and that caused a huge demand in the housing market.... However, when the loans came up for payments most of the people.... ... ... The economy was in shambles.... The global economy was affected as the US economy is one of the most influential economies of the world....
24 Pages (6000 words) Essay

The Relationship between Customer Satisfaction and 3, 4 Star Hotels

Thus, the hotel industry has become a global one, culminating in the establishment of conventional standards and practices and identifiable types of guests, whether traveling for business or pleasure.... The purpose was to compare two types of hotel in Bournemouth, with the goal of determining the factors in customer appeal and customer satisfaction.... They have realized the fundamental importance of positioning themselves through establishing and maintaining a vibrant customer base, grounded on the philosophy of providing quality services that ensure and enhance customer satisfaction, and which create a brand that give the individual hotel a competitive edge over its competitors, other than...
29 Pages (7250 words) Essay

Current and Future Trends in UK Hospitality Industry

The hospitality industry in the uk is the fifth-largest industry and encompasses a wide range of services.... % share in the uk total income whereas this share is high in many of the parts of UK (The Pearson School, 2014).... In this report about the Hospitality and Hotel Industry of the United Kingdom, we will discuss the position of the hotel industry today, and how it has emerged from depression.... The hospitality industry plays a crucial role in economic and social development across the uk....
14 Pages (3500 words) Coursework

Service Challenges of the New Millennium

When a woman at a beach resort hotel lost her engagement ring on the beach, after a fruitless search, the cabana attendant went and purchased a metal detector which helped to locate the ring.... This paper 'Service Challenges of the New Millennium' will review the literature on service quality in the hospitality sector at various levels including, hotels, front office, housekeeping, tourism, restaurants, bars, and pubs apart from travel experiences....
12 Pages (3000 words) Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us