+ Reply to Thread
Results 1 to 3 of 3

Creating a bell chart for standard deviation

  1. #1
    Registered User
    Join Date
    01-31-2011
    Location
    Lynnwood, WA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Exclamation Creating a bell chart for standard deviation

    I need help creating a bell chart for the standard deviation in the data below. Can someone help me pretty please?

    1 2 3 4 5 6 Rating Average Response Count Median Mode St. Dev.
    5 15 10 10 9 4 3.28 53 3.5 2 1.47
    7 16 8 16 4 2 3.00 53 3.5 2, 4 1.34
    4 17 13 12 6 1 3.04 53 3.5 2 1.22
    10 12 14 11 5 1 2.85 53 3.5 3 1.32
    11 14 14 3 9 2 2.83 53 3.5 2, 3 1.48
    16 11 15 7 2 2 2.51 53 3.5 1 1.35
    2 4 15 11 16 5 3.94 53 3.5 5 1.28
    3 10 12 19 7 2 3.43 53 3.5 4 1.22
    4 8 12 19 8 2 3.47 53 3.5 4 1.25
    9 12 13 9 9 1 3.00 53 3.5 3 1.40
    10 23 10 7 2 1 2.45 53 3.5 2 1.17
    0 10 12 13 14 3 3.77 52 4 5 1.21
    4 10 11 13 12 3 3.53 53 3.5 4 1.38
    5 4 14 14 12 3 3.63 52 3.5 3, 4 1.34
    4 7 9 12 18 3 3.79 53 3.5 5 1.39
    5 8 16 10 12 2 3.42 53 3.5 3 1.35
    7 15 13 9 9 0 2.96 53 3 2 1.30
    8 10 7 16 9 3 3.32 53 3.5 4 1.49
    5 10 6 15 10 6 3.63 52 3.5 4 1.52
    3 13 13 15 6 2 3.27 52 3.5 4 1.24

  2. #2
    Registered User
    Join Date
    07-30-2010
    Location
    South Pole
    MS-Off Ver
    Excel 2010
    Posts
    99

    Re: Creating a bell chart for standard deviation

    http://www.exceluser.com/explore/normalcurve.htm

  3. #3
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,054

    Re: Creating a bell chart for standard deviation

    Hi,

    I attached some example files that I mainly found from various sources, off the Internet.

    There are 2 examples.
    Attached Files Attached Files
    MyCon
    -- Using Latest Version of Excel

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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