• 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. :)
 
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