Completed
) Why Tabular Layout is helpful
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data
Automatically move to the next video in the Classroom when playback concludes
- 1 )
- 2 ) Download Excel
- 3 ) Descriptive Statistics: Tabular (Reports) and Graphical (Visualizations)
- 4 ) What type of tabular and graphical summaries based on one variable or two variable
- 5 ) Cheat Sheet with Terms for chapter
- 6 ) Epic Summary for when and how to use Column and Bar Charts
- 7 ) PivotTable to create Frequency Distribution for Categorical Variable “Payment Method”. See three calculations: Frequency, % Frequency, Relative Frequency
- 8 ) Number Formatting for the PivotTable Values Area.
- 9 ) Four examples of Column and Bar charts for Categorical Data from a Frequency Distribution PivotTable
- 10 ) Change Default Settings in a PivotTable: PivotTable Options dialog box and Excel Options Default PivotTable Settings dialog box
- 11 ) Why Tabular Layout is helpful
- 12 ) #1 Rule for Visualizing Data with Charts: “No Chart Junk”.
- 13 ) Linking Chart labels to cells with formula
- 14 ) Copy Chart and change elements to create a slightly different visualization with a different emphasis: Add Data Labels and remove gridlines
- 15 )Copy Chart and create Bar chart that emphasis differences more forcefully
- 16 ) Chart Format Task Pane and Keyboard: Ctrl + 1
- 17 ) Type a new Chart Title
- 18 ) Order of category labels
- 19 ) Pareto Chart: Categorical Data Frequency Numbers Sorted in chart and add a % Cumulative Line
- 20 ) Combo Chart: Column and Line
- 21 ) Custom Number Formatting to show noting – this is done to hide axis numbers
- 22 ) Video Summary
- 23 ) Closing and Video links
