Jump to content



Photo

Excel problem [getting a percentage from percentages?]


  • Please log in to reply
5 replies to this topic

#1 goodbytes

goodbytes

    Just below average Joe

  • Tech Issues Solved: 1
  • Joined: 07-May 04
  • Location: England

Posted 12 December 2012 - 08:35

I've tallied some answers of questions in Excel. The answer was simply yes or no, and the same question was asked across various groups of people.

I have got the percentage of each individual answer in each group of people eg..

GROUP 1
Q.1 - YES - 40% / NO - 60%
Q.2 - YES - 38% / NO - 62%


GROUP 1
Q.1 - YES - 70% / NO - 30%
Q.2 - YES - 10% / NO - 90%

and so on... but now i need to get the over all percentage of each question, out of 100%.

I don't think i can basically add Q1 (40% + 70% = 110%).

Is there a formula for something like this?


#2 virtorio

virtorio

    Neowinian Senior

  • Tech Issues Solved: 14
  • Joined: 28-April 03
  • Location: New Zealand
  • OS: OSX 10.10, Windows 8.1
  • Phone: LG G3

Posted 12 December 2012 - 08:45

Calculate the average:

Q1:
(40+70)/2 = 55% voted yes
(60+30)/2 = 45% voted no

Q2:
(38+10)/2 = 24% voted yes
(62+90)/2 = 76% voted no

Ideally it's better to work with the real data, but I think that's what you're after.

#3 Cheryl_27

Cheryl_27

    Neowinian

  • Joined: 09-January 07

Posted 16 December 2012 - 23:15

Depending on how accurate you need your overall (avg) %, you'd take the grand total of yes (or no) answers divided by total answers, for each question, as virtorio indicated. If need more accuracy, use actual data for the overall averages, instead of rounded off values, from step 1. Then round to desired # of decimal places.

Of course, you must multiply (or have Excell convert decimals to %) decimal fractions x 100 to get percent. 110/2 = .55 x 100 = 55%

#4 OP goodbytes

goodbytes

    Just below average Joe

  • Tech Issues Solved: 1
  • Joined: 07-May 04
  • Location: England

Posted 08 January 2013 - 08:51

Thanks for the replies, i'm pressing on with this now, numbers bend my head.

Here is an actual row of data:

85.7% - 81.8% - 76.2% - 100.0% - 79.2% - 96.0% - 87.5% - 100.0% - 89.3% - 92.3% - What is the cumulative percentage?

I believe what i'm looking for is the Cumulative Percentage, not totally sure what that means but i think it's the same as what i asked for in original post. the % out of 100?

#5 -Himanshu-

-Himanshu-

    Everybody Lies.

  • Joined: 10-September 09
  • Location: Milky Way
  • OS: Windows 8 Pro WMC x64
  • Phone: Nokia 5235

Posted 08 January 2013 - 09:32

Virtorio is right, you just need to calculate the average. Add all the percentages of yes or no, and divide by the total number of groups, and that's your required percentage of the particular choice.

Thanks for the replies, i'm pressing on with this now, numbers bend my head.

Here is an actual row of data:

85.7% - 81.8% - 76.2% - 100.0% - 79.2% - 96.0% - 87.5% - 100.0% - 89.3% - 92.3% - What is the cumulative percentage?

I believe what i'm looking for is the Cumulative Percentage, not totally sure what that means but i think it's the same as what i asked for in original post. the % out of 100?


Does that row show the percentage of people, who selected a particular choice, over 10 groups? In that case,

85.7+81.8+76.2+100+79.2+96+87.5+100+89.3+92.3/10 = 88.8

So, overall, 88.8% people selected that choice.

#6 OP goodbytes

goodbytes

    Just below average Joe

  • Tech Issues Solved: 1
  • Joined: 07-May 04
  • Location: England

Posted 08 January 2013 - 09:55

Thats correct and thank you it looks right now.

Formula: =SUM(B1:B10)/10 = 88.8