opsolz.blogg.se - How to make a histogram from a frequency table in excel

A total of 3 students scored between 90 and 99.Ī histogram is also useful for answering questions about a distribution.įor example, how many students scored less than 70 on the exam?.A total of 7 students scored between 80 and 89.A total of 6 students scored between 70 and 79.

A total of 2 students scored between 60 and 69.

A total of 2 students scored between 50 and 59.

The x-axis of the histogram displays bins of data values and the y-axis tells us how many observations in a dataset fall in each bin. Lastly, we’ll add the bars to the histogram to represent the frequencies in each bin range: Next, we’ll create the x-axis of the histogram so that it ranges from the lowest value in the lowest bin to the highest value in the highest bin, by increments of 10: Step 2: Define the X-Axis of the Histogram

We can create the following frequency table using a bin range of 10 to summarize the frequency of each range of scores: Suppose we collect the following data that shows the exam scores of 20 students in some class: The following step-by-step example shows how to make a histogram from a frequency table. A frequency table is a table that shows how frequently values occur in specific ranges of a dataset.Ī histogram is a type of chart that allows us to visualize the values in a frequency table.