Please analyise the given data and provide your insights in how can I use pivot table and functions of excel
Hi,
I am providing the link which has sample data
https://www.dropbox.com/sh/tovdou4mt5hgrfe/KD878psFt2
The total score the candidate can score is 30
cutoff scr is 25
1. I wanted to create three buckets
bucket 22, bucket >=24 and bucket 25
2. How do I create "Biggest contributor" performed by the candidate in all the parameters?
3. Which parameter a candidate has just missed with the cutoff score.?
4. Can you also help me with the charts and graphs to show the improvement areas in all the parameters?
Please advise
Thakur
Attachment | Size |
---|---|
SAMPLE DATA1.xls | 191.5 KB |
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago