Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have multiple score-variables and i want to make an average. It can be done with set analysis, but i have my reasons why i want it in the script. Anyone knows how to do that?
I have this:
Name | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 |
---|---|---|---|---|---|
A | 7 | 5 | 9 | 1 | |
B | 2 | 9 | 5 | 3 | |
C | 5 | 9 | |||
D | 5 | 7 | 6 | ||
E | 4 |
And i want this:
Name | Average Score |
---|---|
A | 5.5 |
B | 4.8 |
C | 7 |
D | 6 |
E | 4 |
I tried AVG(Score 1, score 2, score 3, score 4, score 5) but it doesn't work.
Thanks,
Isabelle
Try RangeAvg([Score 1], [Score 2],[Score 3],[Score 4],[Score 5])
Try RangeAvg([Score 1], [Score 2],[Score 3],[Score 4],[Score 5])
May be try this:
RangeAvg(Score 1, score 2, score 3, score 4, score 5)
Sunny,
This question is from a few years ago, but I'd like to revive it and ask a follow on...
You correctly advised that <<<<Rangeavg(Score 1, Score 2, Score 3, Score 4, Score 5) >>>>>> will return the results in the second table, i.e. "A" with average of 5.5, "B" average of 4.8, etc.
How can you then get an average of the Range Averages?? In other words, what expression would return the average of {A=5.5}, {B=4.8}? Essentially it would be a column average... How can you write a column average expression when the values in the column are range averages?
THANKS
CM