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.
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.
Question | EE Name | Count of Responses | Average Score | Std Dev | Favorable Percent | Neutral Percent | Unfavorable Percent | 6. Strongly Agree | 5. Agree | 4. Somewhat Agree | 3. Somewhat Disagree | 2. Disagree | 1. Strongly Disagree |
Q1 | AA | 12 | 4.58 | 0.83 | 58.33% | 41.67% | 0.00% | 1 | 6 | 4 | 1 | 0 | 0 |
Q2 | AA | 8 | 4.38 | 0.76 | 50.00% | 50.00% | 0.00% | 0 | 4 | 3 | 1 | 0 | 0 |
Q3 | AA | ||||||||||||
Q1 | BB | ||||||||||||
Q2 | BB | ||||||||||||
Q3 | BB | ||||||||||||
Q2 | CC | ||||||||||||
Q3 | CC | ||||||||||||
Q1 | CC | 16 | 4.06 | 1.52 | 37.50% | 50.00% | 12.50% | 2 | 4 | 7 | 1 | 0 | 2 |
Q2 | DD | 12 | 3.83 | 1.66 | 33.33% | 41.67% | 25.00% | 3 | 1 | 2 | 3 | 3 | 0 |
Q3 | DD | 13 | 5.08 | 0.80 | 76.92% | 23.08% | 0.00% | 4 | 6 | 3 | 0 | 0 | 0 |
Q1 | DD | 8 | 3.13 | 1.49 | 25.00% | 37.50% | 37.50% | 0 | 2 | 1 | 2 | 2 | 1 |
Q2 | EE | 18 | 2.39 | 1.60 | 16.67% | 11.11% | 72.22% | 0 | 3 | 2 | 0 | 7 | 6 |
Q3 | EE | 49 | 4.57 | 1.42 | 57.14% | 32.65% | 10.20% | 14 | 14 | 13 | 3 | 4 | 1 |
Q1 | EE | 22 | 4.86 | 1.16 | 77.27% | 18.18% | 4.55% | 5 | 12 | 4 | 0 | 0 | 1 |
Q2 | FF | 13 | 5.46 | 0.69 | 92.31% | 7.69% | 0.00% | 7 | 5 | 1 | 0 | 0 | 0 |
Q3 | FF | 10 | 4.70 | 1.30 | 60.00% | 30.00% | 10.00% | 3 | 3 | 3 | 0 | 1 | 0 |
Q1 | FF | ||||||||||||
Q2 | GG | 7 | 3.57 | 1.42 | 28.57% | 57.14% | 14.29% | 0 | 2 | 2 | 2 | 0 | 1 |
Q3 | GG | ||||||||||||
Q1 | HH | ||||||||||||
Q2 | HH | ||||||||||||
Q3 | HH | ||||||||||||
Q1 | II | 7 | 4.43 | 1.64 | 71.43% | 14.29% | 14.29% | 1 | 4 | 1 | 0 | 0 | 1 |
Q2 | II | 6 | 3.50 | 1.76 | 16.67% | 50.00% | 33.33% | 1 | 0 | 3 | 0 | 1 | 1 |
Q3 | II | ||||||||||||
Q1 | JJ | ||||||||||||
Q2 | JJ | 6 | 5.00 | 0.89 | 66.67% | 33.33% | 0.00% | 2 | 2 | 2 | 0 | 0 | 0 |
Q3 | JJ | 5 | 5.00 | 0.69 | 80.00% | 20.00% | 0.00% | 1 | 3 | 1 | 0 | 0 | 0 |