Using Pivot table, IF Function and charts

[thakur]

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 understand and analyse the data which I am currently working on to practice more..I also wanted to calculate avg of listening category using pivot table.


here is the sample data..


NAME ROLE SENTCON VOCAB FLUNCY PRONCT LISTNING TOT SCR

CAND 1 VOICE 2 3 3 2 2 14

CAND 2 VOICE 3 3 3 3 3 18

CAND 3 VOICE 2 3 3 2 2 14

CAND 4 VOICE 2 3 3 2 2 14

CAND 5 NON V 2 3 3 2 2 14

CAND 6 NON V 2 3 3 2 2 14

CAND 7 NON V 2 3 3 2 2 14

CAND 8 NON V 3 3 3 3 3 18

CAND 9 NON V 2 3 3 2 2 14

CAND 10 VOICE 3 3 3 3 3 18

CAND 11 NON V 3 3 3 3 3 18

CAND 12 VOICE 2 3 3 3 3 16

 

[SirJB7]

Cross posted here:

http://chandoo.org/forums/topic/data-analysis-on-sample-data