Excel Data Analysis in the application of medical statistics.docVIP

 PAGE \* MERGEFORMAT 5 Excel Data Analysis in the application of medical statistics [Keywords:] Excel; medical statistics; data analysis In scientific research, data collection, analysis and statistical processing, the need to use medical statistics package. Now commonly used statistical packages have excellent medical SAS, SPSS, etc.. Most of these software with powerful data management capabilities, and comprehensive statistical methods, high-precision calculations, as well as a unique multi-platform adaptive technology and powerful. However, the use of these software is relatively complex and difficult to apply without going through training, freely give full play to the role of the software. Excel is a Microsoft developed a feature strong electronic form processing system, which in addition have the general form of software functionality, including word processing, database management and graphics processing capabilities, but also provides a statistical and engineering analysis, decision-making support the analytical tools [1]. In our medical data processing, the most commonly used are mostly to do some simple statistical description or analysis of variance, t test and regression analysis, etc. [2], for such statistical analysis, we can use Excel ‘Data Analysis ‘tools to complete. 1 Excel add-in ‘data analysis’ tool First, start Excel, click the Tools menu in the ‘add’ option, the dialog box that appears select ‘Analysis ToolPak’, determine the installation, in the menu bar of the ‘tool’ will appear under the ‘Data Analysis’ election items. Two statistical description of data using Excel Excel can be used for statistical description of data, including: (1) of central tendency (concentration index), which includes the arithmetic mean, median, geometric mean, mode and so on. Excel provides a ready-made formulas and built-in functions to allow the calculation of these indicators. Such as the first input a set of figures, and then built into the formula =