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 (50%)
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:
How the data will be prepared and organised for analysis
What analytics 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).
Part 2: Spreadsheet Analysis (30%)
Implement and perform the analysis using pivot tables, Excel Analysis ToolPak and PHStat. Create one worksheet for each issue.
Part 3: Report and Communication (20%)
Write an 800 word report summarising the findings of your analysis for all the five issues.
Sample Solution