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. 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 (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 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 (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%) Write an 800 word report summarising the findings of your analysis for all the five issues.
MyAssignmenthelp.com is the most accomplished and credible online dissertation assistance provider in USA, aimed at offering top-quality academic help at affordable price. Despite providing cheap dissertation help, we never let our dissertation writers compromise with the quality of papers. Hence, we have gained the status of best dissertation writing company in USA. Apart from writing help, our dissertation tutors also provide dissertation writing guidelines in order to help students in the best possible manner.
Just share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Dear Expert Thank you for your service and support. The work was good, I got 72%.
Australia
WHAT AN FANTASTIC OUTCOME I RECEIVED!! My essay subject was very difficult with many parts! My MAH\'s expert NAILED IT!!!! thanks a million! I WILL BE BACK!
Australia
It was a very well done job. The writings are accurate and supported with reliable resources which were related to the assignment. It was done on time and quick service.
Australia
Hi, Received the grades for this assignment this morning. Good grades with some minor feedback. Professor is happy with the content, referencing and especially the way assignment was written. Please pass on my thanks and regards to the expert who did...
Australia