Abstract
Purpose: SPC can be defined as the problem solving process incorporating many separate decisions including selection of the control chart based on the verification of the data presumptions. There is no professional statistical software which enables to make such decisions in a complex way.Methodology/Approach: There are many excellent professional statistical programs but without complex methodology for selection of the best control chart. Proposed program in Excel APSS (Analysis of the Process Statistical Stability) solves this problem and also offers additional learning functions.Findings: The created SW enables to link altogether separate functions of selected professional statistical programs (data presumption verification, control charts construction and interpretation) and supports active learning in this field.Research Limitation/implication: The proposed SW can be applied to control charts covered by SW Statgraphics Centurion and Minitab. But there is no problem to modify it for other professional statistical SW.Originality/Value of paper: The paper prezents the original SW created in the frame of the research activities at the Department of Quality Management of FMT, VŠB-TUO, Czech Republic. SW enables to link altogether separate functions of the professional statistical SW needed for the complex realization of statitical process control and it is very strong tool for the active learning of statistical process control tasks.
Highlights
Statistical process control (SPC) is an approach to process control that has been widely used in various industrial or non-industrial fields
APSS itself forms the environment for practicing intended tasks, decision-making, verification of these decisions, quick complementing missing knowledge and communication between user and professional statistical SW (APSS supposes that users are able to use professional statistical SW Statgraphics and Minitab)
4 CONCLUSION This paper deals with the description of the software product which was worked out for the practicing selection of the suitable control chart based on verification of the data
Summary
Statistical process control (SPC) is an approach to process control that has been widely used in various industrial or non-industrial fields. Decisions linked to the main goals of SPC refer to the out-of control signal revelation (1), identification of root cause of assignable causes (2), selection of corrective or improvement action (3) and their realization (4). There is no SW support for very important decision which precedes activities (1) - (4): selection of the suitable type of the control chart (which is one of the most important activities influencing the efficiency of the whole SPC implementation) based on the properly made verification of statistical properties of data (Cox, 2006; Zimmerman, 2011). Integration of partial steps of SPC into one complex solution; Support of learning of the decision-making activities in the frame of the verification and ensuring the statistical stability of the processes, i.e. by the selection of the suitable control charts and by the interpretation of the reached results; Increasing quality of the self-learning process. APSS guarantees following functions: selfstudy, communication, decisionsupport, control, verification of obtained knowledge, data support, methodical support
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
