The Application of Excel in Quality Control of Environmental Monitoring

Xiang-shan YANG,Yan Lv,Jing-shun LI,Shu-hua ZHAO,Hong-yang LIU

DOI: https://doi.org/10.3969/j.issn.1001-3644.2005.03.028

2005-01-01

Abstract:AbstrcatThe application of Excel in quality control of environmental monitoring is introduced. Taking an example,the author (expounds) means and process of making double samples quality control chart by using Excel.

What problem does this paper attempt to address?

Two environmental monitoring quality control results of the exam evaluation methods

Wang Qinghua,Chen Danqing,Huang Weifeng

DOI: https://doi.org/10.3969/j.issn.1007-0370.2012.03.046

2012-01-01

Abstract:Environmental monitoring system,using standard appraisal is commonly used means of quality control samples of the unit or subordinate unit.Using standard samples to ensure that the value range and robust assessment and evaluation results of two methods of Z-score method,combined with case work,the difference of the two evaluation results were compared.
Application Of Embedded System Of Data Sampling To Quality Control

Jj Yin,W Jiang,Zh Yu,Zt Wu

2002-01-01

Abstract:The theory and technology of embedded system of data sampling based on industrial Ethernet is studied according to quality control during manufacturing, Grads criteria of dynamic measuring is advanced. At the same time, the theory and model of Network SPC based industries Intranet, strategy of SPC and CEWMA control chart are researched.
Practical Skills for Statistical Analysis of Medical Quality Control Data with the Software EXCEL

DU De-jie,SHEN Ping,XIE Qin,LI Nai-di,ZHU Li,ZHANG Wei-hong

DOI: https://doi.org/10.3969/j.issn.1008-8199.2012.03.020

2012-01-01

Abstract:This article introduces several practical skills for statistical analysis of medical quality control data with the software EXCEL,which can greatly improve efficiency,reduce errors,highlight key aspects in medical quality management,and yield twice as much accomplishment with half the effort.
Implementation in P. R. China of Computer Aided SPC Using MS EXCEL 2000

刘继颖,秦现生,Xiutian Yan

DOI: https://doi.org/10.3969/j.issn.1000-2758.2002.02.010

2002-01-01

Xibei Gongye Daxue Xuebao/Journal of Northwestern Polytechnical University

Abstract:The microsoft EXCEL 2000 software is superior to other softwares used for implementing CA-SPC. The structure of CA-SPC system, its workflow three key techniques in its implementation: data preparing, scrollable viewing and zooming, and database accessing were proposed. It can monitor the manufacturing process with a control chart, and it is effective in analyzing quality conditions and carrying out office automation of the whole system.
Application of Excel for Data Processing in the Engineering Practice of Wet Dedusting and Desulfurization

SONG Jian-fei,LIU Chun-hua,JIANG Chao-hui,WANG Qiong,LIU Zhi-hua

DOI: https://doi.org/10.3969/j.issn.1673-9140.2006.02.025

2006-01-01

Abstract:Experimental data in the engineering practice of wet dedusting and desulfurization was processed,and relations among all the factors were found by fast calculation and optimization of Excel,which could solve the complex calculation and optimization problem.Practicability and validity were proved by examples.
Application of Statistical Process Control in Engineering Quality Management

Jinmeng Li

DOI: https://doi.org/10.1088/1755-1315/831/1/012073

2021-08-01

IOP Conference Series: Earth and Environmental Science

Abstract:Abstract The control of the statistical process is to apply statistical techniques to monitor each stage of the production process and to achieve the purpose of improving and ensuring the quality of the product. The basic element of quality control is the control chart. Control chart is a statistical tool to control product quality in the production process, and is the most important method in quality control. Statistical process control is widely used in the quality management of energy, environment, chemical engineering and other fields, and plays a vital role in improving the process and product quality in related fields.
Application of Computer to Quality Control of Abnormal Samples in Geochemical Exporation

Liu Xiao

2003-01-01

Abstract:A computer program for searching abnormal points in analysis of geochemical exploration samples has been developed. The program can help quality administrators to search for abnormally high values of samples in a certain region and therefore provide the geological mining with precise chemical analytical data.
Application of Microsoft Excel on Chemical Engineering Experiment "Measurement of Constant Pressure Filtration Parameter"

Pan Lisha,Zhang Dela,Sun Zhongliang,Wang Xiaohong,Zhang Yongming,Liu Jian

