Study on the Methodology System of Sports Statistics Data in Excel - Volume 1 Number 1 (May 2012) - IJCCE
Volume 1 Number 1 (May 2012)
Home > Archive > 2012 > Volume 1 Number 1 (May 2012) >
IJCCE 2012 Vol.1(1): 16-18 ISSN: 2010-3743
DOI: 10.7763/IJCCE.2012.V1.5

Study on the Methodology System of Sports Statistics Data in Excel

Shiwei Zhang, Zuocan Wang, and Cheng Liu

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.

General Information

ISSN: 2010-3743
Frequency: Quarterly
Editor-in-Chief: Dr. Maode Ma
Abstracting/ Indexing: EI (INSPEC, IET), Google Scholar, Crossref, ProQuest, and Electronic Journals Library
E-mail: ijcce@iap.org
  • Aug 06, 2018 News!

    IJCCE Vol. 5, No. 6 - Vol. 6, No. 2 have been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Jul 30, 2018 News!

     IJCCE Vol.7, No.3 is published with online version!   [Click]

  • May 30, 2018 News!

    IJCCE Vol.7, No.2 is published with online version!   [Click]

  • Nov 07, 2017 News!

    IJCCE Vol. 5, No. 5 has been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Jun 28, 2017 News!

    IJCCE Vol. 5, No. 4 has been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Read more>>