Statistical Analysis and Report on Market Sustainability of Cunningham Holdings Limited

A statistical Analysis and Report on
Market Sustainability of Cunningham
Holdings Limited
1

Part 1
Action Plan for Issue I
I. The data in “CHL Accommodation Data” excel file has been restructured by replacing
the categorical variables with their actual classifications instead of numerical grading.
II. Pivot tables have been constructed for average price of accommodations by Brand,
State, and Location. Two-way pivot tables were also constructed for average price of
accommodations for Brand by State, and then for Location.
III. Pivot tables were later restructured along with graphical presentation of the above
situations.
Average price of accommodations by Brand
2

Average price of accommodations by State
Average price of accommodations by Location
3

Average price of accommodations for Brand by State
4