What is the best formula for calculating average based on count?











up vote
0
down vote

favorite












I would like to calculate an average of the series based on the count.



Say, for example,



Series 1 (10 values): 5, 1, 2, 3, 4, 5, 4, 1, 2, 3




Average: 30 / 10 = 3




Series 2 (2 values): 3, 4




Average: 7 / 2 = 3.5




Series 2 has the higher average than series 1 but series attempted 10 times which is more than series 2 (2 times).



I need to find a formula to calculate the average based on the counts to make sure the values are perfectly averaged. Can anyone help me achieve this?










share|cite|improve this question






















  • Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
    – José Carlos Santos
    Nov 25 at 13:25










  • I agree. I quoted what I actually tried in the question itself.
    – good-to-know
    Nov 25 at 13:26










  • The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
    – Ingix
    Nov 25 at 16:15










  • @Ingix What I need to do, then?
    – good-to-know
    Nov 27 at 13:11










  • Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
    – Ingix
    Nov 27 at 13:16















up vote
0
down vote

favorite












I would like to calculate an average of the series based on the count.



Say, for example,



Series 1 (10 values): 5, 1, 2, 3, 4, 5, 4, 1, 2, 3




Average: 30 / 10 = 3




Series 2 (2 values): 3, 4




Average: 7 / 2 = 3.5




Series 2 has the higher average than series 1 but series attempted 10 times which is more than series 2 (2 times).



I need to find a formula to calculate the average based on the counts to make sure the values are perfectly averaged. Can anyone help me achieve this?










share|cite|improve this question






















  • Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
    – José Carlos Santos
    Nov 25 at 13:25










  • I agree. I quoted what I actually tried in the question itself.
    – good-to-know
    Nov 25 at 13:26










  • The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
    – Ingix
    Nov 25 at 16:15










  • @Ingix What I need to do, then?
    – good-to-know
    Nov 27 at 13:11










  • Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
    – Ingix
    Nov 27 at 13:16













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I would like to calculate an average of the series based on the count.



Say, for example,



Series 1 (10 values): 5, 1, 2, 3, 4, 5, 4, 1, 2, 3




Average: 30 / 10 = 3




Series 2 (2 values): 3, 4




Average: 7 / 2 = 3.5




Series 2 has the higher average than series 1 but series attempted 10 times which is more than series 2 (2 times).



I need to find a formula to calculate the average based on the counts to make sure the values are perfectly averaged. Can anyone help me achieve this?










share|cite|improve this question













I would like to calculate an average of the series based on the count.



Say, for example,



Series 1 (10 values): 5, 1, 2, 3, 4, 5, 4, 1, 2, 3




Average: 30 / 10 = 3




Series 2 (2 values): 3, 4




Average: 7 / 2 = 3.5




Series 2 has the higher average than series 1 but series attempted 10 times which is more than series 2 (2 times).



I need to find a formula to calculate the average based on the counts to make sure the values are perfectly averaged. Can anyone help me achieve this?







sequences-and-series average






share|cite|improve this question













share|cite|improve this question











share|cite|improve this question




share|cite|improve this question










asked Nov 25 at 13:24









good-to-know

1011




1011












  • Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
    – José Carlos Santos
    Nov 25 at 13:25










  • I agree. I quoted what I actually tried in the question itself.
    – good-to-know
    Nov 25 at 13:26










  • The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
    – Ingix
    Nov 25 at 16:15










  • @Ingix What I need to do, then?
    – good-to-know
    Nov 27 at 13:11










  • Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
    – Ingix
    Nov 27 at 13:16


















  • Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
    – José Carlos Santos
    Nov 25 at 13:25










  • I agree. I quoted what I actually tried in the question itself.
    – good-to-know
    Nov 25 at 13:26










  • The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
    – Ingix
    Nov 25 at 16:15










  • @Ingix What I need to do, then?
    – good-to-know
    Nov 27 at 13:11










  • Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
    – Ingix
    Nov 27 at 13:16
















Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
– José Carlos Santos
Nov 25 at 13:25




Welcome to MSE. It will be more likely that you will get an answer if you show us that you made an effort. This should be added to the question rather than in the comments.
– José Carlos Santos
Nov 25 at 13:25












I agree. I quoted what I actually tried in the question itself.
– good-to-know
Nov 25 at 13:26




I agree. I quoted what I actually tried in the question itself.
– good-to-know
Nov 25 at 13:26












The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
– Ingix
Nov 25 at 16:15




The problem is that you want an answer for a question that you have not given. What do you mean with "perfectly averaged"? What I guess is that your series' come from some kind of measurement (like school grades) and maybe you want to take into account that having an average score of 3.4 over 10 grades is more reliable than one of 3.5 over just 2 grades. But all of this information needs to come from you, there is no magical formula that will take that into account that is generally applicable.
– Ingix
Nov 25 at 16:15












@Ingix What I need to do, then?
– good-to-know
Nov 27 at 13:11




@Ingix What I need to do, then?
– good-to-know
Nov 27 at 13:11












Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
– Ingix
Nov 27 at 13:16




Describe what you want in your terms, and try not to use phrases like "perfectly averaged", which are not well defined. Include the background of the question (as I guessed at). Make a new question for this.
– Ingix
Nov 27 at 13:16















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',
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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3012825%2fwhat-is-the-best-formula-for-calculating-average-based-on-count%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown






























active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3012825%2fwhat-is-the-best-formula-for-calculating-average-based-on-count%23new-answer', 'question_page');
}
);

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







Popular posts from this blog

Berounka

Sphinx de Gizeh

Different font size/position of beamer's navigation symbols template's content depending on regular/plain...