StatPac for Windows User's Guide
StatPac Home
 

Overview

System Requirements and Installation

System Requirements

Installation

Unregistering & Removing the Software from a PC

Network Operation

Updating to a More Recent Version

Backing-Up a Study

Processing Time

Server Demands and Security

Technical Support

Notice of Liability

Paper & Pencil and CATI Survey Process

Internet Survey Process

Basic File Types

Codebooks (.cod)

Data Manager Forms (.frm)

Data Files (.dat)

Internet Response Files (.asc or .txt)

Email Address Lists (.lst or .txt)

Email Logs (.log)

Rich Text Files (.rtf)

HTML Files (.htm)

Perl Script (.pl)

Password Files (.text)

Exported Data Files (.txt and .csv and .mdb)

Email Body Files (.txt or .htm)

Sample File Naming Scheme for a Survey

Customizing the Package

Problem Recognition and Definition

Creating the Research Design

Methods of Research

Sampling

Data Collection

Reporting the Results

Validity

Reliability

Systematic and Random Error

Formulating Hypotheses from Research Questions

Type I and Type II Errors

Types of Data

Significance

One-Tailed and Two-Tailed Tests

Procedure for Significance Testing

Bonferroni's Theorem

Central Tendency

Variability

Standard Error of the Mean

Inferences with Small Sample Sizes

Degrees of Freedom

Components of a Study Design

Elements of a Variable

Variable Format

Variable Name

Variable Label

Value Labels

Valid Codes

Skip Codes for Branching

Data Entry Control Parameters

Missing OK

Auto Advance

Caps Only

Codebook Tools

The Grid

Codebook Libraries

Duplicating Variables

Insert & Delete Variables

Move Variables

Starting Columns

Print a Codebook

Variable Detail Window

Codebook Creation Process

Method 1 - Create a Codebook from Scratch

Method 2 Create a Codebook from a Word-Processed Document

Spell Check a Codebook

Multiple Response Variables

Missing Data

Changing Information in a Codebook

Overview

Data Input Fields

Form Naming Conventions

Form Creation Process

Using the Codebook to Create a Form

Using a Word-Processed Document to Create a Form

Variable Text Formatting

Field Placement

Value Labels

Variable Separation

Variable Label Indent

Value Labels Indent

Space between Columns

Valid Codes

Skip Codes

Variable Numbers

Variable List and Detail Windows

Data Input Settings

Select a Specific Variable

Finding Text in the Form

Replacing Text in the Form

Saving the Codebook or Workspace

Overview

Keyboard And Mouse Functions

Create A New Data File

Edit Or Add To An Existing Data File

Select A Different Data File

Change Fields

Change Records

Enter A New Data Record

View Data For A Specified Record Number

Find Records That Contain Specified Data

Duplicate A Field From The Previous Record

Delete A Record

Data Input Settings

Compact Data File

Double Entry Verification

Print A Data Record

Variable List & Detail Windows

Data File Format

Overview

HTML Email Surveys

Plain Text Email Surveys

Brackets

Item Numbering

Codebook Design for a Plain Text Email Survey

Capturing a Respondent's Email Address

Filtering Email to a Mailbox

General Considerations for Plain Text Email

Overview

Internet Survey Process

Server Setup

Create the HTML Survey Pages

Upload the Files to the Web server

Test the survey

Download and import the test data

Delete the test data from the server

Conduct the survey

Download and import the data

Display a survey closed message

Server Setup

FTP Login Information

Paths & Folder Information

Design Considerations for Internet Surveys

Special Variables for Internet Surveys

Script to Create the HTML

Command Syntax & Help

Saving and Loading Styles

Survey Generation Procedure

Script Editor

Imbedded HTML Tags

Primary Settings

HTML Name (HTMLName=)

Banner Image(s)  (BannerImage=)

Heading  (Heading=)

Finish Text & Finish URL (FinishText= and FinishURL=)

Cookie (Cookie=)

IP Control (IPControl=)

Allow Cross Site (AllowCrossSite=)

URL to Survey Folder  (WebFolderURL=)

