***** SIMS: Top/Bottom 2 Boxes & 3 Boxes  Basic Usage Notes *****
Purpose:

The Top/Bottom 2 Boxes & 3 Boxes Report summarizes the extreme observations for Hedonic Attributes.
Market research studies often refer to positive and negative rating measures
using the Top/Bottom 2 Boxes & 3 Boxes percentages as indicators of consumer acceptance.
Line Scales, new Top/Bottom Report support for Line Scales, effective update 2016.
Only those Line Scales which are Discrete Increments = 1
AND Max  Min >= 4 (at least 5 categories) AND Max  Min <= 15 (looks like a category scale).
The categories for Line Scales will be reported as the actual numeric values on your Line Scale. SIMS can't extract any captions.
If you intend to use this report with your Hedonic Attributes, it is generally a good
idea to design your Questionnaire's Hedonic Attributes so that the return values assigned
to each Hedonic choice DESCEND from the top answer to the bottom answer. The top answers
should be favorable (Like extremely, Like very much, etc.) while the bottom ones should
be unfavorable (Dislike extremely, Dislike very much, etc.).
For Horizontal Hedonics, choices should DESCEND from the left answer to the right answer.
The left answers should be favorable (Like extremely, Like very much, etc.) while the
right ones should be unfavorable (Dislike extremely, Dislike very much, etc.).
The Top/Bottom 2 Boxes & 3 Boxes are commonly Ranked by the 'VISUAL' location of the Boxes, Top & Bottom.
For Horizontal Hedonics, Top 2 == Left 2 and Bottom 2 == Right 2
The Top/Bottom 2 Boxes & 3 Boxes can also be Ranked by the Return 'VALUES' of the Boxes, High & Low.
Top 2 == 2 Highest Return Values and Bottom 2 == 2 Lowest Return Values
If your Hedonic questions are already designed with Top/HighValue and Bottom/LowValue,
the most common usage, then the report will produce same result with either rank option.
Top/Bottom 3 Boxes follow same logic and notes.
Top/Bottom 1 Box, and Middle 1 Box are used less often then T2/B2 & T3/B3.
Here is an example:
Using the scale below, how do you feel about the sample flavor?
Like extremely
Like very much
Like slightly
Neither like nor dislike
Dislike slightly
Dislike very much
Dislike extremely
The values of each answer are assigned from 7 (Like Extremely)
down to 1 (Dislike extremely).
Your Report for Top 2 might look like this:
Top 2 boxes
Attribute Sample 1 Sample 2 Pval Sig
Liking 9 (75%) 6 (50%) 0.234 NS
In this example Twelve respondents answered the question for each sample.
Nine respondents (75%) selected either Like Extremely or Like very much
for Sample 1, while six (50%) selected either of those answers for Sample 2.
Report Options:

Hedonic Attribute Selection. By default, all Hedonic Attributes are included in report.
You have the option to select individual Hedonic Attributes, one, many, or all.
Include Statistics Pval & Significance  SAS Analysis
This report option will include the superscripts, pvalues, and significance levels
as reported in normal Anova/(Duncan/LS) analysis for each of the hedonic attributes.
SAS Analysis Specs: (per B. Thomas Carr, M.S., Feb 2002)
Actual Attribute return data points are not exported to SAS, instead these actual
values are compared with Top/Bottom 2 Values, and if inclusive then a data value
of '100' is exported to SAS, otherwise a data value of '0' is exported to SAS.
In other words, the SAS Data Sets, for each Hedonic question (X1Xn),
will always export either:
a) 100, b)0, or c). ( . = null)
Top Two Boxes are defined as being the Top Two SEEN Boxes, Bottom is opposite.
Option: Use 'OneWay Model' Between Samples
 Used in PROC GLM to calculate means and Pvalues based
on the Sample as the ONLY independent variable.
Otherwise the normal default independent variables are Judge and Sample (Two Variables).
 When your Experimental Design is of the type n Samples Present 1, the OneWay
