Reference no: EM132950566

Learning objectives:

o Explain the importance of information as an organisational resource and to develop an appreciation for issues in managing data/information/knowledge
o Apply graphical and numerical tools for organising, analysing, interpreting, and presenting data
o Integrate the knowledge of Microsoft Excel and other application software with the knowledge of accounting and finance.
• Course learning objectives:
o Retrieve, analyse, synthesise and evaluate complex information, concepts and theories from a range of sources
o Apply a range of methods, techniques and tools to plan and conduct business
o Organise, analyse and interpret complex business data using analytical, statistical and digital skills to make informed decisions
o Present complex business analyses and information appropriately to both accountants and non-accountants using:
• (a) Effective oral presentation skills
• (b) Clear and fluent written communication.
•

• Aligned professional standards/competencies:
o CPA Australia Section 3: Professional skills, competency areas and learning outcomes.

• 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.

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.

o Issue 1: Determine current average pricing of the accommodation by brands, states, and locations
o Issue 2: Determine whether price differentiation exists among the accommodation brands.
o Issue 3: Determine whether price differentiation exists between states among the accommodation brands.
o Issue 4: Determine whether price differentiation exists between locations among the accommodation brands.
o Issue 5: Determine if the introduction of the Comfort brand has increased internal competition among the other accommodation brands.

o Part 1: Action Plan
o 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:
o How the data will be prepared and organised for analysis
o What analytics tool will be used to perform the analysis
o How hypothesis testing will be performed for Issues 2 to 5 (see more details in the case study description).

o Part 2: Spreadsheet Analysis
o Implement and perform the analysis using pivot tables, Excel Analysis ToolPak and PHStat. Create one worksheet for each issue.

o Part 3: Report and Communication
o Write an 800 word report summarising the findings of your analysis for all the five issues.

Attachment:- Cunningham Holdings case study.rar