Create graphs:

Award ID

Grant Type

PI Last Name

PI First Name

Original Award Amount

Payment Amount

Date Paid

Title

Awardee

Payee Country

Start Date

End Date

1. Create a a graph showing a comparison of all awardees using the above data and their total amount of funding across all grant types.

2. Create a graph showing the amount of funding paid (separated by month) in 2015.

3. Create a graph comparing funding in the United States versus international funding.

Award ID Grant Type PI Last Name PI First Name Original Award Amount Payment Amount Date Paid Title Awardee Payee Country Start Date End Date 1 Conference Grant Smith John $ S 20,000.00 $ 20,000.00 10/30/2015 Harvard University United States 10/1/2015 9/30/2016 2 Conference Grant Smith John S 15,000.00 $ 15,000.00 8/31/2015 Astronomy Conference Biology Conference Neuroscience Workshop Yale University United States 8/1/2015 7/31/2016 3 Conference Grant Smith John S 50,000.00 S 50,000.00 7/31/2015 7/1/2015 6/30/2015 4 Research Grant Miller Jane $ 250,000.00 $ 75,000.00 12/31/2015 Jane's SIFT Grant 10/1/2015 9/30/2018 4 Research Grant Miller Jane $ 250,000.00 $ 75,000.00 12/31/2016 Jane's SIFT Grant 10/1/2015 9/30/2018 4 Research Grant Miller Jane $ 250,000.00 $ 75,000.00 12/31/2017 Jane's SIFT Grant 10/1/2015 9/30/2018 5 Research Grant Halman Andrew $ 250,000.00 $ 75,000.00 12/31/2015 Andrew's SIFT Grant 10/1/2015 9/30/2018 Princeton United States University Columbia United States University Columbia United States University Columbia United States University King's College United Kingdom London King's College United Kingdom London King's College United Kingdom London The Scripps United States Research Institute The Scripps United States Research Institute The Scripps United States Research Institute 5 5 Research Grant Halman Andrew $ 250,000.00 $ 75,000.00 12/31/2016 Andrew's SIFT Grant 10/1/2015 9/30/2018 5 5 Research Grant Halman Andrew $ 250,000.00 $ 75,000.00 12/31/2017 Andrew's SIFT Grant 10/1/2015 9/30/2018 6 Equipment Grant Sam Eric S 40,000.00 $ 40,000.00 9/30/2015 Microscope 9/1/2015 8/31/2016 7 Travel Grant Sam Eric $ S 8,000.00 $ $ 8,000.00 8/31/2015 Collaboration with Co- 8/1/2015 7/31/2015 8 Clinical Grant Sam Eric $ 100,000.00 $ 100,000.00 3/30/2016 Eric's CTA Grant 10/1/2015 9/30/2016 9 9 Clinical Grant Anderson Rick $ 600,000.00 $ 200,000.00 6/30/2015 Rick's CTA Grant United States 4/1/2015 3/31/2017 9 Clinical Grant Anderson Rick $ 600,000.00 $ 200,000.00 6/30/2016 Rick's CTA Grant Northwestern University Northwestern University Northwestern University United States 4/1/2015 3/31/2017 9 Clinical Grant Anderson Rick $ 600,000.00 $ 200,000.00 6/30/2017 Ricks CTA Grant United States 4/1/2015 3/31/2017