+ Reply to Thread
Results 1 to 2 of 2

Bell curve - ratings

  1. #1
    Registered User
    Join Date
    01-27-2015
    Location
    Bosnia and Herzegovina
    MS-Off Ver
    Microsoft office 365 ProPlus
    Posts
    50

    Bell curve - ratings

    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
    Attached Files Attached Files
    Last edited by hkaric; 11-23-2018 at 05:47 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Bell curve - ratings

    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
    3
    Emp 1
    2
    5
    1
    5
    4
    1
    4
    4
    6
    4
    3.6
    5.5
    M3: =AVERAGE(L3:L22)
    4
    Emp 2
    3
    6
    5
    6
    2
    5
    2
    2
    5
    2
    3.8
    1.079
    M4: =STDEV(L3:L22)
    5
    Emp 3
    5
    3
    6
    8
    3
    6
    3
    3
    6
    3
    4.6
    6
    Emp 4
    6
    5
    8
    7
    5
    8
    5
    5
    3
    5
    5.7
    7
    Emp 5
    8
    6
    7
    5
    6
    7
    6
    6
    2
    6
    5.9
    8
    Emp 6
    9
    8
    3
    6
    8
    2
    8
    8
    3
    8
    6.3
    9
    Emp 7
    1
    7
    5
    9
    9
    3
    9
    9
    5
    9
    6.6
    10
    Emp 8
    2
    5
    6
    10
    1
    5
    6
    1
    6
    6
    4.8
    11
    Emp 9
    3
    6
    8
    5
    5
    6
    6
    2
    8
    1
    5.0
    12
    Emp 10
    5
    9
    9
    5
    6
    8
    9
    5
    9
    2
    6.7
    13
    Emp 11
    6
    10
    1
    6
    8
    9
    10
    6
    1
    1
    5.8
    14
    Emp 12
    8
    5
    5
    8
    7
    1
    5
    8
    4
    5
    5.6
    15
    Emp 13
    7
    5
    6
    7
    6
    4
    6
    7
    2
    6
    5.6
    16
    Emp 14
    5
    8
    8
    5
    1
    2
    8
    5
    3
    8
    5.3
    17
    Emp 15
    6
    7
    7
    6
    5
    3
    9
    6
    5
    7
    6.1
    18
    Emp 16
    9
    8
    5
    9
    6
    5
    1
    9
    6
    1
    5.9
    19
    Emp 17
    10
    9
    6
    10
    8
    6
    6
    10
    8
    5
    7.8
    20
    Emp 18
    2
    6
    9
    10
    7
    8
    5
    3
    9
    6
    6.5
    21
    Emp 19
    5
    3
    10
    2
    8
    9
    5
    2
    1
    8
    5.3
    22
    Emp 20
    2
    6
    5
    3
    6
    1
    2
    3
    1
    7
    3.6
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bell curve
    By Marie81 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-17-2017, 08:27 AM
  2. Replies: 2
    Last Post: 02-19-2015, 02:00 PM
  3. How to make a bell curve/statistical curve????
    By pittstonacl in forum Excel General
    Replies: 1
    Last Post: 08-04-2014, 10:49 AM
  4. Normal distribution curve / Bell curve
    By LAG1 in forum Excel General
    Replies: 0
    Last Post: 05-24-2012, 07:20 AM
  5. A bell curve
    By Nighteg in forum Excel General
    Replies: 0
    Last Post: 02-15-2012, 09:47 AM
  6. Bell Curve
    By uglymonky in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-06-2009, 09:25 AM
  7. Bell Curve
    By Todd Nelson in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1