Главная
Study mode:
on
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
Description:
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.

Excel Statistical Analysis - Frequency Distributions & Visualizations for Categorical Data

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization #Bar Charts #Mathematics #Statistics & Probability #Categorical data #Frequency Distribution #Data Analysis #Spreadsheets #PivotTables #Column Charts
0:00 / 0:00
1 of 23

)