E
Eric
Does anyone have any suggestions on how to do the calculation?
There is a list of raw data under column A
50, 52, 53, 53, 55, 56
There is a list of numbers under column B
3%, 9%, 5%, 4%, 8%, 8%
I would like to create a matrix to count the frequency
On X-axis, 50, 51, 52, 53, 54, 55, 56
On Y-axis, 0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9%
Does anyone have any suggestions on how to set the formula to determine the
frequency? For example, 4% & 5& will count 1 for each for the number 53.
Thanks in advance for any suggestions
Eric
There is a list of raw data under column A
50, 52, 53, 53, 55, 56
There is a list of numbers under column B
3%, 9%, 5%, 4%, 8%, 8%
I would like to create a matrix to count the frequency
On X-axis, 50, 51, 52, 53, 54, 55, 56
On Y-axis, 0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9%
Does anyone have any suggestions on how to set the formula to determine the
frequency? For example, 4% & 5& will count 1 for each for the number 53.
Thanks in advance for any suggestions
Eric