Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Plot 2 graphs show revenue and expenses as absolute and relative values in R (show the code) using these csv files. Also, plot two different
Plot 2 graphs show revenue and expenses as absolute and relative values in R (show the code) using these csv files. Also, plot two different graphs that show things have not changed over those 5 years shown in the data. So 4 graphs in total, please show the code and the graphs. Using RStudio.
B C D E F Year Private 6 1 2 3 4 5 Grants 2014 2013 2012 2011 2010 Tuition Ancillary 67.6 53.6 22.7 67 50.9 22.2 66.7 47.5 22.7 65.4 44.5 22.2 63.2 41.6 20.4 Other 4.1 4.1 2.9 4.2 3.3 4.4 4.4 3.9 5.1 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Revenue Absolute(1) + + A B C D E F Year Private 1 2 3 4 5 Grants Tuition Ancillary 2014 43.9 34.8 14.7 2013 45 34.3 14.9 2012 46.3 32.9 15.7 2011 46.7 31.7 15.8 2010 47.3 31.1 15.3 Other 2.7 2.8 2 3.9 3 3.1 2.8 3.8 3 2.5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 RevenuePercent(1) + E F G H I AE 0 000 u w NP Supplies Interest 3.9 22.5 3.3 23.1 3.5 21.8 2.8 23.6 2.4 22.6 im in i io ni nini Amortizatior FVA 2.7 8.9 2.8 9 2.6 9.9 1.6 1.3 8.6 -0.8 0.1 1.4 0.5 -0.1 4.9 0.1 -1.5 0 -1.7 9.3 1 A B D 2 1 Year Isalaries 3 Scholarships Utilities 2 2014 99.3 4 9.9 3 2013 99.8 5 9.3 4 2012 97.8 6 9.4 5 2011 92.7 7 8.9 6 2010 91.3 8.8 8 7 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 ExpenseAbsolute(1) E F G H I Interest AE 2.6 Supplies 14.9 15.7 -0.5 0.1 3.2 0.1 2.2 A B D 1 Year Salaries Scholarships Utilities 2 2014 65.6 6.5 3 2013 67.6 6.3 4 2012 67.5 6.5 5 2011 66.5 6.4 6 2010 68.5 6.6 7 Amortizatior FVA 1.8 5.9 1.9 6.1 1.8 6.8 1.1 6.7 1 6.5 2.4 15 2 16.9 1 0.4 -0.1 -1 0 -1.3 1.8 17 8 9 LO 1 2 L3 -4 -5 6 _7 -8 _9 20 21 22 23 24 25 UW No to Voir w Ni-O ExpensePercent(1) + + B C D E F Year Private 6 1 2 3 4 5 Grants 2014 2013 2012 2011 2010 Tuition Ancillary 67.6 53.6 22.7 67 50.9 22.2 66.7 47.5 22.7 65.4 44.5 22.2 63.2 41.6 20.4 Other 4.1 4.1 2.9 4.2 3.3 4.4 4.4 3.9 5.1 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Revenue Absolute(1) + + A B C D E F Year Private 1 2 3 4 5 Grants Tuition Ancillary 2014 43.9 34.8 14.7 2013 45 34.3 14.9 2012 46.3 32.9 15.7 2011 46.7 31.7 15.8 2010 47.3 31.1 15.3 Other 2.7 2.8 2 3.9 3 3.1 2.8 3.8 3 2.5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 RevenuePercent(1) + E F G H I AE 0 000 u w NP Supplies Interest 3.9 22.5 3.3 23.1 3.5 21.8 2.8 23.6 2.4 22.6 im in i io ni nini Amortizatior FVA 2.7 8.9 2.8 9 2.6 9.9 1.6 1.3 8.6 -0.8 0.1 1.4 0.5 -0.1 4.9 0.1 -1.5 0 -1.7 9.3 1 A B D 2 1 Year Isalaries 3 Scholarships Utilities 2 2014 99.3 4 9.9 3 2013 99.8 5 9.3 4 2012 97.8 6 9.4 5 2011 92.7 7 8.9 6 2010 91.3 8.8 8 7 9 8 10 9 11 10 12 11 13 12 14 13 15 14 16 15 17 16 18 17 19 18 20 19 21 20 22 21 23 22 24 23 25 24 26 25 27 26 28 27 ExpenseAbsolute(1) E F G H I Interest AE 2.6 Supplies 14.9 15.7 -0.5 0.1 3.2 0.1 2.2 A B D 1 Year Salaries Scholarships Utilities 2 2014 65.6 6.5 3 2013 67.6 6.3 4 2012 67.5 6.5 5 2011 66.5 6.4 6 2010 68.5 6.6 7 Amortizatior FVA 1.8 5.9 1.9 6.1 1.8 6.8 1.1 6.7 1 6.5 2.4 15 2 16.9 1 0.4 -0.1 -1 0 -1.3 1.8 17 8 9 LO 1 2 L3 -4 -5 6 _7 -8 _9 20 21 22 23 24 25 UW No to Voir w Ni-O ExpensePercent(1) + +
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started