Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula

Описание к видео Excel 2013 Statistical Analysis #09: Cumulative Frequency Distribution & Chart, PivotTable & Formula

Download files: https://people.highline.edu/mgirvin/A...
Topics in this video:
1. (00:09) Overview of % Cumulative Frequency
2. (00:42) Formulas to create Cumulative Frequency Distribution and % Cumulative Frequency Distribution.
3. (04:17) % Cumulative Frequency (Ogive) Chart using X-Y Scatter Chart
4. (07:36) PivotTable to create Frequency Distribution and % Cumulative Frequency Distribution.
5. (10:30) Combine Chart that shows Frequency Distribution as a Column Chart with No Gap width and % Cumulative Frequency as a Line.
6. (11:43) Custom Number Formatting to hide all values using three semi-colons

Комментарии

Информация по комментариям в разработке

Похожие видео