# Recent content by Ewa

1. ### Finding Correlations

Thank you!!!!! This is soooo helpful I could kiss you! What would I need in order to spit out this spreadsheet, dendrogram, and scatterplot (besides an advanced degree in mathematics ;) )? Can I do it in Excel? Do I need another software? When I tried scatterplot in Excel it only graphed one...
2. ### Finding Correlations

So the way I should be reading this is that responses 7, 19, 31, 35, 56, 89, 118, 143, 171, 180, 268, 269, 276, and 342 all belong to the same cluster.... and so on and so forth.... Is that correct? You said there were 13 clusters but the spreadsheet shows 18. Does that mean that the similarity...
3. ### Finding Correlations

Thanks for all your help! I'm afraid I need more tangible answers. You say my data appear "to condense to 2 factors of importance"? What are they? I should be looking at 13 clusters? How did you get 13? Is it possible to condense even further? How do I perform cluster analysis? Do I need...
4. ### Finding Correlations

For a second there I thought I understood: I figured that the numbers in parentheses represented values in my columns. But the 8 and 9 threw me off. Am I looking at two segments? One that represents people who hardly ever create or edit menus and are not very tech or design savvy and another...
5. ### Finding Correlations

I'm trying to find a way to segment the population based on the answers in the survey, so I can understand people's behaviors, their needs and frustrations in order to build personas. But I have no inkling about how to parse the data I've collected. If it were only a few responses, I could...
6. ### Finding Correlations

Thank you for replying to my question, which clearly is not stated very clearly :S After watching a number of youtube videos, I learned that the matrix shows a negative correlation between design abilities, food and menu creation, and tech savviness. What does that mean exactly? What else can I...
7. ### Finding Correlations

I'm trying to find some clusters/ segments or correlations between data based on survey results. I've attached a simplified version of the data. Can anyone help me make sense of it? I would be most obliged. Thanks.
8. ### Latent Class Analysis for User Segmentation

Hi! I am a UX researcher, and I am trying to use both qualitative and quantitative methods to identify personas, types of users. To that end, I am going to send out a survey to a large sample of our users, identify segments using some statistical clustering technique, determine key variable that...