How to: Overlay Histograms and Data Analysis Tool Pak In Excel

WHAT IS A HISTOGRAM: (Measures Count/Frequency, Data is in Groups/Bins, No gaps between Columns) 0:35 Making Pivot table: 1:25 Placing Pivot table on existing worksheet: 1:33 Creating Bins/Groups 2:10 Creating a histogram 3:05 Removing gaps between columns 3:15 Adding Borders 3:30 Adding Categorical data to Pivot table (For histogram) 4:26 Creating Overlayed Histogram 5:00 Series Overlap (OVERLAYING THE TWO DATA SETS) 5:35 Making Dual Histogram Readable (Creating Transparency) 6:09 Points of central Location (Auto-Calculate) [Start-New Section] 7:25 Sorting your Data 8:28 Auto Calculating Mean, Median, Range 8:43 (Finding Data Analysis Button) 8:07 Discussing the Findings 10:35 Closing Notes 12:10 Ask me questions: bit.ly/YorJeFB