Weighted Average

zinah

Active Member
Joined
Nov 28, 2018
Messages
368
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have survey data that have 3 questions for each manager, and what I need is to get the weighted average of Favorable Percent for all of these 3 question for each manager. Can you tell me how can I accomplish that?

Below is a sample table of the data, knowing that some employees they didn't answer some questions that's why there are blank cells.

QuestionEE NameCount of ResponsesAverage ScoreStd DevFavorable PercentNeutral PercentUnfavorable Percent6. Strongly Agree5. Agree4. Somewhat Agree3. Somewhat Disagree2. Disagree1. Strongly Disagree
Q1AA
12​
4.58​
0.83​
58.33%​
41.67%​
0.00%​
1​
6​
4​
1​
0​
0​
Q2AA
8​
4.38​
0.76​
50.00%​
50.00%​
0.00%​
0​
4​
3​
1​
0​
0​
Q3AA
Q1BB
Q2BB
Q3BB
Q2CC
Q3CC
Q1CC
16​
4.06​
1.52​
37.50%​
50.00%​
12.50%​
2​
4​
7​
1​
0​
2​
Q2DD
12​
3.83​
1.66​
33.33%​
41.67%​
25.00%​
3​
1​
2​
3​
3​
0​
Q3DD
13​
5.08​
0.80​
76.92%​
23.08%​
0.00%​
4​
6​
3​
0​
0​
0​
Q1DD
8​
3.13​
1.49​
25.00%​
37.50%​
37.50%​
0​
2​
1​
2​
2​
1​
Q2EE
18​
2.39​
1.60​
16.67%​
11.11%​
72.22%​
0​
3​
2​
0​
7​
6​
Q3EE
49​
4.57​
1.42​
57.14%​
32.65%​
10.20%​
14​
14​
13​
3​
4​
1​
Q1EE
22​
4.86​
1.16​
77.27%​
18.18%​
4.55%​
5​
12​
4​
0​
0​
1​
Q2FF
13​
5.46​
0.69​
92.31%​
7.69%​
0.00%​
7​
5​
1​
0​
0​
0​
Q3FF
10​
4.70​
1.30​
60.00%​
30.00%​
10.00%​
3​
3​
3​
0​
1​
0​
Q1FF
Q2GG
7​
3.57​
1.42​
28.57%​
57.14%​
14.29%​
0​
2​
2​
2​
0​
1​
Q3GG
Q1HH
Q2HH
Q3HH
Q1II
7​
4.43​
1.64​
71.43%​
14.29%​
14.29%​
1​
4​
1​
0​
0​
1​
Q2II
6​
3.50​
1.76​
16.67%​
50.00%​
33.33%​
1​
0​
3​
0​
1​
1​
Q3II
Q1JJ
Q2JJ
6​
5.00​
0.89​
66.67%​
33.33%​
0.00%​
2​
2​
2​
0​
0​
0​
Q3JJ
5​
5.00​
0.69​
80.00%​
20.00%​
0.00%​
1​
3​
1​
0​
0​
0​
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Note: Favorable Percent is calculated by = Sum (Strongly Agree+Agree)/Count of Responses
 
Upvote 0

Forum statistics

Threads
1,223,877
Messages
6,175,134
Members
452,614
Latest member
MRSWIN2709

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top