Go to Data Menu on the right top we can find the data analysis. We will see how to apply histogram by following the below steps. We can find a histogram in the data analysis group under the data menu, which is nothing but add-ins. how much tins have been sold out for specific salespersons. CP is nothing but Consumer Pack and Tins are range values, i.e. 
Go to the Insert menu and select the Column chart.Įxcel Frequency Distribution Using Histogramīy using the pivot table, we have grouped the sales data now, we will see how to make historical sales data by Frequency Distribution in excel.Ĭonsider the below sales data for creating a histogram which has Sales Person Name with corresponding sales values.We can see that Sales data has been grouped by 1000 with Minimum to Maximum values, which can be shown more professionally by displaying in graphical format. After that, we will get the below following result where sales data has been grouped by 1000 as shown below:.
Edit the grouping numbers starting at 5000 and ending at 18000 and it Group By 1000 and then click ok. So that we will get the grouping dialogue box as shown below:. Click on the row label sales number and right click then Choose Group option. Make sure that we have selected the pivot field setting to count to get the sales count numbers shown below. 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.
0 kommentar(er)