DOI: https://doi.org/10.3969/j.issn.1000-6168.2008.02.028

2008-01-01

Abstract:Method of using Microsoft Excel 2007 to deal with data of Chemical Engineering Experiment "Measurement of Constant Pressure Filtration Parameter" is introduced.The method is simple,quick and credible.
Application of Microsoft Excel: A simple and convenient tool for data analysis in medical research

Xie Hong,Zhou Ming,Dang Shaonong,Xiao Shengbin,Zeng Lingxia,Kang Yijun,Yan Hong

DOI: https://doi.org/10.3969/j.issn.1004-5287.2005.06.026

2005-01-01

Abstract:In this paper we presented statistical analysis on data from Medical Statistics,the textbook designated by the Ministry of Public Health,by using the module of data processing in Microsoft Excel XP(2003) software in order to illustrate the merits of this data-processing module for its convenience and speediness in learning and application in medical science.
Application of Statistical Process Control in Improving Manufacture Data Quality

GUO Hong-qi,WANG Chun-feng

DOI: https://doi.org/10.3969/j.issn.1001-2265.2007.10.030

2007-01-01

Abstract:Many data will product in the manufacture process,which affects the data using validity.Based on the key processes of the data production and the statistical process control,the data quality controlling system is established,which included the data quality property diagnose,analysis and control.At last the application example is described.The paper provides basic theory and application reference to improve manufacture quality systematically and thoroughly.
The Application on Data Processing of the Regression Analysis Function of Excel

Qiong Xu

2001-01-01

Abstract:It is presented that how to use regression analysis function for processing data. The mathematics relation about a great deal resistance values that were measured in different temperature to corresponding temperature was analyzed. It concluded that the regression error is very little,and it satisfies the demand of the common engineering analysis.
The Application of Excel Software in the Teaching Course of Probability and Mathematical Statistics

ZHANG Xue-feng,ZHANG Jin-xi,WU Yue-jian,WANG Si-han

DOI: https://doi.org/10.3969/j.issn.1001-5337.2013.04.025

2013-01-01

Abstract:The application of Excel software is introduced.The course characteristics of probability and mathematical statistics is stated.The usage method of statistical analysis database is disscussed.By emphasizing how to solve practical problem,the course reform practice and teaching thought are deeply considered.The issue of how to develop the teaching reform with Excel software is addressed.Excel data analysis function is introduced into the classroom teaching.The course reform and the trend of development are investigated.The paper can promote the application of computer simulation in specific teaching practice.
Research on Design and Analysis Techniques for Surface Water Quality Monitoring Information Management

Qiongyao Zhu,Guangxin Zhang,Pingjie Huang

DOI: https://doi.org/10.1109/icetce.2012.598

2012-01-01

Abstract:Combined with the design and development of a surface water quality monitoring information management system, the water quality monitoring information management requirements and water quality data items and data structures are analyzed. The framework of the database construction is presented and the concept design and logical architecture design are introduced. The titling formats and content regulations are investigated. Under the surroundings of Oracle and VB.Net, the front end and back end system are developed. The key functions of the system including water quality query and management and monitoring factors information query are introduced. Furthermore, the concept of the Rough Sets is introduced, and water quality information completion and uniformities, attribute reduction and rule induction algorithms are investigated based on the Rough Sets model. Thus the data analysis and early-warning functions are established. The operation performance of the system shows that it can wholly meet the needs of the water quality monitoring and management.
Excel Application in Mining Geological Work

Jiao Jian,Sun Wen-jie,Cui Zheng-jun

DOI: https://doi.org/10.3969/j.issn.1005-2801.2009.06.052

2009-01-01

Abstract:Excel is one of the American Microsoft suit Office softwares,which is convenient and practical.With strong function,it can deal with various data,and have accurate computation.The application of Excel in calculation of parameters for mine outflow rate and estimation of coal reserves can improve the work efficiency and solve practical problems.
Applications of Excel in the Tray Hydrodynamics and Tray Efficiency Experiments

雷志刚,陈标华,李成岳

DOI: https://doi.org/10.3969/j.issn.1001-4160.2002.06.029

2002-01-01

Abstract:In the experiment of tray hydrodynamics and tray efficiency, the variants involved are generally many and the calculating expressions are complicated. The experimental data of tray hydrodynamics and tray efficiency is conveniently dealt with by the Excel software to timely e-valuate the experiment.
Application of Excel in Optimum Planning of Discharge Ports

