Protobi

← All blog posts View post

<p>Crosstabs are a staple of market research. But how do you crosstab values that are unique, like open end text responses?
Or unique within each column, like city within state, or state within country?  </p>
<p>Protobi has a special chart type just for this case.  It's especially useful for responses that are one-of-a-kind. 
The essential idea is that each column is independent, showing just the values that apply to that column.
And each column is sorted independently, by frequency or value.  This allows a lot of values in a small table.</p>
<p>  <img src="/images/blog/2024-06-18-verbatim/verbatim-chart-1.png" alt="Selector">
</p>
<h2 id="open-end-responses-vs-coded-responses">Open end responses vs coded responses</h2>
<p>One application is evaluating an open end coding.  In the example above, we show the raw verbatim text responses 
versus the coded responses.  This way the analyst (and the client) can quickly see the answers that got bucketed into 
each code.</p>
<h2 id="show-frequencies">Show frequencies</h2>
<p>You can optionally show counts or percents for each cell. In the <em>Statistics...</em> dialog set "Distriction" to true:</p>
<p><img src="/images/blog/2024-06-18-verbatim/verbatim-chart-2.png" alt="Selector"></p>
<h2 id="sort-values">Sort values</h2>
<p>You can optionally sort values in each column, by frequency or value, ascending or descending. Press the sort button 
to toggle through the variations.</p>
<h2 id="filter-values">Filter values</h2>
<p>You can optionally filter values in each column, by substring or regular expression. Enter text in the search bar
to limit the values you see.  Press the "Apply" button to turn that search into a filter that applies to all questions.
<img src="/images/blog/2024-06-18-verbatim/verbatim-chart-4.png" alt="Selector"></p>
<h2 id="highlight-values">Highlight values</h2>
<p>You can optionally highlight values to selectively display a few in each column for a presentation or report.
Right-click on any value to add (or remove) it from the list of highlighted values.
Press the "Highlight" button to toggle between displaying highlighted values only or all values.
<img src="/images/blog/2024-06-18-verbatim/verbatim-chart-5.png" alt="Selector"></p>
<h2 id="cross-by-geography">Cross by geography</h2>
<p>This chart type can also be useful for crosstabbing geographical regions, such as state by country, since 
the list of state names tends to be unique for each country:
<img src="/images/blog/2024-06-18-verbatim/verbatim-chart-6.png" alt="Selector"></p>
<h2 id="more-variations">More variations</h2>
<p>There are lots of other variations.  If you have a question for which a chart like this may be useful, 
contact us at <a href="mailto:support@protobi.com">support@protobi.com</a> or find a time on our calendar</p>

Date

Status

Slug edit

Thumbnail

Categories Manage