Part 1 Action Plan and Part B Spreadsheet Analysis
QUESTION
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: Determine whether price differentiation exist among the accommodation brands.
Issue 3: Determine whether price differentiation exist between state among accommodation 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