Statistical problem: Scores, Weights and Averages
As part of a software development project, I'm trying to find the correct mathematical approach for a statistics problem involving scores, weights and averages. Here's a simplified summary of the problem:
I have a security incident and I want to determine its overall severity on a scale of 0.0 to 10.0. I have 5 people who are experts in different security areas, and each individual has given me their own severity score for the incident on the same scale (0.0-10.0). The set of scores may look like so:
[0.4, 8.6, 2.4, 3.6, 3.8]
From these scores I need to determine the final incident severity score. However, the opinions of the 5 security experts are not of equal importance and should be weighted accordingly.
My initial approach involved using weights as a multiplier, so that the following scores and weights:
scores = [0.4, 8.6, 2.4, 3.6, 3.8]
weights = [0.5, 1.1, 1.0, 0.5, 0.5]
Would look like so, once the weights had been applied:
weighted_scores = [0.2, 9.46, 2.4, 1.8, 1.9]
I'm unsure though of how to reach a final score from these weighted scores. I can't simply find the arithmetic mean because a low score with a low weight means a greater effect on the final score, but I need the opposite to happen. In the case of the above set of weighted score; the lower the score, the lower its dampening effect should be on the final incident severity score.
I'm a complete mathematics novice (at best) so apologies in advance if this isn't clear. I'm not sure if mathematics alone can solve this problem. Some of it might need to be implemented at the software level.
statistics means
New contributor
add a comment |
As part of a software development project, I'm trying to find the correct mathematical approach for a statistics problem involving scores, weights and averages. Here's a simplified summary of the problem:
I have a security incident and I want to determine its overall severity on a scale of 0.0 to 10.0. I have 5 people who are experts in different security areas, and each individual has given me their own severity score for the incident on the same scale (0.0-10.0). The set of scores may look like so:
[0.4, 8.6, 2.4, 3.6, 3.8]
From these scores I need to determine the final incident severity score. However, the opinions of the 5 security experts are not of equal importance and should be weighted accordingly.
My initial approach involved using weights as a multiplier, so that the following scores and weights:
scores = [0.4, 8.6, 2.4, 3.6, 3.8]
weights = [0.5, 1.1, 1.0, 0.5, 0.5]
Would look like so, once the weights had been applied:
weighted_scores = [0.2, 9.46, 2.4, 1.8, 1.9]
I'm unsure though of how to reach a final score from these weighted scores. I can't simply find the arithmetic mean because a low score with a low weight means a greater effect on the final score, but I need the opposite to happen. In the case of the above set of weighted score; the lower the score, the lower its dampening effect should be on the final incident severity score.
I'm a complete mathematics novice (at best) so apologies in advance if this isn't clear. I'm not sure if mathematics alone can solve this problem. Some of it might need to be implemented at the software level.
statistics means
New contributor
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago
add a comment |
As part of a software development project, I'm trying to find the correct mathematical approach for a statistics problem involving scores, weights and averages. Here's a simplified summary of the problem:
I have a security incident and I want to determine its overall severity on a scale of 0.0 to 10.0. I have 5 people who are experts in different security areas, and each individual has given me their own severity score for the incident on the same scale (0.0-10.0). The set of scores may look like so:
[0.4, 8.6, 2.4, 3.6, 3.8]
From these scores I need to determine the final incident severity score. However, the opinions of the 5 security experts are not of equal importance and should be weighted accordingly.
My initial approach involved using weights as a multiplier, so that the following scores and weights:
scores = [0.4, 8.6, 2.4, 3.6, 3.8]
weights = [0.5, 1.1, 1.0, 0.5, 0.5]
Would look like so, once the weights had been applied:
weighted_scores = [0.2, 9.46, 2.4, 1.8, 1.9]
I'm unsure though of how to reach a final score from these weighted scores. I can't simply find the arithmetic mean because a low score with a low weight means a greater effect on the final score, but I need the opposite to happen. In the case of the above set of weighted score; the lower the score, the lower its dampening effect should be on the final incident severity score.
I'm a complete mathematics novice (at best) so apologies in advance if this isn't clear. I'm not sure if mathematics alone can solve this problem. Some of it might need to be implemented at the software level.
statistics means
New contributor
As part of a software development project, I'm trying to find the correct mathematical approach for a statistics problem involving scores, weights and averages. Here's a simplified summary of the problem:
I have a security incident and I want to determine its overall severity on a scale of 0.0 to 10.0. I have 5 people who are experts in different security areas, and each individual has given me their own severity score for the incident on the same scale (0.0-10.0). The set of scores may look like so:
[0.4, 8.6, 2.4, 3.6, 3.8]
From these scores I need to determine the final incident severity score. However, the opinions of the 5 security experts are not of equal importance and should be weighted accordingly.
My initial approach involved using weights as a multiplier, so that the following scores and weights:
scores = [0.4, 8.6, 2.4, 3.6, 3.8]
weights = [0.5, 1.1, 1.0, 0.5, 0.5]
Would look like so, once the weights had been applied:
weighted_scores = [0.2, 9.46, 2.4, 1.8, 1.9]
I'm unsure though of how to reach a final score from these weighted scores. I can't simply find the arithmetic mean because a low score with a low weight means a greater effect on the final score, but I need the opposite to happen. In the case of the above set of weighted score; the lower the score, the lower its dampening effect should be on the final incident severity score.
I'm a complete mathematics novice (at best) so apologies in advance if this isn't clear. I'm not sure if mathematics alone can solve this problem. Some of it might need to be implemented at the software level.
statistics means
statistics means
New contributor
New contributor
New contributor
asked Jan 4 at 9:56
AltireAltire
1
1
New contributor
New contributor
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago
add a comment |
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "69"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Altire is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3061477%2fstatistical-problem-scores-weights-and-averages%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Altire is a new contributor. Be nice, and check out our Code of Conduct.
Altire is a new contributor. Be nice, and check out our Code of Conduct.
Altire is a new contributor. Be nice, and check out our Code of Conduct.
Altire is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Mathematics Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3061477%2fstatistical-problem-scores-weights-and-averages%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
So the standard way would be to calculate $$ frac{ 0.5 times 0.4 + 1.1 times 8.6 + 1.0 times 2.4 + 0.5 times 3.6 + 0.5 times 3.8 }{0.5 + 1.1 + 1.0 + 0.5 + 0.5 } approx 4.38 $$ So you cannot use this? Or ... ?
– Matti P.
Jan 4 at 10:47
I would say that a low weight indeed has a very low effect on the weighted mean (the one which I calculated), so it should work just as you describe. That is, if I understood correctly what you want. Why do you say that "a low score with a low weight means a greater effect on the final score?"
– Matti P.
Jan 4 at 11:11
As @MattiP. mentioned, look up weighted mean. The score should be $$S=frac{sum_i w_is_i}{sum_i w_i}$$ If the weight is very close to $0$, then you effectively average only the scores from the other experts.
– Andrei
Jan 4 at 19:44
I had considered this approach and while I think it should work, there's one requirement I also need to consider. Working with the same dataset, let's say that the score of 8.6 (which has a weight of 1.1) came from our most experienced security expert. If he says that the incident is reasonably significant (between 3.0 and 6.0) then his weight remains at 1.1. If however, he thinks it's really bad (6.0 to 10.0), then we're going to take his decision over everyone else's (or at least make is drastically more important). Is there a way to do this mathematically? thanks
– Altire
yesterday
Maybe you have to create a weight function, so that $w_i = w_i(s_i)$ ... Or maybe you could also try something like a geometric mean (or some other type of mean)
– Matti P.
8 hours ago