Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data

).
) Download Excel .
) Descriptive Statistics: Tabular (Reports) and Graphical (Visualizations).
) What type of tabular and graphical summaries based on one variable or two variable.
) Cheat Sheet with Terms for chapter.
) Epic Summary for when and how to use Column and Bar Charts.
) PivotTable to create Frequency Distribution for Categorical Variable “Payment Method”. See three calculations: Frequency, % Frequency, Relative Frequency.
) Number Formatting for the PivotTable Values Area..
) Four examples of Column and Bar charts for Categorical Data from a Frequency Distribution PivotTable.
) Change Default Settings in a PivotTable: PivotTable Options dialog box and Excel Options Default PivotTable Settings dialog box.
) Why Tabular Layout is helpful.
) #1 Rule for Visualizing Data with Charts: “No Chart Junk”..
) Linking Chart labels to cells with formula.
) Copy Chart and change elements to create a slightly different visualization with a different emphasis: Add Data Labels and remove gridlines.
)Copy Chart and create Bar chart that emphasis differences more forcefully.
) Chart Format Task Pane and Keyboard: Ctrl + 1.
) Type a new Chart Title.
) Order of category labels.
) Pareto Chart: Categorical Data Frequency Numbers Sorted in chart and add a % Cumulative Line.
) Combo Chart: Column and Line.
) Custom Number Formatting to show noting – this is done to hide axis numbers.
) Video Summary.
) Closing and Video links.