Ming-de XU,Wei-bin CHENG

DOI: https://doi.org/10.3969/j.issn.1003-6504.2007.07.022

IF: 11.4

2007-01-01

Environmental Science & Technology

Abstract:Based on Solver macro provided by Microsoft Excel,a program of discharge port optimization planning(DPOPMS) was developed including several major parts as multi-river BOD-DO coupling matrix model,automatically creating of Spreadsheets model,optimization planning of discharge ports by invoking Excel Solver and result display.The program was used for pollution control plan of Taiyuan urban section of Fen River,with results in accordance with the actual fact.
Application of Excel in Web Environment Based on Java Technology

LI Shao-jun,XIA Hong-xia,ZHAN Qin

DOI: https://doi.org/10.3969/j.issn.1673-629x.2005.07.037

2005-01-01

Abstract:The application of Excel in Web environment based on Java technology is introduced, with the technology of JavaBean. The method can be used to transfer the data or report forms on Web to Excel, thus we can conveniently modify the data in Excel and print the report forms. It also describes the principle of the method, and the critical technology with an example. The purpose of this paper is to combine Excel with Java technology.
The application of data mining on the process quality control

Shaoxiong Wu,Wei Xu,Biying Wu

2006-01-01

Abstract:With the development of computer and network technology, automation on production and inspection results in the accumulation of a large amount of data for an enterprise. The data as well as its information is an immense treasure. This paper introduces data mining process on quality control and discusses the application of data mining on the process quality control.
The Application of Excel in Probability and Statistics of Middle School Mathematics

Zhezhi JIN,Zhaoling LI

DOI: https://doi.org/10.3969/j.issn.1674-6813.2014.05.073

2014-01-01

Abstract:With the development of information technology, the introduction of secondary mathematics education is particularly important application of information technology.In the study of probability and statistics of middle school mathematics, the understanding of probability starts from the angle of random. Random numbers generated by Excellcan replace the results of repeated random experiences, making the relationship between the frequency and probability more easily to be understood. And Excellalso can calculate probability events, it is much simpler than the conventional calculation. Excellalso can carry out descriptive statistical analysis, sampling and regression fitting operation on data. Coupled with its practical mapping function, Excellhas wide application space in the field of mathematics statistics and probability of middle school.
APPLYING AND COMPARING TO ORIGIN AND EXCEL IN TREATING DATA OF THE PHYSICS EXPERIMENT

Xu Chengwei,Wang Haiyan

DOI: https://doi.org/10.3969/j.issn.1007-2934.2007.04.020

2007-01-01

Abstract:This paper introduces the method how to treat the data of physics experiment by using Origin and Excel software,and compares Origin with Excel.

The Application of Excel in Quality Control of Environmental Monitoring

Two environmental monitoring quality control results of the exam evaluation methods

Application Of Embedded System Of Data Sampling To Quality Control

Practical Skills for Statistical Analysis of Medical Quality Control Data with the Software EXCEL

Implementation in P. R. China of Computer Aided SPC Using MS EXCEL 2000

Application of Excel for Data Processing in the Engineering Practice of Wet Dedusting and Desulfurization

Application of Statistical Process Control in Engineering Quality Management

Application of Computer to Quality Control of Abnormal Samples in Geochemical Exporation

Application of Microsoft Excel on Chemical Engineering Experiment "Measurement of Constant Pressure Filtration Parameter"

Application of Microsoft Excel: A simple and convenient tool for data analysis in medical research

Application of Statistical Process Control in Improving Manufacture Data Quality

The Application on Data Processing of the Regression Analysis Function of Excel

The Application of Excel Software in the Teaching Course of Probability and Mathematical Statistics

Research on Design and Analysis Techniques for Surface Water Quality Monitoring Information Management

Excel Application in Mining Geological Work

Applications of Excel in the Tray Hydrodynamics and Tray Efficiency Experiments

Application of Excel in Optimum Planning of Discharge Ports

Application of Excel in Web Environment Based on Java Technology

The application of data mining on the process quality control

The Application of Excel in Probability and Statistics of Middle School Mathematics

APPLYING AND COMPARING TO ORIGIN AND EXCEL IN TREATING DATA OF THE PHYSICS EXPERIMENT