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 data in the form of an excel workbook, but i dont know how to insert that