## Forum Replies Created

- AuthorPosts
- October 21, 2019 at 11:38 pm #243104

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I don’t understand what you mean by “simulate”.

If you just want to play games with the variation around a .271 or a .300 batting average over time the easiest thing to do is take a thousand samples – in the first case 271 1’s and 729 0’s and in the second case 300 1’s and 700 0’s. Put them in two columns with 271 1’s followed by 729 0’s (or the other way around – it doesn’t matter) and the same for the 300 and 700. Then find a random number generator function out on the web and have it generate a random sequence of integers from 1 to 1000 (sampling without replacement so you only get each integer once). Do this twice and then match the random column one-to-one with the 0’s and 1’s column and then sort the two columns by the random number column so the random numbers are in sequence from 1 to 1000. This will result in a random draw for the 0’s and 1’s and you can take any sub-sample of any size (1-50, 35-220, 14-700, etc.) and compute the batting averages for those sub-samples and see what you see.

1October 7, 2019 at 2:49 pm #242608

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.The old post cited below should provide some insight into the BOB, WOW issues.

https://www.isixsigma.com/topic/shainin-and-classical-doe-a-comparison/

0September 21, 2019 at 10:17 pm #242322

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.In other words, you have noticed some people are not interested in the results of a careful analysis and prefer to go with their gut reactions. It’s been this way ever since homo sapiens emerged as a distinct species and, barring some natural selection pressure that favors logic over emotion, there’s not much you can do about it in the short term and, on an evolutionary time scale, you won’t be around when and if that kind of selection pressure arises and changes the species from homo sap to homo sensible.

0September 20, 2019 at 12:37 pm #242305

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.@cseider – you had to look it up???!!! What else could CCPS be except Capacitor Charging Power Supply???? A rather esoteric subject but one, I’m sure, that must be of intense interest to some members of the IsixSigma community.

0September 9, 2019 at 4:59 pm #242050

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.For a paired frequency test you could have the students run a series of say 50 flips of a clean penny and then run a series of 50 spins of a clean penny to see if there is a significant difference in the odds of the penny coming up heads (or tails).

0September 8, 2019 at 3:37 pm #242023

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Well then, for heavens sake – as a favor to your mental well being – don’t ask it! ;-)

Seriously, I can’t decide if you are just venting, asking for civil ways to counter this question when it is put to you, or something else.

3September 2, 2019 at 9:47 am #241834

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Well, there’s more to it than that. It is correct that you cannot use the generic curvilinear expression for purposes of prediction because there isn’t any way to assign that response to either of the two variables you have. This means, for purposes of prediction, the best you can do is an equation with mains and interaction. However, you don’t just remove the term and forget about what it is telling you.

If you are planning on using the equation you can construct for prediction purposes then there are several things you need to do in order to give yourself some understanding of the risks you are taking by using a predictive equation that has not accounted for all of the special cause variability in your data.

1. Residual plots – look at the residuals against the predicted – how far away from the zero line are the data points associated with the center points? If the distance is “large” (yes, this is a judgement call) then you could go wrong with great assurance. On the other hand if the points associated with the center points are “close to” but still on one side or the other then you are still not accounting for all of the special cause but, if you can’t do any more with respect to a few augmentation runs, it would be worth testing the equation to see how well it performs.

2. You need to scale and center your X’s in the manner I outlined in my first post and rerun the regression. As I said, when you do this you will have a way to directly compare the effects of unit changes in the terms in the model.

Just looking at your equation based on the raw numbers my guess is that the units of X1 and X2 are large which would account for the small coefficient for the interaction. I’m not sure what to make of the large coefficient for the generic squared term. If you re-run the analysis with the scaled X1 and X2 you will be able to directly assess the impact of choosing to ignore the existence of curvature.

0August 30, 2019 at 8:58 am #241697

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.There are two schools of thought concerning main effects and interactions – one school says if the interaction is significant you need to keep the main effects and the other one says you don’t.

As for the curvature:

a) I don’t see that term in your model

b) Assuming the equation is a typo – the curvature is generic which means all you know is that it exists therefore you will need to augment your design with one or perhaps two more experimental runs to identify the variable associated with the curvilinear behavior.

Something worth considering:

Take your two variables and scale them from -1 to 1 and re-run the analysis.

In order to do this you will need to find the actual minimum and maximum settings for each of the two variables and then do the following for each of the two variables.

A = (maximum + minimum)/2

B = (maximum – minimum)/2

Scaled X1 = (X1 – A1)/B1

Scaled X2 = (X2 – A2)/B2

If you re-run the analysis using the scaled terms you will get an equation that will allow you to directly compare the effects of a unit change in X1, X2, the generic squared term, and X1*X2 interaction. What this buys you is the ability to choose between the two methods of final terms in the model.

For example, if the coefficients of the scaled X1 and X2 are small relative to the coefficient of X1*X2 then, since X1 and X2 alone are not significant nothing much will be lost in the way of model use. On the other hand if they are equivalent then you might want to consider keeping them in the model. Of course, all of this assumes you are also doing the usual things one should be doing with respect to assessing the differences in the two models – residual analysis, prediction accuracy, etc.

0August 15, 2019 at 3:03 pm #241060

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.No, I’m afraid this discussion is not an example of a complete misunderstanding of a control chart – Wheeler and Chambers know their stuff.

I agree with 5 data points I can’t apply all of the control chart tests but I can do this – I can get an estimate of the ordinary process variance by employing the method of successive differences, I can get an estimate of the overall mean, and I can make a judgement call with respect to the 5 data points I have as far as addressing the question of grossly out of control points. When you have a process that generates 8 data points per run and when, at best, it is run twice a year, insisting on 30 data points before attempting an analysis means waiting a minimum of 2 years before doing anything – and that approach means you will have to run your process using the the old W.G.P G.A.* rule of thumb which is an excellent way to go wrong with great assurance.

A check of the back of any basic book in statistics will usually reveal a t-table. An examination of that table indicates the minimum number of data points needed for a t-test is 2. With two data points you can get an estimate of the mean and the variance and you can test that sample mean to see if it is statistically significantly different from a target.

When you run a two level two variable design it is quite common to have a total of 5 experimental runs and it is also quite common to use the results of those five experiments to develop predictive equations for a process. Once the equations have been built the first order of business is confirming their validity – typically this will consist of two or three process runs where the equations are used to identify optimum settings. If the equations do a decent job of prediction (and they do this with appalling regularity) those equations will be incorporated in the methods used for process control.

In short, the empirical rule of needing 30 data points before running a rough statistical analysis has no merit.

*Wonder, Guess, Putter, Guess Again

1August 15, 2019 at 7:38 am #241055

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As others have noted – more data points are better when it comes to assessing out of control and for all of the reasons already mentioned. However, waiting until you have more (we will arbitrarily define “more” as at least 20 data points) presumes the time/money/effort needed to get more data is forthcoming. I’ve worked on any number of processes where the total number of data points available for constructing a control chart to assess process control was 8 or less and the hope of getting any more data points in a “reasonable” period of time (say a few days or maybe a few weeks) was a forlorn one.

These processes were batch type processes run on an as needed basis and “as needed” translated into elapsed times of 6 months or more. Since we needed to have an assessment of level of process control I used all of the usual methods for assessing variation in the presence of little data. One of the big issues was that of the question of the in control nature of the first data point in the next cycle of needed production. If it was “in control” we would run the process as set up. If it was “out of control” we had no choice but to adjust the process. This was a decision that was not taken lightly because the effort required to adjust the process was involved, time consuming, and expensive. What I found was that even with a control chart consisting of data from a single run I was able to use what I had to make accurate assessments of the process when we started running the next cycle of production. Of course, once I had data from the second cycle it was immediately incorporated on a data-point-by-data-point basis and the chart was updated each time a new data point was added.

0August 6, 2019 at 10:02 am #240852

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Well @Straydog and @mike-carnell that guy @chebetz has found us out! I guess it’s time we ask Mike Cyger to tell Katie to change our screen names again. I think I’ll go with Dr. Theodore Sabbatini this time around. :-)

I can’t answer for Straydog or Mike but given our interactions over the years I’m pretty sure their answer will be the same as mine – specifically – no , the forum is not a day job and I don’t sit around waiting for the computer to signal me that someone has posted something new.

One of my engineers pointed me to this site back in 2002. I looked over some of the answers to basic statistics questions and couldn’t believe how wrong many of them were. So, with vicious self-interest as a driving force, I started answering various and sundry stat questions. I enjoy responding because this gives me an excellent chance to not only revisit some of my textbooks for details but also practice the art of explaining difficult concepts to non-statisticians. I will usually drop by in the morning before starting work and again in the evening after work to see if there is anything interesting. If there is and I decide to respond I’ll usually do that during lunch or, if it is short enough, during a coffee break. If the response is going to be too long or if I want the think about it I will wait until after work to write a response.

1August 5, 2019 at 9:13 pm #240841

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I don’t see any reason why you can’t if you want to. In most instances though the question will be: which customer spec limits are you going to include on your chart? I worked in industry for many years before shifting over to medicine and I can’t recall a single product where we were making something for just one customer.

There is also the issue of having customer specs that are well inside your control limits but, because of their location, the fact that they are is of no major consequence. For example, let’s say you manufacture polychrome fuzzwarts and the control limits for this sought after product are +- 3 polycrinkles. Customer #1 has a spec limit of -3 or less to -1 polycrinkles, customer #2 has a spec limit of 2 polycrinkles to 3 or more polycrinkles and everyone else is happy with anything between from -3 to + 3 polycrinkles. True, you will have to do lot selection for two of the groups but, if the cost of such an action is less than the cost of shifting the process when orders come in from the two populations then there is a good chance you will leave the process alone. Under such circumstances the inclusion of customer spec limits will just clutter the graph.

1August 2, 2019 at 12:52 pm #240799

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Something doesn’t seem right. I would like to check the calculation. Could you post your total sample size and the values of the two averages?

0July 27, 2019 at 10:34 am #240669

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Let’s see if we can’t get you off of dead center.

You said the following:

**Given a set of data, how do you conduct a baseline performance analysis? Is this the same as a capability analysis?****And, when looking at a set of data, how can you tell where the process changed?****My assignment asks me to complete a baseline performance analysis and “if the process changed, you must select where it changed and compute your answers.” It later says “Divide up the data as separated in the last question.” What does this mean?**1. Have you been given a data set to work with?

2. Is what you posted all that you have been given in the way of a question or is your post a paraphrase of the actual problem?

3. What is your understanding of the definition of the phrase “baseline performance” as it applies to a data set which (presumably) is supposed to represent process data acquired over some period of time?

a. Given what you have posted, does the phrase “baseline performance” relate to the process mean, variance, median, IQR, or some other aspect or some combination of the properties listed?

b. What kind of methods have you been taught to address questions concerning any of the items listed in a)?

c. What kind of methods have you been taught to address changes in any of the items listed in a)?

4. What is your understanding of what constitutes a capability analysis?

5. What is your understanding of what a capability analysis evaluates?

a. In any of your reading about capability analysis did any author conflate the phrases “capability analysis” and “baseline analysis?”

b. Have you taken the time to check these two phrases using a Google search?

1. If so, what did you find?

If you can provide the answers to these questions you should have a partial answer to your original question and if you post your answers here perhaps I or some other poster may be able to offer additional assistance.

1July 21, 2019 at 6:08 pm #240548

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I’ve been away from any computer contact for the last 10 days, however, Happy belated birthday Mike… 19 July…hmmm interesting day that….

Circus Maximus catches fire – 64

15-year-old Lady Jane Grey deposed as England’s Queen after 9 days -1553

Astronomer Johannes Kepler has an epiphany and records his first thoughts of what is to become his theory of the geometrical basis of the universe while teaching in Graz -1595

5 people are hanged for witchcraft in Salem – 1692

HMS Beagle with Charles Darwin arrives in Ascension Island – 1836

1st railroad reaches Kansas – 1860

Franco-Prussian war begins – 1870

0July 10, 2019 at 12:17 pm #240371

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I guess what I find most disturbing about the statement “these are actual questions from the exams” is the very real possibility of failing someone because they DID know the material and, conversely, passing someone who was ignorant of the correct answer.

0July 9, 2019 at 10:51 pm #240357

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.In this instance the question does not make sense. The usual way one describes Type I and Type II error is as follows:

Type I error is the risk of rejecting something when it is true.

Type II error is the risk of accepting something when it is false.

So the risk of rejecting something when it is false doesn’t meet the definitions of either Type I or Type II error and Type III error is providing the right answer to the wrong question.

In this case the null is: No improvement in the process occurred

The alternate is hypothesis is : Improvement in the process occurred.

So if improvement did occur in the process then the null was false and we correctly rejected it and we did not commit either Type I or Type II error.

0July 9, 2019 at 12:03 pm #240341

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.It looks to me like they’ve screwed up again. Answer C is the estimate of the standard deviation (24/6). Your calculations are correct.

