1. I have 2 categorical variables, Gender (Male, Female, Other) and social media use (Instagram, other social media). I ran a 2 way Chi-square test but one of my cells had an expected count of
You can also try a generalized linear model (GLM)! A search on Google shows a number of YouTube video on how to implement a GLM via SPSS. I also used this measure extensively in my initial research - refer to my ResearchGate profile for examples of the research output.
Kindly have a look at this study which describes using a cut-off score.
"Determination the cut-off point for the Bergen social media addiction (BSMAS): Diagnostic contribution of the six criteria of the components model of addiction for social media disorder"
Once you use the cut-off score then you will have a categorical variable. People at risk of addiction and those who are not.
The way of doing the Fisher Exact test is
1. Open the data view of your spss sheet. Go to analyze - descriptive statistics - Cross tabs - Exact tests - select Exact and un-select time limit per test and - continue
2. Below Exact tests would be statistics - click on Chi square - continue.
3. Below statistics would be cells - in percentage select row (or) column what ever best suits you - continue
4. On the Crosstabs interphase you will have to select row and columns. Select Age in the row column and the prevalence of social media addiction (Categorical variable) in the column. - continue. This will give you your Fisher Exact test.
In the chi-square test number 4 would be the Fisher's Exact Test. Check the Exact Sig (2-sided) value. This is your answer. Check the significance level and report the results (X2=.........; p