A3Q1 data - FA22 AP2_MBA 701_Mod 3_MW.xlsx - Year undergrad...

Year undergrad enro total LSUS credundergrad tuitElastcity HC Elastcity CH
2003 3,655 101352 1442
0.97752809 0.07363448479
-6.8341033
2004 3,910 101868 1545 0.159202145 -0.3478209168 -0.4881502
2005 3,940 100181 1621
-3.28264909 -2.8547972273
2006 3,594 92486 1667
2007 3,556 92123 1667 1.892960885 0.54816953179
2008 3,903 94639 1751 1.217176005 1.16328049488
2009 4,220 101972 1867
-0.39430929 -0.3861412197
2010 4,058 98137 2062 0.216086888 0.02785416747
2011 4,134 98372 2247
-0.02539759 -0.5703923217
2012 4,124 93163 2472 -0.91965249 -0.702903429
2013 3,674 85292 2803
-1.43811576 0.31631080608
2014 3,202 87907 3084
-1.69743735 0.41351325467
2015 2,775 91021 3355
-3.82962544 1.80333695943
2016 2,587 94077 3417
2017 2,638 115340 3417
-0.70987026 2.51901985965
2018 2,511 137467 3663
2019 2,577 165057 3663
2020 2,553 191712 3663
2021 2,477 173910 3663
1
1
Average -0.48815023 0.21450460316
inelastc inelastc

P Q TR MR %CQ %CP
$156.00 9344
$1,457,664.00 N/A N/A N/A
$151.32 10040
$1,519,252.80 ($53.41) 7.18% 3.05%
$146.64 10544
$1,546,172.16 ($43.86) 4.90% 3.14%
$141.96 11047
$1,568,232.12 ($18.70) 4.66% 3.24%
$137.28 11483
$1,576,386.24 $177.38 3.87% 3.35%
$134.16 11598
$1,555,987.68 $650.27 1.00% 2.30%
$127.92 11691
$1,495,512.72 $759.24 0.80% 4.76%
$123.24 11753
$1,448,439.72 ($123.24) 0.53% 3.73%
SUMMARY OUTPUT
Regression Statistics
Multple R 0.94223043113
R Square 0.88779818534
Adjusted R 0.8690978829
Standard E 4.10276273956
Observato 8
ANOVA
df SS MS F Significance F
Regression 1 799.1318274174 799.131827417403 47.47507095 0.000461347338
Residual 6 100.9959725826 16.8326620970995
Total 7 900.1278
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 271.91651041 19.22712796331 14.1423363348409 7.8067E-06 224.8694231332
Q -0.0120778524 0.001752899051 -6.89021559566652 0.000461347 -0.01636704184
Demand Funton: P = 271.91651 - 0.0120779Q
SUMMARY OUTPUT
Regression Statistics
Multple R 0.94223043113
R Square 0.88779818534
Adjusted R 0.8690978829
Standard E 320.069146664
Observato 8
ANOVA
df SS MS F Significance F
Regression 1 4863548.448124 4863548.44812437 47.47507095 0.000461347338
Residual 6 614665.5518756 102444.258645939

Total 7 5478214
Coefficients Standard Error t Stat P-value Lower 95%
Intercept 21214.7826969 1495.862817786 14.1823049845319 7.67893E-06 17554.53824033
P -73.506295439 10.66821413914 -6.89021559566652 0.000461347 -99.610475047
SUMMARY OUTPUT
Regression Statistics
Multple R 0.93262472821
R Square 0.86978888366
Adjusted R 0.84374666039
Standard E 3.95536418141
Observato 7
ANOVA
df SS MS F Significance F
Regression 1 522.5270138193