## Z-tests and T-tests in Cross-tabs and charts

Z-tests can be added to crosstabs where values are column based percentages.

T-test can be added to crosstabs where values are mean values, or to the mean row added to a percentage cross table.

With a checkmark for testing each column against the total, OfficeReports will add colors to all the numbers in cells which shows significantly higher (green) or lower (red) results than the Total.

If you uses a test on two confident levels, for example 95% and 90%, OfficeReports will show the colored numbers bold for the highest levels and regular for the lowest level:

In charts the the significant differences and colors can be displayed in number of different ways, for example:

With a check mark for testing for Combination of Columns (excluded the Total) are tested against each other. OfficeReports will give each column a letter (A, B, C, etc.)

If you uses a test on two confident levels for example 95% and 90%, OfficeReports will, in tables, show the Capital letters for significantly higher at the highest level, and Lower case letters for significantly higher at the lowest level. Default, OfficeReports will test all combinations of columns: