Erica Wagner, your boss, sends you this Excel file and gives you the following information. She

says she wants your analysis when she returns from a conference next week.

$$Once you organize this data set. I need you to analyze the $18-19$ academic year $($summer$,$ fall,

winter, spring$)$ enrollment by course and term. I am giving a presentation to the new Provost in

an attempt to convince her to invest more money in the undergraduate business program because

we are growing both online and on campus. I think the following stats will be convincing:

$$ Popularity of our undergraduate classes $($numbers $100-499,$ please exclude $400-410$

course numbers$)$

o By concentration and BA core

o Fill rate and total enrollment

$$ What term$/$meeting day is the most popular and which is the least?

o Fill rate and total enrollment

$$ What is the ratio of ground campus classes versus online courses?

o By concentration and BA core

While you are running these calculates, see what else you can interpret from the data that should

also be included in my talk.

Please get this to me by end of next week. Thanks!$$