Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data

Overview

Dive into a comprehensive video tutorial on creating frequency distributions and visualizations for categorical data in Excel. Master the art of crafting effective column and bar charts, learn to use PivotTables for frequency distributions, and explore advanced techniques like Pareto charts and combo charts. Discover essential tips for data visualization, including the "No Chart Junk" rule, custom number formatting, and linking chart labels to cells. Gain practical skills in manipulating chart elements, changing default PivotTable settings, and creating impactful visualizations that emphasize key data points. Perfect for Excel users looking to enhance their statistical analysis and data presentation skills.

Syllabus

).
) 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.