0July 8, 2019 at 1:51 pm #240320

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I’m sure they do. Here’s the issue

1. What exactly is a 32 factorial design? I’m not aware of any reference that expresses design nomenclature in this manner.

The usual practice is to say say things such as the following:

1. I have a two level design with 3 factors

2. I have a full 2 level factorial design for 5 variables for a total run of 32 experiments.

3. I have a saturated design of 32 runs to investigate 31 variables in 32 experiments.As for the claim concerning the correctness of B – just look at the graph – the greatest tool age occurs with all 3 variables at their highest settings. The only way you could justify the claim would be if you had an interaction plot showing the effects of cutting speed and metal hardness and on THAT graph you had a situation where the combination of low cutting speed and high metal hardness resulted in greater tool aging. You cannot deduce answer B from an examination of those main effects plots.

You are welcome to ask them but, given my experience with such entities it will be nothing more than contrivindum non pissandum.

- This reply was modified 4 months, 1 week ago by Robert Butler. Reason: typo

0July 8, 2019 at 1:15 pm #240316

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I would say C,D,E and I think C is a typo – my guess is that they meant to have 3*2 = 6 experiments.

Actually, there is another possibility – but if it is the case then the problem is poorly presented and C still remains a typo. Since they do claim it is a factorial design one could take a saturated 3 variable in 4 experiments design and augment it with two additional runs. This would still be a factorial design in 6 experiments but not if we are abiding by the standard definition (which I’m assuming they are) of a factorial design. So, if they mean a factorial design in the usual sense, then it would be a 2**3 design which still means C is a typo.

Neither A or B are correct.

- This reply was modified 4 months, 1 week ago by Robert Butler.
- This reply was modified 4 months, 1 week ago by Robert Butler.

0July 6, 2019 at 6:19 pm #240269

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I think you will need to provide some additional details.

1. In your first post you are talking about weight and in your second post you are talking about height – which is it?

2. In your first post you will need to clarify what you mean by “I have a normal distribution for a coating weight per part of 1 gram/m2 and a standard deviation of 0.01 g/m2.”

a. As written it could be taken to mean you have a normal distribution with an average of 1 gram/m2 and a long term population sample deviation of .01 gm/m2 or it could mean you have a part that is 1 gram/m2 which comes from a population that has a population standard deviation of .01 gm/m2. There is also the question of the standard deviation – is it a long term population standard deviation or is it a long term standard deviation of the mean (in which case we will need to know the sample size used to generate the estimate of the standard deviation of the mean).If we assume the 1 gm/m2 represents the long term population mean and if we assume the standard deviation is an estimate of the population mean then the chances of getting a part, never mind a random collection of 100 parts, with an average value of .95 is nil because 3 x the standard deviation is only going to span a range of .97 to 1.03.

If you can provide more information perhaps I or someone else might be able to offer some suggestions.

0July 2, 2019 at 10:22 am #240187

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.No, it’s not a case of the less you have of repeated measures the less precision you have on the value of the standard deviation of the GRR rather it is a matter of the less you have of repeated measures the better the precision of your estimate of the true value of the standard deviation of the GRR. As I said – repeated measures variation will underestimate the actual standard deviation and that, in turn, will adversely impact your conclusions concerning GRR.

1July 2, 2019 at 9:25 am #240184

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.In addition to what @cseider said you also do not have independent measurements – you have repeated measures on a single item which means your estimates of variation are going to be much less than the real variation you can expect in your process.

0June 24, 2019 at 7:49 am #240005

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I’m not trying to be funny at your expense but if you really have a process like this then then next Nobel Prize in Physics will be yours on demand because you have found a process that exhibits zero variation which means you have invalidated the second law of thermodynamics – something that heretofore was deemed physically impossible.

Seriously, it appears you have a measurement system that is completely inadequate with respect to detecting changes in your process. This, in turn, eliminates any possibility of computing process capability. I realize you said in your post to the other thread you started that you couldn’t afford a better measuring device but what I don’t understand is how, with the same measuring device, you could go from the plots you provided in the other thread to the plots you provided in this one.

If both of these plots are of the same process with the only difference between the two sets of data being some kind of “correction” then I would first want to re-examine the correction process because whatever it is doing is wrong.

One additional thought – in both of your threads you do not give any sense of the elapsed time for taking the measurements you have illustrated in your plots. I assumed your first plots in the other thread represented independent samples taken over a “reasonable” period of time (at a minimum multiple days). If the time interval is very short then, not only are you at risk of not having independent samples but, if it is short enough it may explain the odd plot you just provided – i.e. the interval was so short that what variation was exhibited was indeed too small to be detected by your measurement device.

- This reply was modified 4 months, 3 weeks ago by Robert Butler.
- This reply was modified 4 months, 3 weeks ago by Katie Barry.

1June 23, 2019 at 10:09 pm #239995

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I would recommend you re-examine your data. The IMR plot gives a visual impression of three distinct shifts downward in your data. The first cut point occurs at about data point 44, and the second at about data point 83. It also gives the impression the process is drifting back toward the target around data point 93. In short, the plot would suggest you don’t have the process in control. One of the requirements of a capability study is that the data needs to be from a stable process.

Before worrying about issues of normality or capability I would want to go back and see if I could identify the reasons for what appears to be special cause variation and change the process so that the data is exhibiting only ordinary process variation. In the interim, if you want to use the data to give yourself a measure of expected ordinary variation (and also check to see if the visual appearance really is signalling the presence of special cause variation) you could generate an estimate of ordinary variability using the method of successive differences.

1June 19, 2019 at 7:07 am #239875

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I’m not trying to be sarcastic but who is making the claim that linear plots are mostly used in [an examination?] of a linear regression?

There are any number of reasons why an analysis might result in employing simple linear plots. For example:

1. Your plan for analysis involves running a two level factorial design. – In this case, by definition, a simple linear plot is all you are going to get.

2. A plot of your production data says the the trend is linear – therefore if you run a regression on the data linear is going to be the best fit.

3. Even though your knowledge of the process says the relationship between your independent and dependent variables is some sort of curvilinear process, the region where you happen to be running your process is a region where the relationship between the independent and dependent variables are essentially linear.If you are going to look at curvilinear trending then, at the very minimum, you need to have 3 levels for your independent variables. One of the reasons you run center points on two-level factorial designs (we are assuming the X’s are or can be treated as continuous) is to check for possible deviations from linear. If you find this to be the case then one will often augment the existing design to check for some kind of curvilinear response (usually quadratic/logarithmic)and your final plots will be curvilinear in nature.

As for cubic (or higher) – the first question you need to ask is when would you expect to encounter such behavior? If you are actually working on something and plots of your production data do suggest you have a real cubic response then you would want to build a design with 4 levels for the various continuous independent variables.

In all of the years of process analysis the only time I ever encountered a genuine cubic response was when we found out the region we were examining resulted in a phase change of the output (we were adding a rubberized compound to a plastic mix and we crossed the 50% threshold which meant we went from rubberized plastic to plasticized rubber). In short, in my experience, real cubic and higher curvilinear responses are extremely rare.

There is, of course, data that is cyclic in nature such as monthly changes in demand for a product and I suppose you could try to model data of this type using linear regression methods but the first line of defense when attacking this kind of data is time series analysis and a discussion of that tool is, I think, beyond the focus of your question.

- This reply was modified 4 months, 3 weeks ago by Robert Butler.

0June 14, 2019 at 11:53 am #239801

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I see I spoke too soon. What I said above still applies with respect to the graphical presentation and sampling plan you should use when repeating your test but since you provided the actual data there are a couple of other things to consider.

Again, if we pretend the sequential measures within a given operator are independent (they’re not) then for all of the data we find there is a significant difference between shift means 1817 and 2826 (P < .0001) and we also find there is a significant difference in shift variability with standard deviations of 193 and 98 respectively (P = .016).

A quick check of the boxplots suggests the single measure of 2280 in the first shift is the cause for the differences in standard deviations. If we re-run the analysis with that value removed what we get are means of 1784 and 2826 – still significantly different (P < .0001) and standard deviations of 150 and 98 (P = .12). So, overall you first shift has a significantly lower mean scoop measure and a numerically higher (

**but not significantly different**) variability.You could go ahead and try to parse the data down to the individual operator but with just five repeated measures per person I wouldn’t recommend doing this for two reasons 1) the measures within each operator are not independent and 2) even if the measures were independent it is highly unlikely that the variability of a sequential 5-in-a-row sample is at all representative of the variability one would see within a given operator over the course of a shift.

I would recommend summarizing your findings in the form of the graph below along with a few simple summary statistics of the means and the variances and then, before trying to do anything else – address and solve the issues you mentioned in your second post and then re-run the sampling plan in the form I mentioned above.

0June 14, 2019 at 11:16 am #239799

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I don’t know Minitab but I do know they have boxplots graphics which I would recommend you use. You would have side-by-side boxplots of the two shifts. What you will want to do is to make boxplots which also shows the raw data that way you will not only have the boxplot with its summary statistics but you will be able to see visually just how the data distributes itself with each shift. See Attached for example.

For your repetition you will want to take five measurements but not back-to-back – rather randomize the pick through the time of the shift. This will mean extra work for you but it will guarantee that your measurements are representative of what is happening in the course of a shift.

0June 13, 2019 at 9:43 pm #239789

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Just a visual impression of your data says you have a statistically significant difference in mean scoop size between first and second shift. If we check it formally and pretend the measures within each team member can be treated as independent measures then what you have is 1.22 vs 1.88 (which, given the limit on significant digits reduces to 1.2 vs 1.9) with corresponding standard deviations of .168 and .172 (which rounds to .17 and .17). There is a significant difference in the means (P <.0001) and there is no significant difference (P = .92) with respect to shift variability.

One thing you should consider. The above assumes the measures within each team member are independent. If the measures you have reported are random draws from a single shift work for each team member then it is probably reasonable to treat the measures as independent within a given member. On the other hand, if the measures were just 5 scoops in sequence then you are looking at repeated measures which means your estimates for shift variance are much smaller than they really are.

Before you do anything else you need to understand the cause of the difference in scoop means between shifts. If the material is uniform, the front end loaders are the same, the 6 individuals all have the same level of skill in handling a front end loader and all other things of importance to the process are equal between the two shifts then you shouldn’t have a difference like the one you have in your data.

- This reply was modified 5 months ago by Robert Butler.

0June 10, 2019 at 10:57 pm #239709

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Wellll…not counting the mandatory military service I don’t think there’s been any time in my career when I wasn’t involved in process improvement. I started off as a physicist working in advanced optics – the work was a combination of R&D and improving existing systems/processes. One of the groups I worked with had an assigned statistician. I watched what he was doing and liked what I saw so I went back to school and earned my third piece of paper in statistics.

My role as a statistician in industry was to provide support for R&D and process improvement in specialty chemicals, aerospace, medical measurement systems, and plastics. At my last company our major customer demanded we have six sigma black belts working on their projects. Our management picked three of us to go for training and I was one of them. The end result was I wound up running projects as well as providing statistical support to anyone who needed it.

Mr. Bin Laden’s actions a few year back got me (along with a number of other people) laid off from that aerospace company so I went job hunting, found a listing for a biostatistician at a hospital, applied, and was accepted. It’s a research hospital but, just like industry, there are process improvement problems so, as before, I work on both R&D and process improvement issues.

2June 7, 2019 at 5:52 pm #239658

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.You’re welcome. I hope some of this will help you solve your problem.

0June 5, 2019 at 12:45 pm #239629

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I don’t know the basis for your statement “I know that in order to be able to do the Hypothesis Testing we must also be able to test for Normality and the “t-test”. but it is completely false. There is no prerequisite connection between the desire to test a random hypothesis and ANY specific statistical test. Rather, it is a case of formulating a hypothesis, gathering data you believe will address that hypothesis and then deciding which statistical test or perhaps group of tests you should use to address/test your initial question/hypothesis.

If you have run afoul of the notion that data must be normally distributed before you can run a t-test – that notion too is wrong. The t-test is quite robust when it comes to non-normal data (see pages 52-58 The Design and Analysis of Industrial Experiments 2nd Edition – Davies). If the data gets to be “crazy” non-normal then the t-test may indicate a lack of significant difference in means when one does exist. In that case check the data using the Wilcoxon-Mann-Whitney test.

As to what constitutes “crazy” non-normal – that is something you should take the time to investigate. The best way to do that would be to generate histograms of your data, and run both the t-test and the Wilcoxon tests side-by-side and see what you see. You can experiment by generating your own distributions. If you do this what you will see is that the data can get very non-normal and, if the means are different, both the t-test and the Wilcoxon will indicate they are significantly different (they won’t necessarily have the same p-value but in both cases the p-value will meet your criteria for significance).

