Volume 9 Number 12 (Dec. 2014)
Home > Archive > 2014 > Volume 9 Number 12 (Dec. 2014) >
JSW 2014 Vol.9(12): 2998-3004 ISSN: 1796-217X
doi: 10.4304/jsw.9.12.2998-3004

A Data Analysis Method and Its Applications in EXCEL

Jinlei Qin1, Yuguang Niu2, 3, and Zheng Li2, 3
1Information and Network Management Center, North China Electric Power University, Baoding, China
2State Key Laboratory of Alternate Electric Power System with Renewable Energy Sources, North China Electric Power University, Beijing, China
3Department of Computer Science and Technology, North China Electric Power University, Baoding, China

Abstract—Data analysis is a quite important process and has been extensively employed in many areas. Especially in statistics, the distribution type test of data often needs to be handled. This paper presents that linear regression as a type of universal method can be applied to the distribution type test. In reliability engineering due to the failure data is commonly of non-linear relationship so that the linear regression method can not be directly employed. This difficulty can be resolved through linear transformation. Aimed for the linearization procedure of four kind of typical distributions, e.g., exponential distribution, normal distribution, logarithmic normal distribution and twoparameter Weibull distribution, their transformations are respectively different. After linearization transformations, correlation coefficients had been used as a criterion to choose the most matched distribution type. This method can be conveniently operated in MS EXCEL. Several samples and experiments illustrated the detailed transformation and the efficiency than other methods.

Index Terms—data analysis, failure data, linear regression, correlation coefficient, distribution type test


Cite: Jinlei Qin,Yuguang Niu, and Zheng Li "A Data Analysis Method and Its Applications in EXCEL," Journal of Software vol. 9, no. 12, pp. 2998-3004, 2014.

General Information

ISSN: 1796-217X (Online)
Frequency: Monthly (2006-2019); Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Dec 06, 2019 News!

    Vol 14, No 1- Vol 14, No 4 has been indexed by EI (Inspec)   [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Jun 22, 2020 News!

    The papers published in Vol 15, No 5 have all received dois from Crossref    [Click]

  • Aug 01, 2018 News!

    [CFP] 2020 the annual meeting of JSW Editorial Board, ICCSM 2020, will be held in Rome, Italy, July 17-19, 2020   [Click]

  • Jun 22, 2020 News!

    Vol 15, No 5 has been published with online version     [Click]