Part 1- Male/Female Scores (27 MARKS) 1. Use Excel to complete the following table (round your answers to 2 decimal places). [5] Excel Function Female Students Male Students Sample Size COUNT #:#) Mode -MODE: #I Median =MEDIAN #:# Mcan -AVERAGE A # Standard Deviation -STOEV.5(# # Complete the frequency distribution table, and create a frequency histogram for Female Students and Male Students. The Class Limits have been completed for you. [7] Female Male Class Limits Class Boundaries Frequency | Frequency 2 to 3 4 to 5 6 to 7 8 to 9 10 to 11 12 to 1 14 to 15 16 to 17 18 to 19 20 to 21 22 to 23 24 to 25 Female Scores Frequency Histogram Male Scores Frequency Histogram3. Which gender of the two had the largest measures of central tendency (mean, median, and mode)? [1] 4. Consider the sample size from both male and female students. Is It appropriate to say that your answers from the last question are accurate? Why or Why not?' If not, what would need to be done to get data that is more accurate? [2] 5. What is the distribution shape (normal, bimodal, skewed left, skewed right, uniform] of both distributions? What is one similarity and one difference between the graphs?' What could these graphs suggest about short term memory of both males and females? [4] 6. Find a 98% confidence interval for the mean score for the population of Female and Male Students by answering the following questions. a. Find the t, for a 98% confidence level for females and males. [2] b. Find the value of E for both females and males. [21 c. List the 98% confidence for the mean score for the population of Females and Males. [2] d. Is there overlap between the two intervals? If we were to do a confidence interval for the mean score of all students, where would you expect it to be: closer to the female interval, closer to the male interval, between the two, between the two but closer to one? Why?' [2]Calibri 11 BI U USA . fx A B C D E F G H I J K L M N O P Q R S T U V Female Scores | Male Scores IN 2 7 W W N Female Male 8 Sample Size Mode Median Mean 6 0 00 Standard Deviation 16 13 13 13 14 14 17 17 17 24 18Q Calibri 11 BIUSA 5 fx A B C D E F G H I J K L M N O P Q R S T U V 73 12 74 12 75 12 76 12 77 12 78 13 79 13 80 13 81 13 82 13 83 13 84 14 85 14 86 16 87 19 88 20 89 24 90 91 92 93 94 95