This assignment requires the manipulation and analysis of a sample raw data file in Excel to calculate and compare key performance indicators (KPIs) for a hotel and its comp set over a 48 month period.
Obtain a sample raw data file (in Excel) with 48 months of property and comp set data (STR Number, Month Date, Subject Supply, Subject Demand, Subject Revenue, Comp Set Supply,…