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

 

[Kerry_J]

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 know it has been a couple of years since your post, but if you still have the file for Excel Rim weighting, I would appreciate it if you could send it to me.

 

[neda]

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.

Dear Phil,

If you are still sharing this file, I would be grateful if you could send it to: n.sutic@btinternet.com

Thanks

Neda

 

[helloritu83]

Hi..I know the post is quite old but is it possible to send me the excel at helloritu83@gmail.com
I work at Seoul (South Korea).

Thanks

 

[markjames]

Hi guys - can someone send me the excel sheet referred to please?
mark@otherlines.com

many thanks,
mark

 

[abbychic]

Hi all,

Can someone send me the spread sheet with the RIM weighting please? abbychic2000@yahoo.co.uk

Many thanks,
Abi.

 

[Bhupinder Pal]

Hi All,

I also need RIM weighting Example in Excel, someone please send me the spread sheet? pal_bhupinder83@yahoo.co.in

Many thanks,
Bhupinder.

 

[Ivo_Sandev]

Hi all,
I'll be very thankful to send me the excel sheet: wasteoftime@abv.bg

Many thanks,
Ivo

 

[Basao123]

Dear Phil,

If you are still sharing this file, I would be grateful if you could send it to: polivka@centrum.cz

Many thanks

Jan

 

[sallymacgill]

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, as I think this is exactly what I'm looking for as well.

Many thanks in advance if you can send to me at sallymacgill@onetel.com.

Best
Sally

 

[djphilthy]

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 or anyone else

I know this is quite old, but I'd be very interested to have a look at this spreadsheet to if possible - please could someone send it on to me @ djphilthy2006@yahoo.co.uk

Many thanks,
Phil