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 Descriptive StatisticsSan Jose State University via Udacity Information Visualization: Programming with D3.js
New York University (NYU) via Coursera Plots (Graphics) for Data Science
Coursera Project Network via Coursera Data Analysis and Visualization Foundations
IBM via Coursera مقدمة لتحليل البيانات باستخدام جدول البيانات
Coursera Project Network via Coursera