Application of Excel 2007 to realize automatic statistical description, frequency distribution table and histogram drawing, normal test and analysis of clinical teaching experiment data.

Make use of Excel functions (COUNT, MIN, MIX, business, STDEV, ROUND, KURT, SKEW, TDIST, the PERCENTILE, the IF, COUNTIF and NORMDIST, etc.) and self-set formulas to conduct common statistical methods and data processing. Histogram of data and normalized probability distribution curve are drawn by clustering histogram and smooth line scatter graph.

The output parameters of statistical description as follows: the number of cases, minimum, maximum, mean, standard deviation, coefficient of variation, range, the number of clusters and groups difference such as common statistical parameters, but also increase the histogram to describe kurtosis, skewness, σgkurtosis, σgskewness and ukurtosis, uskewness, P_kurtosis, P_skewness, judgment, mode, P₂₅ and P₇₅. Frequency table can automatically calculate group, frequency, frequency percentage, cumulative number and cumulative percentage, and make histogram and standardized probability distribution graph.

Excel can replace manual data processing, realize automatic statistical description, frequency distribution table and histograms drawing, normal test analysis. It also simplifies the complicated statistical procedures, improves efficiency and save time and effort. Thus, Excel can meet the rapid and convenient data statistics requirements.