So I need to figure out a formula to output the normalized average of each step.
For example, for each RUN, I need to normalize the measurement by the # of points: (measurement/#points)
then I want to take the average of all the Step 1 rows.
I tried using averageIF equation, but I can't use that to do the normalization first.
any thoughts?
Like this:
For example, for each RUN, I need to normalize the measurement by the # of points: (measurement/#points)
then I want to take the average of all the Step 1 rows.
I tried using averageIF equation, but I can't use that to do the normalization first.
any thoughts?
Like this:
Step | Run | # of points | Measure1 |
1 | 1 | 24 | 0.88 |
1 | 2 | 25 | 0.11 |
1 | 3 | 25 | 0.89 |
1 | 4 | 25 | 0.71 |
1 | 5 | 23 | 0.77 |
2 | 1 | 22 | 0.15 |
2 | 2 | 20 | 0.99 |
2 | 3 | 19 | 0.54 |
2 | 4 | 25 | 0.70 |
2 | 5 | 17 | 0.40 |
3 | 1 | 20 | 0.62 |
3 | 2 | 21 | 0.97 |
3 | 3 | 25 | 0.92 |
3 | 4 | 2 | 0.47 |
3 | 5 | 25 | 0.56 |
4 | 1 | 25 | 0.52 |
4 | 2 | 25 | 0.94 |
4 | 3 | 24 | 0.63 |
4 | 4 | 23 | 0.28 |
4 | 5 | 21 | 0.44 |
5 | 1 | 24 | 0.40 |
5 | 2 | 25 | 0.62 |