Buy Existing Paper - Erica Wagner, your boss, sends you this Excel file and gives you the following information

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

Category:

Description

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

This is an independent assignment meaning that you may not collaborate with a friend.  If you talk together about the assignment and brainstorm ideas, you must be sure that what you turn in is yours and yours alone.  You must cite ideas that come from others – even if you are not quoting them.  Do not present an idea as your own, if it is not.  When you upload your assignment to D2L dropbox you are stating that the work is your own.

 

After you download the Excel data file associated with this assignment, please look through the data, and then respond to the following questions that are used to assess your information literacy skills. This assignment asks you to think about when analysis tools like charts, sorts, Pivot Tables are useful for business decisions.

 

 

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 dataset. 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)
    • By concentration and BA core
    • Fill rate and total enrollment
  • What term/meeting day is the most popular and which is the least?
    • Fill rate and total enrollment
  • What is the ratio of ground campus classes versus online courses?
    • 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!”

 

Your deliverable:  Word Document with Executive Summary (no more than 800 words) and Screen Prints of the Excel evidence you produced (75 pts).  Also submit your Excel workbook that shows your calculations (25 pts).Erica Wagner, your boss, sends you this Excel file and gives you the following information