Quick Counts
Quick Counts allows you to create tables by selecting variables from your WinCross Executive dataset as table rows and banner columns. Quick Counts is a quick and easy-to-use feature that can help you explore "what if" scenarios and/or whether your data supports further analysis. Your express tables can be filtered and/or weighted and reports can be saved as Excel reports.
Choose a dataset
Choose the dataset for use with Quick Counts from the dropdown list.
Select variable(s) to be used as rows/columns
- Select a variable or group of variables from the Row Variables list to use for creating rows. Variables selected can be non-contiguous.
- Select a variable or group of variables from the Column Variables list to use for creating columns. Variables selected can be non-contiguous.
- Only variables of numeric format are displayed for Row Variables and Column Variables.
- Variables of string format are not listed nor available for selection in Quick Counts as Row Variables or Column Variables.
- Variables of string format can be used in Filter logic.
- Choose the associated Clear option to clear any selected Row Variables and/or Column Variables.
Statistical Options
- Choose the desired Statistical Options (Mean, Median, Standard deviation, Standard error, Frequency, Vertical percents, Horizontal percents and Significance testing).
- Significance testing is performed on both percents and means. The Dependent Paired/Overlap (Multi) test is always used, however, if the data are independent, the results would be the same as if the Independent (using unpooled proportions) Z-Test was used for percents and the Independent (assume unequal variances) T-Test was used for means.
- When Significance Testing is selected, by default, significance testing is done for all banner columns including the Total Answering column.
- You can use Define Groups to create alternative comparison groups to the WinCross Executive default.
Row Nets
- Nets can be automatically generated for row variables by choosing one or more of the Row Nets options.
- You can choose None, Net first 2 values or Net first 3 values for top box nets and None, Net last 2 values or Net last 3 values for the bottom box nets.
Show hidden variables
Enable the Show hidden variables option to display variables that have been hidden using the Variables dialog.
Select a weight variable
- To run your Express Tables weighted, you can choose a weight variable by selecting a variable from the Select a weight variable dropdown list. The variable you choose must already contain the weight value.
- Choose Clear to remove a selected weight variable.
Run filter
- You can enter Filter logic that will be applied to all of your tables.
- Choose Clear to remove filter logic previously entered.
Create Tables
- Choose Create Tables to generate tables for the selected Row Variables and Column Variables.
- If more than one Row Variable is selected, a separate table is created for each variable selected.
Summary of Frequencies
- The Summary of Frequencies option provides a way to create one table from multiple variables and selected code values.
- The Row Variables selected must have similar structure and the same number of code values.
- Choose the desired code values on the Select Code Values dialog.
- One table is created from the Row Variables and Code Values selected.
- Value labels from the selected Code Values are used as row text.
- Value labels from selected Column Variables are used as banner text.
- A generic "Summary of Row Variables" is assigned as the table title, displayed to the left of the row text.
- The Variable labels for selected Column Variables are used as the banner text spanning all banner columns for that variable.
- If a Column Variable is not selected, Row Variables are processed using a "Total Answering" column.
Summary of Means
- The Summary of Means option provides a way to create one table of mean values from multiple variables.
- The Row Variables selected must have similar structure and the same number of code values.
- Choose the desired code values on the Select Code Values dialog.
- One table is created with one row per variable selected.
- Variable labels for each selected Row Variable are used as row text.
- Value labels from selected Column Variables are used as banner text.
- The Variable labels for selected Column Variables are used as the banner text spanning all banner columns for that variable.
- The Variable labels for selected Column Variables are used as the banner text spanning all banner columns for that variable.
Create Excel Report
- Select the Create Excel Report option to create an Excel report from your tables. All tables are written to one worksheet.
- The report is saved to a temporary Excel file at the WinCross Executive site that can be downloaded by choosing Download Excel Report after saving the report to Excel.
- You can append new tables to an existing Excel file by choosing Append to Excel Report. All tables are written to one worksheet and appended to the same worksheet.
- Start a New Excel Report will create a new Excel report.