Default formats

2019-06-10T18:36:17Z

Mtabadmin:

Default formats

2019-06-10T18:35:03Z

Mtabadmin: Created page with "Summary of mTAB Default Format Styles Column %'s, Sample Base Displays a column % value for each question response, along with Subset, Sample and Unweighted Sample Totals. Th..."

Summary of mTAB Default Format Styles

Column %'s, Sample Base
Displays a column % value for each question response, along with Subset, Sample and Unweighted Sample Totals.
The % calculation = Row Response / Sample Total. Subset Total = summation of the row responses selected using
Subset. Sample Total = summation of all row responses, even if they have not been subset. By default, those
respondents that do not provide a response to the question will be excluded from the base used for the%
calculation.

Column %' s, Subset Base
Displays a column %value for each question response, along with Subset and Unweighted Sample Totals. The %
calculation = Row Response / Subset Total. Subset Total = summation of the row responses selected using Subset.
By default, those respondents that do not provide a response to the question will be excluded from the base used
for the % calculation.

Significance Test - Percentages
Includes Column% Sample and Percentage Significance formats. Select this format if you wish to perform
significance testing of questions that can be formatted as Percentages. By default, those respondents that do not
provide a response to the question will be excluded from the base used for the % calculation.

Row %'s, Sample Base
Displays a row % value for each question response, along with Subset, Sample, and Unweighted Sample Totals.
The % calculation = Column Response / Sample Total. Subset Total = summation of the column responses selected
using Subset. Sample Total = summation of all column responses, even if they have not been subset. By default,
those respondents that do not provide a response to the question will be excluded from the base used for the %
calculation.

Row %'s, Subset Base
Displays a row % value for each question response, along with Subset and Unweighted Sample Totals. The %
calculation = Column Response / Subset Total. Subset Total = summation of the column responses selected using
Subset. By default, those respondents that do not provide a response to the question will be excluded from the
base used for the % calculation.

Mean
Displays a row representing the weighted average, or Mean for a specific question, along with the Unweighted
Sample Total. By default, those respondents that do not provide a response to the question will be excluded from
the base used for the mean calculation.

Significance Test - Means
Includes Mean and T-Statistic (unequal variances) formats. Select this format if you wish to perform significance
testing of questions that can be formatted as Means. By default, those respondents that do not provide a
response to the question will be excluded from the base used for the mean calculation.

Median
Displays a row representing the Median for a specific question, along with the Unweighted Sample Total. By
Default, those respondents that do not provide a response to the question will be excluded from the base used for
the median calculation.

Top 2 Box
Displays a column % value representing the sum of the first two question responses in the selected question,
along with an Unweighted Sample Total. By default, those respondents that do not provide a response to the
question will be excluded from the base used for the % calculation.
Bottom 2 Box
Displays a column % value representing the sum of the last two question responses in the selected question, along with an Unweighted Sample Total. By default, those respondents that do not provide a response to the question will
be excluded from the base used for the % calculation.

Weighted Counts
Displays weighted counts for each question response, along with Subset Total and Sample Total Counts. Subset
Total = summation of the row responses selected using Subset. Sample Total = summation of all row responses,
even if they have not been subset. Since no calculation is taking place with this format, those respondents that do
not provide a response to the question will be included in the displayed base.

Unweighted Counts
Displays unweighted counts for each question response, along with Subset Total and Sample Total Counts. Subset
Total = summation of the row responses selected using Subset. Sample Total = summation of all row responses,
even if they have not been subset. Since no calculation is taking place with this format, those respondents that do
not provide a response to the question will be included in the displayed base.

MTAB Knowledge Base

2018-10-09T00:16:03Z

Mtabadmin:

This is a collection of in-depth articles and "how to" guides that describe the features available in mTAB. This mTAB Knowledge Base is updated as new features are added to mTAB.

<html><table border="0" cellspacing="2" cellpadding="2"> <tbody> <tr> <td align="left">We also offer mTAB support through our chat service. Please click the Live Chat button below, or <a href="https://www.mtab.com/live-chat/" target="_blank">click here</a> to access our chat page.</td> </tr> <tr> <td> </td> </tr></tbody></table></html>

