Readings:

1. Read Chapters 1 and 2 in Holmes, L., Illowsky, B., & Dean, S. (2017). Introductory Business Statistics (1st ed.). Openstax. Available at https://open.umn.edu/opentextbooks/textbooks/509

Videos:

1. Descriptive Statistics in Excel Using the Data Analysis Tool from Learn Something (2017)

Discussions: Discussion: Excel, Statistics and Chart Help

Assignments: Assignment 2 Course Schedule Problem

For this assignment, please use the file Course Schedule Problem.xlsx

Please answer the following questions in a Word document.

1. Which variables are numerical? (5 pts)
2. Which variables are categorical? (5 pts)
3. Which variables are qualitative? (5 pts)
4. Which variables are quantitative? (5 pts)
5. Of the quantitative variables, which are discrete and which are continuous? (5 pts)
6. What is the average enrollment by each course category (MIS100,MIS200,MIS300 and MIS400)? (5 pts)
7. What is the average enrollment by each course category for online courses and non-online course? (5 pts)
8. What is the average number of Pell Eligible students for each course category? (5 pts)
9. What is the average number of females enrolled in each course category?(5 pts)
10. What is the average percentage of students who earn a DFW or I for each course category?(5 pts)
11. Using Excel (Data->Data Analysis->Descriptive Statistics), calculate the descriptive statistics for all continuous variables. (25 pts) (NOTE: I deduct 5 pts for each non continuous variable so even if you get all of the continuous variables but try to get all points by including as many variables as possible, you can still earn 0 points for this question.)