With regard to the data you have posted – one of the assumptions of a two sample t-test is that the data samples be independent. Your data strongly suggests you do not have independent samples. As posted, what you have are a group of 7 officials who have tried something using an old and a new method. The smallest unit of independence is the individual official. Therefore, if you want to use a t-test to check this data what you will have to do is use a paired t-test.

The paired t-test takes the differences within each individual official between the old and the new method and asks the question: Is the mean of the DIFFERENCES significantly different from 0. What this will tell you is, within the group of officials you have tested, was the overall difference in their performances significantly changed – which is to say is the distribution of the DIFFERENCES really different from 0.

If you want to ask the question – is method new really better than method old you will have to take measurements from a group of officials running the old method, get a second group of officials and have them run just the new method and then run a two sample t-test on the two distributions. If, as I suspect, these methods require training you will need to make sure the two independent groups of officials have the same level of training in both methods.

0June 3, 2019 at 12:08 pm #239598

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As Kaplan put it in his book The Conduct of Inquiry, ” When attacking a problem the good scientist will utilize anything that suggests itself as a weapon.” :-)

1May 28, 2019 at 11:22 am #239447

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If we couple what you said in your last post with an assessment of the graphs you have generated I think you might have the answer to your question.

As I said previously, the normal probability plots of cycle time days by department is a very important graph. What it shows is that the cycle time data for 4 out of the 5 departments is distinctly bimodal. When you examine the bimodality what you find for Finance, Sales, and Product Plan is a clear break in the distributions of reports with low cycle times and the distribution of the reports with high cycle times. The break occurs around 4-5 days. The Prod Dept, probably by virtue of the large report volume relative to the other 3, does have an obvious bimodal distribution with a break around 5 days. One could argue that the Prod Dept plot is tri-modal with a distribution from 1-3 days, a second from 3-6 days and a third with 6 days or more, however, given the data we have I wouldn’t have a problem with calling the Prod Dept data bimodal with a break between low and high cycle time reports at around 5.

The Exploration Department is unique not only because its report cycle time data is not bimodal but also because it appears that only one report has a cycle time of greater than 5 days.

What the normal probability plots are telling you is whatever is driving long report cycle times is independent of department. This is very important because it says the problem is NOT department specific, rather it is some aspect of the report generating process across or external to the departments.

Now, from your last post you said, “Data for this report is received from the production department. Out of this data, 18 were clean while 50 were dirty…” If I bean count the data points on the normal probability plot for Prod Dept for the times of 5 days or less I get 18. This could be just dumb luck but it bears investigation.

For each department – find the reports connected with dirty data and the reports connected with clean data – data error type does not matter. If the presence of dirty data is predominately associated with reports in the high cycle time distribution (as it certainly seems to be with the Prod Dept data) and if, it turns out that the Exploration Dept data has no connection (or, perhaps a single connection with the 6 day cycle time report) then I think you will have identified a major cause of increased report cycle time.

If this turns out to be true and someone still wants a hypothesis test and a p-value the check would be to take all of the reports for all of the departments, class them as either arising from clean or dirty data, and then class them as either low or high cycle times depending on which of the two distributions with each of the departments they belong (which is which will depend on the choice of cut point between the two distributions – I would just make it 5 days for everyone – report cycle time <=5 = low and >5 = high). This will give you a 2×2 table with cycle time (low/high) on one side of the table and data dirty/clean on the other. If the driver of the longer cycle times for reports is actually the difference between clean and dirty data then you should see a significant association.

1May 27, 2019 at 4:59 pm #239440

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.There’s no need to apologize. You have an interesting problem and I just hope that I will be able to offer some assistance. To that end, I may be the one that needs to apologize. I was re-reading all of your attachments and, in light of what you have in the most recent attachment, I’m concerned that my understanding of your process is incorrect.

My understanding was you had 5 departments in the CD group and that any one of the 5 could produce any one of the 8 types of reports and could expect to deal with any one of the four types of data errors. In reviewing the normal probability plots of the departments it occurred to me that there is a large difference in data points for the probability plot for the production department when compared to all of the others. This, coupled with the large count for Prod Volume reports is the reason for my concern about a dependence between department and report type.

My other assumption was that the counts for the types of error occurrence was “large” which is to say counts in the realm of >25, however, your most recent attachment indicates the boxplots for the types of error are summaries of very small groups of data.

So, before we go any further – are the assumptions I’ve made above correct or are they just so much fantasy and fiction?

In particular:

1. What is the story concerning department and report generation?

2. Do any of the departments depend on output from the other departments to generate their reports?

3. What is the actual count for the 4 error categories

4. Why is it that production department has so many more data entries on the normal probability plot than any of the other departments?If I am wrong (and I think I am) please back up and give me a correct description of the relationships between departments, report generation, and types of error a given department can expect to encounter.

One thing to bear in mind, the graphs you have generated are graphs that needed to be generated in order to understand your data so if a change in thinking is needed the graphs will still inform any additional discussion.

0May 27, 2019 at 2:44 am #239431

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As @Straydog has noted references to standards in measurements has a very long history. The link below suggests referring to such checks as MSA occurred sometime in the 1970’s

https://www.q-das.com/fileadmin/mediamanager/PIQ-Artikel/History_Measurement-System-Analysis.pdf

1May 26, 2019 at 6:08 pm #239427

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.A few general comments/clarifications before we proceed

1. You said “I guess I was looking at the p-value because I know that would determine the kind of test I run eventually.” I assume this statement is based on something you read – whoever offered it is wrong – p-values have nothing to do with test choices.

2. When I made the comment about the boxplots and raw data what I meant was the actual graphical display – what you have are just the boxplots. Most plotting packages will allow you to show on the graph both the boxplot and the raw data used to generate the boxplots and it was this kind of graphical presentation I was referencing.

3. Cycle time is indeed continuous so no problems there and your departments/report types etc. are the categories you want to use to parse the cycle times to look for connections between category classification and cycle time.Steps 1- 3

Overall Data Type

Your first boxplot of data types – no surprises there – however keep this plot and be prepared to use it in your report – it provides a quick visual justification for focusing on dirty data and not wasting time with DR data

Error Type

The graph says the two big time killers are, in order, duplicated data (median 7.1) and aggregated data (looks like mean and median are the same 4).

Report Type

The biggest consumers of time, in order, are Prod Volume (median 5.995), Balances (median 5.79) and Demand Volume (median 4.7). So from a strictly univariate perspective of time these would be the first place to look. However, this approach assumes equality with respect to report volumes. If there are large discrepancies in the report output count then these might not be the big hitters. What you should do is build a double Y graph with the boxplot categories on the X axis, the cycle time on the left side Y axis (as you have it now) and report volume on the right-hand Y axis. This will give you a clear understanding both time expended and quantity. If you don’t have a double Y plotting capability, rank order the boxplots in order of number of generated reports and insert the count either above or below the corresponding boxplot. Knowing both the median time required and the report volume will identify the major contributors to increased time as a function of report type.Department Type

Same plot as before and I have nothing more to add as far as this single plot is concerned (more on this later).

Normality plots

These tell you a lot. With exception of the exploration department all of the other departments have a bimodal distribution of their cycle times. Distribution ranges: Finance – 1-4 and 5-7 days Prod Plan – <1 – 4 and 6-8 days, Sales <1-3 and approx. 4.5 – 5 days. Prod department may have a tri-modal distribution 0-3, 3- <6, and 6-9 days

Based on your graphs you know the following:

1. For each department you know the data corresponding to the greatest expenditures of time. For Finance it is the 5-7 day data, for Prod Plan it is the 6-8 day data, for sales it is the 4.5-5 day data, and for prod department it is the 6-9 day data.

2. You know the two biggest types of error with respect to time loss.

3. Given your graphical analysis of the report types and volumes you will have identified the top contributors to time loss in this category.Your first statistical check:

Since you are champing at the bit to run a statistical test here’s your first. Bean count the number of time entries in each of the 4 error types. Note – this is just a count of entries in each category, the actual time is not important.,

1. Call the counts from aggregates and duplicate data error group 1 and the counts from categories and details group two. Run a proportions test to make sure that the number of entries in group 1 are greater than the number of entries in error group 2. (This should make whomever is demanding p-values happy)Given that there really are more entries in aggregate and duplicate and given that you know from your graphical analysis which of the report types are the big hitters, pareto chart those reports, take the top two or three, and then run your second check by grouping the reports into two categories – the top three (report group 1) and all of the others (report group 2).

Now run your second check on proportions – a 2×2 table with error groups vs report groups. This will tell you the distribution of error groups across report groups. You may or may not see a significant difference in proportions.

Either way – what you now want to do is take the two report groups and the two error groups and look at their proportions for the two regions for Finance, Prod Plan, Sales, and Prod Department. What you are looking for is a differentiation between the short and long times for each department as a function of report type and error type. To appease your bosses you can run proportions tests on these numbers as well.

If the error types and the report types are similar across departments for the longer elapsed times then you will know where to focus your efforts with respect to error reduction and report streamlining. If they are quite different across departments then you will have more work to do. If there isn’t a commonality across departments I would recommend summarizing what you have found and reporting it to the powers that be because this kind of finding will probably mean you will have to spend more time understanding the differences between departments and what specific errors/reports are causing problems in one department vs another.

2May 26, 2019 at 10:27 am #239424

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.The histograms and the boxplots suggest some interesting possibilities. Based on what you have posted I’m assuming your computer package will not let you have a boxplot which includes the raw data. On the other hand, if there is a sub-command to allow this you really need to have a plot that shows both.

If my understanding of your process is correct namely the process flow is Draft Report and then it goes to Cleanse Data the histograms suggest a couple of possibilities:

1. The Draft Report (DR) phase is completely independent of the Cleanse Data (CD) phase

2. The folks in the DR phase are ignoring all of the problems with respect to data and are just dumping everything on the CD group.Of course, if it is the other way around – first you need to cleanse the data and then you draft a report then what you are looking at is the fact that, overall, the CD group did their job well and DR gets all of the benefits of their work and kudos for moving so quickly.

My take on the histograms and the comment on the Multivar analysis is that for all intents and purposes both DR and CD have reasonably symmetric distributions. What I see is a very broad distribution for CD. I don’t see where there is any kind of skew to the left worth discussing.

To me the boxplots indicate two things:

1. Production Planning has the largest variation in cycle time

2. Production Department has the highest mean and median times and appears to have some extreme data points on the low end of the cycle time range.My next step would be the following:

1. If you can re-run the boxplots with the raw data do so and see what you see.

2. Plot the data for all 5 of the CD departments on a normal probability paper and see what I can see. These plots will help identify things like multimodality.

3 The boxplots suggest to me that the first thing to do is look at the product department and product planning.

4. Go back to the product department data and identify the data associated with the extremely low cycle times and see if there is any way to contrast those data points with what appears to be the bulk of the data from the product department.

a. Remove those extreme data points and re-run the boxplot comparison across departments just to see what you see.

5. Take a hard look at what both prod department and product planning do – are they stand alone (I doubt this)? Do they depend on output from other departments before they can begin their work? If they do require data from other departments what is it and what is the quality of that incoming work? Do they (in particular product department) have to do a lot of rework because of mistakes from other departments? etc.The reason for the above statements is because the boxplots suggest those two departments have the biggest issues the first because of greater cycle time and the second because of the broad range. The other thing to keep in mind is that prod planning has cycle times all over the map – why? This goes back to what I said in my first post – if you can figure out why prod planning has such a spread you may be able to find the causes and eliminate them. There is, of course, the possibility that if you do this for the one department what you find may carry over to the other departments as well.

1May 25, 2019 at 8:39 am #239405

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If your post is an accurate description of your approach to the problem then what you are doing is wrong and you need to stop and take the time to actually analyze your data in a proper statistical manner.

The first rule in data analysis is plot your data. If you don’t know what your data looks like then you have no idea what any of the tests you are running are telling you.

So, from the top, I’d recommend doing the following:

You said, “I have … collected data for 2 main activities within the process for analysis – the cycle times for ‘draft report’ and ‘cleanse data’ 9with information on report type, department, error type, etc.). I did a multi-vari analysis which indicates that a large family of variations are from the ‘cleanse data’ activity.”

Run the following plots:

First – side by side boxplots of cycle times (be sure to select the option that plots the raw data and not just the boxplots themselves) split by activity. Do the same thing with overlaid histograms of cycle times by activity type.

What this buys you;

1. An assurance that the “large family of variations from the cleanse data” really is really a large family of variation and not something that is due to one or more of the following: A small group of influential data points, multi-modalities within cleanse data and/or within draft report whose overall effect is to give an impression of large variation within one group when, in fact, there really isn’t, some kind of clustering where one cluster is removed from the rest of the data, etc.Second – side by side boxplots within each of the two main categories for cycle time where the boxplots are a function of all of the things you listed (“report type, department, error type, etc.”). What you want to do here is have boxplots on the same graph that are plotted as (draft report (DR) report type A), (cleanse data (CD) report type A), (DR report type B, CD report type B)…etc.)

