Reference no: EM13972096
Creativity and Decision Making - Quantitative Methods
This data contains information obtained from a random sample of 104 ‘Tom hotel' from Finland, Sweden and Norway.
Tom is a well known chain owning of hotels and offers two main types of accommodation, namely A and B. This chain has hotels around various regions in the country. A hotel is run by one manager and has other employees. The directors of ‘Tom' chain would like to obtain a general profile of the hotels in the Scandinavian as well as investigate means of increasing income by investigating factors such as advertising expenditure, size of the hotel.....etc.
To carry out this assessment, a questionnaire was distributed to 104 randomly selected ‘Tom hotels'. Each hotel is run by one manager. The manager of each hotel filled the given questionnaire. This information includes the following columns (fields):
1. Number of ‘Tom' hotel
2. State the country in which hotel is located.
1. = Finland 2. = Sweden 3 = Norway
3. What is the size of your hotel?
1 = Small 2. = Medium 3 = Large
4 What is the distance of the hotel from the nearest rail link(in miles)?
5 How much do you spend on average per month on advertising? (£)
6. How many employees does this hotel have? (Both full and part time).
7. State your gender. (Gender of the manager) 1 = Male 2 = Female
8. State the group representing the years of service you have as a hotel Manager. (Years of service).
1 = 0 - 3 years 2 = 4 - 7 years 3 = > 7 years
9. What do you estimate the average monthly income from? accommodation type A to be (£).
10. What do you estimate the average monthly income from? accommodation type B to be (£).
Task 1:
a) Summarise each categorical variables using Descriptive Statistics.
b) Produce a pie chart to graphically display the distribution of the Size of the hotel.
Task 2:
a) Summarise the numerical variables using Descriptive Statistics.
b) Calculate the mean, range and standard deviation of average Monthly income from accommodation type A and B.
c) Produce a histogram for each of the above numerical variables to graphically display their distribution.
Task 3:
a) Produce one cross tabulation in order to investigate any possible association between two appropriate categorical variables.
b) Produce multiple bar charts for the above cross tabulation.
Task 4:
The directors of ‘Tom Hotels' chain of hotels believe that the Total Average Monthly incomes may have a relationship with the distance of the hotel from the nearest rail link.
Is there any evidence for this? Carry out an appropriate analysis to Investigate this. Comment on your results.
Task 5:
a) Present your findings as well as give your views.
b) What other information would you have liked to have fore more? thorough investigation into the income of ‘Tom' hotels? Briefly Comment.
Attachment:- Table data.xlsx
|
What circumstances would duration equal maturity
: We have the Goncalves par bond paying a coupon rate of 8% and having a maturity of 20 years. If the coupon rate of Goncalves were to alter to 4%, what would the new duration be? What is the meaning of duration? Under what circumstances would duration..
|
|
How would you describe the work of robert rauschenberg
: How would you describe the work of Robert Rauschenberg? How is it different from what had come before? Why did Rauschenberg create his art with this approach
|
|
Standard costing-job order-direct costing unit costing
: Which of these cost methods does the instructor suggest a pizza business might use, given the variability of the cost of cheese? Standard costing Job order costing Direct costing Unit costing. Todd owns a small factory that makes basketballs for prof..
|
|
How framers of constitution concerne about division of power
: Your paper should explain how the framers of the Constitution were concerned about the division of powers between the federal government.
|
|
Display the distribution of the size of the hotel
: Summarise the numerical variables using Descriptive Statistics - calculate the mean, range and standard deviation of average Monthly income from accommodation type A and B.
|
|
Create a presentation of 10-slides in microsoft powerpoint
: What roles do health care professionals from all areas (healthcare, managed care, and government) need to provide to the consumer to help reach specific objectives in 2020?
|
|
Explain the importance of these substances
: In this Assignment, you will have a conversation where you will translate the medical jargon for a patient. You will interpret his cholesterol panel, explain the importance of these substances and give advice on his lifestyle.
|
|
What factors influenced the choice of assessment used
: What factors influenced the choice of assessment used? If you have not received an evaluation at work, think back to all the assessments you have had as a student. What types of assessments were used? What were some aspects that helped you as a st..
|
|
Considering new three-year expansion project
: Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.64 million. The fixed asset will be depreciated straight-line to zero over its three-year tax life, after which time it will be w..
|