Explain the importance of information as an organisational resource and to develop an appreciation for issues in managing data/information/knowledgeApply graphical and numerical tools for organising, analysing, interpreting, and presenting dataIntegrate the knowledge of Microsoft Excel and other application software with the knowledge of accounting and finance.Course learning objectives:Retrieve, analyse, synthesise and evaluate complex information, concepts and theories from a range of sourcesApply a range of methods, techniques and tools to plan and conduct businessOrganise, analyse and interpret complex business data using analytical, statistical and digital skills to make informed decisionsPresent complex business analyses and information appropriately to both accountants and non-accountants using:(a) Effective oral presentation skills(b) Clear and fluent written communication. :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. InstructionsYou 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 locationsIssue 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. consist 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 analysisWhat analytics tool will be used to perform the analysisHow 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%)
Related Completed Projects
Watch one sitcom episode of a TV show Please choose one option from the list below Option 1: Friends -The One with Five Steaks and an Eggplant (found on Crave for the full episode) .
Start with focus on Canada, and then branch out if needed to connect with other countries internationally, but keep your sources and framing on Canada
Discuss the process of differential diagnosis and how would you distinguish between these disorders and the disorder that you have selected during an assessment.
Describe the issues and a possible solution in a 3Perhaps the most basic and important subject in the he