User Account

All Pages

Determine current average pricing of the accommodation

Assignment Help Case Study
Reference no: EM132294580

Description:

The aim of this assessment is to apply business analytics and statistical theory to analyse a business scenario with a particular focus on the application of Excel Analysis ToolPak and PHStat.

Case study - Cunningham Holdings Limited

Instructions

You are the new business analyst for Cunningham Holdings. The CEO of the CHL hospitality subsidiary, Oscar Cunningham has assigned you the task to conduct a statistical analysis of the current accommodation business data (scroll down to see the CHL Accommodation Data.xlsx) and prepare an 800 word report summarising your findings addressing the five issues below.

Issue 1: Determine current average pricing of the accommodation by brands, states, and locations
Issue 2: Determine whether price differentiation exists among the accommodation brands.
Issue 3: Determine whether price differentiation exists between states among the accommodation brands.
Issue 4: Determine whether price differentiation exists between locations among the accommodation brands.
Issue 5: Determine if the introduction of the Comfort brand has increased internal competition among the other accommodation brands.

Your submission consist of 3 parts:

Part 1: Action Plan
• Create an action plan for how you will conduct the analysis to address the five issues above. Your action plan should describe the following for each issue:
• Now the data will be prepared and organised for analysis
• What analytics tool will be used to perform the analysis
• Now hypothesis testing will be performed for Issues 2 to 5 (see more details in the case study description).

Part 2: Spreadsheet Analysis
• Implement and perform the analysis using pivot tables, Excel Analysis ToolPak and PHStat. Create one worksheet for each issue.

Part 3: Report and Communication
• Write an 800 word report summarising the findings of your analysis for all the five issues.

Attachment:- Cunningham Holdings case study.rar

Reference no: EM132294580

Questions Cloud

What is the appropriate span of control and explain : Give your opinion regarding what is the appropriate span of control and explain your rationale.
How would one describe employer ethics : How does personal or corporate ethics impact decision-making? Conflicts at workplace that can be triggered by the perception of fairness
Two elements of a company business model : Define and explain the importance of the two elements of a company's business model. Apply your answer to a company/product of your choice.
What objection does holmes have to tafts reasoning : Describe Boyd v. U.S.? Explain the relevance of the finding to Olmstead, explaining how the 4th and the 5th did or did not apply.
Determine current average pricing of the accommodation : Determine current average pricing of the accommodation by brands, states, and locations - Determine whether price differentiation exists among the accommodation
Socially responsible in its actions and conduct : Why should a company endeavor to be socially responsible in its actions and conduct? Give an example of a company that practices CSR. How do they do it?
Explain why an organization needs a strategic vision : Explain why an organization needs a strategic vision. What purpose does a strategic vision serve?
Does the court have a way to represent the children interest : Johnny would like to know what joint custody means and if it truly means equal time. Mr. Litthas told you the law on this question recently changed.
Write C program to calculate the amount of fines to be paid : M1H324645 Engineering Computing Assignment, National University of Science & Technology - College of Engineering - Sultanate of Oman

Reviews

len2294580

4/27/2019 3:04:28 AM

Please go through all the files present in the zip folder. Assignment file describes about what to be done in the assignment and other two files gives the information about the company. Please follow each and every instruction given.

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd