how to make a frequency distributrion in excel for a mac

For creating a pivot table, we have to go to the insert menu and select pivot table. Create a Pivot Table for the above sales data.

Now we will see how to use this using a pivot table with the following steps. One of the easiest ways to make excel frequency distribution is using the pivot table so that we can create graphical data.Ĭonsider the below sales data which has a year-wise sale. This example shows how to make excel frequency distribution using graphical data with the available sales database. Now using the Excel Frequency Distribution, we have grouped the student’s marks with mark wise which shows students has scored marks with 0-10 we have 1 student, 20-25 we have 1 student, 50-55 we have 1 student, and 95-100 we have 1 student as shown below.Įxcel Frequency Distribution Using Pivot Table

Once we hit the CTRL+SHIFT+ENTER, we can see the open and closing parenthesis as shown below.

So that we will get the values in all the column.As shown in the above screenshot, we have selected column as data array and Bin array as Student marks =FREQUENCY (F3:F9, C3:C22) and go for CTRL+SHIFT+ENTER.Here we need to select the entire frequency column then only the frequency function will work properly, or else we will get an error value.Use the frequency formulation on the G column by selecting G3 to G9.Now using the frequency function, we will group the data by following the below steps. Now in order to calculate frequency, we have to group the data with students marks, as shown below.

How to make a frequency distributrion in excel for a mac