No announcement yet.
  • 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:

    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
                If cell.Value = lastvalue Then
                    run = run + 1
                    maxrun = Application.Max(run, maxrun)
                    run = 1
                End If
                lastvalue = cell.Value
            End If
        Next cell
        LongString = maxrun
    End Function

    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.


    • #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,



      • #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.


        • #5
          Thanks, Eric and Marcos, for your help!
          I found another forum-post with the answer to my question: