Summary
Keywords
Full Transcript
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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
