Call Back

24x7 Support Available

chat now

In A Hurry? Get A Callback

### shopping cart 0

Subject Solutions Code Description Price Delete

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

#### Question Preview:

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 ...

View Complete Question >>

#### Question Preview:

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 >>

## Solution Preview

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

#### \$25

Orginal Price : \$32.50

Pay Now

250 words

Donâ€™t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

## CUSTOMER REVIEWS

### Excellent

Based on 702 reviews See all reviews here

### One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

### Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

### One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane