Homework
• Create a pivot table of Gender and Major. Then complete the Joint Probability table so you can answer the following:
o What is the probability of randomly choosing a Female?
o What is the probability of randomly choosing a Male AND Finance major?
o What is the probability of randomly choosing a Female OR Leadership major?
o Given that the student you selected is a Male, what is the probability he has no major?
o Given that the student you selected has no major, what is the probability the student is male?
• 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.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Student-Data.rar