Score a Likert Scale Survey

jac2010

New Member
Joined
Jul 16, 2016
Messages
5
I have a Survey of 17 questions regarding specific companies. I need to create a score for each company. The questions are grouped into 3 areas, weighting of 40%, 40% and 30%, using the Likert scale of 5 responses for each question. Based on the score of each area, I came up with where each company fits into one of 9 categories like Experienced (doing well on 3 areas), Engaged and Enabled (doing well on 2 categories, 3 Emergent categories, doing well on one category etc.
How do I come up with an overall score. Looking at the total average doesn't match up to the categories (doing well on 2 categories, the company could have a higher total average score than other companies that do well on all 3 categories. Does anyone have any ideas on how to come up with one score for each company?
Thank you in advance!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Thank you, I've actually already read thru that. Not exactly what I'm looking for, but it gave me a couple ideas. I'll have to try them out to see if they actually work, but I thought there might be an easier way than what I'm thinking
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

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