WEDNESDAY, AUGUST 23, 2017
Font Size
Topic Non-normal Data Query

Non-normal Data Query

Home Forums General Forums New to Lean Six Sigma Non-normal Data Query

This topic contains 12 replies, has 6 voices, and was last updated by  Chris Seider 5 months, 1 week ago.

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #535140 Reply

    Hitesh Kathuria

    I have a sample data where the objective is to estimate the number of parties involved in each contract. The sample shows that variation from 1 name to 12000, which is most likely going to remain in the population. How to deal with such scenario as the mean and median both will not be helpful?

    #535189 Reply

    What do YOU think you should do? Why or why not?

    The iSixSigma audience is helpful, but they are not here to do your work for you.

    #535455 Reply

    Why do you think the mean and/or the median would not be helpful?

    #535549 Reply

    Which of mean or median WILL be helpful?

    #535821 Reply

    Hitesh Kathuria

    I meant to say…..How to deal with such scenario as the mean and median both have an influence of variation?

    The median of data is very low whereas mean is high… The objective is to avoid the risk of over or under estimation.

    #535872 Reply

    The mean and the median are two measures of central tendency. I’m not sure what you mean by saying “both have an influence of variation.”

    Question: Did you plot the data (histogram, normal probability plot, etc.) If so what did you see? Just graphing the data and looking at the result should go a long way with respect to helping you decide which descriptive statistics should be applied.

    #535874 Reply

    And what is the Mode telling you? How big is your sample?

    as @rbutler says graphing the data will give you some clues but that does depend on the size of your sample too.

    #536877 Reply

    Hitesh Kathuria

    I plotted the data and the summary as follow, hope this assist in understanding the summary.

    Anderson-Darling Normality Test
    A-Squared 40.07
    P-Value <0.005
    Mean 38.844
    StDev 73.609
    Variance 5418.341
    Skewness 4.4121
    Kurtosis 21.3030
    N 212
    Minimum 1.000
    1st Quartile 10.000
    Median 18.000
    3rd Quartile 34.750
    Maximum 532.000
    95% Confidence Interval for Mean
    28.879 48.810
    95% Confidence Interval for Median
    14.000 21.000
    95% Confidence Interval for StDev
    67.206 81.372

    #536919 Reply

    In the original post you said “The sample shows that variation from 1 name to 12000”. The summary statistics you provided indicate a minimum of 1 and a maximum of 532 – what happened to 12000?

    Also – could you post a jpeg of the histogram of your data?

    #536961 Reply

    This is a count, correct?

    #545445 Reply

    Hitesh Kathuria

    Yes this is a count

    I have removed the outlier with 12000, considering it as exception.

    Can’t paste the image on it

    #545458 Reply

    So – you have a total sample of 212 contracts and the number of people associated with each contract can vary from 1 to 532 with 50% of the contracts having 18 people or less.

    What is the story with respect to the contracts? Are they all the same kind of contract? If they aren’t then it would be worth splitting the sample by contract type and checking the distributions of number of people by contract type.

    If they are all the same kind of contract then the question you would want to address is: How come supposedly identical contract types have such a wide range of individuals associated with them?

    #545568 Reply

    Yes, you may want to analyze the various demographics categories to begin to solve the problem.

Viewing 13 posts - 1 through 13 (of 13 total)

Register Now

  • Stop this in-your-face notice
  • Reserve your username
  • Follow people you like, learn from
  • Extend your profile
  • Gain reputation for your contributions
  • No annoying captchas across site
And much more! C'mon, register now.

Reply To: Non-normal Data Query
Your information:






5S and Lean eBooks
GAGEpack for Quality Assurance
Six Sigma Statistical and Graphical Analysis with SigmaXL
Six Sigma Online Certification: White, Yellow, Green and Black Belt
Lean and Six Sigma Project Examples
Six Sigma Online Certification: White, Yellow, Green and Black Belt

Find the Perfect Six Sigma Job

Login Form