How to distribute data using factor combined from various variables [closed]
up vote
0
down vote
favorite
here is some data for 4 variables:
State:population:num_schools:size
A:100k:10:500
B:90k:20:350
C:125k15:450
D:300k:40:900
And here is a national sales number: 500k
I'm want to distribute the 500k to the state level using the variables above.
I could distribute the national data according to the "distribution" (the percentage in each state) of each of these variables individually, like so:
State:%population:%num_schools:%size
A:.16:.12:.23
B:.15:.23:.16
C:.20:.18:.20
D:.49:.47:.41
So for state A, 16% of sales would be assigned based on the population data, 12% based on number of schools in the state, but 23% based on the size variable (similarly for the other states). The point is each variable will distribute the 500k differently (500k*%population will be differently distributed than 500k*%size)
So my question is: How can I combine these variables so that my national data (the 500k) is distributed according to a combined factor of these various variables? How do I combine them to get a single factor given that they are on different scales (one is population which is in the '000s, another is in the 100's, etc). Do I simply multiply the percentages (from the second table) together to get a combined factor? (For example, state A's factor would be: 16*.12*.23 =.004). I know that is wrong..but I don't know how to do it correctly.
Any help how to approach this, in particular how to build a combined factor, will be appreciated.
arithmetic data-analysis
asked Nov 16 at 6:20
LeoTurtle
11
closed as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel Nov 17 at 9:01
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
up vote
0
down vote
favorite
here is some data for 4 variables:
State:population:num_schools:size
A:100k:10:500
B:90k:20:350
C:125k15:450
D:300k:40:900
And here is a national sales number: 500k
I'm want to distribute the 500k to the state level using the variables above.
I could distribute the national data according to the "distribution" (the percentage in each state) of each of these variables individually, like so:
State:%population:%num_schools:%size
A:.16:.12:.23
B:.15:.23:.16
C:.20:.18:.20
D:.49:.47:.41
So for state A, 16% of sales would be assigned based on the population data, 12% based on number of schools in the state, but 23% based on the size variable (similarly for the other states). The point is each variable will distribute the 500k differently (500k*%population will be differently distributed than 500k*%size)
So my question is: How can I combine these variables so that my national data (the 500k) is distributed according to a combined factor of these various variables? How do I combine them to get a single factor given that they are on different scales (one is population which is in the '000s, another is in the 100's, etc). Do I simply multiply the percentages (from the second table) together to get a combined factor? (For example, state A's factor would be: 16*.12*.23 =.004). I know that is wrong..but I don't know how to do it correctly.
Any help how to approach this, in particular how to build a combined factor, will be appreciated.
arithmetic data-analysis
asked Nov 16 at 6:20
LeoTurtle
11
closed as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel Nov 17 at 9:01
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
here is some data for 4 variables:
State:population:num_schools:size
A:100k:10:500
B:90k:20:350
C:125k15:450
D:300k:40:900
And here is a national sales number: 500k
I'm want to distribute the 500k to the state level using the variables above.
I could distribute the national data according to the "distribution" (the percentage in each state) of each of these variables individually, like so:
State:%population:%num_schools:%size
A:.16:.12:.23
B:.15:.23:.16
C:.20:.18:.20
D:.49:.47:.41
So for state A, 16% of sales would be assigned based on the population data, 12% based on number of schools in the state, but 23% based on the size variable (similarly for the other states). The point is each variable will distribute the 500k differently (500k*%population will be differently distributed than 500k*%size)
So my question is: How can I combine these variables so that my national data (the 500k) is distributed according to a combined factor of these various variables? How do I combine them to get a single factor given that they are on different scales (one is population which is in the '000s, another is in the 100's, etc). Do I simply multiply the percentages (from the second table) together to get a combined factor? (For example, state A's factor would be: 16*.12*.23 =.004). I know that is wrong..but I don't know how to do it correctly.
Any help how to approach this, in particular how to build a combined factor, will be appreciated.
arithmetic data-analysis
asked Nov 16 at 6:20
LeoTurtle
11
here is some data for 4 variables:
State:population:num_schools:size
A:100k:10:500
B:90k:20:350
C:125k15:450
D:300k:40:900
And here is a national sales number: 500k
I'm want to distribute the 500k to the state level using the variables above.
I could distribute the national data according to the "distribution" (the percentage in each state) of each of these variables individually, like so:
State:%population:%num_schools:%size
A:.16:.12:.23
B:.15:.23:.16
C:.20:.18:.20
D:.49:.47:.41
So for state A, 16% of sales would be assigned based on the population data, 12% based on number of schools in the state, but 23% based on the size variable (similarly for the other states). The point is each variable will distribute the 500k differently (500k*%population will be differently distributed than 500k*%size)
So my question is: How can I combine these variables so that my national data (the 500k) is distributed according to a combined factor of these various variables? How do I combine them to get a single factor given that they are on different scales (one is population which is in the '000s, another is in the 100's, etc). Do I simply multiply the percentages (from the second table) together to get a combined factor? (For example, state A's factor would be: 16*.12*.23 =.004). I know that is wrong..but I don't know how to do it correctly.
Any help how to approach this, in particular how to build a combined factor, will be appreciated.
arithmetic data-analysis
arithmetic data-analysis
asked Nov 16 at 6:20
LeoTurtle
11
asked Nov 16 at 6:20
LeoTurtle
11
edited Nov 19 at 6:14
asked Nov 16 at 6:20
LeoTurtle
11
asked Nov 16 at 6:20
LeoTurtle
11
asked Nov 16 at 6:20
LeoTurtle
11
11
closed as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel Nov 17 at 9:01
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel Nov 17 at 9:01
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18
add a comment |
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Hi I tried to clarify the question...I think it's probably more basic a question than you expect but I'm stuck and will appreciate any pointers. How do I remove the hold? Thanks
– LeoTurtle
Nov 17 at 11:44
Hi can the hold be removed please?
– LeoTurtle
Nov 18 at 5:18