Instructions 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) 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 calculations, 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 Here is the data you need to use Excel Analysis Data xlsx Required Documents Resources Video walk through Excel Analysis Guide Part 1 Excel Analysis Guide Part 2 Excel Analysis Guide Part 3 Your Deliverable ( 2 files, include your name in the filename ) Write up your findings in a Word Document (no more than 800 words) in the Executive Summary format, answering ALL of your boss questions It should contain An introduction with background on the questions asked and eventual purpose of the task A methodology section discussing the steps you undertook A results section with your report your findings Support your analysis with PivotTables, Charts, PivotCharts as evidence to support your conclusions A conclusion section summarizing key findings and recommended steps based on that Also submit your Excel workbook that shows your calculations, charts, figures, tables, etc At this point, you should be very comfortable with some of the analytical tools within Excel, and this is an opportunity to show that Be sure to follow the guidelines set in the BA 325 Information Literacy Expectations and the BA 325 Information Literacy Assessment Rubric (You may use any font size style paragraph spacing line spacing that you are comfortable with)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 07, 2024

Instructions: Erica Wagner, your boss, sends you this Excel file and gives you the following information. She says she wants your analysis when she returns

Instructions:

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)
- 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 calculations, 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!

Here is the data you need to use: Excel Analysis Data.xlsx

Required Documents/Resources:

Video walk through:

Excel Analysis Guide - Part 1
Excel Analysis Guide - Part 2
Excel Analysis Guide - Part 3

Your Deliverable (2 files, include your name in the filename):

Write up your findings in a Word Document (no more than 800 words) in the Executive Summary format, answering ALL of your boss questions. It should contain:
- An introduction with background on the questions asked and eventual purpose of the task
- A methodology section discussing the steps you undertook
- A results section with your report your findings. Support your analysis with PivotTables, Charts, PivotCharts as evidence to support your conclusions.
- A conclusion section summarizing key findings and recommended steps based on that.
Also submit your Excel workbook that shows your calculations, charts, figures, tables, etc.

At this point, you should be very comfortable with some of the analytical tools within Excel, and this is an opportunity to show that. Be sure to follow the guidelines set in the BA 325 Information Literacy Expectations and the BA 325 Information Literacy Assessment Rubric (You may use any font size/style/paragraph spacing/line spacing that you are comfortable with).