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