Closed Thread
Results 1 to 11 of 11

Anderson Darling Normality - Sense Check Please?

  1. #1
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010
    Posts
    3,160

    Anderson Darling Normality - Sense Check Please?

    Folks,

    Could someone "stats savvy" please road-test the attached code for me?

    This function should return a 1x4 array of S, AD, AD*, and p for an AD normality test.

    Useage is =ADNormailty(Range)


    any thanks,

    Dave
    Attached Files Attached Files
    Last edited by sweep; 07-04-2011 at 06:51 AM.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  2. #2
    Registered User
    Join Date
    06-28-2011
    Location
    Cypress, TX
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Anderson Darling Normality - Sense Check Please?

    Hello Dave,

    I compared the results of your function for five data sets using the function contained in the SPC for Excel software (I am the developer of that). Results are identical so it looks like a good function to me.

    Bill

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010
    Posts
    3,160

    Re: Anderson Darling Normality - Sense Check Please?

    Thanks Bill.

    I have had similar agreement - I'll implement it.

  4. #4
    Registered User
    Join Date
    09-20-2011
    Location
    TW
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Anderson Darling Normality - Sense Check Please?

    Dear, hello !
    Thank you for your share!
    And i have some trouble in this code, So can you help me?
    I used the formula select the 10 data :
    57
    67
    49
    64
    73
    91
    66
    87
    74
    58
    but the result output only a value: -102.384, what's wrong happen ?
    ===
    I'm sorry for my careless post .
    Last edited by flying007; 09-20-2011 at 04:30 AM.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,429

    Re: Anderson Darling Normality - Sense Check Please?

    wellcome to the forum. .. Please check rules:

    2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

  6. #6
    Registered User
    Join Date
    04-25-2012
    Location
    hamburg
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Anderson Darling Normality - Sense Check Please?

    Thank you, thank you very much!

  7. #7
    Registered User
    Join Date
    06-30-2013
    Location
    Veldegem
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Anderson Darling Normality - Sense Check Please?

    First of all, thanks for this great function.

    One thing however, this function those not take in account the possibility for empty cells.
    Therefore I have adapted the code - see attachment

    ADNormality.txt


    thanks
    Last edited by ddter; 06-30-2013 at 08:33 AM.

  8. #8
    Registered User
    Join Date
    10-11-2013
    Location
    Beverwijk
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Anderson Darling Normality - Sense Check Please?

    In the below mentioned website, the Anderson Darling test is explained.
    Can anybody tell me why there is a correction in the calculation of the Z-value (see column L of sheet 2 in the embedded excel-sheet of the below mentioned website).

    The P value is not calculated as i/n. But corrected and is now calculated as (i-0,3)/(n+0.4)
    Can anybody give some substantation of the used 0.3 and 0.4. The N is maximised at n=200.

    https://www.spcforexcel.com/knowledg...-for-normality

  9. #9
    Registered User
    Join Date
    10-11-2013
    Location
    Beverwijk
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Anderson Darling Normality - Sense Check Please?

    In the below mentioned website, the Anderson Darling test is explained.
    Can anybody tell me why there is a correction in the calculation of the Z-value (see column L of sheet 2 in the embedded excel-sheet of the below mentioned website).

    The P value is not calculated as i/n. But corrected and is now calculated as (i-0,3)/(n+0.4)
    Can anybody give some substantation of the used 0.3 and 0.4. The N is maximised at n=200.

    https://www.spcforexcel.com/knowledg...-for-normality

  10. #10
    Registered User
    Join Date
    10-11-2013
    Location
    Beverwijk
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Anderson Darling Normality - Sense Check Please?

    In the below mentioned website, the Anderson Darling test is explained.
    Can anybody tell me why there is a correction in the calculation of the Z-value (see column L of sheet 2 in the embedded excel-sheet of the below mentioned website).

    The P value is not calculated as i/n. But corrected and is now calculated as (i-0,3)/(n+0.4)
    Can anybody give some substantation of the used 0.3 and 0.4. The N is maximised at n=200.

    https://www.spcforexcel.com/knowledg...-for-normality

  11. #11
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,429

    Re: Anderson Darling Normality - Sense Check Please?

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Closed 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