Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data
Offered By: ExcelIsFun via YouTube
Course Description
Overview
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.
Taught by
ExcelIsFun
Related Courses
Intro to StatisticsStanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent