Math Notation (for formula)

ExpExchHelp
ExpExchHelp used Ask the Experts™
on
I need some help with writing a formula into correct "notation format".

Please see attached XLS with formula and proposed notation format.   I don't think what I proposed is correct, so I'd welcome any help on this.

Thanks,
EEH
Formula-Notation.xls
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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?
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

ExpExchHelpAnalyst

Author

Commented:
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
ExpExchHelpAnalyst

Author

Commented:
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
ExpExchHelpAnalyst

Author

Commented:
aburr:

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

Thanks,
EEH
ExpExchHelpAnalyst

Author

Commented:
... 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
How does it account for the individual user?

the sub i does that. For the first user i = 1, second i = 2, etc.In usual notation the (sub i) woudl be a subscript on NDS and WDS.
MAX(WDS) would be the maximum WDS fir the ith person
ExpExchHelpAnalyst

Author

Commented:
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
ExpExchHelpAnalyst

Author

Commented:
Excellent solution!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial