Instruction
Easy assignment in Excel. I cannot get Excel on my computer.
Please email me and I will send you the data file, only a few adjustments need to be made to it.
# Insert two columns to the left of the existing data that have the informant number and the record number. There are 52 informants and 33 records per informant.
# The first 22 records for each informant contain the informants' identifications of the emotion expressed in each of the 22 pictures. The rest of the records for each informant contain demographic information that should be saved in a separate worksheet named `demo`. At the end, you should have 22 records with the responses to the pictures for each of the 52 informants (= 1144) in the `polish` worksheet.
# Copy column C into column D so that you keep a copy of the original records before you do anything to them. Use the commas in column D as deliminators to move multiple responses in each record into separate columns.
# Copy and move the responses in columns E and beyond so that, in the end, all responses are in column D each on its own row.
# At this stage, column A is the informant number, column B is the record number, column C is the original record, and column D contains each response. By now you should have 1456 rows in the worksheet, after you have deleted all the blank rows.
# Remove leading and trailing spaces for each response in column D and convert them to lowercase. At the end, the trimmed and lowercase responses should be in column D.
# Code and count the terms for each picture and record most frequently used term for each. If there is a tie, record both.
# In a separate worksheet called `answers`, list the twenty two pictures with the most frequently used term in Polish on one column and, using Google Translate, the English translation of the Polish terms in a second column. Previously, I had asked you to find the most common English term used to describe these photos, but that is no longer necessary.