Let's examine the history of LSUS undergraduate enrollment vs. its tuition and fees. Download the "A3Q1 LSUS enrollment data" Excel file; in it you will see historical information on LSUS undergraduate enrollment, total credit hour production, and (12-hour, undergraduate) tuition and fees. (If you wish, you can verify or look up additional information hereandhere.)

Calculate annual elasticities for both types of quantity variables (i.e., you will have an elasticity of price vs. headcount, and one of price vs. credit hour). You will get an error message in your calculations when the tuition doesn't change (like in 1990-1991), since the elasticity calculation will be trying to divide by zero; just delete those error values in your Excel table so that the cells are blank. The first headcount elasticity will be calculated based on the 1987 and 1988 values of tuition and headcount and should be about 0.191; the first credit hour elasticity will also be based on the 1987 and 1988 values and should be about 0.394 (yes; they are both positive). Calculate the average annual elasticity for headcount (from 1987-2021), and the average annual elasticity for credit hour (from 1987-2021).

Many administrators argue that, to increase revenue to LSUS to cover budget shortfalls, tuition should be raised. Comment on this suggestion, using the evidence you've uncovered.

Year	undergrad enrollment	total LSUS credit hour production	undergrad tuition and fees
1987	3,923	100562	600
1988	3,995	104409	660
1989	3,594	94450	730
1990	3,540	90404	740
1991	3,756	98635	740
1992	4,017	102826	740
1993	3,890	96864	965
1994	3,656	91152	965
1995	3,631	90216	965
1996	3,354	86790	965
1997	3,516	91578	1025
1998	3,678	94979	1025
1999	3,553	94396	1025
2000	3,422	90624	1025
2001	3,419	94446	1150
2002	3,543	96039	1184
2003	3,655	101352	1442
2004	3,910	101868	1545
2005	3,940	100181	1621
2006	3,594	92486	1667
2007	3,556	92123	1667
2008	3,903	94639	1751
2009	4,220	101972	1867
2010	4,058	98137	2062
2011	4,134	98372	2247
2012	4,124	93163	2472
2013	3,674	85292	2803
2014	3,202	87907	3084
2015	2,775	91021	3355
2016	2,587	94077	3417
2017	2,638	115340	3417
2018	2,511	137467	3663
2019	2,577	165057	3663
2020	2,553	191712	3663
2021	2,477	173910	3663