Hi guys,
Can anyone help me out in figuring the bell curve set up for listed average ratings.
Original ratings are from 1 - 10 across 10 dimensions.
Thanks a lot in advance.
BR,
HK
Hi guys,
Can anyone help me out in figuring the bell curve set up for listed average ratings.
Original ratings are from 1 - 10 across 10 dimensions.
Thanks a lot in advance.
BR,
HK
Last edited by hkaric; 11-23-2018 at 05:47 AM.
The average and standard deviation are the parameters of the distribution.
A B C D E F G H I J K L M N 2 # Criteria 1 Criteria 2 Criteria 3 Criteria 4 Criteria 5 Criteria 6 Criteria 7 Criteria 8 Criteria 9 Criteria 10 Avg 3Emp 1 2 5 1 5 4 1 4 4 6 4 3.6 5.5M3: =AVERAGE(L3:L22) 4Emp 2 3 6 5 6 2 5 2 2 5 2 3.8 1.079M4: =STDEV(L3:L22) 5Emp 3 5 3 6 8 3 6 3 3 6 3 4.6 6Emp 4 6 5 8 7 5 8 5 5 3 5 5.7 7Emp 5 8 6 7 5 6 7 6 6 2 6 5.9 8Emp 6 9 8 3 6 8 2 8 8 3 8 6.3 9Emp 7 1 7 5 9 9 3 9 9 5 9 6.6 10Emp 8 2 5 6 10 1 5 6 1 6 6 4.8 11Emp 9 3 6 8 5 5 6 6 2 8 1 5.0 12Emp 10 5 9 9 5 6 8 9 5 9 2 6.7 13Emp 11 6 10 1 6 8 9 10 6 1 1 5.8 14Emp 12 8 5 5 8 7 1 5 8 4 5 5.6 15Emp 13 7 5 6 7 6 4 6 7 2 6 5.6 16Emp 14 5 8 8 5 1 2 8 5 3 8 5.3 17Emp 15 6 7 7 6 5 3 9 6 5 7 6.1 18Emp 16 9 8 5 9 6 5 1 9 6 1 5.9 19Emp 17 10 9 6 10 8 6 6 10 8 5 7.8 20Emp 18 2 6 9 10 7 8 5 3 9 6 6.5 21Emp 19 5 3 10 2 8 9 5 2 1 8 5.3 22Emp 20 2 6 5 3 6 1 2 3 1 7 3.6
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks