Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Maths problem is driving my crazy?
im trying to devise a scoring mechanism for a trend analyses.
ive come up with the following.
there are 2 inputs
x = is the overal position.
for ease ive capped x between -2.5 and 2.5
y is the trend movement direction and size
i use the following formula to devise a rating between 0 and 100. based on x.
100-(50 + (-)50 - sin ( x * 2 / pi) * 50)
my problem is the 100- is optional. it should only be done if x and y are not both positive, or both negative.
cant get the damn thing right in excel. anyone have any ideas?
1 Answer
- ?Lv 76 years ago
In Excel pseudocode, I suppose it would be something like
If (xy < , 100, 0) - (50 + (-)50 - sin ( x * 2 / pi) * 50)