I have the following surveys, all national samples (for the U.S)
- Survey 1 (sample results for california)
* 27% prefer apples for breakfast
* 94% of residents of SF prefer apples for breakfast
* 59% of Californians aged 25-35 prefer apples for breakfast
- Survey 2
*39% of Californians prefer to watch Friends
*63% of residents of SF prefer to watch Friends
*11% of Californians aged 25-35 prefer to watch Friends
I want to merge these datasets where I can say the a person aged 25-35, from California, and specifically SF is X% likely to prefer apples, and X% to prefer watching Friends. So basically, I can simply have a dashboard where I choose the state, city/town, and age/gender and it gives me % of how likely they prefer certain foods, TV shows, etc.?
These are different surveys, with different respondents, and questions
When you respond, TELL ME how you will proceed. I need to know your EXACT process before proceeding!