Results 1 to 11 of 11

Tables - Trying to reverse answers

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Penrith, England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Tables - Trying to reverse answers

    I am currently collecting data for my Dissertation. I am using an online survey tool which will only output answers as data. The questions I am asking are on a scale from 1 - 5. The scoring criteria however are from 5 - 1/ How can I swap all my 5's for 1's and 4's for 2's etc. I also have a second problem that is that some of the questions need reversing. IE they are currently in the correct format. I will hopefully have around 100 respondents when I am finished so doing this manually would be very time consuming. I am currently working on a sample of 5 to see if I can get it to work. If anyone can help I would be much obliged.

    I have uploaded both the raw data with my current thinkings on it (Which are wrong) and a copy of the document I am working from. If anyone wants to take a peek I would be very greatfull.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1