Advanced Settings - Header & Footer

RepeatBannerImage

RepeatHeading

PageNumbers

ContinueButtonText

SubmitButtonText

ProgressBar

FootnoteText & FootnoteURL

Advanced Settings - Finish & Popups

Thanks

Closed

HelpWindowWidth & HelpWindowHeight

HelpLinkText

LinkText

PopupBannerImage

PopupFullScreen

Advanced Settings - Control

Method

Email

RestartSeconds

MaximizeWindow

BreakFrame

AutoAdvance

BranchDelay

Cache

Index

ForceLoaderSubmit

ExtraTallBlankLine

RadioTextPosition

TextBoxTextPosition

LargeTextBoxPosition

LargeTextBoxProgressBar

Advanced Settings - Fonts & Colors

Global Attributes

Heading, Title, Text, & Footnote Attributes

Instructions, Question, and Response Attributes

Advanced Settings - Passwords - Color & Banner Image

LoginBannerImage

LoginBGColor

LoginWallpaper

LoginWindowColor

Advanced Settings - Passwords - Text & Control

PasswordType

LoginText

PasswordText

LoginButtonText

FailText

FailButtonText

ShowLink

EmailMe

KeepLog

Advanced Settings - Passwords - Single vs. Multiple

Password (single password method)

PasswordFile (multiple passwords method)

PasswordField & ID Field (multiple passwords method)

PasswordControl

Advanced Settings - Passwords - Technical Notes

Advanced Settings - Server Overrides

ActionTag

StorageFolder

ScriptFolder

Perl

MailProgram

Branching and Piping

Randomization (Rotations)

Survey Creation Script - Overview

Using Commands More than Once in a Script

Survey Creation - Specify Text

Heading

Title

Text

FootnoteText

Instructions

Question

Survey Creation - Spacing and pagination

BlankLine

NewPage

Survey Creation - Images and Links

Image

Link

Survey Creation - Help Windows

Survey Creation - Popup Windows

Survey Creation - Objects

Radio Buttons for a Single Variable

Radio Buttons for Grouped Variables (matrix style)

DropDown Menu

TextBox for a Single Variable

Adding a TextBox to a Radio Button,
    CheckBox, or Radio Button Matrix

TextBoxes for Grouped Variables

Sliders for Single or Grouped Variables

CheckBox for Multiple Response Variables

ListBox

Uploading and Downloading Files from the Server

Auto Transfer

FTP

Summary of the Most Common Script Commands

Overview

Format of an Email Address File

Extract Email Addresses

List Statistics

Join Two or More Lists

Split a List

Clean, Sort, and Eliminate Duplicates

Add ID Numbers to a List

Create a List of Nonresponders

Subtract One List From Another List

Merge an Email List into a StatPac Data File

Send Email Invitations

Using an ID Number to Track Responses

Email Address File

Body Text File

Sending Email

Overview

Mouse and Keyboard Functions

Designing Analyses

Continuation Lines

Comment Lines

V Numbers

Keywords

Analyses

Variable List

Variable Detail

Find Text

Replace Text

Options

Load, Save, and Merge Procedure Files

Print a Procedure File

Run a Procedure File

Results Editor

Graphics

Table of Contents

Automatically Generate Topline Procedures

Keyword Index

Keywords Overview

Categories of Keywords

Keyword Help

Ordering Keywords

Global and Temporary Keywords

Permanently Change a Codebook and Data File

Backup a Study

STUDY Command

DATA Command

SAVE Command

WRITE Command

MERGE Command

HEADING Command

TITLE Command

FOOTNOTE Command

LABELS Command

OPTIONS Command

SELECT and REJECT Commands

NEW Command

LET Command

STACK Command

RECODE Command

COMPUTE Command

AVERAGE, COUNT and SUM Commands

IF-THEN ELSE Command

SORT Command

WEIGHT Command

NORMALIZE Command

LAG Command

DIFFERENCE Command

DUMMY Command

RUN Command

REM Command

Reserved Words

Reserved Word RECORD

Reserved Word TOTAL

Reserved Word MEAN

Reserved Word TIME

