It is now time to take your work from Data Analysis 2 and turn it into some graphs. More specifically, you are to generate the graphs for the following questions. Be sure to put the graph on its own sheet and get rid of the headings, footings, and other 'stuff' that would not be part of a professional portfolio of your material. Stated somewhat differently, I am looking for some spiffy, ready for prime time graphs. To make your life a bit easier the data set is available for you to download [Finance data set]. For some tips on downloading the data sets you might want to review the download guide.
1. What has happened to the share of unrestricted revenues generated by state appropriations? by tuition?
2. What has happened to the share of total revenues generated by unrestricted revenues?
3. What has happened to 'real' sponsored research revenue?
4. What has happened to the inflation rate over this period? In which year was it largest?
5. What has happened to the share of total revenues generated by auxiliary revenues?
6. What would nominal auxiliary revenues be in 1996 if real revenues had not changed from their 1980 level?
|
YEARS |
UNRESTRICTED |
RIU |
RIU |
AUXILIARY |
SPONSORED |
CPI |
|
|
REVENUE |
STATE |
TUITION AND |
REVENUE |
RESEARCH |
|
|
|
|
APPRO. |
FEES |
|
|
|
|
1980 |
$61,819 |
$39,509 |
$16,067 |
$11,321 |
$18,010 |
82.4 |
|
1981 |
$67,014 |
$42,058 |
$17,769 |
$14,745 |
$19,171 |
90.9 |
|
1982 |
$72,645 |
$44,317 |
$20,645 |
$15,936 |
$19,465 |
96.5 |
|
1983 |
$77,932 |
$47,662 |
$22,213 |
$16,659 |
$22,309 |
99.6 |
|
1984 |
$82,047 |
$49,612 |
$24,601 |
$19,172 |
$23,547 |
103.9 |
|
1985 |
$88,427 |
$53,842 |
$26,011 |
$20,394 |
$24,190 |
107.6 |
|
1986 |
$94,686 |
$57,379 |
$28,218 |
$21,739 |
$24,867 |
109.6 |
|
1987 |
$102,356 |
$60,869 |
$31,494 |
$22,868 |
$25,381 |
113.6 |
|
1988 |
$111,704 |
$64,537 |
$36,342 |
$24,509 |
$27,799 |
118.3 |
|
1989 |
$119,678 |
$68,671 |
$40,448 |
$26,828 |
$28,775 |
124.0 |
|
1990 |
$124,875 |
$69,331 |
$44,118 |
$28,466 |
$29,629 |
130.7 |
|
1991 |
$124,978 |
$62,561 |
$51,218 |
$31,129 |
$34,609 |
136.2 |
|
1992 |
$131,248 |
$56,629 |
$60,256 |
$30,513 |
$35,064 |
140.3 |
|
1993 |
$137,851 |
$57,123 |
$67,737 |
$30,346 |
$36,702 |
144.5 |
|
1994 |
$141,277 |
$59,452 |
$69,470 |
$32,459 |
$37,476 |
148.2 |
|
1995 |
$148,603 |
$62,915 |
$72,674 |
$35,166 |
$37,446 |
152.4 |
|
1996 |
$150,159 |
$63,789 |
$73,342 |
$34,443 |
$39,575 |
158.6 |
Unrestricted revenue includes State appropriations and Tuition and fees
Total RIU revenue includes auxiliary revenue, sponsored research, and unrestricted revenues