+ Reply to Thread
Results 1 to 6 of 6

How do I check if a number of values are normally distributed?

  1. #1
    Registered User
    Join Date
    09-12-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2013
    Posts
    3

    How do I check if a number of values are normally distributed?

    I have a number of values, actually around 50 blood test results. Is there a function in Excel that can tell me whether or not these values are normally distributed? If these 50 blood test results are lined up in A2-A51, how do I formulate the function?



    Thanks!

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How do I check if a number of values are normally distributed?

    Plot a graph and see if it looks like a normal distribution?

    It's not that simple an answer for excel, excel does have two functions Skew() and Kurt() which can guide you as to how "normal" your dataset is (closer they are to 0, more normal your dataset is, crudely). However, in 2003 you can only have 30 arguements but not sure if this is different in newer versions.

    One method for testing how normally distributed a dataset is would be: http://en.wikipedia.org/wiki/Jarque%E2%80%93Bera_test

    You could also have a look at this youtube video: www.youtube.com/watch?v=o3ye4b5TaPU

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: How do I check if a number of values are normally distributed?

    There build in functions in Excel
    Look under NORM.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How do I check if a number of values are normally distributed?

    @RobertMika - I'm not sure the NORM functions will actually tell you whether a dataset is normally distributed? I thought they just give you the normal distribution for a specified set of a parameters? Could be wrong though, in 2003 I think I have NORMDIST and NORMINV, are there any others?

  5. #5
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: How do I check if a number of values are normally distributed?

    Depens how deeper you need to go to extablished your normality.
    SKEW and KURT ara available in Excel 2003.

  6. #6
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: How do I check if a number of values are normally distributed?

    Yes but as I mentioned in post 2, not sure how useful they will be for OP as they are limited to 30 datapoints.

+ 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. Replies: 1
    Last Post: 01-17-2013, 10:44 AM
  2. [SOLVED] Check if cellvalue is text or number, even when number is in textformat
    By MarMo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2012, 07:53 AM
  3. Replies: 1
    Last Post: 09-15-2010, 04:54 PM
  4. Distributed Addins
    By Andy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2005, 03:05 PM
  5. [SOLVED] Distributed retrival
    By Conrad Carlberg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM

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