Analyses Index

Analyses Overview

LIST Command

FREQUENCIES Command

CROSSTABS Command

BANNERS Command

DESCRIPTIVE Command

BREAKDOWN Command

TTEST Command

CORRELATE Command

Advanced Analyses Index

REGRESS Command

STEPWISE Command

LOGIT and PROBIT Commands

PCA Command

FACTOR Command

CLUSTER Command

DISCRIMINANT Command

ANOVA Command

CANONICAL Command

MAP Command

Advanced Analyses Bibliography

Utility Programs

Import and Export

StatPac and Prior Versions of StatPac Gold

Access and Excel

Comma Delimited and Tab Delimited Files

Files Containing Multiple Data Records per Case

Internet Files

Email Surveys

Merging Data Files

Concatenate Data Files

Merge Variables and Data

Aggregate

Codebook

Quick Codebook Creation

Check Codebook and Data

Sampling

Random Number Table

Random Digit Dialing Table

Select Random Records from Data File

Compare Data Files

Conversions

Date Conversions

Currency Conversion

Dichotomous Multiple Response
   Conversion

Statistics Calculator Menu

Distributions Menu

Normal distribution

T distribution

F distribution

Chi-square distribution

Counts Menu

Chi-square test

Fisher's Exact Test

Binomial Test

Poisson Distribution Events Test

Percents Menu

Choosing the Proper Test

One Sample t-Test between Percents

Two Sample t-Test between Percents

Confidence Intervals around a Percent

Means Menu

Mean and Standard Deviation of a Sample

Matched Pairs t-Test between Means

Independent Groups t-Test between Means

Confidence Interval around a Mean

Compare a Sample Mean to a Population Mean

Compare Two Standard Deviations

Compare Three or more Means

Correlation Menu

Sampling Menu

Sample Size for Percents

Sample Size for Means

Email Surveys

Overview

An email survey is one where the body of the email contains the survey itself. This is in contrast to an Internet survey where you send an email invitation and the body of the email contains a link to the Internet survey.

The problem with email surveys is that you don't know what kind of email reader your respondents are using. A survey that looks fine in one email reader might appear distorted in another email reader. Therefore, we discourage you from sending email surveys.

Nevertheless, there are two kinds of email surveys: HTML and plain text.

 

HTML Email Surveys

In an HTML Email survey, the email you send is the survey itself. When the respondent views the email, they will see the survey.

Follow the same procedure as you would if creating an Internet survey, including uploading the survey to the Internet. Then, instead of sending the respondents a link to the survey, you send them the first page of the survey (i.e., the _1.htm file).

When they open the email, they will see the first page of the survey, and when they click the Submit button, the responses will be stored on the server and the second page or thank you page will be displayed. Data is retrieved from the server as if it were an Internet survey.

Conceptually, HTML email surveys are wonderful. However, in reality, HTML email surveys can cause several problems. Some people have their email readers set to not display HTML. Other people have their email readers set to disallow executables which means they delete the JavaScript in the HTML that StatPac relies on. This will cause them to see a JavaScript error when they view the email. Additionally, you cannot use cookies or ID numbers to track who responded and who didn't.

For these reasons, we discourage you from sending HTML email surveys. If you choose to send them anyhow,  please do so knowing that some respondents are likely to have problems.

 

Plain Text Email Surveys

A plain-text Email is one where you create a survey using ASCII text and include it as part of the body text in a regular Email. The survey is Emailed to a potential respondent. They click their Reply button, complete the survey, and then click the Send button to return the completed survey to you. Upon receipt of their reply, you can immediately import it into a StatPac data file, or filter it to a mailbox (i.e., file) with other returned Emails and import all the responses at once. Importing returned Emails appends the respondents answers to the end of a StatPac data file.

There are two kinds of variables that can be included in a plain-text Email.  One is where the respondent uses an X to check the appropriate response(s). The other is where the respondent fills in a text or numerical response. The following simple survey shows both kinds of variables. The first five survey items are "X the box" and the last five items are "fill in the blank":

 

TO PARTICIPATE, PLEASE CLICK THE REPLY BUTTON.

 

