Calculating average customer turnover
I am currently coding a script which displays data for a company intranet. I am stuck with a question that seemed pretty simple, but turned out to give me headaches.
We have the following scenario:
- Store A has 70 male customers and 100 female customers - (170 total)
- Store B has 50 male customers and 230 female customers - (280 total)
Now, I learned that in order to display the average male/female ratio I have to calculate:
$$frac{text{Male Store A} + text{Male Store B}}{170 + 280} = X $$
$X * 100 = 28.9%$ for males, $71.1%$ for females
Yet when thinking it over, it doesn't show the real average, because the total number of clients isn't the same (170 vs 280).
So I did a second approach, which is first separating the percentage by store, and then calculating the average percentage:
- Males, Store A: $cfrac{70}{170} * 100 = 41.2%$
- Males, Store B: $cfrac{50}{280} * 100 = 17.9%$
And then divide it:
$$frac{41.2% + 17.9%}{2} = 29.6% $$
So in the second case, rounded up, male ratio is 29.6% instead of 27.3%
Then I showed both calculations to somebody who is better in math then me, and he told me that both are wrong. He said I should use "weighted average", but when I do i get exactly the same average percentage like in the first calculation.
What am I doing wrong?
Background:
We have a lot of stores, each with a different number of female and male clients. I want to have a percentage of the average client gender, but taking into account the different amount of the guests in each store.
average
add a comment |
I am currently coding a script which displays data for a company intranet. I am stuck with a question that seemed pretty simple, but turned out to give me headaches.
We have the following scenario:
- Store A has 70 male customers and 100 female customers - (170 total)
- Store B has 50 male customers and 230 female customers - (280 total)
Now, I learned that in order to display the average male/female ratio I have to calculate:
$$frac{text{Male Store A} + text{Male Store B}}{170 + 280} = X $$
$X * 100 = 28.9%$ for males, $71.1%$ for females
Yet when thinking it over, it doesn't show the real average, because the total number of clients isn't the same (170 vs 280).
So I did a second approach, which is first separating the percentage by store, and then calculating the average percentage:
- Males, Store A: $cfrac{70}{170} * 100 = 41.2%$
- Males, Store B: $cfrac{50}{280} * 100 = 17.9%$
And then divide it:
$$frac{41.2% + 17.9%}{2} = 29.6% $$
So in the second case, rounded up, male ratio is 29.6% instead of 27.3%
Then I showed both calculations to somebody who is better in math then me, and he told me that both are wrong. He said I should use "weighted average", but when I do i get exactly the same average percentage like in the first calculation.
What am I doing wrong?
Background:
We have a lot of stores, each with a different number of female and male clients. I want to have a percentage of the average client gender, but taking into account the different amount of the guests in each store.
average
add a comment |
I am currently coding a script which displays data for a company intranet. I am stuck with a question that seemed pretty simple, but turned out to give me headaches.
We have the following scenario:
- Store A has 70 male customers and 100 female customers - (170 total)
- Store B has 50 male customers and 230 female customers - (280 total)
Now, I learned that in order to display the average male/female ratio I have to calculate:
$$frac{text{Male Store A} + text{Male Store B}}{170 + 280} = X $$
$X * 100 = 28.9%$ for males, $71.1%$ for females
Yet when thinking it over, it doesn't show the real average, because the total number of clients isn't the same (170 vs 280).
So I did a second approach, which is first separating the percentage by store, and then calculating the average percentage:
- Males, Store A: $cfrac{70}{170} * 100 = 41.2%$
- Males, Store B: $cfrac{50}{280} * 100 = 17.9%$
And then divide it:
$$frac{41.2% + 17.9%}{2} = 29.6% $$
So in the second case, rounded up, male ratio is 29.6% instead of 27.3%
Then I showed both calculations to somebody who is better in math then me, and he told me that both are wrong. He said I should use "weighted average", but when I do i get exactly the same average percentage like in the first calculation.
What am I doing wrong?
Background:
We have a lot of stores, each with a different number of female and male clients. I want to have a percentage of the average client gender, but taking into account the different amount of the guests in each store.
average
I am currently coding a script which displays data for a company intranet. I am stuck with a question that seemed pretty simple, but turned out to give me headaches.
We have the following scenario:
- Store A has 70 male customers and 100 female customers - (170 total)
- Store B has 50 male customers and 230 female customers - (280 total)
Now, I learned that in order to display the average male/female ratio I have to calculate:
$$frac{text{Male Store A} + text{Male Store B}}{170 + 280} = X $$
$X * 100 = 28.9%$ for males, $71.1%$ for females
Yet when thinking it over, it doesn't show the real average, because the total number of clients isn't the same (170 vs 280).
So I did a second approach, which is first separating the percentage by store, and then calculating the average percentage:
- Males, Store A: $cfrac{70}{170} * 100 = 41.2%$
- Males, Store B: $cfrac{50}{280} * 100 = 17.9%$
And then divide it:
$$frac{41.2% + 17.9%}{2} = 29.6% $$
So in the second case, rounded up, male ratio is 29.6% instead of 27.3%
Then I showed both calculations to somebody who is better in math then me, and he told me that both are wrong. He said I should use "weighted average", but when I do i get exactly the same average percentage like in the first calculation.
What am I doing wrong?
Background:
We have a lot of stores, each with a different number of female and male clients. I want to have a percentage of the average client gender, but taking into account the different amount of the guests in each store.
average
average
edited Feb 12 at 23:11
Vedvart1
597418
597418
asked Nov 7 '12 at 13:14
George
111
111
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Okay, so I decided to stick to the weighted average method. Here is a good calculator to cross check your results:
http://www.handymath.com/cgi-bin/average.cgi
add a comment |
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
});
}
});
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%2f232140%2fcalculating-average-customer-turnover%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Okay, so I decided to stick to the weighted average method. Here is a good calculator to cross check your results:
http://www.handymath.com/cgi-bin/average.cgi
add a comment |
Okay, so I decided to stick to the weighted average method. Here is a good calculator to cross check your results:
http://www.handymath.com/cgi-bin/average.cgi
add a comment |
Okay, so I decided to stick to the weighted average method. Here is a good calculator to cross check your results:
http://www.handymath.com/cgi-bin/average.cgi
Okay, so I decided to stick to the weighted average method. Here is a good calculator to cross check your results:
http://www.handymath.com/cgi-bin/average.cgi
answered Nov 14 '12 at 3:54
George
111
111
add a comment |
add a comment |
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%2f232140%2fcalculating-average-customer-turnover%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