Timeline for how to run a two way ANOVA in excel on summary data: counts of consumers
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 13, 2019 at 14:38 | comment | added | LeeZee | How can I deal with not having standard deviations or means if this is summary count data? It's being treated like each of the age groups is a separate level of the factor age group, and each level has an N of 1. Does anyone have clarity on the best way to run the 2-way ANOVA test in SPSS given my situation? | |
| Sep 11, 2019 at 18:37 | comment | added | LeeZee | Thank you for your suggestions user2974951 and Sal--I will look into them. Sal, when you say treat the independent variables as continuous predictors, can you clarify? When I hear predictors, I think of a correlation rather than an ANOVA. | |
| Sep 9, 2019 at 20:11 | comment | added | Sal Mangiafico | I suspect with kinds of counts you have (large and varied), it may not be bad to use a general linear model (anova). Since both of your independent variables are ordered, you may want to consider this, perhaps treating them as continuous predictors or using a linear contrast along with treating them as categorical in the model. | |
| Sep 9, 2019 at 18:24 | history | edited | LeeZee | CC BY-SA 4.0 |
edited for clarity
|
| Sep 9, 2019 at 18:13 | history | edited | LeeZee | CC BY-SA 4.0 |
Edited for clarity
|
| Sep 9, 2019 at 6:29 | comment | added | user2974951 | You could use a (Poisson) generalized linear model, which is an extension of the Chi-square test for count data allowing for interactions and main effects. | |
| Sep 9, 2019 at 1:51 | history | edited | LeeZee | CC BY-SA 4.0 |
edited for clarity
|
| Sep 8, 2019 at 23:42 | history | asked | LeeZee | CC BY-SA 4.0 |