• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to populate % from different totals

R

ridgleye

New Member
Here is the question. We had a survey at work. The creators of the survey didn't do a good job and accidentally created 2 separate work areas even though we have 1.

So I need to figure out how to combine the percentages based on the weight of the two sections.

Group 1 - 13 responders

"unfavorable","neutral","approve"

A1 --- B1 --- C1
10% - 10% - 80%

Group 2 - 16 responders

D1 --- E1 --- F1
0% -- 20% - 80%

This goes down roughly 50 questions. How do I combine them? I just need one set of answers instead of two.

Thank you for any assistance you guys may be able to provide.
 
I would go back to the original data and combine it, then recalculate

You can do it from the data you provided

Group 1

A1 = 1.3
B1 = 1.3
C1 = 10.4

Group 2

D1 = 0
E1 = 3.2
F1 = 12.8

Then combine the like questions and recalculate the totals

If D1 is the same as A1 and E1 the same as B1 etc

A1 = 1.3 + 0
B1 = 1.3 + 3.2 = 4.5
C1 = 10.4 + 12.8 = 23.2
Out of a total of 29

So new Percentages are

A1 = 1.3/29 = 4.5%
B1 = 4.5/29 = 15.5%
C1 = 23.2/29 = 80.0%
 
Hui,

Thank you for the reply. The question I have though, is - how do I go about this for all the questions in the survey, as the percentages vary greatly throughout the survey. Is there a way to write a formula that I can autopopulate right down the spreadsheet? Or is the weight in itself 0.3 per answer (i.e. if there were 3 responses the new weight for B1 be 3.9)?

What I don't have is the original numbers/responses per question outside of it being the percentage.

Apologize if this is a simplistic thing I'm making more difficult - but my brain just isn't comprehending it.

Hui said:
I would go back to the original data and combine it, then recalculate

You can do it from the data you provided

Group 1

A1 = 1.3
B1 = 1.3
C1 = 10.4

Group 2

D1 = 0
E1 = 3.2
F1 = 12.8

Then combine the like questions and recalculate the totals

If D1 is the same as A1 and E1 the same as B1 etc

A1 = 1.3 + 0
B1 = 1.3 + 3.2 = 4.5
C1 = 10.4 + 12.8 = 23.2
Out of a total of 29

So new Percentages are

A1 = 1.3/29 = 4.5%
B1 = 4.5/29 = 15.5%
C1 = 23.2/29 = 80.0%
Click to expand...
 
.......... I slept on it and am feeling a little foolish today.

I just convert each field to a whole number. Add respective group together then divide total by 29. Autopopulate down and viola. :)
 
Divide by the Total of the Original Data, in the example it was 29.
 
lol

man .... if that's the lowest point of my day I'll be more than pleased with how life is going.

Though, to get on grammar/spelling, the use of "an" before US is incorrect ...... so there is that. ;) :D
 
You must log in or register to reply here.
Back
Top