Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Web survey: Detecting insufficient effort respondents

    I have web survey data and I want to detect respondents who answered 8 or more consecutive items in the same way (e.g. 'strongly agree'). I am looking for an easy way to code this, but so far I didn't find a satisfying solution. Does someone have a good idea?

  • #2

    I found an example of calculating Maximum LongString using Excel. Find below the Excel-syntax:

    Code:
    Function LongString(cells As Range) 
        Dim cell As Range
        Dim run As Integer
        Dim firstrow As Boolean
        Dim maxrun As Integer
        Dim lastvalue As String
    
        firstrow = True
        run = 1
        maxrun = 1
       
        For Each cell In cells
            If firstrow = True Then
                firstrow = False
                lastvalue = cell.Value
            Else            
                If cell.Value = lastvalue Then
                    run = run + 1
                    maxrun = Application.Max(run, maxrun)
                Else
                    run = 1
                End If
                lastvalue = cell.Value
            End If
        Next cell
    
        LongString = maxrun
    End Function
    Source: http://neoacademic.com/2016/12/21/calculating-longstring-excel-detect-careless-responders/

    But so far, I have no idea how to calculate Maximum LongString using Stata. Does someone have an idea?
    Last edited by Ernst-Jan de Bruijn; 14 Jun 2018, 05:29.

    Comment


    • #3
      Welcome to the Stata Forum / Statalist,

      I'm not sure but, assuming the variables are coded, maybe a combination of - egen - with the option anycount() plus the if clause could do the trick.

      Perhaps you could share a short sample or a toy example with the data. You can use - dataex - for that matter.
      Best regards,

      Marcos

      Comment


      • #4
        A recent paper, I can recommend, in which a new method is discussed, to inspect suspect respondents, is: Haller, C. S., & Courvoisier, D. S. (2010). Personality and thinking style in different creative domains. Psychology of Aesthetics, Creativity, and the Arts, 4(3), 149-160.
        http://publicationslist.org/eric.melse

        Comment


        • #5
          Thanks, Eric and Marcos, for your help!
          I found another forum-post with the answer to my question: https://www.stata.com/statalist/arch.../msg00869.html

          Comment

          Working...
          X