Here is a spreadsheets which demonstrates how to perform a crosstabulation analysis with a chi-square test in Google Sheets. Google Sheets does for some reason not have a function to arrive at a p-value for chi-square distributions, but since we can arrive at an F-value by dividing the Chi-square value with the degrees of freedom, we can do just that.

Thank you to my colleague Neil Spencer for pointing me in the right direction for this solution, and to Aris Alissandrakis for giving me an excuse to try it out. Any mistakes are of course, mine, and cannot be blamed on either of these two.

The example below shows how this can be practically implemented using Google Sheets:

Google Sheet Example

For an explanation of the relationship between the distributions, see the following (external link):

How are the chi-squared and F distributions related?