Model Between Samples may be an appropriate analysis option, especially
when there are different sets of respondents testing each sample.
'OneWay Model' 'TwoWay Model'
PROC GLM; PROC GLM;
CLASS SAMPLE; CLASS JUDGE SAMPLE;
MODEL X1X10 = SAMPLE; MODEL X1X10 = JUDGE SAMPLE;
MEANS SAMPLE / DUNCAN ALPHA = 0.05; MEANS SAMPLE / DUNCAN ALPHA = 0.05;
Column Designations Format Market Research
 An alternative method sometimes utilized by Market Research professionals.
 An alternative method for the analysis reporting 'Letters' for Mean Separations and Column Designation.
 Within an Attribute row, a letter indicates the sample is significantly different than the designated column.
 Column header for each Sample description is appended with an (a), (b), (c), (etc).
Example: Table Header: S1 (a) S2 (b) S3 (c)
Attribute Sweetness: S1 S2 (c) S3 (b)
Interpretation: S2 and S3 differ, while S1 and S2, and S1 and S3 do not differ.
 As a review, the above alternative MR method *differs* from the common sensory usage, which is:
Where any two sample means that do not share a common letter will differ at some significance level.
Example: Table Header: S1 S2 S3
Attribute Sweetness: S1 (ab) S2 (a) S3 (b)
Interpretation: S2 and S3 differ, while S1 and S2, and S1 and S3 do not differ.
 Option: High Only, Column Designations Format Market Research
Only shows the *higher value* cell for Each Pair which is significantly different.
Within an Attribute row, a letter indicates the sample is significantly different *higher value* than the designated column.
Example: Table Header: S1 (a) S2 (b) S3 (c)
Attribute Sweetness: S1 S2 (c) S3
Interpretation: S2 and S3 differ, S2 is higher value then S3, while S1 and S2, and S1 and S3 do not differ.
 A more complex example, where all samples are significantly different from each other:
S1=38 S2=48 S3=42 PValue=0.0001 ***
Common Sensory Usage: S1 (c) S2 (a) S3 (b)
MR Usage: S1 (bc) S2 (ac) S3 (ab)
MR High Only Usage: S1 S2 (ac) S3 (a)
Include Hedonic Attribute Details
This report option will include, for every Hedonic Attribute on your report,
details about the Hedonic's a) choice labels b) Seen Order c) actual return values
Selecting this report option could add a few additional pages to your report.
Include SAS Data Set Details
This report option will include ALL the Hedonics SAS Data set Details, Actual and SAS.
Selecting this report option could add a few additional pages to your report.
Drop Counts, Show Only Percentages
This report option will drop the count of panelists (n) who answered within the Top/Bottom 2 Boxes
for each Attribute/Sample, and only display the Percentages of panelists.
Include Means Rows
Will include rows of mean score calculations for each Attribute/Sample.
These are the means for *ALL* of the data, not just the Top/Bottom Boxes.
Include Stats Mean Separations, pvalues, and Sig:
If this option is desired, you need to run statistical analysis PRIOR to Top/Bottom Boxes, see SIMS Main Menu  Statistical Analysis.
The values used for the extra Means Row are from the most previously performed statistical analysis.
The mean separation letters will be displayed EXACTLY as it was from the most previous statistical analysis.
The mean separation letters will appear next to the Mean in the Mean Rows, example 7.16ab
Note about mean separation letters consistency, for the Tn/Bn stats and this optional Means Row:
Consistent options selections: If you're selecting the option for: Column Designations Format Market Research,
it is quite likely that you will want the mean separation letter handling to be consistent.
What statistical options did you select for this test in SIMS Main Menu  Statistical Analysis? Be consistent.
If in doubt, go rerun SIMS Main Menu  Statistical Analysis with your desired options.
Report Destination Excel Direct:

