Coming soon - the calendar of workshop events, hosted on EventBrite and delivered live via Zoom.
😎
We provide business improvement training online in a LIVE Workshop format that challenges the student with interactive exercises and exams that enhance retention of key learning points.
Multiple Regression Analysis can be a powerful tool for evaluation of multiple process, or product inputs versus a single output characteristic which is often a balanced scorecard element. The results can provide insight into what makes a difference, what doesn’t make a difference, and unfortunately the just can’t tell.
The keys to the analysis boil down to the structuring of your data set for the multiple regression. A common stratification factor that aligns all of the data elements is paramount and the most common one is the date that is associated with the data elements, both the input X’s and the output Y. If some data is missing for a particular date the best practice is to remove all of the data elements for that date from the model. Maintaining balance is critical.
Before throwing all of the data into a multiple regression analysis using a statistical analysis package such as JMP or Minitab look at the data graphically with a matrix scatterplot. Look for relationships, either positive or negative, that relate an input X with the output Y. Also, be wary of highly correlated X to X relationships. That could be colinearity, which can lead to misinterpretation of your regression model.
The graphic look at the relationships will point out the X variables that don’t need to be included in the model to start with. During the multiple regression analysis multicolinearity can be dealt with using variance inflation factors (VIFs) which require values of 5 or less. Depending on the statistics software package during the first iteration of your regression model you will be presented with T statistics or F statistics. These statistics are used to generate the all important p values.
Pooling is the elimination of the non-significant variables. The first step in reduction of variables is to identify the X’s that have either F<=1 or absolute value of T<=1. These must be removed from the model. Now re-run the regression model and check the VIFs. Typically any VIFs that are greater than 5 can be removed based upon having a large p value. The caution here is to take them out one at a time and rerun the model. I forgot to tell you, that is why it is called multiple regression analysis, you will be doing this multiple times.
Now that your regression model has been reduced to the significant X’s you should have the following.
The next question after all of this work has been completed is, “Do the relationships in the model make sense?” Use your process and product knowledge to give the results a sanity check. If it makes sense than you are ready to use the mathematical model developed to make predictions. The conservative approach is to stay within the minimum and maximum values for each of the significant X variables that were used to develop your model, remember that is the only data that you have and is the basis for the model.
Here is why. There was a study done in Oslo. The population of storks was increasing along with the number of babies being born which is a strong positive correlation. Therefore, we can declare that Storks bring Babies! The truth is, storks nest near warm chimneys so as the population was growing more houses were built, more chimneys, and thus more nesting places for the birds. Remember, you’re a priori knowledge about products, processes, and services should be used to give your multiple regression model results a sanity check.
The Process Design for Six Sigma Course will teach you the DMADV five phased approach to new process development. The five phases of the DMADV approach are Define, Measure, Analyze, Design, and Validate.
To facilitate the course we follow an actual new process being developed, a Quality Management System, step by step using the Process Design for Six Sigma method. You will see first hand how the deliverables lead to the creation of the new process.
You will be provided a set of tools that can be used to develop a new process following the DFSS, Design for Six Sigma methodology. The course features animations, videos, interactive quizzes, and a final exam. The course takes about 3 hours and 10 minutes of total seat time. No module within the course is longer than 30 minutes. There are 20 modules in this course which includes 6 quizzes and a final exam.
Course Outline
This course is priced at $200. A bargain for learning how to develop new processes that will meet and exceed customer requirements. Register Today!
Just how reliable is your data? Everyday, devices are used to measure things and give us the data. Colleagues evaluate things and make decisions about goodness and badness. Then, all this information ends up in a computer where the data can be crunched and plotted using a software tool. We can then evaluate the results and make those all important data driven decisions. That’s what we want to do, but what if the data isn’t reliable?
To answer that question the often overlooked Measurement System Analysis (MSA) comes into play. We can all agree that using data and statistics to guide our decision making process makes sense. Assuring that our data has integrity is therefore highly important. That is just what a MSA can do for you.
MSA can be applied whether the measurements are taken with a device or assessed based upon some criteria. For the data to be considered reliable for use in a statistical analysis for making decisions it must be captured by a process that is repeatable and reproducible. Repeatable means that if I evaluate the same item multiple times I will get the same answer each time. Reproducible means that if you, me, and your best friend were to evaluate the same item multiple times we would all get the same answer each time.
The reliability of our data is very important because taking corrective actions or making data driven decisions can make or break an organization. It gets back to the old saying, “If it ain’t broke don’t fix it.” The MSA study does take a little time and some planning. It is basically a hypothesis test to determine if the measurement system can determine if there is a difference or not. We want to prove that all the variation in the data is associated with the differences in the items being evaluated, not in the measurement system that is being used for the evaluation.
Time and again we have found that the first place to take corrective action in a process is the measurement system itself. Be wary of data that came from the information system. Just how did that data get into the system in the first place? Make sure that time is aligned with the data. Measurement System Analysis is important, especially if you want to make good business decisions based upon data.
Sales and Marketing is the process of converting the efforts of the company into revenue. The Process should create value in the market place by differentiating the products and services of the company versus your competitor’s alternatives resulting in prospects becoming customers. The Six Sigma approach to improving any business process follows the DMAIC Improvement Process namely Define, Measure, Analyze, Improve, and Control. Organizations that are embracing this approach have realized productivity increases, cost reductions, and revenue stream enhancement. Success has been proven in operations, production, and service delivery. It is now time to rollout Six Sigma DMAIC in Sales and Marketing.
Ask yourself if your organization is facing any of the following issues:
Any of the above issues can be tackled as a Six Sigma DMAIC improvement project.
Six Sigma DMAIC can be applied whether the improvement project scope can be accomplished in days, weeks, or months.
Operations improvement is not magic, but strategically focused hard work. The keys to successful operations improvement include these five elements:
Include these elements sequentially in the operations improvement plan as your strategy for success.
Performance Metrics tied to business goals and objectives
The leadership team reviews the goals and objectives for the business and selects the performance metrics that measure success. Often, Quality Function Deployment (QFD) or a Prioritization Matrix is used to align and rank the performance metrics with the business goals and objectives. The marching orders are now set for the improvement projects.
Leadership agreement on, and support for, select improvement projects
The leadership team reviews the processes across the supply chain from the beginning to the end. Where are the issues? Where do we fall short of expectations? Where is the waste in the system? These questions drive the brainstorming to identify potential improvement projects. A list is made of the projects and incorporated into another QFD or Prioritization Matrix to align and rank the improvement projects with the rated and ranked performance metrics. Using the matrices keeps the prioritization of the projects aligned with the business goals and objectives.
Project teams staffed for success
The leadership team focuses on the top four or five projects based upon the priorities they have agreed on using prioritization matrices. The teams for these projects are selected from the best and the brightest personnel within the organization that have knowledge or skills relevant to the project. Often these individuals are considered too important or too busy to work on improvements. That is the reason for their selections. These personnel decisions answer the question, “Are you serious about making improvements?”
Project centric training
Each project and its assigned team progress through the Lean Six Sigma training and apply the tools and techniques directly on their improvement opportunity. As quickly as methods are learned they are applied to make progress toward the completion of the project following the train and do philosophy. If the opportunity is a process improvement the methodology follows DMAIC (define, measure, analyze, improve, and control). If the opportunity is a design improvement the methodology follows DMADV (define, measure, analyze, design, and validate), or Design for Six Sigma.
Accountability for timely successful project completion
Success requires the leadership team and the improvement project teams be held accountable to complete the projects in a timely manner. Deliverables based project plans focus the effort of the teams to move through the DMAIC, or DMADV, process phases successfully. Phase exit reviews are held between the project and the leadership teams. Phase exit reviews assure that all parties involved are held accountable to achieve successful strategically focused operations improvement.
A question my students often ask is, “Which hypothesis test should I use and when?” In this article we will address some guidelines to answer the question. The available hypothesis tests are:
The following examples will address which test to use given a certain set of circumstances. In hypothesis testing we are faced with answering the question, “Do the variables in my process make a difference, or not, if they are changed?”
Continuous Variable Outcomes
The output, or outcome, in the process is measured on a continuous scale. We will refer to the outcomes as the “Y”. The input variables, or the things we will be changing, are varied between discrete settings, or levels. The variable could be continuous, but the settings are specific and can be considered discrete.
Case 1: T Test
The T Test allows testing of two items only, or two level settings only. Let’s say we want to improve our gas mileage. The output Y is miles per gallon. The inputs for the T Test are gasoline additives. The level settings could be Yes (use the additive) and No (plain gasoline without additives). The sample size can be small using the T Test. Run 5 tanks of fuel under each condition and measure the miles per gallon. The null hypothesis for this test is regardless of whether or not we use the additive the gas mileage will remain the same evidenced by p values much greater than 0.05. The alternative hypothesis is that there is a difference between Yes and No which is evidenced by p values that are less than or equal to 0.05.
Case 2: Paired T Test
In the Paired T Test only two items can be tested, but the tests are run concurrently, or in pairs of both items. We use the pairing technique when environmental factors may influence the outcomes. We want that “noise” to have an equal chance to affect the test subjects so running the test concurrently assures this equality of noise distribution. In this case, we will test two hull designs for nautical speed. Testing will be carried out over several days so the conditions in the ocean will definitely be changing such as wind speed, wind direction, wave height, and currents. Both of the hull designs will be subjected to the same conditions when we conduct the tests simultaneously in pairs. The plan is to conduct 5 races over the course of one week. If the p values in the Paired T Test are less than or equal to 0.05 than the hull design with the greatest nautical speed can be declared the winner because the test shows a significant difference. If the p value is much greater than 0.05 then we need to go back to the drawing board because there is no difference in the hull designs.
Case 3: ANOVA
Analysis of Variance, or ANOVA, is very powerful because there is essentially no limit to the number of items, or level settings that can be evaluated during the testing. We are limited only by practicality. In this case we want to determine if there is a difference in the distance a golf ball can travel. The outcome Y is the distance in yards. We will test Pinnacle, Nike, Titleist, Srixon, Bridgestone, and Callaway. A robot with one type of golf club will be used to launch the golf balls. Swing speed and force will be the same for each test subject. Twenty of each ball will be launched and the driving distance will be measured. As in all of these hypothesis tests, the p value is the measuring stick for declaring if a difference exists or not. When the p value is < or =" to" style="mso-spacerun:yes"> When the p value is much, much greater than 0.05 we declare that no significant difference exists between the test subjects.
Case 4: Test for Equal Variances
In the three previous cases the concern was a difference in the average value of the outcome based upon the level setting of the input variable. With Test for Equal Variances the evaluation is the variability of the outcomes about the average. The standard deviations are evaluated to test for differences in variation. In this case we will use the data from Case 3, the driving distance of the golf balls. Which golf ball is most consistent in driving distance? If I buy a dozen of these golf balls can I expect the same results? The Test for Equal Variances provides the answer. If the p value is low than the null must go, but if the p value is high the null applies. The null hypothesis is always “There is no difference.” Two tests are used, one is called
Discrete Variable Outcomes
The output, or outcome, in the process is measured by counting occurrences which is a discrete variable. We will refer to the outcomes as the “Y”. The input variables, or the things we will be changing, are varied between discrete settings, or levels.
Case 5:
Chi Square testing compares discrete Y’s and discrete X’s. In this type of analysis categories, or groups, are compared to other categories, or groups. For example, “Which cruise line had the highest customer satisfaction?” The discrete X variables are (RCI, Carnival, and Princess Cruise Lines). The discrete Y variables are the frequency of responses from passengers on their satisfaction surveys by category (poor, fair, good, very good, and excellent) that relate to their vacation experience.
Conduct a cross tab table analysis, or
Now you should have a good understanding of which hypothesis test to use and when it is most appropriate. Remember that it is just as important to determine that there is no difference as well as that there is a difference. Sound business decisions depend on making choices based on significance.