Problem: Average Hospital Expenses Per Day Trends: FOHC would like to understand the trends for the average Hospital Expenses Per Day in the 1st half of the year (January through June). They would also like a projection into the first months of the 2nd half of the year (July/August) assuming the 1st half of the year trends continue. o Note: FOHC is not looking for trends for each hospital. It is looking for the aggregate for all hospitals. o For each metric, plot by month and add trend lines for projection into coming months. o What can you observe in the data and what are reasonable predictions based on your analysis? o Suggestion: a pivot table can save much work in generating such an analysis.