The data that we are using in this was collected from various statistics classes here at Durham College. The participants were asked to take part in a brief experiment playing the memory game found at https://www.memozor.com/simon-games/simon-game. The game has four coloured buttons that each produce a unique sound when pressed. The game reveals a sequence of the buttons lighting up/making their sound and then asks the played to repeat the sequence. Every time the player does so successfully the sequence is increased by one.

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]Part 2 - Mature Students (27 MARKS) For the sake of this project, a mature student will be considered any student that is 25 years old or older. 1. Use Excel to complete the following table (round your answers to 2 decimal places). [31 Expel Function All Students Mature Students Sample Slee COUNT #:#| Mcan =AVERAGE# # Standard Deviation -STOEV.5 8. . For this question only, use the sample mean and sample standard deviation found in Question 1 as the population mean and population standard deviation for all students and mature students. a. What is the probability that a sample of $ random students has a mean score greater than 10 on the memory game?' [21 b. What is the probability that a sample of 5 mature students has a mean score greater than 10 on the memory game?' [2] 3. Find a 98% confidence interval for the mean score for the population of All Students and Mature Students by answering the following questions. a. Find the to for a 98% confidence level for all students and mature students. [21 b. Find the value of E for all students and mature students. [21 C. List the 98% confidence for the mean score for the population of All Students and Mature Students. [214. It is known that the mean score for college students on this particular memory exercise is 9.34. Conduct a single sample t-Test to determine if the mean score obtained by mature students is greater than the mean score obtained by students in general. Use a 0.01 p-level. Recall that the sample mean and standard deviation for mature students was found in Question 1. [13] Step 1: Population 1: Population 2: Step 2: Let An = Let #3 = Step 3: M = Step 4: Step 5: Step 6: 5. Calculate the effect size (Cohen's d) for the single sample t-test conducted above. [1]Bart 3 -Sound ON/OFF (27 MARKS) 1. Use Excel to complete the following table (round your answers to 2 decimal places]. [3] Excel Function Sound ON Sound OFF Sample Size COUNT :# Mcan AVERAGE|: # Variance =VAR.SIA #I 2. Carry out a two-tailed independent samples t-test, at a p level of 0.05 to determine whether there is a difference between the mean score obtained by students playing the game with sound ON and sound OFF. All calculations may be done in Excel with only the final answers required here. [21] Step 1: Population 1(X): Population 2 (Y): Step 2: Ho: Step 3: HY - Ax = MI = MY = S= df. = df = dfratel = Spooled= Saifferenen=Step 4: d fratal = Step 5: Step 6 3. Determine a 95% confidence interval around the true population difference between means (by - My) of score obtained with and without sound. [3]