Analysis: Analysis

The Analysis menu contains all the tools necessary for creating custom tables, bar plots, pie charts, histograms, and crosstabulations. Other tools are provided for convenience.

creates a new bar plot, pie chart, table, or histogram
allows you to create custom tables in EZReport
creates new queries
groups multiple questions together for reporting purposes
creates text versions of your tables for export into other software
creates a fast text summary
allows you to save your comments and more
shows results of two or more questions together
performs ANOVA test
performs Chi-Square test
calculates correlation between two variables, in EZReport only
performs multiple regression, in EZReport only
tests the difference between variables or groups, in EZReport only

Plot

Plot allows you to create tables, pie charts, bar charts and histograms of your response type questions. A response question is either a Multiple Choice, ListBox, Combobox, Weighted Score, Check All that Apply, or Write in Number. Write in Number type questions cannot be displayed as a graph. They must be displayed in a table format.

To create a plot:

1. Select Analysis | Plot. The Chart Properties dialog will appear with settings for the plot. You can change these settings again later with Object | Properties.
2. In the listbox labeled Select question, select the question to use in the plot.
3. In the listbox labeled Plot type, select the type of the graph to make. The options include Table, Pie, Bar, Horizontal Bar, and Histogram. All the plot types except for Table come in both 2-D and 3-D versions.
4. Select the Options tab and check the options you want to appear in the plot.
5. Select the Colors tab to set the colors for each response in a bar plot, pie chart, or histogram or to pull out wedges in a pie chart.
6. Click OK to finalize the settings.
7. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.

You can sort your questions alphabetically by placing a check in the Sort option box. You can also decide on which type of questions you want in the list by placing checks in the Response, Weighted and Number option boxes. Placing a check in one or more of these option boxes has the following effects:

If you have none of the options checked or if you have all of them checked it will have the same effect: all questions of all the above described types will be in the Select questions listbox.

Changing Plots

You can change a plot once it is created by selecting the plot and clicking on a different plot type or question.

To change the plot type:

1. Select View | Plot type to show the Plot type toolbar.
2. Select the plot to change.
3. Click on one of the buttons in the Plot type toolbar to change the plot to the type represented by the button.
4. You can do this multiple times to quickly view all your options.

To change the question to a single question:

1. Select View | Question list ( Ctrl-Q) to show the Question list window.
2. Select the plot to change.
3. Click on a different question in the Question list window.
4. You can do this multiple times to quickly view all your options.

To change the question to a group of questions:

1. Select View | Group list to show the Group list window.
2. Select the plot to change.
3. Click on a different group in the Group list window.
4. You can do this multiple times to quickly view all your options.

See Compose group for instructions on how to create question groups.

[ TOP ]

Compose query

This option allows you to set up a query on your database for displaying plots. A query is a method for taking a subset of the total data based on certain criteria. The subset consists of all records in the database which satisfy the criteria. In Analysis you can do two kinds of queries:

By Question

By question queries create subsets of the database by the responses of a response-type question. Examples:

What is your GENDER? ¨ Male ¨ Female

What is your height? ¨ Under 5 feet ¨ Between 5 and 6 feet ¨ Over 6 feet

To set up a By Question query:

1. Select Analysis | Compose query. The Compose query dialog box will appear. If not already selected, select the By Question tab.
2. In the listbox labeled All Questions, a list of all the questions in your form appear. If you want to narrow down which types of questions you want to appear in the list, uncheck Responses or Weighted to eliminate Multiple choice-type responses or Weighted response questions from the list.
3. Select the questions you want to be able to query and click the --> button.
4. Click OK to close the dialog box.
5. Select View | Query list to display the list of queries.
6. The choices in the Query list after All are the responses from the questions you selected.
7. To activate a query on a particular plot, select that plot, then click on the query in the list that you want applied.

Compound Queries

In Analysis click on Analysis | Compose query, select the Compose tab and choose New and you will be able to create a compound query.

Compound queries are those which use a multiple set of criterion using the operators AndIf or OrIf. They allow you to narrow down a data set further than you could with a By Question query.

To set up a compound query:

