Cross Curricular Capstone Assignment Due Date: Friday, August 7 @11:59pm via DC Connect Assignment Drop box The scenario: A researcher studying the effect of marijuana on memory decided to have a...

create a frequency distribution table


Cross Curricular Capstone Assignment Due Date: Friday, August 7 @11:59pm via DC Connect Assignment Drop box The scenario: A researcher studying the effect of marijuana on memory decided to have a group of subject participates memorize a series of numbers in the exact order they appeared in a list. The number of recall errors were recorded and the total number of errors were tabulated for each subject. In one condition, the active ingredient of the drug (THC) was removed. In the second condition, the active ingredient of the drug (THC) was included. Complete all of the questions below using the provided excel file. Within the excel file there is a worksheet set up for each question for this cross curricular capstone assignment. Carry out the assigned calculations and fill in your answers in the text boxes provided in the excel file. Submit your completed excel file to the designated assignment drop box (Cross Curricular Capstone Assignment). Please answer the following questions in excel: Question 1) Create a frequency distribution using excel for each of the conditions. (10 marks) Question2) Determine two measures of central tendency (Mean, Median) for both conditions. (10 marks) 2a) For each condition, to what extent did these two measures of central tendency differ? 2b) For these sets of data, is the mean providing us with an accurate measure of central tendency? Question 3) Determine the five number summary and construct a box plot for each condition. (20 marks) Question 4) Calculate the Range, Variance and Standard Deviation for both conditions. (10 marks) Conclusion from the study: Question 5) Based on the data analysis you performed, what conclusions would you draw regarding the effect that THC has on recall errors? Make sure you back up your conclusions by at least drawing on the results of the analyses conducted in this assignment. (5 marks)