Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how should I organize this correctly? please help me solve After you download the Excel data file associated with this assignment, please look through the

how should I organize this correctly? please help me solve 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 what analysis tools like Charts, Filter/Sorts, or PivotTables 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 calculations see what else you can interpret from the data that should also be included in my talk

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions