Survey Scoring - Weighted

[tomwllrd]

Phone Survey - Scoring Recommendations?

Weighted by a percentage, but all have high-low anwers that need to be reflected. How is it best to do this?

1. How would you rate the amount of time you were on hold? 10%

Possible Answers: Very Satisfied, Santisfied, Long, Extreamly Long

2. Was this your 1st call regarding this issue? 10%

Possible Answers: Yes, No

3. How would you rate the friendliness of the analyst you spoked with? 15%

Possible Answers: Very Frendly, Frendly, Unfrendly, Extreamly Unfrendly
4. How would you rate the technical knowledge of the analyst you spoke with? 15%

Possible Answers: Excellent, Good, Average, Poor

5. How would you rate the sense of urgency of the analyst you spoke with?10%

Possible Answers: Excellent, Good, Average, Poor

6. Was your problem resolved during this call? 20%

Possible Answers: Yes, No

7. Overall, How satisfied were you with the level of service provided on this call? 20%

Possible Answers: Very Satisfied, Santisfied, Long, Extreamly Long

All % Add up to 100%

 

[PaddyD]

hi -welcome to the board!

i think you'll need to be a bit more specific - what, exactly, are you looking for?

 

[tomwllrd]

Iam looking for a way to score this sheet given that the choices are varried for each question. Then the actual whole question has a weight ranging from 10-20 percent. Of course I want the score to be on a 100 point scale.

 

[TheBuGz]

tomwllrd

Welcome to the board i myself is a newbie.

Would request all newbies to make use of HTML maker provided freely on this forum.
It surely makes it convenient in understanding wat you are saying .

regards

 

[plettieri]

Hi:

Something like this

Book1
	B	C	D	E	F	G	H	I
41							question	Weighted
42	Weighing table criteria				question	Answer	max score	score
43	Very Satisfied,	1	100		A	2	0.1	7.5
44	Santisfied	2	75		B	Y	0.15	12
45	Long	3	50
46	Extreamly Long	4	25
47		Y	80
48		N	30
49
50
51
Sheet4

plettieri