Grouping data within intervals
Hi Mangesh,
thank you for the answer.
Tha frequency function "only" counts the data array and allow to test
several possible ditributions of this variable.
Given the example:
Data Bins
Array Var B Array Frequency
1 High 3 3
5 Medium 5 2
10 Medium 8 2
8 High 10 4
9 High
10 Medium
2 Low
3 High
5 Low
8 Low
9 Medium
The FREQUENCY function counts the number of items of the data array
into the bins array. I need something more...I would like to associate
every single item with the class, in order to make a cross analysis of
the Data array and Variable B, within a pivot table.
In the example the function I need should insert a column Class:
Data Bins
Array Class Var E Array Frequency
1 3 High 3 3
5 5 Medium 5 2
10 10 Medium 8 2
8 8 High 10 4
9 10 High
10 10 Medium
2 3 Low
3 3 High
5 5 Low
8 8 Low
9 10 Medium
And the pivot table would be as follows:
Count of
Data Array
Var E
Class High Medium Low Grand
Total
3 2 1 3
5 1 1 2
8 1 1 2
10 1 3 4
Grand
Total 4 4 3 11
Thank you.
Bye.
Massimo
|