Forum Discussion
Stephanie0412
Aug 20, 2020Copper Contributor
Excel question
Hello. From a spreadsheet, I have calculated the percentage of answers for each category rating that we have within the company. However, we have goals that we would like to achieve (70, 20, 10). ...
PReagan
Aug 20, 2020Bronze Contributor
Hello Stephanie0412,
If 3% of the 667 entries are rating "a", then this equates to about 20 entries equal to rating "a".
If 5% of the 667 entries are rating "a", then this equates to about 33 entries equal to rating "a".
Thus the difference would be, an additional 13 entries should upgrade to rating "a".
For x%, that would be 667*(x%-3%)
- Stephanie0412Aug 20, 2020Copper ContributorThank you!
- PReaganAug 20, 2020Bronze Contributor