Reference no: EM132364229
Assignment -
Learning outcomes -
Learning objectives:
1. Explain the importance of information as an organisational resource and to develop an appreciation for issues in managing data/information/knowledge
2. Apply graphical and numerical tools for organising, analysing, interpreting, and presenting data
3. Integrate the knowledge of Microsoft Excel and other application software with the knowledge of accounting and finance.
Course learning objectives:
1. Retrieve, analyse, synthesise and evaluate complex information, concepts and theories from a range of sources
2. Apply a range of methods, techniques and tools to plan and conduct business
3. Organise, analyse and interpret complex business data using analytical, statistical and digital skills to make informed decisions
Aligned professional standards/competencies: CPA Australia Section 3: Professional skills, competency areas and learning outcomes.
Description: 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.
- 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
- 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
- Implement and perform the analysis using pivot tables, Excel Analysis ToolPak and PHStat. Create one worksheet for each issue.
Part 3: Report and Communication
- Write an 800 word report summarising the findings of your analysis for all the five issues.
Note - Total 1000 words and 2 excel sheets.
Attachment:- Assignment File.rar
|
Compute amazons balance in cash at the beginning of the year
: Operating expenses 2,060 Net operating cash flow 734, Other income expense, net 31, Compute Amazon's balance in cash at the beginning of the year.
|
|
Describes eight core functions of global financial service
: Describes eight core functions of the global financial service sector which blockchain technology will likely change. Create a new thread,
|
|
What methods of knowing are appropriate for christians
: Define epistemology and describe the 3 models of how certain we are that our perceptions mirror reality. Which position do you hold, and why? What are the.
|
|
How much of the above is included in spartans gross income
: Gain on the sale of Johnson County School bond $100. How much of the above is included in Spartan's Gross Income for tax purposes?
|
|
Determine current average pricing of the accommodation
: Analyse a business scenario - Determine current average pricing of the accommodation by brands, states, and locations
|
|
How graph theory has advanced the knowledge in your area
: Examine how these applications are being used in your specialization. Determine how graph theory has advanced the knowledge in your area of specialization.
|
|
Examine the ethical implications of a controversial topic
: For this paper, you will examine the ethical implications of a controversial topic related to forensic psychology. Choose from the following topics.
|
|
How the marginal rate of substitution must be related
: Explain how the Marginal Rate of Substitution and the Marginal Rate of Transformation must be related to each other at the optimal choice, and why ?
|
|
Business manager participate in information systems decision
: In your opinion and according to your recommended textbook under introduction, why will business managers participate in information systems decisions?
|