CO5124 Data Analysis and Decision Modelling
This course which is CO5124: Data Analysis and Decision Modeling requires organizing, interpreting and analyzing multifarious business data using digital, statistical and analytical skills to make informed decision.
Group or individual: Individual
Weighting: 40%
Description:
The aim of this assessment is to apply business analytics and statistical theory to analyze 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 summarizing 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 consists 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 summarizing the findings of your analysis for all the five issues.
In today’s fast-paced business environment, the problems faced by decision makes can be addressed through several courses of actions. Data analysis and modeling play a key role in presenting data and constructing various variables and constraints that can support eminent information. The crucial part of collecting data is to be used statistically in getting intellectual analysis and to make inferences. The data modeling is a part of data analysis technique that concentrates on discovering knowledge for predictive purposes. The data model reflects set of mathematical evaluations, logical assumptions and vital data anchored in future conservative projection, current variables and historical evidences. Moreover, it stimulates the real world and arrives at numerous probable outcomes of single decision.
Techniques used to perform Data Analysis and Decision Modeling:
The Data Analysis and Decision Modeling can be performed through numerous techniques like:
- Descriptive statistics
- Data analysis to discover new features.
- Existing hypothesis (about the data) use to confirm data analysis process.
- Statistical model application to make predictive forecasting for predictive analysis.
- Text analytics use linguistic, statistical and other few methods to acquire data and classify information gained from text sources.
Get Data Analysis and Decision Modeling Online Tutoring from Professional Experts
The universal truth is, the real world is modeled on unrealistic, impractical and unsupported assumptions. That’s the reason the statistical consultants prepare the data analysis and modeling to produce a solution condense of epic proportions. Data modeling is the most powerful tool used by business community at their disposal. It’s a very technical subject that requires an individual to think and work in the same way. This particular assignment, CO5124 Data Analysis and Decision Modeling comprises of 3 parts: Action Plan, Spreadsheet Analysis, Report and Communication. Each part is allocated specific mark so that the students can incorporate details according to it. The parts are sequenced, that make it mandatory to work in a flow. Many students who get stuck at any step, and fail to succeed after making several attempts seek for Online Tutoring. There is no way that a writer unfamiliar with this subject can draft a sentence even. Myassignmenthelp has qualified subject experts who have worked earlier on similar task, also know when to use software, the techniques and tools and accurately analyze the findings.
For every urgent Online Tutoring, the experts revise data several times to get the necessary data required to construct reliable model. They constructively use the analysis in business planning, getting profitable inclination towards the decision already taken. As they master Forecasting Techniques in Excel, Pivot Table, slicer and other necessary tools for analysis; to craft the work using the requirements is at their fingertips.
Elevate your understanding of Corporate Modeling with MyAssignmentHelp’s specialized Online Tutoring on Corporate Modeling. Our expert tutors provide personalized guidance, helping you master financial analysis, forecasting, and decision-making strategies. Access convenient assistance online and excel in corporate finance modeling. Boost your skills with us today!
[citationic]