Type an X between the brackets to indicate your selection.

 

1. Gender   [  ] Male   [  ] Female                                                        

 

2. Ethnicity:

           [  ] Black

           [  ] White

           [  ] Other                                                    

 

3. What is your favorite brand?

 

    [  ] Brand X      [  ] Brand Y

    [  ] Brand Z      [  ] Undecided        

 

4.  Overall, how would you rate our product?

     (Type an X between the brackets to indicate your response.)

 

    Excellent                               Poor

      [  ]   [  ]   [  ]   [  ]   [  ]   [  ]   [  ]

        1     2      3     4      5      6      7

 

5. Where did you hear about the product?

      (Type an X between all brackets that apply.)

           [  ] Radio

           [  ] TV

           [  ] Newspaper

 

6. Overall,  how would you rate our product?

    Excellent                           Poor

         1    2    3    4     5     6     7

     Type the number of your rating here. [   ]

 

7. How old are you?  [       ]

   (Type your age between the brackets)

 

8. What do you feel would be a fair price for this product?

   [         ]  Type the dollar amount between the brackets..

 

9.  What is your favorite brand?

     (Type the name of your favorite brand between the brackets).

     [                                                 ]

 

10. What could we do to make our product better?

     (Type your answer between the brackets).

     [

 

                                                                                             ]

 

CLICK THE SEND BUTTON TO FINISH THIS SURVEY.

 

THANK YOU FOR YOUR PARTICIPATION.

 

Brackets

Notice that the brackets are used to show respondents where to type their answers. The text of the Email is completely free-form, except that brackets may only be used to specify where respondents are supposed to type their answer. You may not use brackets anywhere else in the Email. 

Item Numbering

The numbering of the survey items is optional. The purpose of these numbers is to guide the respondent from one question to the next. They are not necessarily the same as the variable numbers in the codebook. That is, some survey items might be multiple response and occupy multiple variables in the codebook. For example, survey item 5 is multiple response and takes three codebook variables. From that point on, the item numbering on the survey is no longer is the same as the codebook variables.

Numbering the items on an Email survey also serves an additional purpose. When a respondent replies to your Email, StatPac will extract their answers from the Email by looking at what's between the brackets. If a respondent inadvertently deleted one of the brackets, StatPac might get confused on which variable it was evaluating. When item numbering is not used, StatPac will report the error and not add any of that respondent's answers to the data file. When item numbering is used, StatPac will be able to identify the start of a new variable or series of multiple response variables, and it will leave only the defective item blank. StatPac will report the error, but the rest of the data for that respondent will be added to the data file. Thus, item numbering allows StatPac to "re-synch" with the variables in the codebook, even when a bracket has been deleted.

If you do use item numbering on your Email survey, the number may begin with the letter Q (a common abbreviation for question). It must also end in a period followed by a space, and it may not contain non-numeric characters. Each of the following would be correct usage of item numbering.

 

5. Where did you hear about the product?

Q5. Where did you hear about the product?

Q5. (a) Where did you hear about the product?

 

The following would be incorrect usage of item numbering. The first example does not have a period following the number. The second example has a space after the Q. The third example has the letter "a" before the period and space.

 

5 Where did you hear about the product?

Q 5. Where did you hear about the product?

Q5a. Where did you hear about the product?

 

Codebook Design for a Plain Text Email Survey

The codebook for an Email survey is the same as any other codebook. The rule is, if you want the respondent to use an X to show her response, the codebook must specify a value label for each response. If you want the respondent to fill in an answer, do not specify any value labels for that variable.

Variables can be alpha or numeric. When multiple sets of brackets (boxes) are required, they can be placed horizontally (items one and four)  or vertically (items two and five). If you specify more than one column of boxes (item three), they must be positioned horizontally. That is, the first box is associated with value label 1 and the box to the right of it is associated with value label 2. In the second row, the first box is associated with value label 3, and the box to the right of it is associated with value label 4.

Here is the codebook for the first five items:

 

V1. Gender  (A1)

       M=Male

       F=Female

