### Assignment related to data analysis || Action Plan (50%) || Spreadsheet Analysis (30%) || Report and Communication (20%)

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. 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) 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. View Less >>
Among the total of 144 accommodation samples by three brands, 48 were selected for each brand in the sample. The average price for the resort was \$200, Cottage was \$203, and Classic was \$201.It shows that there is no price difference among brand types, however, statistical testing is required to confirm it. In the total of 144 accommodation samples by three states, 48 were selected for each state in the sample. The average price for NSW was \$201, QLD was \$202, and VIC was \$201. It shows that there is no price difference among state types, however, statistical testing is required to prove it. From the total sample of 144 accommodations by two locations, 72 were selected for each location in the sample. The average price for metropolitan cities was \$202 and for regional cities, it was \$201. It shows that there is no price difference among location types, the however statistical testing process is required to prove it. Get solution

Place a new order
Pages (550 words)
Approximate price: -