What this buys you:

1. An excellent understanding of how the means, medians, and standard deviations of reports, department, error type, etc are changing as a function of DR and CD. I am certain you will find a lot of commonality with respect to means, medians, and standard deviations between DR and CD for various reports, departments, etc. and you will also see where there are major differences between DR and CD for certain reports, departments, etc.2. The boxplots will very likely highlight additional issues such as data clustering and extreme data points within and between DR and CD. With this information you will be in a position to do additional checks on your data (why clustering here and not there, what is the story with the extreme data points, etc.)

3. If the raw data on any given boxplot looks like it is clustered – run a histogram and see what the distribution looks like – if it is multimodal then you will have to review the data and figure out why that is so.

Third – multivar analysis – I have no idea what default settings you used for running this test but I would guess it was just a simple linear fit. That is a huge and totally unwarranted assumption. So, again – plot the data. This time you will want to run matrix plots. You will want to choose the simple straight line fit command when you do these. The matrix plots will allow you to actually see (or not) if there is trending between one X variable and cycle time and with the inclusion of a linear fit you will also be able to see a) what is driving the fit and b) if a linear fit is the wrong choice.

1. You will also want to run a matrix plot of all of the X’s of interest against one another. This will give you a visual summary of correlations between your X variables. If there is correlation (which, given the nature of your data, there will be) then that means you will have to remember when you run a regression that your variables are not really independent of one another within the block of data you are using. This means you will have to at least check your variables for co-linearity using Variance Inflation Factors (eigenvalues and condition indices would be better but these things are not available in most of the commercial programs – they are, however, available in R).

Once you have done all of the above you will have an excellent understanding of what your data looks like and what that means with respect to any kind of analysis you want to run.

For example – You said “I want to know with 95% confidence if the cycle time for cleanse task process is influenced by the source department that prepared the original data file with HO: µD1 = µD2 =µD3 = µD4 = µD5 and HA: At least one department is different from the others. Tests: Based on my A-D normality test done on the cycle time data, I concluded it was not normal and proceeded to test for variance instead of mean by using levene’s test since I have more than 3 samples (i.e.5 departments)”

Your conclusion that non-normality precludes a test of department means and thus forces you to consider only department variances is incorrect.

1. The boxplots and histograms will have told you if you need to adjust the data (remove extreme points, take into account multimodality, etc). before testing the means.

2. The histograms of the five departments will have shown you just how extreme the cycle time distributions are for each of the 5 departments. My guess is that they will be asymmetric and have a tail on the right side of the distribution. All the Anderson-Darling test is telling you is that your distributions have tails that don’t approximate the tails of a normal distribution – big deal.

Unfortunately, there are a lot of textbooks, blog sites, internet commentary, published papers which insist ANOVA needs to have data with a normal distribution. This is incorrect – like the t-test, ANOVA can deal with non-normal data – see The Design and Analysis of Industrial Experiments 2nd Edition – Davies pp.51-56 . The big issue with ANOVA is variance homogeneity. If the variances across the means are heterogeneous then what might happen (this will be a function of just how extreme the heterogeneity is) is ANOVA will declare non-significance in the differences of the means when, in fact, there is a difference. Since you have your graphs you will be able to decide for yourself if this is an issue. If heterogeneity is present and if you are really being pressed to make a statement concerning mean differences you would want to run Welch’s test.

On the other hand, if you do have a situation of variance heterogeneity across departments, what you should do first is forget about looking for differences in means and try to figure out why the variation in cycle time in one or more departments is significantly worse than the rest and since you have your graphs you will know where to look. I guarantee if heterogeneity of the variances is present and if you can resolve this issue the impact on process improvement will be far greater than trying to shift a few means from one level to another.

1May 24, 2019 at 6:12 pm #239378

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Please understand I’m not trying to be snarky, condescending, or mean spirited but your post gives the impression that all you have done is dump some data in a machine, hit run, and dumped out a couple of statistics that suggest your data might not exactly fit a normal curve. To your credit it would appear you do know that one of the requirements for a basic process capability study is data that is approximately normal.

Let’s back up and start again.

I don’t have Minitab but I do know it has the capability to generate histograms of data and superimpose idealized plots of various distributions on the data histogram.

Rule number 1: Plot your data and really look at it. One of the worst things you can do is run a bunch of normality tests (or any kind of test for that matter) and not take the time to visually examine your data. One of the many things plotting does is put all of the generated statistics in perspective. If you don’t plot your data you have no way of knowing if the tests you are running are actually telling you anything – they can be easily fooled by as little as one influential data point.

So, having plotted your data:

Question 1: What does it look like?

Question 2: Which ideal overlaid distribution looks to be the closest approximation to what you have?Since you are looking at cycle time you know you cannot have values less than zero. My guess is you will probably have some kind of asymmetric distribution with a right hand tail. If you wish you can waste a lot of time trying to come up with an exact name for whatever your distribution is but given your kind of data it is probably safe to say it is approximately log normal and for what you are interested in doing that really is all you have to worry about.

One caution: if your histogram has a right tail which appears to have “lumps” in it – in other words it is not a “reasonably” smooth tapering tail you will want to go back to your data and identify the data associated with those “lumps”. The reason being that kind of a pattern usually indicates you have multiple modes which means there are things going on in your process which you need to check before doing anything else.

If we assume all is well with the distribution and visually it really is non-normal then the next thing to do is choose the selection in Minitab which computes process capability for non-normal data. I don’t know the exact string of commands but I do know they exist. I would suggest running a Google search and/or going over to the Minitab website and searching for something like capability calculations for non-normal data.

1May 3, 2019 at 5:00 pm #238893

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I had to look up the definition of IIOT – and the manager in charge of obfuscation proliferation strikes again … :-). If all you have is paper entries then someone somewhere is going to have to sit down and transcribe the data into some kind of electronic spreadsheet.

I suppose their might be some kind of document scanner that could do this but my guess would be a scanner like that would require uniformity with respect to paper entries – something like a form that is always filled out the same way. Even if you could do that there would have to be a lot of data cleaning because paper records, even when in a form, can and will have all sorts of entries that do not meet the requirements for a given field. For example – say one field is supposed to be a recorded number for some aspect of the process. I guarantee you you will get everything from an actual number, for example 10, to anything approximating that entry: 10.0 , >10, <10, ten, 10?, na, ” ,etc.

There are some ways to approach a data set of this kind. Since the process will have changed over time (and, most likely, the reporting and measurement systems will have as well) the first block of data to examine would be the most recent. Let’s say you have a year’s worth of data for a given process. First talk to the people doing the recording. The focus will be on their memories with respect to times during the last year when the process was functioning properly and times when it wasn’t.

Using their memories as a guide, go into the paper records and pull samples from those time periods, find someone who can do the data entry, and transcribe the data and analyze what you have. If the memory of the people on the line is any good (and in my experience it is usually very good) your sample will provide you with an excellent initial picture of what the process has done and where it is at the moment.

1May 3, 2019 at 4:29 pm #238892

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.This looks like a homework problem so rather than just give you the answers – let’s think about how you would go about addressing your questions.

Question 1: How do you determine the average effect of A?

Question 2: How do you determine the average effect of B?

Question 3: If you have the average effect of A – what is another term for that average?

Question 4: If you have the average effect of B – what is another term for that average?

Question 5: How do you know that your average effect of A is independent of your estimate of your average effect of B?

Question 6. If you wanted to know the effect of the interaction AxB what would you do to your design matrix to generate the column for AxB?

Question 7: Given the column for AxB how would you determine its average effect?

Question 8: What is another term for the average effect of AxB?If you can answer these questions you will not only have the answers to the questions you have asked but you will have an excellent understanding of the power of experimental design methods over any other kind of approach to assessing a process.

4April 29, 2019 at 8:51 am #238766

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If that’s the case then the issue should be framed and analyzed in terms of what you mean by on-time delivery.

1. What do you mean by on-time delivery? – need an operational definition here

2. What does your customer consider to be on-time delivery? – need an operational definition here too.

3. What do you need to take into account to adjust the on-time delivery definition for different delivery scenarios?

a. If it is the physical delivery of a product to a company platform – how are you addressing things like, size of load, distance needed for travel, etc.

b. If it is a matter of delivering something electronically – how are you adjusting for things like task difficulty, resource allocation to address a problem, etc.After you have your definitions and an understanding of how your system is set up for production you should be able to start looking for ways to assess your on-time delivery and also identify ways to improve it.

0April 23, 2019 at 8:25 am #238625

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Not that normality has anything to do with control charting but, in your case, 100% represents a physical upper bound. If your process is operating “close” to the upper bound then the data should be non-normal – which would be expected. If it is “far enough” away from 100% then I could see where the data might be approximately normal – again not an issue – but if your process is that removed from 100% then it would seem the first priority would be to try to find out why this is the case instead of tracking sub-optimal behavior.

To your specific question, since 100% is perfection and since you want to try tracking the process with a control chart what you want is a one sided control chart where the only interest is on falling below some limit.

1April 17, 2019 at 8:33 am #238524

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Ok, that answers one of my questions. I still need to know what constitutes a rigorous design. Given your answer to the question of order I’m guessing all rigorous means is that you actually take the time to implement the design and not stop at some point and shift over to a WGP analysis (wonder-guess-putter), however, I would still like to know what you actually mean by “rigorous”.

To your first question concerning two-three level factorial designs or any of the family of composite designs, the biggest issues for running a design are the issues that drove you to wanting to run a design in the first place – time, money, effort. What this typically means is taking the time to define the number of experiments you can afford to run and then constructing a design that will meet your constraints.

From a political standpoint the biggest issue with running an experimental design is convincing the powers that be that this is indeed the best approach to assessing a problem. You need to remember that simple one-variable-at-a-time experimentation is what they were taught in college, it is what got them to the positions they occupy today and, of course, it does work.

If you are in a production environment where you will be running the experiments in real time you will have to spend a lot of time not only explaining what you want to do but you will also have to work with the people involved in the production process to come up with ways of running your experiments with minimal disruption to the day-to-day operation. The political aspects of design augmentation can be difficult but, as someone who has run literally hundreds of designs in the industrial setting, I can assure you that the issues can be resolved to everyone’s satisfaction.

0April 16, 2019 at 8:15 pm #238508

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.You will have to provide a little more detail before anyone can offer much.

1. What is a rigorous experimental design?

2. What are lower and higher orders?1April 13, 2019 at 1:57 pm #238438

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Give two levels for each factor you have the following:

Factor A, df = (a-1)

Factor B, df = (b-1)

Factor C, df = (c-1)

Factor D, df = (d-1)in each case a = b = c = d = 2

For each interaction

AxB, df = (a-1)*(b-1)

AxC, df = (a-1)*(c-1)

etc.

AxBxC, df = (a-1)*(b-1)*(c-1)

etc.

and

AxBxCxD = (a-1)*(b-1)*(c-1)*(d-1)

Error, df = a*b*c*d*(n-1) where n = number of replicates

Total df = a*b*c*d*n -1As an aside – 3 full replicates is gross overkill. The whole point of experimental design is minimum effort for maximum information. Unless you have a very unusual process it is unlikely that 3 and 4 way interactions will mean anything to you physically. Under those circumstances just take the df associated with the three and the 4 way interactions and build a model using only mains and two ways – this dumps all of the df for the higher terms into the error and instead of running 48 experiments you will have run 16.

The other option, assuming you actually have a process where 3 way and 4 way interactions are physically meaningful and the variables under consideration can all be treated as continuous, is to replicate just one or perhaps two of the design points – this will give you df for error and will also allow you to check the higher order interactions. Given that they can be treated as continuous a better bet would be to just add 2 center design points to your 2^4 design. This will give you a run of 18 experiments, an estimate of all mains, 2,3, and 4 way interactions, an estimate of error, and a check on the possible curvilinear behavior.

1April 8, 2019 at 7:59 am #238179

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.1. Control charts do not require normal data – see page 65 Understanding Statistical Process Control 2nd Edition – Wheeler and Chambers

2. When you have the kind of count data you have it can be treated as continuous data – see page 3 Categorical Data Analysis 2nd Edition – Agresti

3. I-MR would be the chart of choice – you should check to make sure your data is not autocorrelated. If it is you will have to take this into account when building the control limits – Wheeler and Chambers have the details.1March 14, 2019 at 8:18 am #237270

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.DOE is a method for gathering data. Regression (any kind of regression) is a way to analyze that data. As a result it is not a matter of using DOE or regression.

Experimental designs often have ordinal or yes/no variables as part of the X matrix. The main issue with a design is that you need to be able to control the variable levels in the experimental combinations that make up the design. In your case you said you have the following:

A. $

B. Name

C. Social proof (others have said the same thing but here’s what they found…)