V2. Ethnicity  (N1)

       1=Black

       2=White

       3=Other

V3. What is your favorite brand?  (N1)

       1=Brand X

       2=Brand Y

       3=Brand Z

       4=Undecided

V4.  Overall, how would you rate our product?  (N1)

       1=Excellent

       2=

       3=

       4=

       5=

       6=

       7=Poor

V5. Where did you hear about the product?  (N1)

       1=Radio

       2=TV

       3=Newspaper

V6. Where did you hear about the product?  (N1)

       1=Radio

       2=TV

       3=Newspaper

V7. Where did you hear about the product?  (N1)

       1=Radio

       2=TV

       3=Newspaper

 

The last five items on the sample survey are fill in the blank items. The variable formats in the codebook specify the maximum response length for each of the items. The actual distance between the opening an closing bracket on the Email survey can be any length. If the respondent "stretches" the space between the brackets by typing a longer response, the data will be recorded properly in the data file provided the answer does not exceed the field length specified in the codebook. If the respondent's answer does exceed the field length, StatPac will allow you to adjust the codebook so that all fields are sufficient to hold the responses. Also note that the opening and closing brackets do not need to be on the same line of the Email. Item ten in the example offers the respondent several lines for their answer. Here is the codebook for the second five items

    

V8. Overall,  how would you rate our product?  (N1)

V9. How old are you?   (N2)

V10. What do you feel would be a fair price for this product?  (N6)

V11.  What is your favorite brand?  (A45)

V12. What could we do to make our product better?  (A500)

 

If a respondent prefixes a numeric response with a dollar symbol (as might readily happen for V10), the dollar symbol will be eliminated from response when importing the Email file.

The basic text for an e-mail survey can be created by selecting Design, Email Survey.  This will provide a foundation for the body of your email. It is expected that you will edit the text as necessary for your specific application and audience.

Capturing a Respondent's Email Address

To capture the respondents' Email addresses, include a variable in the codebook that has the name EMAIL. Give it a format sufficient to hold all Email addresses (e.g., A70)  The EMAIL variable may be placed anywhere in the codebook. Do not indicate anything on the Email survey itself. StatPac will properly capture the respondent's Email address when ever the EMAIL variable name is specified in the codebook.

Unlike plain-text Email, CGI Email cannot automatically capture the respondent's email address. Therefore, in order to capture the respondent's Email address, and you must explicitly specify it as a field on your web page.

Filtering Email to a Mailbox

All e-mail programs allow you to automatically or manually send a received e-mail to a mailbox or text file.  Automatic "filtering" is often used to sort the incoming Email into a series of mailboxes. These mailboxes are simply text files containing all the Emails that have be routed to the mailbox. The naming convention for the mailboxes is different for each Email program. Eudora and Outlook Express programs use a .mbx extension.  The first step is to determine the name of the mailbox. That is, the name of the file that contains the completed surveys (i.e., that. holds the filtered Emails). This is the file that you will import into StatPac. If you do not have an Email program that has filtering to mailboxes, you could import the incoming Email survey's into StatPac one at a time from the clipboard, but this might be slow. A better technique might be to use notepad to copy/paste all the Emails into one file that can then be imported into StatPac.

General Considerations for Plain Text Email

Because of the wide diversity in e-mail readers, we suggest that you limit every line of your e-mail survey to 60 characters. This will avoid unintentional word wrap. Create your email using a non-proportional font (e.g., Courier) to make it perfectly clear as to you how long a 60 character line will be.

We suggest that HTML tags not be used to enhance the appearance of your e-mail. Many e-mail readers do not recognize the control sequences used by HTML tags, and these potential respondents will see control codes as part of their e-mail. Make your e-mail surveys generic looking so they will display properly with all e-mail readers.

Before actually sending out the surveys, send several copies of the e-mail survey to yourself.  Make sure the surveys look exactly the way you want the respondent to see them. Then reply to each of the surveys. Now check your mail to make sure that they get filtered to the correct mailbox. and check the import procedure to make sure that the data is being properly imported. Checking the entire import process is crucial for e-mail and Internet surveys.