Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

I need help with the value chain analysis. Can you help?

Answered: 1 week ago

Question

What is the cerebrum?

Answered: 1 week ago