D. Regular scriptBefore anyone could offer anything with respect to the possibility of including these variables in a design you will need to explain what they are. You will also need to explain the scheduling rate measure – is this a patient scheduled yes/no or is it something else.

However, in the interim, if we assume all of these variables are just yes/no responses then you could code them as -1/1 (no/yes). The problem is that you cannot build patients. Rather you have to take patients as they come into your

hospital(?). What this means is that you have no way of randomizing patients to the combinations of these factors and this, in turn, means you have no way of knowing what variables, external to the study, are confounded with the 4 variables of interest which means you really won’t know if the significant variables in the final model are really those variables or a mix of unknown lurking variables that are confounded with your 4 chosen model terms.What you can do is the following: Set up your 8 point design and see if you have enough patients to populate each of the combinations. Given that this is the case, you can go ahead and build a model and, if the response is scheduled yes/no, the method of choice for data analysis would be logistic regression. The block of data you use will guarantee, for that block of material, your 4 variables of interest are sufficiently independent of one another. What this approach WILL NOT AND CANNOT GUARANTEE, is that the 4 variables of interest actually reflect the effect of just those 4 variables and are not an expression of a correlation with a variety of lurking and unknown variables.

Another thing to remember is the coefficients for the variables in the final reduced logistic model are odds ratios which are not the same as coefficients in a regular regression model and cannot be viewed in the same way.

If you don’t have enough patients to populate the combinations of an 8 point design you will have to take the block of data you do have and run regression diagnostics on the data to see just how many of the 4 variables of interest exhibit enough independence from one another to permit their inclusion in a multivariable model. All of the caveats listed above will still apply.

What all of this will buy you is an assessment of the importance of the 4 variables to scheduling with the caveat that you cannot assume the described relationships mirror the relation between the chosen X variables and the response to the exclusion of all other possible X variables that could also impact the response. While not as definitive as a real DOE this approach will allow you to do more than build a series of univariable models for each X and the measured response.

This entire process is not trivial and if, as I suspect, you are working in a hospital environment I would strongly recommend you talk this over with a biostatistician who has an understanding of experimental design and the diagnostic methods of Variance Inflation Factors and eigenvalue/condition indices.

0March 13, 2019 at 11:23 am #237254

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I would like to offer a few comments and make a few recommendations with respect to your initial post.

Statistical methods, machine learning, advanced methods of data analytics and statistics are all tools one can/does use in the analysis phase of six sigma. In this light, the observation “Of course, these techniques would be used after the current standard methodologies.” does not make sense.

At first I thought your statement in your second question “… experimental design and analysis to optimize waste and process variance to maximize business revenue / business expansion instead of minimizing defect rates?” Meant you were talking about waste and variance reduction in a process but then later you said, “…a business may have the desire to increase some of its process variation to improve overall revenue and shareholder support.” Assuming this was not a typo, the only business of which I’m aware that would view increased process variation as a good thing is the field of cryptography where increased variability means increased difficultly in code breaking – in every other instance the focus is on variance reduction.

The overall impression I have of your initial post is you want to gain some basic understanding of analytical methods and their underpinnings. If this is the case then you might want to consider the following:

1. With respect to connections between machine learning and statistics I think your best bet would be a Google search. I plugged those terms into their engine and a number of peer reviewed papers came up in the first pass. I can’t vouch for the quality/relevance to your question but it would be a start.

2. For a basic understanding of statistical principles I’d recommend reading Gonick and Smith’s book The Cartoon Guide to Statistics.

3. For a basic understanding of regression methods (I’m citing the 2nd edition) try Draper and Smith Applied Regression Analysis. For a first pass, read and understand Chapter 1, in particular the very well written description of just what linear regression is and the basic assumptions of the method. You could skip Chapter 2 because that is just Chapter 1 in matrix notation form and then read and memorize Chapter 3 – residual analysis. You might want to augment Chapter 3 with Shayle Searle’s August 1988 paper in The American Statistician concerning data that results in banded plots of residuals. You could follow this with a reading of Chatterjee and Price’s book Regression Analysis by Example.

4. Experimental design is experimental design and it can be used to address changes in the mean, changes in the variance, or both. To the best of my knowledge there are no special requirements/restriction if one wishes to employ experimental design methods in conjunction with machine learning or data analytics – indeed I have built experimental designs to explicitly guide machine learning efforts.

A good overview of design methods would be Schmidt and Launsby’s book Understanding Industrial Designed Experiments. It covers all of the types and provides a good discussion of when and where you might want to use the various forms. It also contains an excellent discussion of the Box-Meyers method for using the data from an experimental design to identify sources of process variation.

5. Data quality: A book that is worth reading in its entirety, particularly in this age of big data, is Belsley, Kuh and Welsch’s book Regression Diagnostics – with the subtitle “Identifying Influential Data and Sources of Collinearity.” The book is not an easy read and you will need some knowledge of matrix algebra/symbol manipulation in order to understand what it is saying.

The issues it discusses and evaluates are particularly important given the somewhat prevalent attitude which can be summarized as; if I have a big data set I have everything and I don’t need to concern myself with issues that are related to “small” data sets. The attitude has no foundation in anything save blissful ignorance – big data has the same problems as small data and, to keep yourself from going wrong with great assurance, you need to keep this in mind and know what questions to ask. A good recent book which discusses some of these issues in a non-technical manner is Weapons of Math Destruction by Cathy O’Neil. She is a mathematician who has worked with big data and I think her book is a balanced look at the promise and pitfalls of big data analysis.

2March 13, 2019 at 10:01 am #237252

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.@cseider I suppose it could be but if it is I would nominate the question for the scatological award for worst posed homework question of the year.

0March 12, 2019 at 5:58 pm #237235

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As asked your question has no answer because you have not provided any information about your production line. For example, if the process target is 1 ppm and my in control process 3 standard deviation limits around that target are plus/minus .01 ppm the answer would be – not a thing.

0March 11, 2019 at 7:32 am #237199

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.The standard calculation for Cpk requires normality in the data. Your data is naturally non-normal so what you need to do is use the methods for calculating Cpk for non-normal data. Chapter 8 of Bothe’s book Measuring Process Capability has the details of how to do this.

The basic method consists of plotting the data on normal probability paper and identifying the .135 and 99.865 percentile values (Z = +-3). The difference between these two values is the span for producing the middle 99.73% of the process output. This is the equivalent 6 sigma spread. Use this value for computing the equivalent process capability.

It is my understanding Minitab has included this method in its software. I’m not familiar with Minitab but I’m sure if you check the “help” section of the program you will find the necessary commands. If you can’t find it there you could contact Minitab help or, since this topic has been discussed time and again on this forum, you could use the search engine to locate older posts on this subject. As I recall, one or more of the older posts were made by people familiar with Minitab and they provided instructions on how to find this method in the Minitab package.

0March 6, 2019 at 6:16 pm #237099

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As I said in my first post – the problem is that of sample independence. If your batches consist of something like widgets stamped out on a production line then you would need to first take as many samples as you can at a uniform time interval for a single batch and run a time series analysis to determine the minimum separation in time between samples needed to declare that the samples are truly independent of one another and then take samples at that time interval or at some time interval greater than the minimum and look at the number of samples per batch this approach will provide and use those to compute your Cpk.

If you can’t do this then you will have to take the time to understand the issues associated with control charting and calculation of Cpk in the presence of lack of independence of measurement (auto-correlation). As Wheeler and Chambers note in their book Understanding Statistical Process Control 2nd edition – there is a myth (see pp.80-81) that the data needs to be independent before it can be control charted. As they note- you can use auto-correlated data but there are issues and things you need to keep in mind.

If the batch is something like a large reactor vessel then the multiple samples per batch will not be independent and auto-correlation is guaranteed.

As for a Cpk with auto-correlated data you should borrow a copy of Measuring Process Capability by Bothe through inter-library loan and read pages 781-792 – the chapter subheading is 13.3 Processes With Auto-Correlated Measurements. In short, if the batch samples are not independent you will need to do some reading to gain an understanding of the issues before you try to build and interpret a control chart or calculate a Cpk with this kind of data. For both issues, control chart and Cpk, I would recommend the section in the Bothe book as a good starting point.

0March 6, 2019 at 4:14 pm #237097

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Ok, sounds good.

0March 6, 2019 at 4:12 pm #237096

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.So, is it a total of 30 samples from 6 batches for a total of 5 samples per batch or is it a case of 30 samples from each of 6 batches for a total of 180 samples?

0March 1, 2019 at 5:39 pm #236983

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.To your points

– It’s not that I don’t recommend trying more than three rather it is the odds of finding raw material lots (a minimum of 6 if we go with the D-optimal design I mentioned earlier) with the right levels for each of the 6 combinations. If you have prior data on lots of raw materials it would still be worth examining the data to see if there were lots whose overall material properties would have met those six combinations. You might get lucky and you might find your supply chain is such that you could actually run an analysis including the five supplier variables.– The biggest problem with running a 2^(5-1) design on a lot of material from each of the three suppliers is there is no guarantee the lot is representative of the lot-to-lot variation one might expect from each supplier. Based on some rather bitter past experience, I think you would find the following:

1. The final equations for each of the suppliers will differ with respect to significant in-house terms and/or significant differences in corresponding coefficients.

2. When you attempt to test the developed equation for a given supplier using a new lot of material from that supplier you will find the predicted correct settings for optimizing the process (based on the old lot) do not apply and do not provide guidance with respect to optimizing.If you choose to try running the 2^(5-1) with a lot of material from each supplier try to do the following:

1.Across suppliers try to pick the three lots so that two of the supplier variables of interest match the small matrix we talked about previously and let the other three fall where they may.

2. Build the three models for each of the suppliers. Make sure you build each model using scaled levels (-1 to 1) for the in-house variables.

a. Take the three models and examine them for term similarity and difference.

b. Since the models are based on scaled parameters you can compare term coefficients across models directly. This will allow you to easily see not only term similarities and differences but also see what happens to the magnitude of the coefficients for similar terms in each of the models.3. Next pool the data from all of the experimental runs. Re-scale all of the in-house variables to a -1 to 1 range. If you were able to find three lots that allowed you to check the two supplier terms add those terms (again scaled to a -1 to 1 range) to the list of parameters you can consider and re-run the model.

a. Take this model and compare it to the results of the three separate models again looking for similarities with respect to term inclusion and coefficient size.4. If you can’t find lots across suppliers that allow you to check some of the supplier variables then take the data from the three runs and assign an additional dummy variable to the data from each fractional factorial run (-1,0,1 will suffice).

a. Build a model based on all of the data and including the dummy variable which will represent material lots/supplier differences.

b. Examine this equation in the same manner as above – looking at similarities/differences in model terms between this overall equation and the three separate ones.

c. If there seems to be “reasonable” agreement between this model and the three separate models (any term in the “big” model is present in at least one of the three separate models and the coefficients of those terms are of the same magnitude and direction) and IF the coefficient for the lots is such that any unit change in that variable can easily be overcome with combinations of changes in the other terms in the model then it would be worth testing the “big” model with a new lot from any one of the suppliers to see how well it can predict the outcome.

d. If, on the other hand the “big” equation has a “number” of terms (sorry, I can’t be more precise than this) not found in the three separate equations and/or there are large differences in coefficient size or direction this would argue there is more to the issue of suppliers and lots than you expected. It would still be worth checking the equation based on all of the data just to make sure.

e. The worst case is one in which the final equation based on all of the data has just a few in-house process terms with small coefficients and a term for the lot/supplier variable with a large coefficient whose size is such that no combination of the other variables in the final model could overcome lot changes. In this case about all you can say is that lot-to-lot variation is impacting your process in ways that cannot be overcome with the current group of in-house variables you are using for process control.0March 1, 2019 at 10:37 am #236786

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I’m a statistician – discussions like this are never a bother. :-) As to your plan – there is a problem with the way you have laid out the supplier information – specifically it does not match the example you provided earlier and which I used as a starting point for my post yesterday.

In the earlier post you gave the following:

supplier 1 670 Rm and 19% elongation

supplier 2 640 Rm and 15% elongation

supplier 3 650 Rm and 19% elongation…and I translated the above settings into the following design matrix for the two variables RM and Elongation

Source…..RM…. Elongation

Supplier 1 +1 and +1 ……..Thus the combination is (1,1)

Supplier 2 -1 and -1 ……..Thus the combination is (-1,-1)

Supplier 3 -1 and +1 ……..Thus the combination is (-1,1)What you have done now is two things

1. You increased the number of supplier variables from 2 to 5.

2. You are trying to use just one lot of material from each supplier to fill out the supplier part of the design matrix.If you choose to go with 5 supplier variables then, at a minimum and assuming two levels per variable (I just checked with a D-optimal run) you will need to have material from your various suppliers which meets the following conditions

**WITHIN**a single lot of material from a supplier:

Code: (Level Variable 1, Level Variable 2, Level Variable 3, Level Variable 4, Level Variable 5)

