Practice Problems: Student data
Use the Student.xls file for the following problems:
- PRACTICE PROBLEM 1: Create a pivot table of Gender and Major. Then using the JOINT_PROBABILITY.xls file, complete the Joint Probability table so you can answer the following:
a) What is the probability of randomly choosing a Female?
b) What is the probability of randomly choosing a Male AND Finance major?
c) What is the probability of randomly choosing a Female OR Leadership major?
d) Given that the home you selected is a Male, what is the probability he has no major?
e) Given that the home you selected has no major, what is the probability the student is male?
- PRACTICE PROBLEM 2: Let's assume that the Student_Data.xls file was the entire population. We know the mean and standard deviation of student ages to be 42.3 and 8.9, respectively. Using the NORMAL_PROBABILITY.xls file, compute the percentage of students that are older than 50, younger than 40, between 41 and 46, and oldest 10% are at what age? Then compare to the truth as found in the actual file. Solutions are provided to practice problems so you can check your work.
Attachment:- Student Data.xls