1. Select Analysis | Compose query. A dialog box will appear.
2. Select the Compose tab, then click the New button.
3. Enter a name for this query in the box labeled Query Name. Make it descriptive, like 'If Q1 is A AND Q2 is B'
4. Select the function (If, OrIf, AndIf) in the Function box. (The compound query must start with an If function.) Select the question on which you want to perform the first function in the Question box.
5. Select the comparison operator you want to apply in the Operator box.
6. If it is a choice response, select the desired value(s) you want to check for. If you select more than one, the query will be the union of the selected responses-- one response OR another. This is equivalent to the OrIf function.

If it is a number question, type the value you want to check for in the box.

7. Click the right arrow button to add the query to the list.
8. If you want to add additional queries to the compound query, select the Function: AndIf or OrIf, and follow steps 4-7 to add another query. When finished, click OK.
9. A list of compound queries will be on the left. If you would like to delete a query from the list, select it and click the Delete button. If you would like to edit one of the queries, select it and click the Edit button.
10. Click OK when finished to close the Compose query window.
11. Select View | Query list to bring up the Query list window.
12. To activate a query on a particular plot, select that plot, then click on the query you want in the list.
[ TOP ]

Compose group

Compose group allows you to group multiple questions with the same response set into a single question for analysis purposes. For instance, if you have five questions which ask you to rate six different employees on a scale of 1 to 10, it would be useful to group the five questions together in order to find out information such as:

a. the minimum or maximum rating received by any employee
b. the average rating received by any employee
c. the total number of rating points achieved by all the employees

To create a custom group:

1. Select Analysis | Compose group
2. In the listbox labeled All questions, select the set of questions you want to group.
3. Click the --> button to move the questions into the Group components listbox.
4. Name the group by typing a name in the Group Name box. This should be a descriptive name so that you can identify the group later.
5. Click the Save button to add the group to the Groups listbox. You can edit or delete it later by selecting it in the Groups listbox and clicking Edit or Delete.
6. Repeat the above process for additional groups. Click OK when finished.
[ TOP ]

Customize:

This option is only available in Raosoft EZReport.

[ Calculate | Responses | Numbers | Weighted Score | Group Pareto ]

Customize provides you with subsets of your data so you can construct a table exactly how you want it. The following table options are at your disposal:

Calculate

Calculate allows you to take data from your questions and use it to calculate other numbers you may need for your report. You can either calculate static numbers (such as 3+4=7) or you can find the ratio between two weighted score type questions. In order to get information from your response question you must first choose the question you want and the type of data you want to take from that question. You have the following functions available to you:

If you want to use the data from a question in a specific calculation, just follow the instructions above to Add the field to the Calculation window, then add any additional mathematical symbols or numbers you need to accomplish the calculation you want. If you click on any of the keypad buttons on the right of the Calculate tab the number or symbol will be placed automatically into the Calculation window.

Note: You may also type directly into the calculation window. If you know exactly what you want this is the quickest method for setting up a calculation.

On the Options tab you have a few choices for your comment formatting:

The Responses tab just allows you to look at all your response-type questions and determine what response codes are defined for it.

The Location tab allows you to define the location of the calculated value in inches. The distances are relative to the top and left sides of the page (or piece of paper).

Responses

Clicking on this option will bring up a dialog that allows you to get information on all responses on any of your response type questions in your database. Select a question in the Select Question listbox, then in the Count Codes type for response codes you want counted. As shown in the example on the dialog you can choose to only have one code or any combination of the codes in the question displayed on the report page.

Other options for the way your data is presented include:

Style:

Numbers

This option behaves like the Responses option in that it provides you with subsets of the data for the question you have selected. The only questions that appear in the select question list are Write in Number and Weighted Score questions. To place data on the report page:

Weighted Score