Combination 1 (1,1,1,1,1)

Combination 2 (-1, 1,-1,1,-1)

Combination 3 (1, -1, 1, -1, -1)

Combination 4 (-1, -1, 1, 1, 1)

Combination 5 (-1,1,1,-1,-1)

Combination 6 (1,1,-1,-1,1)As I mentioned in the last post – since you have to take what is sent you won’t hit the same low and the same high values for each variable across the combinations – the issue is to make sure that within a given variable the range of values you are calling “low” do not cross over into the range of values you call “high”.

It also now appears you do not have a physical measure for roughness, homogeneity, and conductivity so you now have to treat the measures as a two level rating. This is fine but do not treat the ratings as categorical when you build the design. The ratings do have a rank ordering and, as long as your in house expert is confident he/she can discriminate between good and bad, you can treat those variables in the same way you would treat the other variables when building your design.

The really big issue would be identifying lots of raw material from the various suppliers whose spec sheets in combination with your in house ratings, could populate the supplier design matrix I listed above. In my experience it is almost impossible to build a matrix for more than 3 variables at two levels given this method of variable level selection and control (actually lack of control). I’m not saying you can’t do this but you should review your prior spec sheets and your prior in house ratings for past lots of materials across all suppliers just to see if, in the historical data, you have a subset of measures that would have met the requirements of the matrix.

As for telling the difference between suppliers my interpretation of your problem was that you wanted to be able to optimize the process regardless of supplier. If you are able to populate the supplier matrix with material across suppliers then the resulting model would describe the behavior of your process with respect to variables only. Thus, when you received a new lot of material from any supplier you could plug the corresponding values into your predictive equation and then ask the equation to identify your in house process parameter levels that would result in optimum product.

0February 28, 2019 at 9:22 pm #236778

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Addendum to the last post: One thing to keep in mind when your low’s and high’s have ranges of values is the “fuzziness” of the -1 and 1 settings can be an issue. If the highest low value and the lowest high value for a given variable are too close together you may find you will lose information with respect to some variable interactions. In your case this would most likely apply to any attempt to check the interactions of the supplier variables with one another or with the in house variables.

The way you check to see if this is a problem requires scaling the actual low and high values to their actual negative and positive settings and not pretend that any low setting is automatically a -1 and any high setting is automatically a +1. The way you do this is to take the max and the min values for a given variable and scale the entire range of that variable from -1 to 1.

To do this compute A = (Max value + min value)/2 and B = (Max value – min value)/2 and scale each setting according to the formula

Scaled X = (Actual X – A)/Bonce you have the actual matrix of X’s expressed as levels ranging between -1 to 1, use this matrix to compute the scaled values for whatever terms you expect to be able to check with the design you have built and then check the resulting matrix to see if you get confounding.

This check is performed by assigning a simple count variable to each experiment in the design (1 for the first experiment, 2 for the second experiment, etc.) Regress the counts against the model terms as expressed in scaled form and look at the VIF’s for each of the model terms. Those with a VIF > 10 are too highly confounded with other terms and cannot be estimated.

An even better way to do this is to look at the eigenvalues/condition indices of each of the model terms but to the best of my knowledge this capability is not present in most computer packages.

0February 28, 2019 at 5:26 pm #236768

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Ok, let’s make that assumption. You have the following:

supplier 1 670 Rm and 19% elongation

supplier 2 640 Rm and 15% elongation

supplier 3 650 Rm and 19% elongationTherefore what you have are the following combinations for the two factors Rm and elongation

Supplier 1 +1 and +1

Supplier 2 -1 and -1

Supplier 3 -1 and +1The key here is to remember that it is rare, even when you have the capability to actually control the settings of a given variable, to be able to get back to the exact same setting for the “low” or the “high” value. As long as the range of values for some “low” setting do not overlap the range for some “high” setting you can view the values in the manner indicated.

So what you now have to do is build a matrix of experiments that the D-optimal design can use for construction. For everything at two levels this would be the full 2**7 matrix (I’m saying 2**7 because, using the above example, you only have two supplier variables in addition to your 5 process variables).

If we assume all you have are the three choices for the suppliers listed above you would instruct the D-optimal program to only consider those experimental combinations that have those three combinations for the variables Rm and elongation and have it build a design that will allow an examination of all 7 variables based on the restricted subset. Once you have the results of the design you would run the usual regression analysis and use backward elimination and forward selection with replacement (stepwise) regression methods to construct your reduced model (you would want to run the analysis both ways because D-Optimal designs are rarely perfectly orthogonal).

Let’s assume the residual analysis indicates all is well with the final model and let’s assume the final model has both supplier terms and process terms. Given that model you can fix the levels of the supplier values at whatever you choose and then run optimization studies on the process variables. This analysis will tell you what you can expect given that you have no control over supplier variables.

In light of the statement you made in your second post – “We are pretty sure that higher tensile strength and smaller roughness would enhance the process” I think you should be prepared for the possibility that your ability to influence product quality using only in house variables will be limited. However, if this turns out to be the case, because of your efforts you will have real proof that approaching the problem just by looking at in house variables is not enough.

0February 27, 2019 at 2:52 pm #236736

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Since each of the supplier lots are allowed to vary within a range of (separate?) values for tensile strength, elongation, and roughness and since you only want to run an analysis where you are controlling your in house process parameters the best thing to do would be to review your collection of spec sheets from prior lots of raw material and summarize the reported property values. This will give you a picture of the distributions of tensile strength, elongation, and roughness you have accepted in the past. Once you know these distributions you should look over the spec sheets of those material lots which you do have on hand to see where their properties fall relative to prior history.

If, collectively, the current raw material lots have levels of the three properties which span say 95% of the range of each property of interest you could take that data, ignore the lot source, and attach a complete design matrix for the in house properties to each of the lots and use this matrix of design points as a basis for identifying runs in a D-Optimal design. (If the current supply of raw material does not meet this requirement you will have to put aside some portion of the current lots and wait for your suppliers to send you material that, when combined with your saved samples, does cover an acceptable range of the three variables of interest).

What you will have will be a design that will allow you to check for the impact of your in house variables as well as the impact of the material property variables. What you will get from the analysis will be a predictive equation involving both the in house variables as well as the material property variables. The point of the predictive equation is NOT to try to control material properties, rather it is to give you and understanding of how well your in house variables can be expected to control your process given that you are NOT controlling material lot properties.

What you would do with this predictive equation is take the prior measurements from the old spec sheets for material you have already used, set you target and tolerance for the measured response and then use the equation to identify settings for each of your in house variables that would result in a within tolerance predicted response. The matrix of values for the in house variables used in the equation would be based on the range of settings you know you can run for each in house variable.

The matrix of predicted responses will tell you what you need to know with respect to your ability to control product properties given that lot properties will vary and how much control you can or cannot expect given the properties of the incoming raw material.

Based on your description I don’t think a basic design run on a lot of material from each of the three suppliers would be of much value. If the available lots from these three suppliers just happen to have about the same values with respect to tensile strength, elongation, and roughness then all you will have done is essentially replicate a saturated design 3 times.

As for treating the suppliers as a noise variable – you can’t. If you are going to try to run a Taguchi design what you need to remember is that a noise variable is a variable you would rather not have to control when running your process. However, when running the design you HAVE to control the variable you have designated as a noise variable because you have to be able to set it to high and low levels in order to meet the design requirements. Based on what you have said, you do not have this level of control.

0February 26, 2019 at 12:36 pm #236719

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I think we need to back up a bit. If I understand your most recent post correctly you get a spec sheet from a supplier which provides tensile strength, elongation, and roughness measurements on each shipped lot. If this is the case then this would argue that you have zero control with respect to independently varying these three measures – for any given lot they are what they are.

If this is the case and if you want to check your hypothesis that higher tensile strength and smaller roughness would improve the process then, you will have to lot select for four different combinations of tensile strength and roughness. Assuming you can do this what you will need to do is use the methods of computer generated designs (D-Optimal is one that is readily available) to build a design to test this. Of course, if you want to toss elongation into the mix then you would have to lot select on this variable as well to come up with the four combinations of the three variables (-1, -1, 1), (1,-1,-1), (-1,1,-1) and (1,1,1). Given you can do this you would build a full 2**8 matrix, restrict the combinations for tensile strength, elongation, and roughness to the 4 combination and use D-optimal to find the minimum number of experiments necessary to test all 8 items.

The above is, of course, based on a lot of assumptions. We are assuming the spec sheet really reflects measurements on the provided lot of material and isn’t some generic Good Housekeeping Seal of Approval. We are assuming you have the ability to do lot selection/retention. We are assuming that, regardless of what the manufacturer is sending you, it is possible for tensile strength, elongation and roughness to vary independently of one another.

If you could provide more detail on the above assumptions we’ll see if we can come up with some suggested courses of action.

0February 25, 2019 at 11:57 am #236698

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Since you are concerned with the ranges of incoming material properties in addition to the things you vary in your process a better approach would be to run a saturated design on the 8 variables

Tensile Strength: from 600 to 800 N/mm^2

Elongation: from 20% to 10%

Roughness: from 2 to 0,5 µm

Energy Flow (Ampere)

Upsetting speed (mm/secs)

Clamping pressure (Bars)

Anvil speed (mm/secs)

Upsetting delay (secs)You would select random material from all three suppliers to fill in the low and high values for tensile strength, elongation, and roughness and identify your high and low settings for your in house process parameters in the usual way. If you have overlap with respect to supplier raw material quality you could run a couple of replicate points using alternate material. You could run a main effects check in 18 experiments if you just wanted to run a semi-saturated 2 level factorial design or, if you have the computing firepower, you could plug your data matrix into a D-optimal design generator and probably identify a design of about 12 runs.

0February 25, 2019 at 11:45 am #236697

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.You will have to provide more detail before anyone can offer much in the way of advice.

Questions:

1. What kinds of questions are on the survey? Are they yes/no, or are they Likert scale (ratings 1-5, 1-10), or are they multiple choice or are they open ended please-add-a-comment kind or is the questionnaire a combination of all of the above?

2. Regardless of the questions – how have you vetted the questions to make sure you are not biasing the response?

3. What do you plan to do with the results?

4. If you have please-add-a-comment type questions – how are you going to approach their analysis?If you can answer these questions perhaps I or some other individual may be able to offer suggestions.

0February 24, 2019 at 9:51 am #236678

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.In order to get an answer to your question you will have to read the detailed description of the derivation of the requirements for that particular USP protocol. Somewhere in the description will be statements concerning minimum detectable differences and power along with other things and it will be these assumptions/requirements that result in the minimum requirement of 10 samples.

0February 23, 2019 at 11:29 am #236630

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If your process is expected to exhibit large variation then you should ask yourself why it is that you are seeing variation that is much lower than you thought it would be. Some things you might want to check:

1. Where did you get the idea that the process variation is large? Does someone actually have prior data that exhibits large variation or is this just someone’s impression based on who knows what? Also, if prior data does exist – how do you know it is representative of the process?

2. For the XbarR chart – are the samples actually independent? If you are taking repeated samples from the same lot of production material then there is a very good chance that the samples are repeated measures and not independent. Estimates of variation based on repeated measures will be much less than estimates based on independent samples.

If your process really is as tight as your initial calculations would indicate then you are in the very fortunate situation of being able to meet customer requirements 100% of the time.

0February 14, 2019 at 4:45 pm #236396

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I guess I don’t understand why you are bothering with Z scores. To rephrase your question – I have an estimated average travel time of 39 minutes to get to work with a sample standard deviation of 7 minutes.

The question that is being asked is: what kind of reduction in variation of individual travel time must an employee make in order to meet (the absolutely absurd) management target of a maximum of 40 minutes travel time.

The basic equation to consider is management time = meantime +-(2*std/sqrt(n))

Therefore, for one person n = 1. If all employees have a time of 39 minutes then to have 40 minutes travel time the standard deviation would have to drop from 7 minutes to 30 seconds.

Now, 39 is just the mean of the population. The 95% CI for that mean – assuming symmetry with respect to the distribution of arrival time – is going to be 39 minutes +-2*7. Thus, at the extremes you have someone arriving at work after 25 minutes of travel and someone arriving after 53 minutes of travel.

The poor soul who needs 53 minutes to get to work can reduce the variation in his travel time to 0 and he will still need a time machine at the entrance to the workplace to take him back in time 13 minutes in order to meet the target set by management.

As for the gal who needs only 25 minutes to get to work, she can stop off for a coffee, do a little window shopping, and still show up at the gate with an elapsed travel time of less than 40 minutes.

In short, the management target is based on wishful thinking and has no connection to what is happening in the real world.

1February 14, 2019 at 2:06 pm #236391

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.That has to be one of the worst homework problem statements I think I’ve ever seen. As written there are all kinds of answers and solutions to the problem.

