+ Reply to Thread
Results 1 to 3 of 3

Anderson Darling/ Normality - Question about a specific correction

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

    Anderson Darling/ Normality - Question about a specific correction

    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 substantiation of the used 0.3 and 0.4. The N is maximized at n=200.

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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,819

    Re: Anderson Darling/ Normality - Question about a specific correction

    Why don't you ask the question on that website at the bottom of the article? The author (Bill) still seems to be supporting it, judging by recent comments there.

    Pete

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

    Re: Anderson Darling/ Normality - Question about a specific correction

    Thanks. initially missed that possibility. However when I tried the possibility it did not work.
    Last edited by Stefan1234; 03-29-2016 at 09:46 AM.

+ 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. Anderson Darling Normality - Sense Check Please?
    By sweep in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-29-2016, 07:03 AM
  2. Replies: 15
    Last Post: 03-19-2014, 03:44 AM
  3. Check Normality of the data in Excel
    By rsoumitra in forum Excel General
    Replies: 3
    Last Post: 10-20-2006, 06:46 AM
  4. correction to the question
    By Mir Khan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2006, 10:00 PM
  5. Correction, x y axis question...
    By JcR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2006, 11:40 AM
  6. [SOLVED] how to do normality test in excel
    By sabrina in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-22-2005, 12:20 AM
  7. Tests for Normality in Excel
    By Barb Reinhardt in forum Excel General
    Replies: 2
    Last Post: 09-29-2005, 09:05 PM
  8. Chi-Squared, Komogorov-Smirnov, Anderson-Darling tests
    By yo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-21-2005, 04:06 PM

Tags for this Thread

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