Reference no: EM133665031
Case - Cunningham Holdings case study
Instructions
You are the new business analyst for Cunningham Holdings. The CEO of the Cunningham Holdings subsidiary, Oscar Cunningham has assigned you the task to conduct a statistical analysis of the current accommodation business data (see CHL Accommodation DATA.xlsx) and prepare 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: Deter/nine whether price differentiation exist among the accommodation brands.
Issue 3: Determine whether price differentiation exist between state among accommoc„,tion brands.
Issue 4: Determine whether price differentiation exist between location among accommodation brands.
Issue 5: Determine if the introduction of the Comfort brand has increased internal competition among the other accommodation brands
Part 1: Action Plan
- Create an action plan for how you will conduct the analysis to address the three (3) issues above. Your action plan should describe the following for EACH issue:
- How the data will be prepared and organised for analysis
- What analytic tool will be used to perform the analysis
- How hypothesis testing will be performed for issues 2 to 5 (see more details in the case study description)
- This should be presented in MS Word.
Part 2: Spreadsheet Analysis
- Implement and perform the analysis using pivot table, Excel Analysis Tool and PHStat.
- This should be presented in MS Excel, 1 file for each issue: 5 issues = 5 MS excel files
Part 3: Report and Communication
Write an 800 word report summarising the findings of your analysis for each issue.