I have a simulator built in excel that includes individual part worth utilities, and individual share of preference.
I'd like to test for sig difference in SOP between 2 mutually exclusive groups (cell1 and cell2).
From previous posts that I saw on the topic, I saw that this can be done utilizing a t-test.
t = (cell1 share - cell2 share)/sqrt( (SE cell1)^2 + (SE cell2)^2 )
My uncertainty is how to calculate SE for the 2 cells.
Should SE for a particular cell =
where 'share' = the aggregate level share, reported in the simulator for that cell
(2) SE = standard deviation of respondent level shares within that cell/sqrt(n)
where n = the size of that cell.