[[File:Live_chat_button.png|center|link=https://www.mtab.com/live-chat/]]

==Administration==
===Changing your mTAB password===
:''Main article:'' [[Changing your mTAB password]]
===Retrieving your mTAB password===
:''Main article:'' [[Retrieving your mTAB password]]
===Security Features===
:''Main article:'' [[Security Features]]
===Save the .JNLP message when launching mTAB (XP)===
:''Main article:'' [[Save the .JNLP message when launching mTAB (XP)]]
===Save the .JNLP message when launching mTAB (Windows 7)===
:''Main article:'' [[Save the .JNLP message when launching mTAB (Windows 7)]]
===Clearing the mTAB cache===
:''Main article:'' [[Clearing the mTAB cache]]

==Filter==
:''Main article: ''[[Filter Overview]]
The ability to filter allows the mTAB user to eliminate from a tab all respondents who do not match the filter criteria.
===Filter description options===
:''Main article:'' [[Filter description options]]
===Filter Logic===
:''Main article:'' [[Filter Logic]]
===Ignore Filter===
:''Main article: ''[[Ignore Filter]]
This feature allows users to compare FILTERED and UNFILTERED columns of data side by side within the same mTAB spreadsheet view.

==Format==
:''Main article:'' [[Format Overview]]
===Selecting a format style===
:''Main article:'' [[Selecting a format style]]
===Maximum and Minimum===
:''Main article:'' [[Maximum and Minimum]]
===Creating a new format style===
:''Main article:'' [[Creating a new format style]]
===Subset remainder question format===
:''Main article:'' [[Subset remainder question format]]
===Quartile formats===
:''Main article:'' [[Quartile formats]]

==Layer==
:''Main article:'' [[Layer Overview]]
===Introduction to layer===
:''Main article:'' [[Introduction to layer]]
===Selecting an alternative weight with multiple studies===
:''Main article:'' [[Selecting an alternative weight with multiple studies]]
===How to edit short study descriptions===
:''Main article:'' [[How to edit short study descriptions]]

==Recode==
:''Main article:'' [[Recode Overview]]
===Importing new labels into a recode===
:''Main article:'' [[Importing new labels into a recode]]
===Auto create recode across selected studies===
:''Main article:'' [[Auto create recode across selected studies]]
===Create recode new labels from base questions subset===
:''Main article:'' [[Create recode new labels from base questions subset]]
===Recode auto map dialog===
:''Main article:'' [[Recode auto map dialog]]
===Sorting in the recode editor===
:''Main article:'' [[Sorting in the recode editor]]
===Saving a draft recode===
:''Main article:'' [[Saving a draft recode]]
===Auto map, parsing stat values, saving===
:''Main article:'' [[Auto map, parsing stat values, saving]]
===Enhanced copy old to new in recode editor===
:''Main article:'' [[Enhanced copy old to new in recode editor]]
===Duplicate New Label Detection===
:''Main article:'' [[Duplicate New Label Detection]]

==Verbatim Responses==
:''Main article:'' [[Verbatim Overview]]
===How to use verbatim questions===
:''Main article: [[How to use verbatim questions]]
===Bigrams, Trigrams and Porter Stemming===
:''Main article:'' [[Bigrams, Trigrams and Porter Stemming]]
===Tag Clouds===
:''Main article:'' [[Tag Clouds]]
===Selected column tag cloud===
:''Main article:'' [[Selected column tag cloud]]
===Tag cloud frequencies===
:''Main article:'' [[Tag cloud frequencies]]
===Tag cloud breadcrumbs===
:''Main article:'' [[Tag cloud breadcrumbs]]
===Verbatim Filtering===
:''Main article:'' [[Verbatim Filtering]]

==Spreadsheet==
:''Main article:'' [[Spreadsheet Overview]]
===Applying a conditional format===
:''Main article:'' [[Applying a conditional format]]
===Conditional formatting - Auto Legend===
:''Main article:'' [[Conditional formatting - Auto Legend]]
===Conditional formatting - User defined benchmark column===
:''Main article:'' [[Conditional formatting - User defined benchmark column]]
===Interpreting K-means cluster analysis===
:''Main article:'' [[Interpreting K-means cluster analysis]]
===Simplified datasheet===
:''Main article:'' [[Simplified datasheet]]
===Support for URL's in spreadsheet===
:''Main article:'' [[Support for URL's in spreadsheet]]
===Sorting by question response labels===
:''Main article:'' [[Sorting by question response labels]]
===Spreadsheet Search/Replace Feature===
:''Main article:'' [[Spreadsheet Search/Replace Feature]]
===Text orientation in the spreadsheet===
:''Main article:'' [[Text orientation in the spreadsheet]]

==Subset==
:''Main article:'' [[Subset Overview]]
===Subset Indicator===
:''Main article:'' [[Subset Indicator]]

==TopN==
:''Main article:'' [[TopN Overview]]
===TopN report in layer outside worksheets===
:''Main article:'' [[TopN report in layer outside worksheets]]
===Colorization===
:''Main article:'' [[Colorization]]
===TopN in the spreadsheet view===
:''Main article:'' [[TopN in the spreadsheet view]]
===TopN additional data type analysis===
:''Main article:'' [[TopN additional data type analysis]]

==User Defined Questions==
:''Main article:'' [[User Defined Questions Overview]]
===Creating a user defined question===
:''Main article:'' [[Creating a user defined question]]
===Applying a user defined question to another study===
:''Main article:'' [[Applying a user defined question to another study]]
===Updating a user defined question===
:''Main article:'' [[Updating a user defined question]]
===Update new question responses in a user defined question===
:''Main article:'' [[Update new question responses in a user defined question]]

==Slice==
:''Main article:'' [[Slice Overview]]
===How to use Slice===
:''Main article:'' [[How to use Slice]]
===Importing a SLICE file into SPSS===
:''Main article:'' [[Importing a SLICE file into SPSS]]

==Sig Testing/Statistics==
:''Main article:'' [[Sig Testing/Statistics Overview]]
===Statistical formulas documentation===
:''Main article:'' [[Statistical formulas documentation]]
===Variations in means/statistical calculations===
:''Main article:'' [[Variations in means/statistical calculations]]
===Spreadsheet view - rounding differences explained===
:''Main article:'' [[Spreadsheet view - rounding differences explained]]
===Significance testing===
:''Main article:'' [[Significance testing]]
===Significance testing - Adjacent columns===
:''Main article:'' [[Significance testing - Adjacent columns]]
===Significance testing - Top/Bottom box===
:''Main article:'' [[Significance testing - Top/Bottom box]]
===Significance testing - Effective Base===
:''Main article:'' [[Significance testing - Effective Base]]
===Significance testing - Overlap Correction===
:''Main article:'' [[Significance testing - Overlap Correction]]
===Correlation===
:''Main article:'' [[Correlation]]

==Charts==
:''Main article:'' [[Charts Overview]]
===Charts Getting Started===
:''Main article:'' [[Charts Getting Started]]
===Chart Gallery===
:''Main article:'' [[Chart Gallery]]
===Correspondence analysis===
:''Main article:'' [[Correspondence analysis]]

==Save/Export==
:''Main article:'' [[Save/Export Overview]]
===Ability to export spreadsheet as an XML===
:''Main article:'' [[Ability to export spreadsheet as an XML]]
===Tab saving dialog===
:''Main article:'' [[Tab saving dialog]]
===Publish tabs to selected users===
:''Main article:'' [[Publish tabs to selected users]]
===MyTabs sort by date===
:''Main article:'' [[MyTabs sort by date]]
===Creating a folder structure in studies and mytabs lists===
:''Main article:'' [[Creating a folder structure in studies and mytabs lists]]

==Other==
===Question nesting in mTAB===
:''Main article:'' [[Question nesting in mTAB]]
===Optimizing Java for mTAB===
:''Main article:'' [[Optimizing Java for mTAB]]
===Batch Run===
:''Main article:'' [[Batch Run]]
===Understanding the icons in mTAB===
:''Main article:'' [[Understanding the icons in mTAB]]
===Loyalty/Source of Sales===
:''Main article:'' [[Loyalty/Source of Sales]]
===Overview: mTAB User Interface===
:''Main article:'' [[Overview: mTAB User Interface]]
===Group Questions===
:''Main article:'' [[Group Questions]]
===Hide topics/questions in the question view===
:''Main article:'' [[Hide topics/questions in the question view]]
===Meaning of (MK)(G1)?===
:''Main article:'' [[Meaning of (MK)(G1)?]]
===Use of the GROUP uniquing options===
:''Main article:'' [[Use of the GROUP uniquing options]]
===Setting the default to the column pane===
:''Main article:'' [[Setting the default to the column pane]]
===Search===
:''Main article:'' [[Search]]
===Updated Icons for Color Blind Users===
:''Main article:'' [[Updated Icons for Color Blind Users]]
===Change Font Size===
:''Main article:'' [[Change Font Size]]
==Videos==
===Tutorials===
:''Main article:'' [[Tutorials]]
===Webinars===
:''Main article:'' [[Webinars]]

MTAB Knowledge Base

2018-10-09T00:01:56Z

Mtabadmin:

This is a collection of in-depth articles, describing the features available in mTAB. The articles are separated by categories, allowing you to quickly locate assistance.

<html><table border="0" cellspacing="2" cellpadding="2"> <tbody> <tr> <td align="left">We also offer mTAB support through our live chat service. Please click the live chat button below, or <a href="https://www.mtab.com/live-chat/" target="_blank">click here</a> to access our chat page.</td> </tr> <tr> <td> </td> </tr></tbody></table></html>

[[File:Live_chat_button.png|center|link=https://www.mtab.com/live-chat/]]

==Administration==
===Changing your mTAB password===
:''Main article:'' [[Changing your mTAB password]]
===Retrieving your mTAB password===
:''Main article:'' [[Retrieving your mTAB password]]
===Security Features===
:''Main article:'' [[Security Features]]
===Save the .JNLP message when launching mTAB (XP)===
:''Main article:'' [[Save the .JNLP message when launching mTAB (XP)]]
===Save the .JNLP message when launching mTAB (Windows 7)===
:''Main article:'' [[Save the .JNLP message when launching mTAB (Windows 7)]]
===Clearing the mTAB cache===
:''Main article:'' [[Clearing the mTAB cache]]

==Filter==
:''Main article: ''[[Filter Overview]]
The ability to filter allows the mTAB user to eliminate from a tab all respondents who do not match the filter criteria.
===Filter description options===
:''Main article:'' [[Filter description options]]
===Filter Logic===
:''Main article:'' [[Filter Logic]]
===Ignore Filter===
:''Main article: ''[[Ignore Filter]]
This feature allows users to compare FILTERED and UNFILTERED columns of data side by side within the same mTAB spreadsheet view.

==Format==
:''Main article:'' [[Format Overview]]
===Selecting a format style===
:''Main article:'' [[Selecting a format style]]
===Maximum and Minimum===
:''Main article:'' [[Maximum and Minimum]]
===Creating a new format style===
:''Main article:'' [[Creating a new format style]]
===Subset remainder question format===
:''Main article:'' [[Subset remainder question format]]
===Quartile formats===
:''Main article:'' [[Quartile formats]]

==Layer==
:''Main article:'' [[Layer Overview]]
===Introduction to layer===
:''Main article:'' [[Introduction to layer]]
===Selecting an alternative weight with multiple studies===
:''Main article:'' [[Selecting an alternative weight with multiple studies]]
===How to edit short study descriptions===
:''Main article:'' [[How to edit short study descriptions]]

==Recode==
:''Main article:'' [[Recode Overview]]
===Importing new labels into a recode===
:''Main article:'' [[Importing new labels into a recode]]
===Auto create recode across selected studies===
:''Main article:'' [[Auto create recode across selected studies]]
===Create recode new labels from base questions subset===
:''Main article:'' [[Create recode new labels from base questions subset]]
===Recode auto map dialog===
:''Main article:'' [[Recode auto map dialog]]
===Sorting in the recode editor===
:''Main article:'' [[Sorting in the recode editor]]
===Saving a draft recode===
:''Main article:'' [[Saving a draft recode]]
===Auto map, parsing stat values, saving===
:''Main article:'' [[Auto map, parsing stat values, saving]]
===Enhanced copy old to new in recode editor===
:''Main article:'' [[Enhanced copy old to new in recode editor]]
===Duplicate New Label Detection===
:''Main article:'' [[Duplicate New Label Detection]]

==Verbatim Responses==
:''Main article:'' [[Verbatim Overview]]
===How to use verbatim questions===
:''Main article: [[How to use verbatim questions]]
===Bigrams, Trigrams and Porter Stemming===
:''Main article:'' [[Bigrams, Trigrams and Porter Stemming]]
===Tag Clouds===
:''Main article:'' [[Tag Clouds]]
===Selected column tag cloud===
:''Main article:'' [[Selected column tag cloud]]
===Tag cloud frequencies===
:''Main article:'' [[Tag cloud frequencies]]
===Tag cloud breadcrumbs===
:''Main article:'' [[Tag cloud breadcrumbs]]
===Verbatim Filtering===
:''Main article:'' [[Verbatim Filtering]]

==Spreadsheet==
:''Main article:'' [[Spreadsheet Overview]]
===Applying a conditional format===
:''Main article:'' [[Applying a conditional format]]
===Conditional formatting - Auto Legend===
:''Main article:'' [[Conditional formatting - Auto Legend]]
===Conditional formatting - User defined benchmark column===
:''Main article:'' [[Conditional formatting - User defined benchmark column]]
===Interpreting K-means cluster analysis===
:''Main article:'' [[Interpreting K-means cluster analysis]]
===Simplified datasheet===
:''Main article:'' [[Simplified datasheet]]
===Support for URL's in spreadsheet===
:''Main article:'' [[Support for URL's in spreadsheet]]
===Sorting by question response labels===
:''Main article:'' [[Sorting by question response labels]]
===Spreadsheet Search/Replace Feature===
:''Main article:'' [[Spreadsheet Search/Replace Feature]]
===Text orientation in the spreadsheet===
:''Main article:'' [[Text orientation in the spreadsheet]]

==Subset==
:''Main article:'' [[Subset Overview]]
===Subset Indicator===
:''Main article:'' [[Subset Indicator]]

==TopN==
:''Main article:'' [[TopN Overview]]
===TopN report in layer outside worksheets===
:''Main article:'' [[TopN report in layer outside worksheets]]
===Colorization===
:''Main article:'' [[Colorization]]
===TopN in the spreadsheet view===
:''Main article:'' [[TopN in the spreadsheet view]]
===TopN additional data type analysis===
:''Main article:'' [[TopN additional data type analysis]]

==User Defined Questions==
:''Main article:'' [[User Defined Questions Overview]]
===Creating a user defined question===
:''Main article:'' [[Creating a user defined question]]
===Applying a user defined question to another study===
:''Main article:'' [[Applying a user defined question to another study]]
===Updating a user defined question===
:''Main article:'' [[Updating a user defined question]]
===Update new question responses in a user defined question===
:''Main article:'' [[Update new question responses in a user defined question]]

==Slice==
:''Main article:'' [[Slice Overview]]
===How to use Slice===
:''Main article:'' [[How to use Slice]]
===Importing a SLICE file into SPSS===
:''Main article:'' [[Importing a SLICE file into SPSS]]

==Sig Testing/Statistics==
:''Main article:'' [[Sig Testing/Statistics Overview]]
===Statistical formulas documentation===
:''Main article:'' [[Statistical formulas documentation]]
===Variations in means/statistical calculations===
:''Main article:'' [[Variations in means/statistical calculations]]
===Spreadsheet view - rounding differences explained===
:''Main article:'' [[Spreadsheet view - rounding differences explained]]
===Significance testing===
:''Main article:'' [[Significance testing]]
===Significance testing - Adjacent columns===
:''Main article:'' [[Significance testing - Adjacent columns]]
===Significance testing - Top/Bottom box===
:''Main article:'' [[Significance testing - Top/Bottom box]]
===Significance testing - Effective Base===
:''Main article:'' [[Significance testing - Effective Base]]
===Significance testing - Overlap Correction===
:''Main article:'' [[Significance testing - Overlap Correction]]
===Correlation===
:''Main article:'' [[Correlation]]

==Charts==
:''Main article:'' [[Charts Overview]]
===Charts Getting Started===
:''Main article:'' [[Charts Getting Started]]
===Chart Gallery===
:''Main article:'' [[Chart Gallery]]
===Correspondence analysis===
:''Main article:'' [[Correspondence analysis]]

==Save/Export==
:''Main article:'' [[Save/Export Overview]]
===Ability to export spreadsheet as an XML===
:''Main article:'' [[Ability to export spreadsheet as an XML]]
===Tab saving dialog===
:''Main article:'' [[Tab saving dialog]]
===Publish tabs to selected users===
:''Main article:'' [[Publish tabs to selected users]]
===MyTabs sort by date===
:''Main article:'' [[MyTabs sort by date]]
===Creating a folder structure in studies and mytabs lists===
:''Main article:'' [[Creating a folder structure in studies and mytabs lists]]

==Other==
===Question nesting in mTAB===
:''Main article:'' [[Question nesting in mTAB]]
===Optimizing Java for mTAB===
:''Main article:'' [[Optimizing Java for mTAB]]
===Batch Run===
:''Main article:'' [[Batch Run]]
===Understanding the icons in mTAB===
:''Main article:'' [[Understanding the icons in mTAB]]
===Loyalty/Source of Sales===
:''Main article:'' [[Loyalty/Source of Sales]]
===Overview: mTAB User Interface===
:''Main article:'' [[Overview: mTAB User Interface]]
===Group Questions===
:''Main article:'' [[Group Questions]]
===Hide topics/questions in the question view===
:''Main article:'' [[Hide topics/questions in the question view]]
===Meaning of (MK)(G1)?===
:''Main article:'' [[Meaning of (MK)(G1)?]]
===Use of the GROUP uniquing options===
:''Main article:'' [[Use of the GROUP uniquing options]]
===Setting the default to the column pane===
:''Main article:'' [[Setting the default to the column pane]]
===Search===
:''Main article:'' [[Search]]
===Updated Icons for Color Blind Users===
:''Main article:'' [[Updated Icons for Color Blind Users]]
===Change Font Size===
:''Main article:'' [[Change Font Size]]
==Videos==
===Tutorials===
:''Main article:'' [[Tutorials]]
===Webinars===
:''Main article:'' [[Webinars]]

2018-08-02T21:42:10Z

2018-08-01T06:51:27Z

2018-08-01T01:17:21Z

Mtabadmin:

Correlation determines if there is a connection between two variables.

When one variable changes, the other variable changes in a specific direction.

Statistical correlation is a quantitative way to measure the direction and strength of the tendency to vary together.

-1.00 Perfect Correlation (both variables move in opposite directions)
0.00 No Correlation
1.00 Perfect Correlation (both variables move in the same direction)

Please follow these steps and guidelines to setup and run correlation in mTAB.

Begin by including questions in rows. The most commonly used question types for correlation reports run in mTAB are Likert-scale or ratings questions.

Columns are not used in correlation. If a question is included in columns, it will be ignored.

Including Filters or a Layer question are optional. This example includes a Brand question in Layer.

Include the question you would like to correlate the rest of the questions to at the top of the list in rows.

In this example, Overall Opinion is included first, so the rest of the questions will be correlated to Overall Opinion.

Click the bottom part of the Run (lightning bolt) icon. It will expand and offer additional Run options. Click the Run Correlation icon.

If you receive a warning message that highlights any of your row questions, this most likely means that the question(s) you selected does not have any stat values assigned to it. To proceed with a correlation report, you’ll need to assign some type of stat values to the highlighted questions. Proceed by double-clicking the highlighted question. The Subset Editor will appear.

In this example, the responses (Yes, No, etc.) do not have any numeric stat values assigned to them. Assign your own values by clicking in the column to the right of the question and enter stat values for each response.

If assigning a stat value is not applicable for one or more responses, you can use the subset feature to include only the responses you’ve assigned values to. In this example, plus signs [+] indicate that Yes, No, and Yes, None Checked will be included in the correlation report. Other will not be, since it does not have a stat value assigned.
Click OK to proceed and exit out of the Subset Editor.

mTAB currently supports two types of correlation, Spearman’s and Pearson’s. By default, mTAB will run Spearman’s, but you can change the option, based on the descriptions for the type of data you would like to run.

The correlation report will run. Since a question was included in Layer (Brand question), the correlation report will include a worksheet per brand and an additional Report view sheet, which includes the correlation results for Overall Opinion for each brand.

Click on the Indicators icon

The following options are available:

'''Hide Significance Values''' This hides the Correlation Significance rows and values (most will be 0.00) for each question.

'''Select Confidence Interval''' Options include either 95% or 99%. The default is 95.

'''Significant''' Significant values are identified in bold font. A value in bold font is equivalent to other programs such as SPSS assigning an asterisk to identify 95% significance and two asterisks to identify 99% significance.

'''Heat Map – Degree of Correlation''' This option assigns colors to help categorize the strength of the correlation. The darker the color, the stronger the correlation. The default colors of green and red identify positive correlation (green) and negative correlation (red). The colors can be changed based on user preference.

NOTE: The heat map colorization is not identifying significance or any other type of mathematical calculation. It is intended more as an art to categorize correlation strength.

Green identifies a positive correlation, so the 2 questions (such as Overall Opinion and Ease of Use) change in the same direction.

Red identifies a negative correlation, so the 2 questions (such as Overall Opinion and Did You have any Problems) change in the opposite direction.

Click the Export icon to save a fully editable file of the correlation report in either ''XLSX'' or other formats.

Correlation

2018-08-01T00:55:21Z

Mtabadmin: Created page with "Correlation Knowledge Base Article and Webinar mTAB Demonstration Correlation determines if there is a connection between two variables. When one variable changes, the other..."

Correlation Knowledge Base Article and Webinar mTAB Demonstration

Correlation determines if there is a connection between two variables. When one variable changes, the other variable changes in a specific direction.

Statistical correlation is a quantitative way to measure the direction and strength of the tendency to vary together.

-1.00 Perfect Correlation (both variables move in opposite directions)
0.00 No Correlation
1.00 Perfect Correlation (both variables move in the same direction)

Please follow these steps and guidelines to setup and run correlation in mTAB.

Begin by including questions in rows. The most commonly used question types for correlation reports run in mTAB are Likert-scale ratings questions.
Columns are not used in correlation. If a question is included in columns, it will be ignored.
Filters and including a Layer question are optional. This example includes a Brand question in Layer.
Include the question you would like to correlate the rest of the questions to at the top of the list in rows. In this example, Overall Opinion is included first, so the rest of the questions will be correlated to Overall Opinion.

Click the bottom part of the Run (lightning bolt) icon. It will expand and offer additional Run options. Click the Run Correlation icon.

If you receive a warning message that highlights any of your row questions, this most likely means that the question(s) you selected does not have any stat values assigned to it. To proceed with a correlation report, you’ll need to assign some type of stat values to the highlighted questions. Proceed by double-clicking the highlighted question. The Subset Editor will appear.

In this example, the responses (Yes, No, etc.) do not have any numeric stat values assigned to them. Assign your own values by clicking in the column to the right of the question and enter stat values for each response.

If assigning a stat value is not applicable for one or more responses, you can use the subset feature to include only the responses you’ve assigned values to. In this example, plus signs [+] indicate that Yes, No, and Yes, None Checked will be included in the correlation report. Other will not be, since it does not have a stat value assigned.
Click OK to proceed and exit out of the Subset Editor.

mTAB currently supports two types of correlation, Spearman’s and Pearson’s. By default, mTAB will run Spearman’s, but you can change the option, based on the descriptions for the type of data you would like to run.

The correlation report will run. Since a question was included in Layer (Brand question), the correlation report will include a worksheet per brand and an additional Report view sheet, which includes the correlation results for Overall Opinion for each brand.

Click on the Indicators icon

The following options are available.

Hide Significance Values: This hides the Correlation Significance rows and values (most will be 0.00) for each question.
Select Confidence Interval: Options include either 95% or 99%. The default is 95.
Significant: Values are identified in bold font. A bold font is equivalent to other programs such as SPSS assigning an asterisk to identify 95% significance and two asterisks to identify 99% significance.
Heat Map – Degree of Correlation: This option assigns colors to help categorize the strength of the correlation. The darker the color, the stronger the correlation. The default colors are green to identify positive correlation and red to identify negative correlation. The colors can be changed based on user preference.

NOTE: The heat map colorization is not identifying significance or any other type of mathematical calculation. It is intended more as an art to categorize correlation strength.

Green identifies a positive correlation, so the 2 questions (such as Overall Opinion and Ease of Use) change in the same direction.

Red identifies a negative correlation, so the 2 questions (such as Overall Opinion and Did You have any Problems) change in the opposite direction.

Click the Export icon to save a fully editable file of the correlation report in either XLSX or other formats.

Change Font Size

2018-01-29T19:24:46Z

Mtabadmin:

Changing the Font Size

Users are now able to change the font size themselves in mTAB by adjusting a few settings under Global Preferences. Changes in font size will apply to text and labels in the mTAB application as well as the data results in the spreadsheet view.

This allows for more flexibility, so each individual user can customize their experience in mTAB. With a large variation in monitor sizes and display preferences, each user can control how large or small their font size will display in mTAB.

[[File:Change_font_size_global_prefs.png|center]]

Start by going to the '''View''' menu, then click the '''Global Preferences''' icon.

[[File:Set ss base font.png|center]]

The Global Preferences window will appear. Click on the '''Spreadsheet''' section, then click on the '''Set Spreadsheet Base Font''' button.
 
 
[[File:Ss font auto.png|center]]

Under the '''Size''' options, confirm that it is set to '''Automatic'''. If a font size value such as 12 is currently being used, change that setting to '''Automatic''', then click '''OK'''.
 
 

[[File:Change_font_global_prefs_settings.png|center]]

Next, go to the '''Environment''' section. Find the '''User Interface Font Size''' setting, located at the bottom of the options.

[[File:Change_font_global_prefs_setttings_resize.png|center]]

The default font size will be set to 12.

Change the '''User Interface Font Size''' setting to something higher than 12 if you want a larger font.

Change the setting to a value lower than 12 for a smaller font.

Click the '''Apply''' button to preview the new font size.

Click the '''Close''' button to exit mTAB and apply the settings.

[[File:Change_font_global_prefs_close.png|center]]

You will be required to close the session of mTAB that you currently have open before the changes are applied.

If you want to wait for a more convenient time to restart, you can delay closing mTAB down by clicking '''No'''.

After clicking '''No''', you can continue working and the font size changes will be applied the next time you close mTAB and restart it.

Be sure to save your before proceeding. Clicking '''Yes''' will automatically close mTAB down. You will need to re-launch mTAB.
 
 

[[File:Change_font_resize5.png|700px|center]]

After mTAB opens, you should notice your font size changes in both the application labels and text and also in the spreadsheet results.
 
 

[[File:Change_font_ss6.png|700px|center]]