excel重点（Excel重点）.docVIP

excel重点（Excel重点） 1. data preparation process: in data analysis, statistical analysis of the data before the audit, the original data collected on the task of encoding, input, conversion and cleaning, make systematic and orderly, so that the next data statistical analysis can be carried out smoothly and get satisfactory results. 2., the data preparation process consists of four steps: data review, data encoding, data entry and data cleaning. 3. data review is an analysts process of reviewing and verifying raw data collected to eliminate errors and data that do not meet the requirements, thereby improving the quality of data. 4. data encoding refers to the process of assigning different codes to different answers 5. data entry means to input data into the computer and prepare for the statistical analysis of the data 6. data cleaning is to check and process data before statistical analysis so as to avoid erroneous data entering the operation process 7. data audit: audit data is the first step in data preparation, it is related to data quality problems, implement standard and strict audit data can improve the accuracy and completeness of the data, so it can greatly improve the quality of the data, a solid foundation for the next work lay. 8., the main content of data audit four aspects: A, consistency audit, B, integrity of the audit C, the questionnaire whether there is a certain pattern of audit D, the unqualified questionnaire for processing 9. data encoding: the purpose is to translate the information contained in the questionnaire into symbols that can be identified by the computer 10. data cleaning: refers to the system analysis before the data to check and deal with, in order to avoid the wrong data for the operation process. 11. data cleaning mainly has the following aspects: A, missing value processing, B, overflow value processing, C, consistency checking The 12. frequency distribution function FREQUENCY is one of the Excel statistical worksheet functions, whi