Hello, I abandoned SPSS a few months ago and have been using excel to do most of my thesis analysis.
The one thing I can't work worked out how to replicate in Excel is apply sample weights before running frequencies/counts. Can they be calculated within a COUNTIFS formula using a SUMPRODUCT function?
I'm working mostly with simple formulas like:
=(COUNTIFS(DATA!$A$3:$A$10,1,DATA!$B$3:$B$10,1))
How can I adapt this so the figure calculated take into accounts the various weights assigned to respondents 3 through 10? They are held in DATA!$C$3:$C$10 (as an example).
Any help would be appreciated.
The one thing I can't work worked out how to replicate in Excel is apply sample weights before running frequencies/counts. Can they be calculated within a COUNTIFS formula using a SUMPRODUCT function?
I'm working mostly with simple formulas like:
=(COUNTIFS(DATA!$A$3:$A$10,1,DATA!$B$3:$B$10,1))
How can I adapt this so the figure calculated take into accounts the various weights assigned to respondents 3 through 10? They are held in DATA!$C$3:$C$10 (as an example).
Any help would be appreciated.
