Abstract—Objective: In the practical activities of physical education, we often collect numerous data, how to fully exploit more valuable information that are hidden among the large amounts of data, we will need to choose reasonable method of data processings, that will be providesd the basis for scientific judgment and analysis. Method: Based on the introducing of the sports statistics processing need statistics, parameters and its classification, analyzes the type of sports statistical data and processing requirements, The authors analyses sports statistics data types and processing requirements from statistical properties and mathematical statistics group neede. Result: The authors describes Excel methodology for sports statistical processing from the four aspects of data analysis: “the function method”, “the chart function equations to obtain statistics and functions”, “pivot tables and perspective”, and “Analysis Tool Pak”. Conclusion: Although Excel has not been grouped into statistical software, as long as we take the actual practise into consideration, fully tap the power of Excel statistical functions, improve methodology system of sports statistics data in Excel, enhance data exchange with other statistical software to realize resource sharing, further study and research Excel software development, we can achieve maximum results with little.

Index Terms—Excel, sports data, statistical processing, methodology system.

Shiwei Zhang is with the Dept. of Physical Education, Laiwu Vocational and Technical College, Laiwu, Shandong, China, 271100 (e-mail:lwzsw@yahoo.com.cn, lwzyzsw@163.com, tel.: + 86-015563419160; fax:+86-0634-6268137).
Zuocan Wang is with the Dept. of Physical Education, Linyi University,Linyi, Shandong, China, 276005.
Cheng Liu is with the Dept. of Educational Administration, Laiwu Vocational and Technical College, Laiwu, China, 271100.

Cite: Shiwei Zhang, Zuocan Wang, and Cheng Liu, "Study on the Methodology System of Sports Statistics Datain Excel," International Journal of Computer and Communication Engineering vol. 1, no. 1, pp. 16-18 , 2012.