+ Reply to Thread
Results 1 to 2 of 2

Bell curve

  1. #1
    Registered User
    Join Date
    08-22-2017
    Location
    perth, ea
    MS-Off Ver
    2010
    Posts
    4

    Bell curve

    Hi,

    I've made the bell curve graph from the file attached. Can someone guide me whether I have to include 2 new columns like 1 standard dev and 2
    standard dev. How do I check for 68% observations within 1 standard deviation and 95% within 2 standard deviation range.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-16-2016
    Location
    Greece
    MS-Off Ver
    2013
    Posts
    69

    Re: Bell curve

    Why do you need to include 2 new columns?

    To check for 68% of observations being within 1 standard deviation, you can use this formula:
    Please Login or Register  to view this content.
    If you do it you'll see that the result is 63% (I suppose it's acceptable but it's up to you to decide). I'm sure you can figure out the rest.

+ 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. Help with Bell Curve
    By itshere in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2015, 01:34 PM
  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. Bell curve
    By alykins in forum Excel General
    Replies: 10
    Last Post: 05-27-2011, 12:56 PM
  6. Bell Curve
    By Girish H Tandon in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-05-2011, 11:44 PM
  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