Loading
Home › Anthropology Help › Easy assignment in Excel. I can
Status: Completed

Easy assignment in Excel. I can

Date Posted: 09/03/2011
Category: Anthropology
Due Date: 11/03/2011
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.
Attached
No File uploaded yet.
Bidders
Homework_Nerd 15 years ago
Rated 9.64 earned 198461.97 around 1228 assignments.
Hey hudson. I'm interested in the hw, could you please attach it here so i can get a better idea of what it is?
$35.00
  • Sure, what is your email adress? i can give you the link to the homework site, where all the directions are.
    User_277 | Oct 03, 2011, 09:42 AM
  • homeworklinguist@gmail.com
    Homework_Nerd | Oct 03, 2011, 09:52 AM
  • Hey there. I'm looking at the assignment, but i'm missing something... a dataset or something or i can't do it
    Homework_Nerd | Oct 03, 2011, 10:09 AM
  • http://cognition.clas.uconn.edu/~jboster/courses/anth3004_s11/midterm/index.htm click on the xls file. this should be it, if not, let me know
    User_277 | Oct 03, 2011, 10:15 AM
  • http://cognition.clas.uconn.edu/~jboster/courses/anth3004_s11/index.htm everything is on this link.
    User_277 | Oct 03, 2011, 10:18 AM
  • ok, you're right. I didn't know there were multiple sheets. I'll be able to do this fine, please assign it and i can get on it. Thanks
    Homework_Nerd | Oct 03, 2011, 10:36 AM
  • Yellow?
    Homework_Nerd | Oct 03, 2011, 10:55 AM
  • i will do it.
    User_277 | Oct 03, 2011, 11:02 AM
  • i will do it.
    User_277 | Oct 03, 2011, 11:02 AM
  • Is my bid too high? I'll do it for 30 if you want
    Homework_Nerd | Oct 03, 2011, 11:04 AM
  • 35?
    User_277 | Oct 03, 2011, 11:05 AM
  • ok. I can get this to you in a couple of hours
    Homework_Nerd | Oct 03, 2011, 11:08 AM
  • im trying to add funds to my paypal account..that takes 4 days though. does this website have any other way of paying? i can def. send you cash/check though in the mail if there is no instant transactions on here.
    User_277 | Oct 03, 2011, 11:34 AM
  • alright..its paid for. let me know if you need anything else. THANK YOU!!
    User_277 | Oct 03, 2011, 11:38 AM
  • :) Pleasure! Thanks!
    Homework_Nerd | Oct 03, 2011, 11:39 AM
  • hows it going? everything good?
    User_277 | Oct 03, 2011, 16:15 PM
  • hi, this is due at 12 NOON tmrw, friday the 11th. FYI. Will it be done by then? thanks.
    User_277 | Oct 03, 2011, 20:04 PM
  • Hey hudson, i'll get it to you in an hour or so from now
    Homework_Nerd | Oct 03, 2011, 21:17 PM
  • ok thanks
    User_277 | Oct 03, 2011, 21:29 PM
  • Done :( Took me forever.
    Homework_Nerd | Nov 03, 2011, 04:29 AM
  • Download the second file. Right-click save as. I'm sure of the answers
    Homework_Nerd | Nov 03, 2011, 04:42 AM
  • i cannot find the file. can u send it to skyychase@gmail.com
    User_277 | Nov 03, 2011, 10:24 AM
  • when i open it, it is an html file..all it shows are weird symbols and stuff. can u reformat it so it can open in excel and also send t to skyychase@gmail.com then i will release payment thanks.
    User_277 | Nov 03, 2011, 10:28 AM
  • hello??????????????/
    User_277 | Nov 03, 2011, 12:39 PM
  • I'll send it to your email now. Did you try right clicking and saving it?
    Homework_Nerd | Nov 03, 2011, 12:49 PM
  • yes it didn't work. it is an HTML, i need it in the excel format. when i right click, it says, "save LINK as" doesn't work.
    User_277 | Nov 03, 2011, 13:09 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}