SurveyMonkey - 2012 Manual do Utilizador descarregar pdf (Página 46)

SurveyMonkey User Manual

Page 45

How to Correlate the Respondent Number to the response in

your Export:

When browsing through the respondents in the Analyze section or online in your

account, they are presented in the same order in which they are received.

The 1

respondent to your survey will be listed as #1 out of “n” or the total number of

respondents. The responses will then go from oldest to newest with the first person to

respond saved as #1, the second respondent as #2, the 3

as #3, and so on.

However, in the exported spreadsheet file, they are presented in the reverse

order.

 When viewing the respondents in Excel, they are shown in the reverse order.

 Respondent #1 from the Analyze section will be the last response listed in your

export spreadsheet. The newest response will be the 1

row of your

spreadsheet.

EXAMPLE: If you had 10 respondents, then Respondent 10 out of 10 from the Analyze

screen will be the first response of your export starting in the respondent’s row. In Excel

(All Responses Collected export), the respondent row starts on row 3. The questions

are in row 2 and the other headers are in row 1.

The response in row 3 of the spreadsheet will be the same response as respondent

number 10 when you are browsing the results in the Analyze section.

How to read the All Response Collected Spreadsheet in Excel: Learn more.

1 2 ... 41 42 43 44 45 46 47 48 49 50 51 ... 67 68

Sem comentários

SurveyMonkey - 2012 Manual do Utilizador Página 46