1. Let's examine the history of LSUS undergraduate enrollment vs. its tuition and fees. Download the \"A301 LSUS enrollment date" 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 heiand m.) 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 doesnt change (like in 2006-2007), 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 2001 and 2002 values of tuition and headcount and should be about 1.223; the first credit hour elasticity will also be based on the 2001 and 2002 values and should be about 0.574 (yes: they are both positive). Calculate the average annual elasticity for headcount {from 2001-2020). and the average annual elasticity for credit hour (from 2001- 2020). 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. A301 d at a A s c 0 1 Year undergrad enrollment total LSUS credit hour production undergrad tuition and fees 2 2001 3419 94446 1 1 50 3 2002 3543 96039 1134 4 2003 3655 101352 1442 5 2004 3910 101363 1 545 6 2005 3.940 100.131 $1,621 7 2005 3.594 92.436 31.667 3 2007 3.556 92.123 31.667 9 2003 3,903 94,639 $1,751 10 2009 4.220 101,972 $1.367 11 2010 4,053 93,137 $2,052 12 2011 4.134 93.372 32.247 13 2012 4.124 93.1 63 $2.472 14 2013 3,674 35,292 $2,303 1 5 2014 3.202 37.907 $3.034 16 2015 2775 91021 $3,355 17 2015 2537 94077 $3,417 13 2017 2637 1 1 5340 $3.417 19 2013 251 1 137467 $3,663 20 2019 2577 165057 $3.663 21 2020 2553 191712 33.663 22 23 24 25 26 27 23 29 30 31 331 l1 *- 34 35 36 37 please do it correctly will upvote please