Your goal with this project is to analyze and explain trends in college funding over a selected 15-year period. At a minimum, you should:

1) Perform a merge of the College ID and Revenue Source & Enrollments data.

2) Create three calculated columns that set forth the following:

a. Relationship between Tuition and State Appropriations

b. Relationship between Tuition and Enrollment

c. Relationship between State Appropriations and Enrollment

3) Create at least 4 pivot tables that analyze the data. Include a text box within the worksheet that sets forth your explanation of each table.

4) Create at least 3 charts that visualize the data. Include a text box within the worksheet that sets forth your explanation of each chart.

5) Include a text box within your worksheet that summarizes your overall analysis of the data (e.g., trends, observations, inferences, etc.).

You are expected to format your data tables and charts in a manner that best conveys the story (e.g., labels, rounding, number formatting, etc.).

*there is additional information in the form of an excel workbook, but how do i attach it?