I have two columns. (A) is a prediction and (B) is an actual. I need a formula for accuracy. Right now I calculate the difference (A)-(B)=C and then calculate accuracy =1-(C/B) This works fine unless the prediction is lower than the actual in which case the accuracy % is given as more than 100%.
For example if the prediction is 14.5 and the actual is 15.15, the accuracy computes as 104.29%. I understand that I can subtract that number from 200 to get 95.71 - the correct accuracy. My question is how do I put all of that into one equation for a global formula for accuracy? I don't want to have to go back and switch formulas on a case by case basis depending on the prediction being over or under the actual.
For example if the prediction is 14.5 and the actual is 15.15, the accuracy computes as 104.29%. I understand that I can subtract that number from 200 to get 95.71 - the correct accuracy. My question is how do I put all of that into one equation for a global formula for accuracy? I don't want to have to go back and switch formulas on a case by case basis depending on the prediction being over or under the actual.