Frequency Distribution and Chart - discrete as well as grouped (By Pivot table, Pivot Chart).

Frequency Distribution - discrete  (ungrouped) (By Pivot table) :

To create frequency distribution through pivot table is quite easy .

We, already covered frequency distribution with complex formulas in below blogs. See the links for detail.

http://myresolution-to-learn-excel-daily.blogspot.in/2013/12/creating-unique-list-of-variable-and.html

http://myresolution-to-learn-excel-daily.blogspot.in/2013/12/grouped-frequency-distribution-class.html


Let's begin ,

Here we have data of student's marks .

From insert tab, create Pivot table. I choose "existing worksheet" radio button instead you can also choose "new worksheet" , choice yours.

In Pivot Table Field List, put Score in both "Row Labels" as well as "Values". Since we need "count of score" instead "sum of score", select "Value Field Settings.." as shown below. 

In "Value Field Settings" , from tab "Summarize Values By " select "Count".

And yeah ! here we done discrete frequency distribution . Simple !

Frequency Distribution (Grouped) :

Same procedure as with ungrouped frequency distribution. For Grouped data , we further need to add little step :

In PivotTable Tools , from Options tab select "Group Selection".

Group Selection Dialogue Box appears like as shown in below print shot. And in that dialogue box, enter starting and ending values with the width of classes lets say 5. 

And here we done with our grouped frequency distribution .

You can also customized grouping score with different width . Like if you want to grouped as "below 35" , "between 35 to 75" , and "above 75".

For that, same way select "Group selection" and group it manually . Like in this example, I used to enter middle class interval i.e for "between 35 to 75" which automatically make the classes of "below 35" and "above 75". Enter in "Starting at" value 35 and in "Ending at" value 75. and in "By:" value 20 (difference of 75 and 35).Click Ok.

Result are shown in below printshot :

Frequency Chart, can be done with pivot chart.

Select pivot chart instead of pivot table from insert tab . As pivot chart opens both pivot table and pivot chart. Then in Axis field put "Score" and in Values field put "Count of Scores". From Group Selection in PivotTables Tools, grouped it as per your choice, here the magnitude of classes is 5 . Once, this is done pivot chart shown like below:

Thank you !!