×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Normal distribution for data entered as percentages

Normal distribution for data entered as percentages

Normal distribution for data entered as percentages

(OP)
Dear all,

I am doing normal distribution analyses on parameters expressed in percentages. Sometimes the parameters have specified ranges, sometimes not.

This works fine when the data and their specifications are in the mid percentage ranges. I can determine the number of samples expected in spec, out of spec, in some other given range, cp, cpk etc.

When however data/ specs are at the percentage extremes ie. close to 0 or 100 the analysis gives me expected stats for samples falling below 0 or greater than 100.
For example if the data has a mean of 95% and an sd of 2 it predicts that a percentage of results can be expected to have values >100% which of course they can't.

Ok so I can add that percentage back into the those expected to fall =<100% but is that the correct way to handle this situation. I would prefer to stick with normal distibution analysis if possible because it works well for most parameters and I would like results across all parameters to be comparable.

Any help would be much appreciated.

regards Hugh.

RE: Normal distribution for data entered as percentages

If you stop usng percentages, and instead normalise everything as a function of the mean value, then all your problems will go away.

The %ages are not simple %ages, they are per cent of the mean value. As such 135% is a valid number.

Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Normal distribution for data entered as percentages

(OP)
Greg,

Thank you for responding so quickly.
Unfortunately I do not understand what you are telling me - so can you expand on it a little if not completely.

regards Hugh,

RE: Normal distribution for data entered as percentages

Suppose your mean value is 3, and your standard deviation is 2.

Then your upper and lower 3 sigma limits are 9 and -3.

Howver, since you have chosen to use %ages, your mean is 100%, +3 sigma is at 300%, and -3 sigma is at -100%.

These look daft, it is because you are normalising that which should not be normalised.

Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Normal distribution for data entered as percentages

(OP)
Greg,

I have not chosen to use percentages, the data I am working with is percents passing given sieve apertures. Such data is always measured and specified in terms of percent passing in the aggregate/ construction industry. e.g. a material may be specified to have 95 -100 % passing a 20mm sieve, 30 - 50 passing a 28mm sieve and 0-10 % passing a 10mm sieve.

Some of my stuff at http://www.gradlab.com/DistMultiGraf.htm ref especially the 14mm sieve

Does this make a difference?

regards Hugh,

RE: Normal distribution for data entered as percentages

Any particular reason why you are applying a normal distribution analysis to a non-normal distribution?

Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Normal distribution for data entered as percentages

(OP)
Greg,

It's just normally done that way.

So what distribution would you consider more appropriate?

Would that apply just to the parameters (sieves) having values close to 0% and 100% or all of them?

regards Hugh,

RE: Normal distribution for data entered as percentages

The common approach is to transform your distribution into a normal one. This is a bodge.

Strictly speaking you can't apply normal distributions to any data that has hard limits. Often we do, but it ain't clever.

This is not an appropriate forum for this discussion, you really need to sit down with a big stats book and figure out your own solution for non-normal distributions.

Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: Normal distribution for data entered as percentages

(OP)
Greg,

Ok, so the solution is not a simple one.

Thanks for your help and a star for you.

kind regards Hugh,

RE: Normal distribution for data entered as percentages

HughL - why not look up Indiana's INDOT aggregate manual.  They have a pretty good section on statistics and control of aggregate gradations.  (p.s. to all:  sorry this isn't "statistical"!)
cheers

RE: Normal distribution for data entered as percentages

(OP)
BigH,

Thanks for your feedback. The INDOT manual is interesting.
I see with some reassurance that INDOT (6. Statistical QC for Aggregate Processing)stick with the normal distribution and simply add the percentages expected beyond zero and 100 back into the compliant group (as proposed in verse 4 of my original post). Just why they present Table 6-1 is a bit of a mystery because it can be simply derived from Table 6-2 (a standard norm dist table) by adding 0.5 to all the values.

regards Hugh,

 

RE: Normal distribution for data entered as percentages

Glad it is of some help - it is how this is done in standard highway practice.  I am in the process of implementing this same procedures for crushing operations at my project here in Indonesia.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources