RIM weighting in Excel, is it possible?

[ricknye]

Hi

I don't know if anyone can help, but I'm wondering whether it is possible to use an Excel formula or VBA routine to weight individual cases of data using multiple variables so that my overall sample is representative of the general population as a whole for variables such as gender, age, region and social grade - I obviously have target weights for each of these variables.

I am currently using SPSS Advanced Models and a rake weighting module written in Python to do this but would like to be able to eliminate SPSS from the process altogether if I could.

Has anyone succeeded in doing this in Excel? Or could anyone provide me with any pointers?

Many thanks

Rick Nye

 

[Connie Ng]

Yes, it is possible in Excel. I have a working example that I can send to anyone who is interested. However, you may find specialist market research software programs are more versatile than Excel.

Hi Phil,

I'm really hoping you're still there, thanks in advance if you can send the excel file to me at: nch1016@ymail.com

Many thanks
Connie

 

[KatK6]

Hi Rick, I'm interested in how you generate frequency tables that take into account the weighting factor? Do you multiply everything out in a separate sheet or build the weight condition into the formulas?

 

[jonjshotton]

Hi Phil,

I know this is very old, but if possible could you please share your Excel file with RIM weighting in, that would be much appreciated!

Thanks,
Jon

 

[enohpascal]

I know this is old, but does anyone have a copy of this rim macro?

 

[Phil_Hearn]

The free Excel rim weighting model is available from MRDC Software website. There's more info in this blog article here. If you use the "You Ask, We Answer" feature on the website, it will be sent to you.