For Electronic Dataset 1, you have an Excel dataset from a memory experiment. In this experiment, participants were first put in a positive mood by watching cat videos on YouTube (https://www.youtube.com/watch?v=6-SfjPGTu8s) and then given a list of 30 words to remember. Their memory was tested after 5 minutes, and participants were asked to write down as many words as they could remember. For each participant, you can see the number of words correctly remembered in the third column.
For this data set, you should complete the following and submit the assignment via Canvas: Part A (IN SPSS)
1. Import the Excel file into SPSS (File > Import Data > Excel)
2. Using the appropriate function(s), have SPSS create or calculate:
a. A frequency table of the data
b. Measures of Central Tendency (Mean, Median, Mode)
c. Measures of Variability (Range, Variance, Standard Deviation)
d. A histogram with a curve drawn over it.
3. Export the output window to an Excel file with your last name, the program, and the assignment as the name of the file (with the Output window selected, File > Export > Change Document Type to Excel 2007 and Higher > change File Name (in the appropriate folder, e.g., Desktop/EidsonSPSSElectronicDataset1).
4. Open the exported Excel file of SPSS output.
5. Highlight in yellow each of the above items in the excel file (MCT, Variability, etc.).
6. In a blank cell, note any trends that you can see based on either or all of the frequency table, measures of central tendency, measures of variability, and the histogram below the output and, again, highlight your observations in yellow.
Part B (IN EXCEL)
1. Open the original data file in Excel.
2. First, sort the data from lowest values to highest values of words remembered.
3. Use formulas to calculate the mean, median, mode, standard deviation, and variance in cells next to the data.
4. Next to the cells you have used to calculate each of these, list the formula you have used (in order to do this without Excel doing a calculation again, you can either format the cell as text – Format > Cells > Choose Category of Text – or place some punctuation before the equal sign in the formula such as .=mean(a1:a15)).
5. Create a grouped frequency distribution using approximately 5 classes (Note: you should use formulas to help you construct the distribution rather than counting up frequencies).
6. Highlight your calculated cells, listed formulas, and grouped frequency distribution in yellow.
7. Create a histogram based on your frequency distribution (remember: you will have to swap the way your table is constructed in order to make your X-axis appropriate).
8. In a blank cell, note any differences that you see between your Excel frequency table and histogram and the SPSS frequency table and histogram.
9. Save your Excel file similar to your SPSS outp