When you choose to relate two Categories to each other, Statwing produces a “crosstab”. Below is one such crosstab, from a survey of 10,000 software developers, showing the relationship between the size of the company at which they work and their job satisfaction:
Initially, each column in the crosstab sums to 100%. So, of developers at companies with 1,000 to 3,000 employees, 20.9% say they love their job.
Above we asked, “Of developers in companies of 1,000 to 3,000, what percent love their job?” We can also reverse the question, asking “Of developers who love their job, what percent are in companies of 1,000 to 3,000?”
To answer that question, select “Row %” from the options above the chart, and the table will change to this:
Of developers who love their job, 5% are at companies with 1,000 to 3,000 employees. Depending on your data, one or the other ways of looking at the data may be more interesting. If you were a developer trying to choose how large a company to work for, you’d probably be most curious about which size has the highest proportion of its developers loving their job, so you’d be more interested in the first table, the “Col %” table.
Of course, by selecting “Count” you can see the same table as just the number of developers in each group:
Or you can also see that number a proportion of the total number of developers surveyed:
The green and red arrows indicate cells that are statistically significantly lower or higher than expected. That is to say, if there was no relationship between size of company and levels of job satisfaction, you would not expect to see such a high number of developers at very small companies that love their job. Cells can contain up to three arrows, indicating varying degrees of statistical significance.
Another way to think of what those arrows mean:
For more details, see our crosstab technical notes.