Survey Data Generator

Instructions

The Survey Data Generator will create an Excel file that contains responses to your six survey questions. To create this file, type the minimum, the maximum, and the expected values for questions 5 and 6 into the Survey Data Generator.

You do not need to enter anything into the generator for your binary questions (1 through 4). The Survey Data Generator will automatically generate 0s and 1s for the responses to those questions.

Once you have entered each of the values for questions 5 and 6, select the Download Your Data button. The Excel file generated will include six columns (A through F), one column for each question (1 through 6).

Columns A through D represent the responses for questions 1 through 4, and will only contain 0s and 1s. Columns E and F represent the responses for questions 5 and 6, and will contain numbers between your minimum and maximum.

Note:Remember that if a column contains all the same numbers, you will need to use the Survey Data Generator again.

Survey Question 5(column E in spreadsheet):

Enter the minimum value:

Enter the maximum value:

Enter the expected value:

Survey Question 6(column F in spreadsheet):

Enter the minimum value:

Enter the maximum value:

Enter the expected value: