Descriptive Statistics – categorical variables: Region

Descriptive Statistics – categorical variables: Region

 Dr Assignment Subscription

Produce one cross tabulation (what is cross tabulation) in order to investigate any possible association between two appropriate categorical variables.

Comment on the results and make relevant recommendation to Hotel’s management

According to the data which given on the pages ??, which data was provided by 104 hotels. After collected the 104 surveys from the hotels, found two outline data on -1 data on distance from the nearest from the rail link and -1 data on the service years of the hotel managers. So, we decided ignore these two surveys data. However, the total of the surveys from the hotels are 102 only.

The total of the hotel is 102, 40 of the hotels are located in Finland, it is 39% of the total.

The second one 33 hotels are located in Sweden, 32 % of the total. Norway is 29% of the total, only 29 hotels in there.

Descriptive Statistics – categorical variables: Size of the Hotel

This figure shows that 45 Hotels of the total 102 is less that 50 rooms, 44% of the total.

Only 26% of the Hotels are operating more than 100 rooms.

Descriptive Statistics – categorical variables: Gender of the manager

In 102 hotel managers, 60 managers are male to take 59% of the total. The rest of 41% managers are female.

Descriptive Statistics – Categorical variables: Years of service

The survey of the service year is 55% of the managers are working in the hotel between 0-3 years. Less than 7% of the managers are working over 7 years.

Descriptive Statistics – numerical variables: Distance

Firstly, the categorical variables which are: Distance, Advertising, Employees, Type A and B.

According to the Distance (in miles) chart, the nearest distance between hotel and rail link is 0.5 miles, the longest distance is 4 miles, the mode is 1.5 miles.

The mean is 2.43 and the median is 2.5, figures are closed together.

Descriptive Statistics – numerical variables: Advertising

The Advertising (£) table showing that the mode of the hotel where spend on advertising average per month is £1460.00. The maximum spends on advertising(£1798.00) are almost 2.5 times of the minimum spending (£651.00).

Descriptive Statistics – numerical variables: Employees

The maximum of employees who works in hotel is 34, the minimum of the manpower of the hotel is 10 only. It is different in 3.5 times between in maximum and minimum.

The median is 18 employees and the mode is 15 employees, these two figures are closed.

Descriptive Statistics – numerical variables: Accommodation A

Descriptive Statistics – numerical variables: Accommodation B

This table shows the 104 hotels they got the similar on the average monthly income from the accommodation A and B.

Investigate of relationship between Region and Size of Hotel

We are choosing region of the hotel located and the size of the hotel to investigate ant possible association from the categorical variables.

Our hypothesis is set as below:

: No relationship between the room size and the hotel located in country.

: There is a relationship between the room size and the hotel located in country.

According to the data are given from Region and Size of the hotel, we are organizing as the below table:

So, base the on above table, we change to the observe value as below table:

Then, we start to calculate the expected value, for example,

After that, we got the figure as below table

The Chi-square test statistics:

Due to the degree of freedom is = (m-1) (n-1) = (3-1) (3-1) = 4, so that, the critical value of 5% on 4 degree of freedom is 9.488.

Since 13.53782015 is greater than 9.488, we reject .

We conclude that there is a relationship between the room size and the hotel located in country.

Relationship between the total average monthly incomes and distance of the hotel from the nearest rail link

Total we have 102 surveys of hotel,  After group the data of total average income and distance of the hotel from the nearest rail link, the figure shown as below table:

n = 102                        Σx = 248          Σy = 62235700            Σxy = 144416375

= 690.105                         = 3.89E+13

r =                                  = -703983350

= 8886.71

= 9.46E+13

= 916834454

r = -0.76784129

So that, base on the general interpretation of Correlation coefficient, we got the figure is

-0.76784129, that means that there is no relationship between the total average monthly incomes and the distance of the hotel from the nearest rail link.

Descriptive Statistics – categorical variables: Region

Dr Assignment Subscription

Last Updated on February 14, 2019