Part 1 Action Plan and Part B Spreadsheet Analysis

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