Analysis of Accommodation Prices by Brands, States, and Locations

Action plan
Action Objective Hypothesis Data
organization
Analysis method
Issue one To determine current
average pricing for
accommodation by
brands, states and
locations
_ Data will be
organized using
a Pivot table
Descriptive analysis
will be applied to
derive the average
mean prices
Issue two To determine whether
price differentiation exist
among the
accommodation brands
H0: The
accommodation
price is uniform
among
accommodation
brands.
H1: Price
differentiation
exist among the
accommodation
brands.
The prices will
be organized
into three
accommodation
brands i.e.
Resort, Cottage
and Classic
using filter and
placed in a
separate excel
sheet.
Analysis of variance
technique will be to
test the hypothesis by
comparing the p value
of the F ratio with
default value at 95%
level of significance.
Bar graph and table
will be used for
presentation.
Issue three To determine whether
price differentiation exist
among the states
H0: The
accommodation
price is uniform
among the states.
H1: Price
differentiation
exist among the
states.
The prices will
be organized
into three states
i.e. NSW, QLD
and VIC
using filter and
placed in a
separate excel
sheet.
One-way analysis of
variance from excel
add in analysis tool
Pak.
Bar graph and table for
presentation
Issue four To determine whether
price differentiation exist
between the locations
H0: The
accommodation
price is uniform
between the
locations.
H1: Price
differentiation
exist between the
locations.
The prices will
be organized
into two
locations i.e.
Metropolitan
cities and
Regional cities
using filter and
placed in a
separate excel
sheet.
Two independent t test
to compare prices of
the two locations.
Tables and bar graph
will be used to
represent the findings.
Issue five Determine whether
introduction of the
comfort brand has
increased competition
among the
accommodation brands
- Pivot table will
be used to
organize the
data.
Descriptive statistics

Report
Results and findings
Average accommodation prices by Accommodation brands
Brands
Average of
Price
1 - Resort 200.2704167
2 - Cottage 202.65625
3 - Classic 201.4627083
Grand Total 201.463125
Average accommodation prices by States
State Average Price
1 - NSW 201.02375
2 - QLD 202.196875
3 - VIC 201.16875
Grand
Total 201.463125
Average accommodation prices by Locations
Location
Average of
Price
1 - Metropolitan
Cities 201.5591667
2 - Regional
Cities 201.3670833
Grand Total 201.463125
Comparison of accommodation prices by accommodation brands
ANOVA
Source of
Variation SS df MS F P-value F crit
Accommodati
on 136.6128292 2
68.3064
1
7.19034
6
0.00106
3
3.06029
2
Error 1339.463265 141
9.49973
9
Total 1476.076094 143

Resort Cottage Classic
199
199.5
200
200.5
201
201.5
202
202.5
203
200.27
202.66
201.46
Graphical representation of average prices
against accommodation brand
Accommodatoion brand
Accomodation price
Comparison of accommodation prices by accommodation states
SUMMARY
State Count Sum Average
Varianc
e
NSW 48
9649.1
4 201.0238
9.70880
3
QLD 48
9705.4
5 202.1969
11.9640
2
VIC 48 9656.1 201.1688
8.89754
7
ANOVA
Source of
Variation SS df MS F P-value F crit
State 39.2686125 2 19.63431
1.92679
8
0.14942
8
3.06029
2
Error 1436.807481 141 10.19012
Total 1476.076094 143