The situation: You have successfully run an experiment and analyzed the data. The results include a prediction equation with a high predicted R-squared that will be useful for many purposes. How can you share this with colleagues?
The solution: Design-Expert® software has a little-known but useful “Copy Equation” function that allows you to export the prediction equation to MS Excel so that others can use it for future work, without needing a copy of Design-Expert software. The advantage of using this function is that it brings in all the essential significant digits, including ones not showing on your screen. This accuracy is critical to getting correct predictive values.
3. Open Excel, position your mouse and use Ctrl-V to correctly paste the formula into Excel (Ctrl-V allows the spreadsheet functionality to work.)
4. As shown in the figure (coloration added within Excel), the blue cells allow the user to enter actual factor settings. These values are used in the prediction equation, with the result showing in the yellow cell.
You can also view this process in this video.
Good luck with your experimenting!
The upcoming 2019 Analytics Solutions Conference will be the premier meeting to learn about how others are using statistical tools (design of experiments (DOE), multivariate analysis (MVA) and process analytical technology (PAT)). Come see how these tools are used to dramatically impact the bottom line.
And registration is now open for the conference! Don’t miss out on early bird registration.
Reason #3 to be there: Sharon Flank’s keynote talk "Field Authentication and Adding Chemistry to Blockchain".
These days, companies need to find effective ways to secure quality and protect against counterfeit products. Whether you are the manufacturer or the end user, using the right product is important.
This complex problem requires an elegant solution. One that is non-destructive, fast, and user friendly. Dr. Flank takes us thru a solution that uses spectroscopy and analytics to identify a products chemical ‘fingerprint’. This can be applied on pharmaceuticals, cosmetics, spare parts, electronics, wine and additive manufacturing, and the talk will include use cases and real-life examples.
Reason #4 to be there: a dinner cruise down the Mississippi. That’s right. Network with your fellow attendees while cruising down the Mississippi river at sunset. Then have dinner and a drink before returning to shore.
Need more reasons to attend? More keynote speakers, more fun networking opportunities, and summer in Minnesota! And to top it off, early bird registration is still open.
Register now to ensure your seat!
General Info: https://www.statease.com/asc-2019
The upcoming 2019 Analytics Solutions Conference is your opportunity to discover how others are using statistical tools (design of experiments (DOE), multivariate analysis (MVA) and process analytical technology (PAT)) to dramatically impact the bottom line.
Reason #1 to be there: Keynote Speaker Dr. Geoff Vining. Jump-start your education by learning about leading-edge methodology with Geoff’s talk on “Solving Complex Problems”.
These days, organizations need solutions for increasingly complex problems that are critical to their operation. Statistical engineering is the discipline dedicated to the art and science of solving these complex problems. These problems almost always are unstructured and typically large, crossing several disciplines. Typically, the data associated with them come from a wide variety of sources and thus usually look like a “mess.” The key is how to provide enough definition, data analysis, and structure to create a reasonable path to a truly sustainable solution.
Statistical engineering provides a structure to determine which statistical and analytic tools/methods are appropriate depending on the circumstances, and it outlines how to create sustainable solutions efficiently and effectively. Ultimately, it is the discipline that helps practitioners determine “the right tool for the right job at the right time, properly applied.”
This talk introduces this new discipline at a high level. It then outlines the important roles that both DOE and data analytics play in the solution of complex problems. In the process it emphasizes the importance of strategy and understanding exactly what the tools can and cannot do.
Reason #2 to be there: Cost. At $495 (with the early bird special rates, in place until April 15), this is a truly inexpensive conference. With the tremendous value to be had in technical content for all audiences entry-level to advanced, and the great price point, this is a no brainer.
Need more reasons to attend? More keynote speakers, fun networking opportunities, and summer in Minnesota!
General Info: https://www.statease.com/asc-2019
“Multifactor testing via design of experiments (DOE) is the secret weapon for medical-device developers,” says Stat-Ease Principal Mark Anderson, lead author of the DOE and RSM Simplified series*. “They tend to keep their success to themselves to keep their competitive edge, but one story, that we can share, documents how a multinational manufacturer doubled their production rate while halving the variation of critical-to-quality performance. That’s powerful stuff!”
The case study that Mark is referring to can be found here: RSM for Med Devices.
Stat-Ease has guided many manufacturers in the medical device industry in the streamlining of their products and processes. Now, we have put that experience together into one place, the Designed Experiments for Medical Devices workshop.
In this one-of-a-kind workshop, learn how to optimize your medical device or process. Our DOE experts will show you how to use Design-Expert® software to help you save money or time while ensuring the quality of your product. We welcome scientists, engineers, and technical professionals working in this field, as well as organizations and institutions that devote most of their efforts to research, development, technology transfer, or commercialization of medical devices. Throughout this course you will get hands-on experience while using cases that come directly from this industry.
During a fast-paced two days, explore the use of fractional factorial designs for the screening and characterization of products or processes. Also see how to achieve top performance via response surface designs and multiple response optimization. Practice applying all these DOE tools while working through cases involving medical device design, pacemaker lead stress testing, and typical processes that may be used in the testing or production of these devices such as seal strength, soldering, dimensional analysis, and more.
For dates, location, cost, and more information about this workshop, visit: www.statease.com/training/workshops/class-demd-adin.html
About Stat-Ease and DOE
Based in Minneapolis, Stat-Ease has been a leading provider of design of experiments (DOE) software, training, and consulting since its founding in 1982. Using these powerful statistical tools, industrial experimenters can greatly accelerate the pace of process and product development, manufacturing troubleshooting and overall quality improvement. Via its multifactor testing methods, DOE quickly leads users to the elusive sweet spot where all requirements are met at minimal cost. The key to DOE is that by varying many factors, not just one, simultaneously, it enables breakthrough discoveries of previously unknown synergisms.
So, you formulate products. Yes, you, in the industry of making beverages, chemicals, cosmetics, concrete, food, flavorings, metal alloys, pharmaceuticals, paints, plastics, paper, rubber, and so forth.
You also need to optimize that formulation—quickly. Mixture design of experiments (DOE) to the rescue! “Wait, what?” you ask.
When creating a formulation, you can use mixture DOE to model the blend in the form of a mathematical equation. It also allows you to show the effect each component has on the measured responses, both by itself and in combination with the other components.
This model then leads you to the optimal composition, or “sweet spot”, based on your desired outcome. And mixture design does this fast.
"Yeah, OK," you say. "It's going to take me months to learn how to do that. So, no thanks."
We have software that will do it for you, and a 3-day workshop that shows you how to use it. Not months, 3 days. We get it. You're not a statistician, you don't have the time to learn all the ins and outs of the theory. You just need to get to the information. We'll help you get there.
Ready to know more? Good! Download this white paper that illustrates how mixture design works and how Design-Expert® software will help you.
Ready to know even more? Head over to our Mixture Design workshop webpage and register now. This hands-on workshop will show you how Design-Expert® software can be used to design and analyze mixture experiments. The software provides the power for the generation of optimal designs, as well as sophisticated graphical outputs such as trace plots. You will learn how these methods work and what to look for. No statistical background needed!
If you have any questions regarding the workshop, email us at firstname.lastname@example.org.