How the data will be prepared and organised for analysis

Assignment Help Other Subject

Reference no: EM133665031

Case - Cunningham Holdings case study

Instructions

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: Deter/nine whether price differentiation exist among the accommodation brands.

Issue 3: Determine whether price differentiation exist between state among accommoc„,tion 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

Part 1: Action Plan

- Create an action plan for how you will conduct the analysis to address the three (3) issues above. Your action plan should describe the following for EACH issue:
- How the data will be prepared and organised for analysis
- What analytic 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)
- This should be presented in MS Word.

Part 2: Spreadsheet Analysis
- Implement and perform the analysis using pivot table, Excel Analysis Tool and PHStat.
- This should be presented in MS Excel, 1 file for each issue: 5 issues = 5 MS excel files

Part 3: Report and Communication

Write an 800 word report summarising the findings of your analysis for each issue.

Reference no: EM133665031

Questions Cloud

How you describe alexs leadership or managerial philosophy : How would you describe Alex's leadership or managerial philosophy? Theory X, Y or Z or something else or a combination?

Develop a care plan for mrs white pathophysiology : Develop a care plan for Mrs. White, make including the following: Pathophysiology-nursing diagnosis.

What are the options for sarah if this was retaliation : How does the company's organizational culture appear to conflict with its ethical policies? What are the options for Sarah if this was retaliation?

Explain health care facility design project management : You use your skills in project management to explain health care facility design project management by creating a proposal of what this project might look like.

How the data will be prepared and organised for analysis : Create an action plan for how you will conduct the analysis to address the three (3) issues above and How the data will be prepared and organised for analysis

How low marginal costs and switching costs have combined : How low marginal costs, network effects, and switching costs have combined to help create a huge and important industry.

Physical exam reveals pericardial friction rub : A patient presents to the ER with acute onset of sharp chest pain and "flu-like" symptoms. Physical exam reveals a pericardial friction rub.

Role of technology in general in the fight against covid-19 : What type of advantages does technology provide us with respect to public health? How did COVID-19 pandemic changed the use of technology in healthcare?

What is most likely pathophysiological process : What is the most likely pathophysiological process underlying a patient's esophagitis with dysphagia, heartburn,

User Account

All Pages