Forum Discussion
How can I write this as a formula?
Hi I've done a survey of two seperate locations - location A has 12 employees and location B has 5 employees. The staff at location B scored as total of 24 for their 'issues related answers' ...
cheeseontoast101 Can't really judge what risk you mean but when 12 people score 36 and 5 score 24, the average scores would be 36/12 = 3 for the first group and 24/5 = 4.8 for the second group.
So, in your example the lower average would mean the higher risk. I a formula that could look like this: