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

  What is the cdc''s procedure for mass immunizations

What is the CDC's procedure for mass immunizations that are necessary for certain types of infectious outbreaks such as influenza, mumps, and tetanus?

  Is the problem encapsulated in a single question

Is it clear that this problem can be approached through social science research (instead of theoretical or speculative reasoning or natural science methodology)?

  How many standards have been issued by fasb

How Many Standards Have Been Issued by FASB? Dissents Portending Future? Hybrid Historical Cost and Market Value-Why the Mix? Cash Basis or Accrual Basis?

  How should shirley ensure that the project is finished

Capture screenshots of the "Who does what" report that shows the tasks each resource is involved in and when they are scheduled to work on that particular task. Add the screenshots to the Word document in answer to this question.

  How the symptoms impact on his activities of daily living

What community assistance would be available for Mrs Barber whilst Mr Barber remains in hospital? Give an example of an allied health care worker who would make these arrangements prior to Mr Barbers discharge - What actions should you take now tha..

  Explain the concept of a states police power

Discuss federal preemption and where in the US Constitution federal preemption is discussed. Explain the concept of a state's Police Power.

  Write a differential diagnosis of disorders

Why is it that the later in age this disease manifest itself, the less severe the disease is and what tests would you run to clarify your differential and potentially come to a definitive diagnosis?

  Identify the different types of knowledge needed

Exploring Innovation in Action - Evolving Knowledge Needs of a New Venture. Identify the different types of knowledge needed throughout the growth of the new venture.

  Do you agree with the federal judges decision

What are the ethical Issues in this case and who are the stakeholders. and how are they impacted by this situation?

  Recruit the ceo from the inside seems to work well fur intel

Case Analysis - Intel Prepares Its Top Leaders and to recruit the CEO from the inside seems to work well fur Intel. Do you believe this is a sound policy? Why?

  Write a proposal to address problems faced by computers r us

Write a research proposal to address the problems faced by Computers R Us. You are required to follow the following structure of the proposal?

  What do you understand by the term cost plus pricing

Describe what do you understand by the term "Cost plus Pricing "and highlight any limitations this may have. How does this differ from "Target Costing "pricing - Describe the type of pricing policy being applied by Hewlett- Packard in regard to the..

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