Excel Statistics 15: Category Frequency Distribution w Pivot Table & Pie Chart

See how to use create a Frequency Distribution, Relative Frequency Distribution, Percent Frequency Distribution and Pie chart with a Pivot Table (PivotTable) and a Pivot Chart for Categorical Data.

See how to create a Pie Chart (compare the parts to the whole)

Chapter 02 Busn 210 Business and Economic Statistics and Excel Class

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• Relative
• Percent
• Frequency
• Distribution
• Pie
• chart
• with
• Pivot
• Table
• and
• Chart

[JJTheBigDog]

when i want to rename the title in the pivot table, an error message pops up, telling 'cannot change this part of a pivot table report.'

what's the problem?

[ExcelIsFun]

Right-click PivotTable, Clcik on PivotTable Options, Display tab, check checkbox for Classic PivotTable layout.

[RandyKelly19]

My data is the same for the 1st Pivot Table, but I have two Headers - one says Count of Product (Boomerang Name) below that Says Product (Boomerang Name) It allows me to modify the "Product (Boomerang name), but not the other Header or the "Total" Header... Not sure if that will make since, but wasn't sure why I couldn't modify the header without an error

[ExcelIsFun]

I am not sure why that is happening.

[domi2020]

Hi

Great job!! Do you know what the alternative short cuts are on mac excel??

I just dont get the same response with my mac. Thanks

[ExcelIsFun]

I do not know the MAC.

Try asking Excel questions at the best Excel question site around:

mrexcel[dot]com/forum

[xXblahismahblahXx]

He has so much enthusiasm lol Thanks for the vid! Helped a lot!

[dragon1501]

I'm trying to do a frequency table with the cases as numbers and they are giving me very large numbers for frequency. how do I fix this?

[ExcelIsFun]

I am glad that it was useful for you!

[snharinder]

its really useful