How to distribute data using factor combined from various variables [on hold]











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.










share|cite|improve this question









New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel yesterday


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
    yesterday










  • Hi can the hold be removed please?
    – LeoTurtle
    14 hours ago















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.










share|cite|improve this question









New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel yesterday


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
    yesterday










  • Hi can the hold be removed please?
    – LeoTurtle
    14 hours ago













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.










share|cite|improve this question









New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











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.







probability statistics arithmetic data-analysis






share|cite|improve this question









New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|cite|improve this question









New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|cite|improve this question




share|cite|improve this question








edited yesterday





















New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









LeoTurtle

11




11




New contributor




LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






LeoTurtle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel yesterday


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.






put on hold as unclear what you're asking by José Carlos Santos, s.harp, Paul Frost, Shailesh, Parcly Taxel yesterday


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
    yesterday










  • Hi can the hold be removed please?
    – LeoTurtle
    14 hours ago


















  • 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
    yesterday










  • Hi can the hold be removed please?
    – LeoTurtle
    14 hours ago
















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
yesterday




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
yesterday












Hi can the hold be removed please?
– LeoTurtle
14 hours ago




Hi can the hold be removed please?
– LeoTurtle
14 hours ago















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

Popular posts from this blog

Willebadessen

Ida-Boy-Ed-Garten

Residenzschloss Arolsen