Statistics - 2.1 Frequency Distributions

In this video, we will learn about frequency distributions and pivot tables in Excel. We'll see how to create a frequency distribution, determine its characteristics, and use pivot tables to summarize the data. If you're looking to learn more about pivot tables in Excel, then this video is for you! By the end of this video, you'll have a better understanding of how to use pivot tables to analyze data. Now go and make your data Analysis dreams a reality! 00:00 Intro 00:05 Frequency Distributions 01:01 Frequency Distributions by Hand 05:13 Frequency Distributions (Pivot Tables) in Excel 08:57 Characteristics: Class Boundaries 09:56 Characteristics: Class Midpoint 10:44 Characteristics: Relative Frequency 12:40 Characteristics: Cumulative Frequency 13:13 Overview Slide 13:23 Putting it all Together 16:41 Putting it all Together in Excel 19:25 Up Next This playlist follows the text, Beginning Statistics, 3rd ed, Warren, Denley, Atchley Power Point: https://bellevueuniversity-my.sharepoint.com/:p:/g/personal/kbrehm_bellevue_edu/EcYPj8NPLyBDtIUZzyJiZisBSHF2sl5QcRJ1-jvEAYjCDw?e=OlIacZ Excel Data: https://bellevueuniversity-my.sharepoint.com/:x:/g/personal/kbrehm_bellevue_edu/EZ6z8C3sRKFGitWoYmTjYswBtXdpUfAX645U3vD1q6OeYA?e=McFMNw The playlist can be found here: https://www.youtube.com/playlist?list=PLl-gb0E4MII1dkfGxmdt8YA0Dgabdvdmq