近年來，由於生活水準的提高，品質已經成為消費者在選擇商品或服務時的一項重要決策要素之一，因此廠商們皆希望產出的產品的品質能夠滿足人們的需求，並且能夠同時講求製程作業成本的經濟性。為了達此目標，統計製程管制(Statistical Process Control)在業界被廣泛地使用，而其中管制圖也被證實為改善生產力最有效的工具之一。
本論文即是探討統計製程管制與管制圖之概念，並且針對各種計量值管制圖(Control Chart for Variables)探討其原理與使用時機。並在最後，嘗試利用Excel VBA (Visual Basic for Application)針對華特管制圖(Shewhart control chart)、累積和管制圖(Cusum chart)與指數加權移動平均管制圖(EWMA chart)撰寫出一套計量值管制圖軟體，並在軟體設計上，講求操作的便利以及程式的擴充性，以期能夠提供業界或教學使用。

Quality is the most important decision for consumers to choose product or services due to improvement of the living standard recently. The manufacturer produces merchandise not only to satisfy buyer’s demand but also to achieve cost-effective in the production process. As a result, Statistical Process Control is adopted extensively by most of company, and Control Chart is verified as the most efficient tool to improve productivity.
This thesis is to research the concept of Statistical Process Control and Control Chart, and emphasize what theory of all kinds of Control Chart for Variables is and how it is executed. Furthermore, the Excel VBA (Visual Basic for Application) is used and planned for preparing for Shewhart control chart, Cusum chart, and EWMA chart. Therefore, the software is designed friendly for users and flexibility upgraded for designers so that the marketplace and school can utilize this tool to reach their goal.

1. 徐世輝，「品質管理」，三民書局，民國八十五年。
2. 徐世輝，「品質管理」，華泰書局，民國九十六年。
3. 房克成，「管制圖」，中華民國品質管制學會，民國八十三年。
4. 林秀，「統計品質管制─管理的新境界」，五南圖書出版公司，民國八十五年。
5. 張織雲，呂汝漢，簡兆權，「統計品質管制」，曉園出版社，民國八十年。
6. 鄭春生，「品質管理」，三民書局，民國八十四年。
7. 傅和彥，「生產管理」，前程企管，民國八十九年。
8. 潘浙楠，李文瑞，「品質管理」，俊傑書局，民國九十一年。
9. 齊鋒，「Visual Basic 6.0入門與應用」，知城數位科技股份有限公司，民國九十年。
10. 山賀弘 著，亮亨 譯，「Excel VBA功能索引式參考手冊」，旗標出版股份有限公司，民國九十五年。
11. 大村 著，亮亨 譯，「超圖解Excel VBA基礎講座」，旗標出版股份有限公司，民國九十五年。
12. 鍾朝嵩，「應用Excel的統計品管與解析」，先鋒企業管理發展中心，民國九十五年。
13. Peter Aitken,” Visual Basic for Windows Insider”, 1993.
14. Montgomery, D. C.,” Introduction to Statistical Quality Control”, 5th ed., Wiley, 2000.
15. Amitava Mitra,” Fundamentals of Quality Control and Improvement”, Macmillan Publishing Company, 1993.
16. Dale H. Besterfield,” Quality Control”, 5th ed., Prentice-Hall, 1998.
17. Eugene L. Grant, Richard S. Leavenworth, “Statistical Quality Control”, 6th ed., McGraw-Hill, 1988.
18. Page, E. S., “Continuous Inspection Schemes,” Biometika, Vol. 41, 1954, pp. 101-115.
19. Hawkins, D. M., “A CUSUM for a Scale Parameter,” Journal of Quality Technology, Vol. 13, No. 4, 1981, pp. 228-231.
20. Hawkins, D. M., “A Fast Accurate Approximation for Average Run Lengths of CUSUM Control Charts,” Journal of Quality Technology, Vol. 24, No. 1, 1992, pp. 37-43.
21. Hawkins, D. M., “Cumulative Sum Control Charting: An Underutilized SPC Tool,” Quality Engineering, Vol. 5, No. 3, 1993a, pp. 463-477.
22. Barnard, G. A., “Control Charts and Stochastic Process,” Journal of the Royal Statistical Society, Ser. B, Vol. 21, 1959, p. 239.
23. Johnson, N. L., “A Simple Theoretical Approach to CUSUM Chart”, Journal of the American Statistical Association, Vol. 54, 1961.
24. Woodall, W. H., and B. M. Adams, “The Statistical Design of CUSUM Charts,” Quality Engineering, Vol. 5, No. 4, 1993, pp. 559-570.
25. Roberts, S. W., “Control Chart Tests Based on Geometric Moving Averages,” Technometrics, Vol. 1, No. 3, 1959, pp. 239-250.
26. Davis, G. B., and Olson, M. H., ”Management Information System(6-7)”, 2nd ed., McGraw-Hill, 1985.
27. Juran, J. M., “Quality Control Handbook”, 3rd ed., McGraw-Hill, 1974.