Hi,
There are two Groups of Data:
GROUP A
From A TO D there are initial values.
From E TO H there are values which have occured more than once.
For Group A there are 2 tasks to be completed.
The first task is to arrange the rows in E TO H according to the number of times it has occured at A TO D in descending order as followes:
As "43,5,40,18" has occurred the maximum number of times which is 4 times so it is on top then follows "19,18,16,12" & "6,7,12,41 as they have occurred 3 times each, then there is "4,9,30,18"
at the bottom because it has occurred the minimum number of times which is 2 times.
The second task is to display the frequency of each rows From I TO L at M as follows:
AS "43,5,40,18" has occurred 4 times in A TO D there is 4 at M1, "19,18,16,12" and "6,7,12,41" has occurred 3 times each in A TO D there is 3 at M2 and M3 respectively, then "4,9,30,18" has
occurred 2 times in A TO D there is 2 at M4.
GROUP B
From N TO P there are initial values.
From Q TO S there are values which have occured more than once.
For Group B there are 2 tasks to be completed same as in Group A.
The first task is to arrange the rows in Q TO S according to the number of times it has occurred at N TO P in descending order as follows:
As "43,5,40" has occurred the maximum number of times which is 4 times so it is on top then follows "19,18,16" & "6,7,12 as they have occurred 3 times each, then there is "4,9,30"
at the bottom because it has occured the minimum number of times which is 2 times.
The second task is to display the frequency of each rows From T TO V at W as follows:
AS "43,5,40" has occurred 4 times in N TO P there is 4 at W1, "19,18,16" and "6,7,12" has occured 3 times each in N TO P so there is 3 at W2 and W3 respectively, then "4,9,30" has
occured 2 times in N TO P there is 2 at W4.
Thank you so much for your admirable support.
Bookmarks