bqmassey
Line Up and Wait
I have Excel data that looks something like the block below. I want to create a table that looks something like the block below.
I want to create a table that averages the B values for ranges in the A column.
I want to end up with this:
Thoughts?
I want to create a table that averages the B values for ranges in the A column.
Code:
A B
7 0.82
0 0.41
2 0.93
7 0.24
4 0.7
1 0.18
9 0.99
10 0.65
1 0.63
7 0.36
1 0.21
8 1
9 0.27
6 0.75
6 0.41
9 0.76
7 0.6
9 0.49
4 0.49
0 0.82
Code:
0-1 .500
2-3 .500
4-5 .500
6-7 .500
8-9 .500
9-10 .500
Thoughts?