The city of Chapel Hill, North Carolina is concerned about their financial condition. They have hired you to assess their current condition and provide any feedback that you can. They have provided you with a dataset of financial data from the past few years, but the dataset has not been well-maintained, and is sort of a mess. ChapelHillData.xlsx Download ChapelHillData.xlsx Work with this dataset to isolate some factors of interest: Fixed Cost as a Percentage of Total Expenditures (as defined in lecture) Operating Deficits Intergovernmental Revenues as a Percentage of Gross Revenues Calculate these values for all available years of data. For each measure, present the calculated values and discuss any trends that you see in the data over time. Are these values and trends indicators of improving or worsening fiscal condition? Do you have any recommendations for the city?
