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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |