felipeplatzer
New Member
- Joined
- Sep 15, 2018
- Messages
- 1
Hi all,
I am analyzing a survey where people rank several product attributes on a scale from 1 to 5. I want a frequency distribution (of how many people selected 1,2,3,4,5) for all attributes in one table. Is this possible, preferably with PivotTables? I want to avoid using formulas like COUNTIF, because I want to be able to generate data cuts easily without re-writing the whole formula again.
Thanks a lot!
This is the raw data:
<tbody>
</tbody>
This is the table I need:
<tbody>
</tbody>
I am analyzing a survey where people rank several product attributes on a scale from 1 to 5. I want a frequency distribution (of how many people selected 1,2,3,4,5) for all attributes in one table. Is this possible, preferably with PivotTables? I want to avoid using formulas like COUNTIF, because I want to be able to generate data cuts easily without re-writing the whole formula again.
Thanks a lot!
This is the raw data:
Product color | Product look and feel | Product price | Product's ease of use | |
Respondent 1 | 1 | 5 | 5 | 3 |
Respondent 2 | 4 | 4 | 5 | 1 |
Respondent 3 | 3 | 2 | 5 | 1 |
Respondent 4 | 4 | 3 | 5 | 1 |
... | ... | ... | ... | ... |
<tbody>
</tbody>
This is the table I need:
Product color | Product look and feel | Product price | Product's ease of use | |
% of respondents rating it 1 | 20% | 20% | 0% | 70% |
% of respondents rating it 2 | 0% | 20% | 0% | 20% |
% of respondents rating it 3 | 40% | 20% | 0% | 10% |
% of respondents rating it 4 | 40% | 20% | 10% | 0% |
% of respondents rating it 5 | 0% | 20% | 90% | 0% |
Total | 100% | 100% | 100% | 100% |
<tbody>
</tbody>