1. If the reported standard deviation is the standard deviation of the mean and not just the sample standard deviation then there isn’t much of anything you can do with the statement concerning personal vehicles.

2. If the standard deviations are the sample standard deviations then we are assuming that somehow employees taking public transportation have some kind of control over how that mode of transportation functions.If we assume the standard deviations are sample standard deviations and we assume the employees have total control of traffic conditions and how public transportation functions then I guess you have the makings of a homework problem one could address.

Questions for you:

1. What is the basic expression for a confidence limit around a mean?

2. If we pretend the standard deviations are sample standard deviations and we pretend the average represents the central tendency of a reasonably symmetric time distribution then how would you determine the range of actual arrival times (95%) around the mean?

3. As the question is written, what is the sample size we need to use to discuss the results of an individual employee?

4. Given that you have identified the 95% limits for the mean and that you have identified the sample size associated with an individual you should be able to calculate the ranges of variation associated with various employees. I will give you one hint – some of the employees will have to employ time travel in order to meet the requirement.

2February 12, 2019 at 12:42 pm #236293

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If by a batch you mean a single run such as contents of one reactor vessel then the answer is neither because those samples are repeated measures – not independent measures. If you try to build any control chart with that kind of data the control limits will be too narrow because the sample-to-sample variability within a single batch is going to be less (and possibly much less) than batch-to-batch variability.

As for the second question concerning 30 results from 30 batches – the question you need to answer is this: Is there any obvious subgrouping of the measures? If there isn’t then forcing what amounts to single measures into some artificial grouping is of little value. In all of the cases I ever dealt with where the output was a batch of material I used IMR charts and never had a problem.

0February 11, 2019 at 12:48 pm #236212

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Which one is better depends on many things. If it is preliminary and you have no prior information concerning a possible curvilinear response over the range of variables you are examining then it comes down to a matter of time/money/effort. If we are discussing the example of your other post – 2 variables, then you would be running 6 vs 10 experiments – 2**2 + two center points vs 3**2 and a single replicate of one of the design points.

One compromise is to run the 2**2 plus the two center points and, if the analysis indicates curvlinear behavior, augment the existing run of experiments with a couple of additional design points to test the curvature with respect to the two variables of interest. To do this you would need to use one of the computer generated design methods such as D-Optimal. You would force in the existing design and allow the program to choose additional runs from all of the possible design points in a 3**2 design.

0February 10, 2019 at 11:36 am #236185

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Addendum: With respect to the residual plot. I left out a piece – You want to look at the overall pattern of the residuals – not just where the center points fall. If the model is adequate you should see a random distribution of data points above and below the 0 residual line. As part of that assessment you will want to see how the center points behave.

0February 10, 2019 at 11:33 am #236184

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.QUESTION 1: is this already okay?

Yes, except as written your point #2 sounds like you are just going to look at a model of X1 and X2 and not bother with including the interaction. The full model would be response = fn(X1, X2, X1*X2). What you want to do is run backward elimination on the full model to see what terms remain in the reduced model (the model containing only significant terms).

QUESTION 2: Do i still need to validate my model using RMSE or R^2 method?

I’m not sure what you are suggesting here. You test for model adequacy by looking at a plot of the residuals vs. predicted. If the residuals of the replicates on the center points are split by the 0 line then it would strongly indicate that, over the region you have examined, the relationship between the Y and the X’s is linear (straight line). If the two center point residuals plot either above or below the 0 line then it would suggest there is a curvilinear aspect which would mean you should consider augmenting what you have done with a couple additional runs to identify the variable(s) driving the curvature.

As for model validation – given the residual analysis says everything is OK then you will need to use the regression equation to identify settings of X1 and X2 that will predict the best Y and go out and run that experimental combination and see what you see. If the resulting Y is within the prediction limits of the model then you will have your model validation. If it isn’t then you will have some more work to do.

As for using RMSE or R^2 to assess the model – don’t. R^2 is an easily fooled statistic and RMSE by itself doesn’t tell you much either.

There are any number of posts, blogs, even articles that tell you that you must have an R^2 of X amount before the model is of any use. The often cited value for X is 70% or greater. By itself this statement is of no value. If your process is naturally noisy then the odds of your being able to build a model that explains 70% of the variation is very low. Rather than waste time chasing some level of R^2, just test the equation using the method mentioned above. If the results are as indicated above then you have a model that will address your needs with respect to predicting the behavior of your process over the ranges of the X1 and X2 you used.

As a counter to the R^2 must be such-and-such before the model is useful claim I’ll offer the following: A number of years ago the company I worked for made additives which were used in the hand lotion industry. One of our customers asked if we could run a series of experiments that would give them some level of predictive capability with respect to outcomes. We signed a non-disclosure agreement, they paid for the research and, after a lot of discussion, I built a design that I thought would address their concerns.

Hand lotions are evaluated by a team of people who have been trained on control compounds to assess various characteristics of lotion. The ratings for the various measures are ordinal and, depending on the characteristic, the rating scales can be either 1-5, 1-7 or 1-10. There were about 10 different characteristics of interest. After they had built the compounds corresponding to each of the experimental runs and got the responses from their evaluation teams, I built separate models for each of the characteristics and then used all of the models together to identify the best trade offs with respect to product properties. None of the models had and R^2 greater than 30% and, because of the ordinal nature of the responses, the prediction errors were rounded to the nearest .5.

We generated a series of predictions of product properties based on the regression models and the manufacturer went out and built the formulations that matched the predicted combinations. When they gave the confirming runs to their panels for evaluate – every one of the responses were well within the prediction limits associated with each predicted response. The company found the models to be extremely useful and they used them to guide research into ways to further improve their product.

0February 9, 2019 at 8:43 am #236158

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.The issue is this – the basic philosophy of experimental design is if you are going to see a difference in response when you change conditions your best chance of seeing that difference is by comparing the results for the extremes of the variables of interest. This is the point of two level factorial designs. Thus, if you take the extremes of the settings of your two variables and run the 4 point experimental design and replicate just one of those experiments (total 5 experiments) you can build a single model which will include your main effects and the interaction of the two terms.

You could custom build a 4 level factorial design but the big question is why would you want to do this? A 4 level design means you believe you have responses that would map to a cubic polynomial. Unless you happen to have, within the design space, something like a phase change I can’t think of any measured response of any kind of variable that would plot as a cubic function (and if you do have a phase change then you really need to go back and revisit a number of process issues before considering a design).

If you believe you have a response that is curvilinear (i.e. not a simple straight line) then you could run a three level design for the two variables of interest. This would give you a total of 9 experiments and would allow you to look at all main effects , all squared terms, and the interaction of the two variables. If the cost per experiment is low and there aren’t any issues with time constraints you could opt for a 9 point run.

If time/money/effort is an issue then a better approach would be to run the two level factorial design along with a center point (you haven’t mentioned the kinds of variables you are considering but we are assuming they are continuous in some fashion – either interval or ordinal) and then run a replicate of that center point. This would allow you to build a model with the main effects and the interaction and it would allow you to check for curvilinear behavior. If curvature is present you won’t be able to determine which of the two variables are generating this response but you will at least know it exists and you can augment your existing work with a couple of other design points to parse out the variable that is generating this curvilinear behavior.

2February 2, 2019 at 2:38 pm #236004

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I wouldn’t say “People in charge of hiring rarely understand the steps to getting a PhD and typically lump academics into a group of elitists “sitting in a corner studying to take a test”. Rather, it is a matter of how you present the fact of earning your degree to them.

For example, my first two pieces of paper are in physics. When I went for my first job interview I knew at that time the perception of physicists fell into one of two categories – we were either head-in-the-clouds Albert Einstein wannabes or we just wanted to build bigger and better hydrogen bombs. I did my graduate work in vacuum physics which has all kinds of practical applications but I was aware few people knew this or had any idea vacuum physics is/was very experimental/applied. So, when I went to my first interview I took along one of the vacuum couplings I had made for my apparatus. The coupling required extensive precision machining/thread cutting in different metals as well as knurling on the screw caps.

Within 2 minutes of the start of the interview the interviewer said, “Well, physics….that’s mostly theoretical isn’t it?” Without another word I pulled out the vacuum coupling, set it on the desk in front of him and said, “I had to build that, and other things just like it, for my research.” The interviewer turned out to be a mechanical engineer. He grabbed the coupling and started turning the caps, feeling for smoothness of thread, firmness of the seal, etc. He looked at me and said, “Well, but you bought the knurled caps right?” I said, ” No, I built the whole thing.” He returned his attention to the coupling and focused so intently on the feel and look of that piece of equipment that I know I could have said something like, “You know, I understand your mother is an unmarried orangutan. ” and I’m sure he would have just nodded his head in agreement. :-)

From that moment forward I owned that interview. I got a job offer less than a week later.

Based on your post it sounds like you would want to focus the interviewer attention on some of the green energy projects with Shell or perhaps the projects with the concrete innovation company. The focus would be – what was the problem, how did I solve it, was the solution implemented, how much was it worth – dollars saved, new dollars to the bottom line, process made better, cheaper, faster, etc.

As a statistician in industry I had to provide a yearly summary of my efforts to management – basically justify my cost/value to the company. To that end, towards the end of the year I would go back to the various engineers I had worked for and ask them for an evaluation of what I had done for them with particular emphasis on dollars saved, new dollars to the bottom line, process made better, cheaper, faster, etc. If it was a failure or if what I had done had not been implemented I would record that and include these things in my summary to management as well. On a typical year I could point to about 3 million dollars to the bottom line that my engineers said I had contributed. Because these estimates came from the people I had worked for, management never questioned the summaries.

If you haven’t done so already and if you still have contact with the people for whom you did your work you should ask them for this kind of feedback and make sure they understand you want the unvarnished truth and why you want it. Given that you have this information choose a couple of the more impressive projects and make them the body of the text of your job application. In my experience a detailed focus on a few projects along with things like actual value, goes much further with HR types looking over a resume as opposed to just a long list of I-worked-on-this-and-then-I-worked-on-that.

1February 2, 2019 at 11:38 am #236001

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I agree with @mike-carnell as far as the “Wow” factor is concerned – in my experience there isn’t any. I’ve worked in industry and medicine as a physicist, engineering statistician, and biostatistician (oh yes,and as a black belt) for almost 40 years. Except for including the facts and dates of my three degrees on the initial job application form (four if you count the BB cert), no one has ever once asked about the number of degrees, the levels, or the types.

In every case it is always just “Can you do this? When can I expect to see what you have done? When will you present your findings?” …and “Please remember when you write your final report that you will need to make sure everyone understands what it is that you have done for them.”

In a similar vein, during the job interviews the questions are never about the degrees attained. Rather they are of the form: “Given the situation you have just read – how would you approach it?” (presenting you with a written what-if scenario, asking you to quickly read it, and then respond to a battery of questions from your interviewers is common). On those occasions where, in addition to a battery of what-if scenarios, I’m asked to make a presentation the presentation is in the form of – present the problem, highlight major issues, briefly describe the approach, and summarized the final results – all in a form that an audience consisting of everyone from people on the line up to and including the VP in charge will be able to understand.

4February 2, 2019 at 10:51 am #235999

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.As written your question is meaningless. You will need to give some idea of what it is that you are trying to do. For example, if you are running an analysis of some kind and the outcome is productive yes/no where you have an operational definition of “productive” and you are looking for possible relationships between measured inputs and the yes/no outcome then it is a binomial situation and it has nothing to do with a normal distribution. On the other hand, if it is something else then the answer could be yes/no/maybe.

1January 30, 2019 at 10:57 am #235835

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Never mind – it always helps to correctly read your own calculator screen – the sum is .004800 not .004880. When you take the square root of .004800 and divide .04 by that you get .577 which rounds up to .58

0January 30, 2019 at 10:46 am #235834

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Hmmmmmm…there must be some kind of double precision inside the calculator. If I first sum the two values and take the square root of the sum and do a division of that number into .04 I get the numbers indicated. However, if I just input .00488 and take the square root of that number I get .069857 which when divided into .04 gives .572 which doesn’t round up to .58.

0January 30, 2019 at 10:28 am #235833

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email..002112 + .002688 = .0048800 and the square root of that is .069282. Divide .04 by that and you get .577350 which when rounded up to the level of precision allowed in your calculation is .58

0January 17, 2019 at 8:50 am #235479

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Just tallying how many times some X variable shows up in a series of regression equations (one for each Y response) isn’t going to address the importance of that X. If we use your example Y1 = X2*X1^2 and Y2 = X2*X1*Y1^2 then, in order for what you are saying to be true, the coefficients for the X’s in both of the models for Y1 and Y2 would have to be equivalent in magnitude – that is a unit change in X1 in Y1 would have the same effect as a unit change in X1 in Y2.

There is nothing that says this would be the case. Indeed, it is precisely because this is more often than not the situation that one can use the simultaneous equations for Y1 and Y2 to identify regions of “optimum” performance where “optimum” means the best trade off’s with respect to Y1 and Y2 given that both are dependent, to some degree, on the same variables.

