Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

ExcelIsFun via YouTube Direct link

) Frequency Distributions defined

17 of 34

17 of 34

) Frequency Distributions defined

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Introduction to topics in video
  2. 2 ) Tabular Reporting goals for this video: 4 Different Frequency Distributions
  3. 3 ) PivotTable to create Frequency Distribution from Nominal Data that is located in the worksheet
  4. 4 ) What is the PivotTable Cache?
  5. 5 ) Introduction to PivotTable User Interface
  6. 6 ) Change calculation in PivotTable with: Summarize Values By and Shows Values As
  7. 7 ) Alt Keyboard Efficiency Tricks to create PivotTable and other features
  8. 8 ) Power Query to Import & Transform CSV file with table of data
  9. 9 ) What is a CSV File? What is a Delimiter?
  10. 10 ) Where is the Power Query tool in Excel?
  11. 11 ) What are Data Types in Power Query? And why are they Important!
  12. 12 ) Merge two fields to create one element field
  13. 13 ) Load Power Query Table to Excel Worksheet
  14. 14 ) Edit Query after it has been loaded
  15. 15 ) Terms to describe the table, fields and data.
  16. 16 ) Frequency Distributions for different types of data
  17. 17 ) Frequency Distributions defined
  18. 18 ) Frequency Distribution for Nominal Data, using a PivotTable.
  19. 19 ) Frequency Distribution for Discrete Quantitative Data, using a PivotTable and the Grouping Feature
  20. 20 ) How to Group in a PivotTable and create Upper and Lower Limits for Counting Categories.
  21. 21 ) Use Field Settings to show categories without data.
  22. 22 ) Change Grouping Categories
  23. 23 ) Grouping Categories Created for Discrete Quantitative Data
  24. 24 ) Frequency Distribution for Continuous Quantitative Data, using a PivotTable and the Grouping Feature
  25. 25 ) Grouping Categories Created for Continuous Quantitative Data
  26. 26 ) What happens to PivotTable when Source Data Changes?
  27. 27 ) Refreshing a PivotTable to allow new data into Report
  28. 28 ) Fixing Ambiguous Grouping Categories in a PivotTable with Decimal Number Data. Three Methods.
  29. 29 ) How Grouping works with PivotTable Cache.
  30. 30 ) How to create Multiple Grouping Categories from a Single Data Source using PivotTable Wizard QAT Button or Keyboard: Alt, D, P.
  31. 31 ) Summary of video
  32. 32 ) How to Printout Notes from Excel Workbook File
  33. 33 ) Homework files to download from in Canvas
  34. 34 ) Closing and Video Links

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.