Significant Cells Colors refers to row cells where the Significance Levels are either '*' or '**' or '***', typically 95% confidance or more.
The separation letters will be lower case when Significance Levels are '*', and UPPER case when '**' or '***'.
[ ] Include Columns Pval & Sig
Example: PVal = .001 Sig = " *** "
[ ] Drop 'Bottom' stats
Optionaly omit the Bottom 3 & Bottom 2 & Bottom 1 stats from appearing on the report.
[ ] Merge/Rollup the Tn/Bn choices text
Example: 5pt Overall Liking: Like Very Much Like Moderately Neither Like nor Dislike Dislike Moderately Dislike Very Much
If not selected the minimal choice text label will be displayed; Top 2 example: Like Moderately
If selected the Merge/Rollup choices text labels will be displayed; Top 2 example: Like Very Much/Like Moderately
If selected SIMS will attempt smart text merge, where the 'common' ending choice text words for choices will not be repeated when possible.
Top 2 example: Very satisfied , Quite satisfied  > Very/Quite satisfied
Rounding Notes:

SIMS adheres to ASTM standards for Rounding Test Data.
ASTM E2993a
'Standard Practice for Using Significant Digits in Test Data
to Determine Conformance with Specifications'.
Clause 6.4 of E29 covers the rounding rules, which go beyond the 5/4 rule.
Here is a brief summary:
 When the digit beyond the one you want to keep is less than 5,
do not change the digit you are keeping.
 When the digit beyond the one you want to keep is greater than 5,
increase the digit you are keeping by 1.
 When the digit beyond the one you want to keep is equal to 5,
And there are nonzero digits beyond it, increase the digit you are keeping by 1.
 When the digit beyond the one you want to keep is equal to 5 exactly,
And the digit you are keeping is odd, increase the digit you are keeping by 1.
If the digit you are keeping is even, keep it unchanged.
(this odd vs even rule is also commonly known as the bankers rounding)
Viewing Analysis Files Notes:

Optionally use these files to review what occurred within SAS Statistics.
You can not Re Export/Analyze your TOP2/BOTTOM2 SAS file from Viewing Analysis Files,
because of the formatting and inclusion of means and percentages included on the final table.
Analysis is only available from the Main Tab on TOP2/BOTTOM2 Analysis Screens.
File Names:

SAS Export/Import Files Names will be named similar to
MyTestT2.* , MyTestB2.* , MyTestT3.* , MyTestB3.* , etc. Or MyTestTBM.*
where the T2 or B2 in file name indicates Top 2 or Bottom 2 Analysis.
where the T3 or B3 in file name indicates Top 3 or Bottom 3 Analysis.
where the T1 or B1 or M1 in file name indicates Top, Bottom, or Middle 1 Analysis.
or TBM if multiple Top Bottom check box report options are selected.
File name will always start with the first SIX characters of your Result Code name,
followed by the Tn Bn TBM which applies.
Test Combine:

Test Combine is not currently supported in the Top/Bottom reports of SIMS2000.
It may be possible to combine manually with some time and effort.
Export each test report individually to Excel. Use one of the excel spreadsheets to manually edit.
Are the Tests Sample numbers Static (2+2=2) or do they Increment Sequentially (2+2=4)?
Static, manually combine the Top/Bottom frequencies, recalc the % percentages.
Increment, manually copynpaste combine insert additional columns.
SAS statistics, if needed for Top/Bottom pvalue and mean separations.
Combine the .dat files, copy/combine .dat file rows into one .dat file.
Static, sample #s should already be aok, ex. 2+2=2
Increment, some .dat file rows will need to have the sample #s corrected where needed, ex. 2+2=4
Load and run .sas file using your local PC SAS program natively, i.e. not from SIMS2000.
You may need to change the .dat file source name in the .sas file, see /*Read the Data*/ area.
Manually locate pvalues and mean separations letters from GLM SAS listing file output.