This option behaves like the Responses option in that it provides you with subsets of the data for the question you have selected. The only questions that appear in the select question list are Weighted Score questions. To place data on the report page:

  • How do you rate our services?

  • Where Excellent=5, Good=4, Average=3, Below Average=2, Poor=1 and Don't Know=X. If you place "4,5" in the Agree text box then all respondents that chose a 4 or 5 would be defined as agreeing the services provided were good.
  • Group Pareto

    Group Pareto provides you with a bar plot comparison of the groups you have composed. To place a pareto graph on the page:

    [ TOP ]

    ASCII output

    If you have many crosstabulated tables or if you want to export a table from your data, you should use the ASCII output option.

    To export a table:

    1. Select Analysis | ASCII output and select the type of table you would like to create for output.
    2. You will be told to go to the Select tab to make your question selection. You will see that the question selection follows the same rules as if you were making a table or crosstab for your report page.
    3. Select the Options you want to appear on the table.
    4. Once you hit OK you will be brought to the Results tab and the table will be updated in the Results window. Each time you make a change in the table questions or options make sure you hit the OK button to refresh the Results window.
    5. Now that you have created your table(s) you need to select or create a text file to hold this data. Go to the Results tab and click on Browse, and go to the directory you want to place or create the file in. If the text file does not exist just type in the filename in the File Name area. In order to export the data you have three options:
      • Replace - this erases data in the text file and replaces it with the table(s) you just created.
      • Append - this adds the table(s) you created to the end of the data in the text file.
      • To Notepad - this opens Windows Notepad with your table(s) so you can do more editing.

    Now all you have to do is click on one of the buttons described above to export your data.

    [ TOP ]

    Summary

    Summary allows you to create a fast text summary of your data. The summary includes small text tables of all data for particular questions, and all the queries you have created applied to the data for those questions as well.

    To do this:

    1. Select Analysis | Summary to open the Data Summary window.
    2. The Select Question(s) listbox contains all the questions in the database. You can narrow down the list by unchecking the Response, Weighted, and Number checkboxes to eliminate questions of that type. Check Sort if you want the questions to be sorted alphabetically: otherwise they will appear in the order in the database.
    3. Select the Options you want to appear in the summary.
    4. Select the questions you want to summarize, then click the right arrow button.
    5. Click the Save button to save the summary to a text file.
    6. Give the text file a name, then click OK.
    7. Click OK again to close the Data Summary window, or create another summary.
    [ TOP ]

    Comments

    Comments allows you to retrieve the data from your comment-type questions in addition to crosstabbing your comment questions against any other question in your database. Once you have created a comment list you can save it as DOS ASCII .TXT for importing into any word processing application. Each element of the list will be tab separated for easy importing.

    To retrieve comments from your database do the following:

    1. Select Analysis | Comments
    2. Select the comment questions you want from the All questions list and move them to the Questions in table list by clicking on the right arrow button. Now all you need to do is click on OK to see the comments listed in the Comment analysis window.
    • File | Save will save the comments as a text (.TXT) file that can be opened in any word processing program.
    • File | Print will print the comments.
    • When you scroll through the list to the end, the !More command will continue the list. You can then save or print this continued list.
    • The !Top command will return you to the top of the list.

    Before you do this you should look over the options you have concerning the format of the text you will see:

    • Table Type
      • Show as is - this will show the comment as it is typed in the database.
      • Count responses - this will provide you with a list of comments and a frequency of how many times the same comment shows up in the database.
      • Count words - this will provide you with a frequency of how many times a specific word shows up in the database.
      • Sort by count - this will sort the counted responses or words in order of frequency from the highest to the lowest.
    • Arrange Multiple Questions (applies only if you have multiple comment questions selected)
      • By question - this will list the question title and all of the comments for that question, then it will move on to the next question and list the comments for it and so on.
      • By case - this will list the comments for all questions selected for the first record and then move on to the next record and list the comments for all questions selected and so on.
    3. (optional) If you click on the Options tab you can make additional choices on how the comment data is sorted and formatted. The following options are available:
    • Show sequence number - this will number each comment that is displayed.
    • Show case number - this will show the case number for each comment that is displayed.
    • Word count characters - this will allow you to filter the words in a comment so you only see the words of a specific size. This option only works if you have the Count Words option chosen on the Select tab.
      • Minimum - this is the minimum number of letters the word must have in the comment
      • Maximum - this is the maximum number of letters the word must have in the comment
  • If you are not concerned with the number of maximum or minimum characters required just set the value to zero.
    • Spacing - this will set the number of hard returns that will separate the comments.
    • Percent - this will set the format of any percentage numbers printed. You will only be able to see a percent value for a comment if you have Count Words or Count Responses options selected on the Select tab.
      • Show percent - check this if you want to see the percentage for Count Words or Count Responses.
      • % - check this if you want the percent symbol next to the percentage.
      • Decimals - the number of decimal places to calculate when displaying the percentage.
    4. (optional) If you click on the Crosstab tab you can choose a question to crosstab against your comment questions. To crosstab a question with your comment question, select it in the All questions list and move it to the Crosstabulate with list. Now when you hit OK your comments will be sorted depending on what the user selected for your crosstab question.
    5. (optional) If you click on the Script tab you can change the way in which the data is presented to you.
    • Question - this window changes the way in which your comment question is displayed. For example, if on the Select tab if you chose a comment question Q1 which corresponds how a person feels about services your company provided, you could type into the Question Window the following text:
  • How do you feel about our services? {Q1}

    Now when you hit OK to display your data you will get the "How do you feel about our services?" text prefixing each comment for the question Q1.

    • Crosstab Info - this window changes the way in which your crosstab information is displayed. For example, if on the Crosstab tab you chose a multiple choice question Q3 which corresponds to how much education a user had, you could type into the Crosstab Info window the following text:
  • Level of education: {Q3}

    Now when you hit OK to display your data you will get the "Level of education:" text prefixing the option the user chose for each crosstab.

  • [ TOP ]

    Crosstab

    A crosstab is a way of showing the results of two or more questions together. You can use a crosstab report to look for relationships within your sample. SURVEYWin lets you look at multiple questions for both rows and columns.

    To create a crosstab plot:

    1. Select Analysis | Crosstab. The Crosstabulations dialog will appear.
    2. In the listbox labeled All Questions, select the row and column question to use in the plot and use the right arrow button to move them to their respective row and column windows.
    3. Select the Options tab and check the options you want to appear in the plot.
    4. Click OK to finalize the settings.
    5. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.
    [ TOP ]

    Analysis of Variance

    To produce the Analysis of Variance (ANOVA) table set choose Analysis | Analysis of variance. An analysis of variance table is meaningful only when the column variable is a number field and the row variable is a multiple choice type field in crosstabulation.

    Analysis of Variance tests for the null hypothesis that all the categories have the same average value for the column variable. If at least two categories are not the same then the hypothesis will be rejected. This test is based on the assumption that all the categories have the same variance.

    For a test between two categories use Hypothesis Testing (in Raosoft EZReport), instead of the ANOVA, which computes the familiar t-test and allows for the unequal variance assumption.

    To create a ANOVA plot:

    1. Select Analysis | Analysis of Variance. The Analysis of Variance dialog will appear.
    2. In the listbox labeled Row Questions, select the row question to use in the plot; in the listbox labeled Column Questions select the column question to use in the plot..
    3. Select the Options tab and check the options you want to appear in the plot.
    4. Click OK to finalize the settings.
    5. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.
    [ TOP ]

    Chi-Square

    The Chi-square test is used to test whether two multiple choice type fields are related.

    When you select Analysis | Chi-Square and you crosstabulate two multiple choice type fields then the Chi-square value will be printed at the bottom of the table.

    If any of the cells in the table has less than 5 cases then the Chi-square test is not valid.

    This test computes numbers expected in each cell if the two fields are independent of each other. The difference between what is expected and what is actually observed forms a basis for the test.

    To create a Chi-Square plot:

    1. Select Analysis | Chi-Square. The Chi-Square dialog will appear.
    2. In the listbox labeled Row Questions, select the row question to use in the plot; in the listbox labeled Column Questions select the column question to use in the plot..
    3. Select the Options tab and check the options you want to appear in the plot.
    4. Click OK to finalize the settings.
    5. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.
    [ TOP ]

    Correlation Matrix

    This option is only available in Raosoft EZReport.

    If you ask for crosstabulation between two number fields or weighted score questions Raosoft SURVEYWin computes Pearson correlation between the two fields. Here is a quick example to describe what correlation means:

    If you have two questions on your form such as 'How much money do you make?' and 'What type of car do you drive?' and you want to see if people who make more money drive expensive cars, you would do a correlation matrix on these two questions.

    If you are using weighted score questions then you need to make sure you set up the options accordingly. For example if your income options were:

    Income per year:
    1 = $10k
    2 = $20k
    3 = $30k
    4 = $40k

    Then in order to correlate properly you would want your vehicle choices in ascending order of cost:

    Car owned costs:
    1 = $5k
    2 = $10k
    3 = $15k
    4 = $40k

    With our questions set up like this, if you get a positive correlation then this means people who make more money drive more expensive cars. Conversely, if you get a negative correlation it means that people who make more money drive less expensive cars. If the correlation value is marked with a + symbol, then your correlation is significant. A non-significant correlation means that your two variables are not strongly related (income has no effect on car ownership).

    To create a Correlation Matrix:

    1. Select Analysis | Correlation Matrix. The Correlation Matrix dialog will appear.
    2. In the listbox labeled All Questions, select the question to use in the plot and move it into the Correlations window by using the right arrow button. You must move in two weighted score or write in number questions.
    3. Select the Options tab and check the options you want to appear in the plot.
    4. Click OK to finalize the settings.
    5. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.
    [ TOP ]

    Multiple Regression

    This option is only available in Raosoft EZReport.

    Multiple regression measures the error involved in using the regression line as a basis of estimation. The regression line is created from the variables you choose (both dependent and independent) and describes the average relationship existing between the variables within a specified confidence level. You will choose one dependent variable and at least one independent variable to run the regression test.

    To perform Multiple Regression:

    1. Select Analysis | Multiple Regression. The Multiple Regression dialog will appear.
    2. In the listbox labeled All Questions, select the question to use as the dependent variable in the plot and move it into the Dependent Variable window by using the right arrow button. Again from the All Questions listbox, choose your independent variables and move them into the Independent Variables window using the right arrow button.
    3. Select the Options tab and check the options you want to appear in the plot.
    4. Click OK to finalize the settings.
    5. The mouse pointer will change to a crosshair. Position the crosshair where you want the upper left corner of the plot to appear and click the left mouse button to place it on the page.
    [ TOP ]

    Hypothesis Testing

    This option is only available in Raosoft EZReport.

    Two basic types of decision problems can be attacked by using hypothesis testing in Raosoft EZReport. In the first type of problem, we want to know whether a sample parameter has changed from or differs from a particular value. This situation is a one group test, where you can compare the difference between your selected variable and a known value, which is zero by default or can be defined on the Options tab. The second type of hypothesis test is whether two sample parameters are significantly different from each other. The level of significance is by default 95%, but can be set to other values on the Options tab. This is a two group test, where you compare two variables against each other.

    To perform a one question Hypothesis Test:

    1. Select Analysis | Hypothesis Test. The Hypothesis Test dialog will appear.
    2. Make sure you have the One Set tab selected. You can have a query applied for this test by choosing a query you have created, by clicking on the query name in the Query listbox. Now choose the question you would like to test from the Question listbox. Now you should see data in the Stats, Limits of Population Value and the Test Conclusion windows. Note that the data windows are scrollable.
    3. If you need to change either the value the question is being compared against or the level of confidence select the Options tab and check the options you want. Then go back to the One Set tab and RESELECT your question to update the data windows.

     

    To perform a two question Hypothesis Test:

    1. Select Analysis | Hypothesis Test. The Hypothesis Test dialog will appear.
    2. Make sure you have the Two Set tab selected. You can have a query applied for each question in the test by choosing a query you have created, by clicking on the query name in the Query listbox. Now choose the questions you would like to test from the Question listbox. Now you should see data in the Stats, Limits of Population Value and the Test Conclusion windows. Note that the data windows are scrollable and contain all standard testing information.
    3. If you need to change either the value the question is being compared against or the level of confidence select the Options tab and check the options you want. Then go back to the One Set tab and RESELECT your question to update the data windows.
    [ HELP FILE ] [ PROJECT WINDOW HELP ] [ TOP ]