In this lesson, we are going to be talking about how to create frequency distributions in Excel from raw data. In order to create these distributions, we need to go first from the data to frequency tables, then from the tables we will go to the visualizations. The reason we want to do this is oftentimes when we look at raw data it is really hard to make sense of. It is just rows and rows of data. When we summarize and visualize that data we get a sense of what it looks like. We are going to be talking later about actual shapes of distributions.
Lecture Slides are screen-captured images of important points in the lecture. Students can download and print out these lecture slide images to do practice problems as well as take notes while watching the lecture.
This book provides a clear and methodical approach to essential statistical procedures. It clearly explains the basic concepts and procedures of descriptive and inferential statistical analysis. This book features a new emphasis on expressions involving sums of squares and degrees of freedom as well as a stronger stress on the importance of variability.