Statistics: descriptive statistics: Cross Tabulation and Chi-Square
Perform cross tabulation analysis
This feature is for OriginPro only.
crosstab row:=col(B) col:=col(G) lay:=col(C);
Please refer to the page for additional option switches when accessing the x-function from script
Input
Range
Specify data from a column as row variable.
Specify data from a column as column variable.
Specify data from a column as layer variable. When a layer variable is specified, the Cross Tabulation between the row and column variable will be created at each level of the layer variable.
If data is summarized as frequency data mode, specify the frequency column as frequencies variable.
TreeNode
It determines which statistics to calculate and output in the Contingency Table.
double
Specify the significant level for the following hypothesis testing.
int
Specify whether to perform Chi-Square Tests to determine whether there is a significant relationship between variables in the contingency table.
Note: To learn more details for these statistics, see the introduction, algorithm and the interpreting results page
Specify whether to perform Fisher's Exact Test to determine whether there is a significant relationship between variables in the contingency table.
It determines which statistics to calculate to assess the strength of the relationship between the variables in the contingency table.
Specify whether to perform this test to measure and test the agreement of matched-pairs data.
Specify whether to analysis the relationship of multiple contingency tables, including conditional independence test, odds radios’homogeneity test and common odds radio.
Specify whether to calculate Relative Risk to measures the ratio of the odds of an event occurring in an group to the odds of the event occurring in a comparison group.
Specify whether to calculate Odds Ratio to measures the ratio of the odds that an event or result will occur to the odds of the event not happening.
Specify whether to display Mosaic Plot whose area of each rectangle is proportional to the proportions of the Y variable in each level of the X variable.
Output
ReportTree
Specify the sheet for the crosstab result. The default value is a new sheet in the workbook of input data.
ReportData
Specify the sheet for the mosaic plot data. The default value is a new sheet in the workbook of input data.
Cross tabulation is particularly useful for analyzing categorical data. In these analyses, a contingency table is used to display the frequency distribution of two or more variables. Analyses based on the table can determine whether there is a significant relationship between variables, and assess the strength of the relationship between the variables.
Options Tree Details
For more information, please refer to our User Guide.
This example shows how to perform the Cross Tabulation. To get the interpretion of the Results, please refer this page.
// Import data file newbook; impASC fname:=system.path.program$+"\Samples\Statistics\MontanacOutlookPoll.dat"; // Preparing data for analysis. Set three columns as Categorical. wks.col2.categorical.type=2; wks.col3.categorical.type=2; wks.col7.categorical.type=2; //Performing Cross Tabulation crosstab -r 2 row:=[MontanacOutlo]MontanacOutlookPoll!B"Age" col:=[MontanacOutlo]MontanacOutlookPoll!G"Financial Status" lay:=[MontanacOutlo]MontanacOutlookPoll!C"Sex" mosaic:=1;