Statistics is a science that collects, sorts out, generalizes, describes and analyzes data materials by scientific methods, and stops inference and decision-making on this basis. Statistics in a narrow sense refers to data or some numbers obtained from data. From the definition of statistics, we can see that the key of statistics lies in the analysis and processing of data, and Excel's powerful data analysis function is just in line with the problems to be dealt with in statistics, so it has been widely used in statistics since its birth, and various macros specially developed for statistical analysis make Excel a suitable and efficient tool in statistical analysis. Although SPSS, SAS and other professional statistical software have more powerful statistical analysis functions in some aspects, they need professional programming or are expensive, so the promotion is far less than Excel. Take Excel 2003 as an example to introduce its typical application in statistics.

1. Database statistical functions and pivot tables

As a spreadsheet software, the data structure of Excel is centered on cells and cell areas, so Excel, like database software, manages and processes a batch of regular data. Based on the row and column structure of Excel, according to the standardized database standard, the data is stopped in the worksheet, which is also called the internal database technology of Excel. After the Excel internal database is created, the statistical analysis of data can be completed through database functions.

1. 1 database statistics function

On the basis of establishing an internal database, Excel specially contains a set of worksheet functions to stop statistical operations on data stored in a data list or database. These functions are collectively called database functions, that is, DFFunctions. Among them, each function generally corresponds to three parameters: database, field and condition, and corresponds to the worksheet area used by the function. Applying these functions can stop some basic statistical operations in daily statistical work.

Data functions have the same syntax format: data functions (database, field, standard). These include:

(1) ①Dfunctions are the titles of database functions, and there are 12 database functions in Excel;

② Database is a cell area that constitutes a data list and a database. A database is a list containing a set of related data, including behavior records of related information, and columns containing data are fields. The first line of the list contains the flag item of each column, which is the data column or field used by the function. The data columns in the data list should be located in the first row and have marked items;

③ Fields can be text, that is, sign items with quotation marks at both ends, such as Category and Consumer, or the position of data columns in the data list, such as 1 in the first column and "2" in the second column. Fields can also be omitted, and then the function will return all the qualified values in the data list;

④ A condition is a set of cell areas containing a given condition. You can specify any range for the parameter standard, as long as it contains at least one column flag and one cell under the column flag for setting conditions.

Closing words:

Execl is 100% paper net in statistics /article.asp? ID=32772 Paper web has many applications, such as probability scatter plot, sampling deviation, parameter estimation, hypothesis testing, regression analysis and prediction, time series analysis and so on. Its powerful statistical function can meet the needs of data analysis in economy, medicine, climate, agriculture and other fields, providing a solid reference for people's analysis and decision-making. With the popularization of Excel version from time to time, its function is becoming more and more perfect, and it has broad application prospects.