I wouldn’t recommend trying to build a weighting scheme for your X’s. If you do have a situation where the number of X’s is such that you can’t build a screen design to check them then I would just bean count the number of times you think a particular variable is going to matter to the Y’s of interest, pareto chart the results, and go with the top N where N is the number of variables you can comfortably run in a screen design.

1January 9, 2019 at 1:12 pm #211433

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Value Stream Mapping (VSM) is a way to track a process from beginning to end with an eye towards examining the system to look for places for improvement within the process. Your description of what you plan to do isn’t VSM. Indeed, based on your post I’m not sure what it is that you are trying to do.

My understanding of your post is as follows:

1. You have two products A and B.

2. Each product is produced twice each month.

3. You are proposing to gather work orders corresponding to each of the products.

4. You are proposing to measure the “amount of raw material” coming from the supplier each month

5. You are going to take some kind of data from each of the work orders and analyze the numbers in some fashion.

6. You are planning to look at the averages of these numbers from the work orders and draw conclusions about something.As I said this isn’t VSM. I’m not trying to be mean spirited or snarky but if the above is a correct summary of what you are proposing to do I don’t see what you plan to gain from any of this.

1. You want to measure amounts of raw material from suppliers but give no indication as to why you are doing this. In your description of proposed actions this measure does not seem to have any purpose.

2. What is it about A and B you want to know?

3. If we assume taking some averages of data from work orders is meaningful to some aspect of A and B then what are you going to do with these averages?

a. Compare averages of various work order data from A against that of B?

b. Is this a situation where data recorded in work orders is known to reflect actual process behavior?

1. if it is, then how will this relate back to assessing A and B?

c. As an aside, it should be noted that if you are planning on comparing averages for any aspect of your process you will have to employ statistical methods for means comparisons.If you could provide more detail concerning what it is that you are trying to do and address some of the questions I’ve asked then either I or some other poster may be able to offer suggestions.

0January 9, 2019 at 12:45 pm #211432

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I don’t understand what you mean by “setup in Minitab 18.” The six point design is all there is and it would just be a matter of building the appropriate spreadsheet for the X’s and Y responses. If you go with just the six points you can build a model where Y is a function of A, B, AB, and B*B. If you toss in a single replicate of one of the design points you could also check A*B*B.

You would reduce the model to just the significant terms in the usual way – first plot the data and see what you see, run backward elimination and forward selection with replacement regression and check the final model using residual analysis. If all is well then you would confirm the validity of the final reduced model by using it to make predictions with certain combinations of A and B, run those combinations, and see if your final result was inside the prediction error limits associated with your prediction.

If you have more than one Y you would follow the above procedure for each of them and then you would use all of the equations together to predict a couple of optimum conditions (these will most likely be trade offs – most of the time you can’t get all of the Y responses simultaneously at their optimum level for a given level of A and B) and you would test the predictions in the same manner as above.

0January 8, 2019 at 5:39 pm #211391

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Thanks Mike

1January 8, 2019 at 5:20 pm #211389

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Thanks Katie(?), for correcting the design display on my first post. You can remove the second one if you wish.

0January 8, 2019 at 11:58 am #211379

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.The other option is to not bother with any kind of transformation. Since you know the distribution is non-normal for data when the process is in control just use the usual methods for calculating Cpk for non-normal data. It is my understanding that Minitab has this method as part of the program. The method is described in detail in Chapter 8 of Bothe’s book Measuring Process Capability. The chapter title is “Measuring Capability for Non-Normal Variable Data.” Personally, when having to generate a Cpk for non-normal data, it is my method of choice.

0January 8, 2019 at 11:50 am #211378

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Well, that’s just peachy. What you type isn’t what gets posted. Copy the design with headings into a word document and re-insert the appropriate blanks – you should have 3 columns, experimental number, levels for factor A and levels for factor B.

0January 8, 2019 at 11:48 am #211377

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Sure, it’s a 2 x 3 design

`Experiment Factor A Factor B`

1 -1 -1

2 1 -1

3 -1 0

4 1 0

5 -1 1

6 1 1

1December 31, 2018 at 11:34 am #210206

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Your question sounds like a homework problem. I’ll assume it isn’t and offer the following: If you are doing something for the first time and, based on what you know, you believe what you are doing is going to make a difference then, if it does make a difference it is all value added and if it doesn’t make a difference it is still all value added. In the first instance you will have found a way to do something better/cheaper/faster and in the second instance you will have demonstrated to your satisfaction that approaching the issue from that point will not work. Knowing that something will not work is just as valuable as knowing something does work.

1December 31, 2018 at 8:08 am #210202

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.It sounds like you have a process with a physical lower bound which renders negative values meaningless. In that case you will need to log the data, construct the control limits in log units and then back transform the relevant statistics (target mean and standard deviation). The control limits will, of necessity be asymmetric but they will not go below 0.

0December 15, 2018 at 7:36 am #209518

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.There also seems to be something wrong with the front page. At first you could see the listing of forum topics and other items below the header now there is just a blank space. I thought it might be a browser issue so I tried Google – same result. I can still see the sidebar listing of recent topics and I can get to the full list through that but all of that blank space on the front page has to be some kind of problem on your end.

0December 6, 2018 at 9:30 am #209079

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Well, yes/no/maybe. The issue with the simple Pearson coefficient is that you can get “large” values and still have lack of significance. As for Rsquared -no, it is an easily manipulated/fooled statistic and, by itself, tells you very little. There are websites, blogs, even some papers and textbooks that will offer various “rules-of-thumb” with respect to assessing a regression effort on the basis of R2. Usually the rule-of-thumb is that R2 must be some value (.7 is a favorite) or higher before the regression equation is of any value – this is pure rubbish. The question isn’t one of R2, the question is what is the reason for building the regression equation?

One quick example with respect to the absurdity of insisting on given levels of R2: Many years ago I had to analyze the presence of compounds in a water supply which, when present, indicated cyanide leaching. We ran the analysis over time and found a significant positive trend in the data. The R2 for the regression was .04. The crucial fact of the analysis was that the measured concentration of these compounds were increasing over time and, based on that regression, we could show that the trend predicted the cyanide level in the water would reach a life threatening level in about 3+ years time. The analysis wound up as part of a court battle between the local government and the firm responsible for the problem. I wasn’t present at the hearing and the firm dragged in some clown who had citations with respect to the “need” for high R2 before one could accept the results of a regression. End result – the firm won and about 4 years later the level of cyanide leaching reached the critical level. The cost of addressing the problem 4 years later was a lot more than it would have been at the time of the analysis

If you are going to assess a correlation based on a regression then the only proper way to assess the success of that correlation is to do a regression ANALYSIS which means doing all of the plotting and examining of residuals that are at the heart of a regression ANALYSIS. I would recommend you find a good book on regression analysis and memorize the chapter(s) concerning the correct methods for assessing the value of a regression equation. Whatever you do, don’t make the mistake of judging a regression using only summary statistics like Rsquared.

0December 4, 2018 at 1:23 pm #208930

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Pearson’s correlation coefficient is only useful in the situation where the relationship between two variables is a straight line. If you have a curvilinear relationship between an X and a Y you can still run it by a Pearson’s correlation coefficient and you will find that correlation coefficient is low because the relationship is no longer a straight line. In a similar manner, if you try to fit a simple Y = X regression line to a curvilinear relationship you will find the p-value is most likely not significant. On the other hand, if you fit a Y = fn of X and X*X then you will have a significant P-value and, depending on the kind of curvilinear relationship you might have a significant p-value for both the linear and the quadratic term in the regression.

Just to check this out try the following simple data set

x1 y1 y21 1 1

2 3 2.1

3 5 2.9

4 5.5 4.2

5 6 4.9

6 5.8 6.2

7 5.1 6.8

8 4.9 8

9 4.0 9.2You will find your Pearson’s correlation coefficient for y1 vs x1 is not significant with a value of .519 and a p = .152. If you run a simple regression of y1 = x1 you will get the same p-value. If you run y1 = fn(x and x*x) you will get p-values of <.0001 for both terms. If you run y2 vs x1 you will get a significant Pearson’s correlation coefficient of .998 and p <.0001 and a similar p-value for the regression of y2 vs x1.

By the way the term linear regression only refers to the linearity of the coefficients in the regression equation. Linear regressions can have polynomial terms. Non-linear refers to non-linear in the regression coefficients and is a very different animal.

0October 30, 2018 at 6:28 pm #203154

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.I spent some time checking various reference books looking for something that might help and I’m afraid I don’t have much to offer.

Two thoughts

1. We are assuming you are running ANOVA on continuous variables. If you are running categorical variables then linear and interaction are all you can expect to compute.

2. The level of sophistication of modern statistics packages is such that I doubt you will find anything relating to manual calculations in any of the modern statistical texts for anything other than main effects and interactions.I did find a reasonable discussion of the problem and what looks like a guide for generating the necessary equations in Statistical Analysis in Chemistry and the Chemical Industry by Bennett and Franklin – Wiley – 5th printing January 1967 under the chapter sub-heading “Analysis of Variance for Polynomial Regression.” The text and discussion are too long to attempt to summarize on a forum of this type but you should be able to get a copy of this book through inter-library loan.

If you can’t get this book then you might want to do a search on the web for the same topic – Analysis of Variance for Polynomial Regression – and see if anyone has provided the details.

0October 10, 2018 at 11:11 am #203122

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Then is it fair to say that it makes sense to characterize the workpiece parameter with high and low values? Which is to say – are lambda, theta, and rho connected or can they be varied independently? If it is the former then you have 4 continuous variables which means you could run a screen check in 8 points with two center points for a total of 10 experiments. If it is the latter then you actually have the situation of a 6 parameter study – lambda, theta, rho, voltage, capacitance, and machine speed. In this case you could also run a screen design in 8 experiments again with two center points for a total of 10 experiments.

An analysis of the 10 points would allow a check for significance of the factors of interest and pave the way for a design with fewer factors and the inclusion of some possible interaction terms. The analysis of the 10 point designs would also provide an initial predictive equation which could be tested to see if the observed correlations actually described possible causation.

0October 10, 2018 at 6:47 am #203118

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.No, that’s called cheating. We are assuming your upper spec limit is there for a reason. If it isn’t arbitrary then, given your description of events, you are just trying to pretend that some kind of special cause which is driving your process to the upper spec limit (and presumably at some future date will drive your process past that limit) doesn’t matter. The only solution your approach provides is a way to ignore problems with your process for the time being – this is not process improvement.

0October 9, 2018 at 5:30 am #203113

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.What you are asking is this: is there a way to solve my problem before I know what the problem is – and the answer is “no”. The whole point of DMAIC is that of problem identification, investigation, and resolution.

0October 9, 2018 at 5:26 am #203112

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.If this isn’t a homework problem it certainly sounds like one. In either case no one can offer anything because you have not provided enough information. You need to tell us what it is that you are trying to do. For example – confidence interval around the defect size, detection of a shift in defect size due to process change, etc. …and then there is the issue of precision – alpha and beta levels and why you need those at the level you have chosen.

0October 8, 2018 at 11:29 am #203110

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.What kind of a measure is “the workpiece”? My guess would be categorical unless you have some way of quantifying this variable (really small, small, medium, large, very large), (really simple, simple, average, above average, complex) etc. If it is categorical then the smallest design (we are assuming voltage, capacitance, and machining speed can be treated as continuous variables) would be a basic 3 variable saturated design (3 factors in 4 experiments) run for each of the 5 workpiece categories for a total of 20 experiments – add one replicate per group and you would have a total of 25 experiments.

If, on the other hand, workpiece can be quantified then you could run a 2 level factorial with a couple of replicates at the center point for a total of 18 experiments.

The thing to bear in mind here is that the philosophy of experimental design is that if something is going to occur it is most likely to occur at the extremes so rather than 5 levels for a continuous variable choose the minimum and maximum settings and use variations of a two level factorial design. Of course, if the one variable is categorical then you would run the smaller two level saturated design at each of the 5 categorical values.

If you are worried about the possibility of curvature then you would want to include a center point on the factorial and run your replication there. For the case of the saturated designs with the categorical variable this would bring the total number of experiments to 30 and, if all can be treated as continuous then, as previously noted, the total would be 18.

0October 8, 2018 at 4:59 am #203105

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Practically anything you care to name that has anything to do with any aspect of the way the process functions – is this a homework question or are you actually looking at a process. If you are actually working on a process tell us about it and perhaps I or someone else could offer more specific details.

0October 4, 2018 at 5:16 am #203098

Robert ButlerParticipant@rbutler**Include @rbutler in your post and this person will**

be notified via email.Special cause can impact either the mean or the variability or both and changes in operators and equipment are not limited to changes in mean – these variables (along with lots of other things) can impact variation as well.

0 - AuthorPosts