+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] How do i set up a normal distribution in excel?

  1. #1
    dimi
    Guest

    [SOLVED] How do i set up a normal distribution in excel?

    I need to find out how you can set up a normal distribution curve on
    microsoft excel. When I search normal distribution i get a function for it
    but i want to see the curve, which i can't figue out how to do

  2. #2
    Matt Lunn
    Guest

    RE: How do i set up a normal distribution in excel?



    "dimi" wrote:

    > I need to find out how you can set up a normal distribution curve on
    > microsoft excel. When I search normal distribution i get a function for it
    > but i want to see the curve, which i can't figue out how to do



    In column A set up your X values, For example from -4 to +4. Increments of
    0.1 should be OK.

    In column B use the NORMDIST function like this

    If you X values start at A1 then cell B1 should be

    =NORMDIST(A1,0,1,FALSE)

    Copy the formula down for all X values.

    Produce chart on Column B and use Column A for X values

    HTH

    Matt

+ 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