Math Notation (for formula)

The notation is not correct
1. minor    you do not need the () although they do no harm
2. You are summing over the index. This can be done but I do not think you want to do it.
Usually you sum over a (variable)sub i
3. I do not see why you sum over anything to get NDS when NDS is already calculated or known

I see what you are trying to do now. The summations will not work even if the notation were correct. But (for, next) loops might.

actually a vector might be better. Get MAX and MIN from vector. The other term would be more difficult but doable. To get them into excell at the right cell would be more difficult. Do they have to appear in the order of your example?

aburr:

Thanks... I'm lacking the required mathematical background to fully understand how to write this in vector notation.   Any chance you could provide me some assistance on that.   If yes, simply double-click on the equation... the equation editor should come up.   Pretty nifty tool as long as one knows how to properly write them out.  ;)

Again, thanks for the feedback thus far.

EEH

Oh, right order of example?   See previous post first though.

Here's the process:

Survey participants will submit their answers.   Each of the 10 processes will always be in the same order.    So x1 = process 1... x10 = process 10.   The same for the next survey participant(s).

Makes sense?

EEH

I am getting more insight into your process. My current understanding suggests that you use
-
NDS(sub i) = {WDS(sub i) - MIN(wds)} / {MAX(WDS) - MIN(WDS)}
-
Forget the vector part. No summation needed

aburr:

Yes, I think that looks right.   Is that the proper notation to use or is that a pseudo formula?

Thanks,
EEH

... follow-on to my last response.

How does it account for the individual user?

First user might be "i", second user might be "j"... so, whether I have 2 users or 200 users, how can this be written that academicians agree on the formula and know how to interpret it?

EEH

Ok... but there are two counts... # of users and # of processes.

So, user 1... do the calculation for processes 1 through 10.   Then user 2... do the calculation for processes 1 through 10, etc. etc.

Thank you for your patience on this.   I'm confident I'll close this question soon.  Just needed to clarify above question.

Again, thanks!

EEH

"So, user 1... do the calculation for processes 1 through 10.   Then user 2... do the calculation for processes 1 through 10, etc. etc."
yes

Excellent solution!