Search results

Hi Hui, The Biggest in all categories, which candidate has contributed his best in all the parameters "Sentence Construction", "Vocabulary", "Fluency", "Pronunciation", "Listening & Comphrehension", "Volume, Intonation, PACE". My question is which candidate has given 4 or 5 in all the...

Hi Narayan, 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...

Hi Narayan, I tried uploading the workbook but unable to do so. Can you please tell me how to upload or attach workbook so that it will be easier for you to understand the data. Regards, K.K.Singh

Hi Narayan, Thank you so much for clarifying. However I have bigger data sets to create bucket system to anaylise the given data. How do I create buckets of any value in excel and which function can be used to create these buckets.. Please advise.

Hi Narayan, Sir, My question is How do i get details from the data if any candidate is falling short of some points to meet the cuttoff mark in all the parameters. Can I show this using pivot table... Also get which candidate is having full points in all the parameters and find improvement...

Hi Narayan, Thank you for the chart..This is one method of showing the data. However, my question How do i get details from the data if any candidate is falling short of some points to meet the cuttoff mark in all the parameters. Can I show this using pivot table... Also get which candidate...

thakur Hi Chandoo.. Using pivot table, if function and charts can I show the improvement areas on each parameter in the sample data based on the scores. Can you show me different ways to see improvements on the sample data provided using functions, pivots and charts or any other method to...

Hi Narayan, Using pivot table, if function and charts can I show the improvement areas on each parameter in the sample data based on the scores. Can you show me different ways to see improvements on the sample data provided using functions, pivots and charts or any other method to understand...

Hi Chandoo.. I have a sample data which is basically to evaluate candidates based on the score meeting criteria. Name of the candidate, role, parameters like pronunciation, listening, vocabulary, fluency and total score column The maximum score the candidate can get is 20 and the cut-off...