Empirisoft Support

    Welcome to Empirisoft Support
Results 1 to 10 of 10

Thread: How to capture fractional values in fill-in-the-blanks?

  1. #1

    How to capture fractional values in fill-in-the-blanks?

    How does one capture values that are fractions in questions with a fill-in-the-blank format? I know how to capture decimals, but for my purposes, I need the values to be captured in fractions (e.g., 2/3, 1/2, etc.)

    Thank you in advance.

    Efren

  2. #2
    Join Date
    Nov 2005
    Posts
    3,328
    I assume you mean by some other means than simply having them type "2/3", yes?

  3. #3
    Actually, I want subjects to be able to enter fractions, such as 2/3.
    However, if I enter fractions, the data set converts these into dates, such as 3-Feb.

    Efren

  4. #4
    Join Date
    Nov 2005
    Posts
    3,328
    Excel does this or SPSS?

  5. #5
    Excel does this. Is there a way to prevent this and have Excel capture the data in the right way (i.e., 2/3, etc.)?

    Efren

  6. #6
    Join Date
    Nov 2005
    Posts
    3,328
    Would you mind posting a sample Excel data file that shows this?

  7. #7
    Here is the sample data set. The problem is with the variable named "veto". Notice that the value under that column is 3-Feb, when it should be 2/3.
    Attached Files Attached Files

  8. #8
    Join Date
    Nov 2005
    Posts
    3,328
    That's strange. May I see the que file that produced this data file?

  9. #9
    The question is #26 (i.e., veto). The question file is enclosed.

    Thanks,
    Efren
    Attached Files Attached Files

  10. #10
    Join Date
    Nov 2005
    Posts
    3,328
    Hmm. I just ran it and it seems to work fine here. Try running the attached revision (it's just shortened). When I ran it, it produced the dat file that is also included in the zip file. After you run it, take a look at the new data and see if it has the alternate format you've been seeing. You might want to delete the ioncluded data file first so that it creates one from scratch for you.
    Attached Files Attached Files

Similar Threads

  1. Min-max values being ignored
    By jarvis24 in forum DirectRT Older Versions: Troubleshooting
    Replies: 13
    Last Post: 05-07-2013, 04:40 PM
  2. Multiple fill-in-the-blanks on one screen?
    By anusiva in forum MediaLab Older Versions: Sharing Area
    Replies: 3
    Last Post: 09-05-2011, 05:05 AM
  3. missing values
    By Jessica in forum MediaLab Older Versions: How Do I...
    Replies: 3
    Last Post: 02-29-2008, 09:25 AM
  4. Multiple fill-in-the-blanks on one screen?
    By anusiva in forum MediaLab Older Versions: How Do I...
    Replies: 1
    Last Post: 04-23-2007, 04:19 PM
  5. Assigning values to Scale Ranking
    By s_rooker in forum MediaLab Older Versions: How Do I...
    Replies: 2
    Last Post: 11-28-2006, 08:56 PM

Posting Permissions

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