Must be expert in MS Excel with regard to all complex functions including pivot tables, custom views, graphs and charts, etc.
We will provide you all the data necessary. You will receive a single .xls containing 24-months of a single line-item expense for 800 separate companies. You will analyze the data and create a report that explains the following:
1. Determine which companies have relevant data for the entire sample period (apples to apples).
2. Develop analytic model using only those companies. Document and explain model.
3. Determine average expense by zip code (month, year, total)
4. Determine average expense by U.S. state (month, year, total)
5. Determine expense trend by company, by zip code, by state, and total for each time period of the sample (monthly, quarterly, annually, total).