Open Access Open Access  Restricted Access Subscription or Fee Access

Statistical Study of Melting Point for Cephalosporin Derivatives

Rajendra Sharma, Pratibha Sharma, Rajeev Sharma


Computational chemistry has been proving helpful in research and development. There are many methods which are employed in computational chemistry. QSAR/QSPR is one of the best tools out of them. QSPR follows vast number of statistical methods for developing model. Present paper emphasizes on use of Microsoft Excel software for developing statistical model for melting point of series of compounds belonging to class of cephalosporin antibiotic compounds. For development of statistical model or regression equation step wise, multiple regressions through forward selection were followed. As non-dependent variable/structural representative various topological, quantum mechanical, geometrical indices were calculated through suitable software and employed. For calculation of indices the 2D and 3D structures of molecules were prepared by Chemsketch software. Developed regression equation can be used to modify any one molecule of selected series or molecule belonging to cephalosporin class of molecule to gain required value of melting point. However, during modification of particular molecule a different MLR equation/model was derived (in terms of LD50) and hence considered for controlling or minimizing toxicity

Keywords: QSPR, melting point, Microsoft excel, Pearson’s correlation, 3D-MoRSE, Weiner
index, sum of Keir-hall topological state

Full Text:



Harary F. Graph Theory. AddisonWseley

Publication. 1998; 1–115p.

Balban AT, Ivanciuc O. Topological

Indices and Related Descriptors in

QSAR and QSPR. Gorden and Breach

Publication, Amsterdam. 1999; 59–


Hofmann P. In: Solid State Physics-An

Introduction. Wiley-VCH. 2008. 3-24p

Brown RJC, Brown RFC. Journal of

Chemical Education. 2000; 77(6):


Hofmann P. In: Solid State Physics-An

Introduction. Wiley-VCH. 2008. 45-


Lipnick RL, Cotruvo JA, Hill RN,

Bruce RD, Stitzel KA,

Walker AP, Chu I., Goddard M, Food

and chemical TOXICOLOGY, 1995;

(3), 223–31 P

ACDLAB product. ACD/ChemSketch,

version 12.0, for Microsoft.

Todeschini R, Consonni V. In:

Software for Calculation of Molecular

Descriptor. DRAGON Evaluation

verson 5.5, Talete srl, Milano

Chemometrics Italy, 2007.

Drake PP. In: Online Notes on

Regression Step-by-Step using

Microsoft Excel. James Madison

University. Accessed on 20 Oct 2012;


Sharma RK, Sikarwar A, Sharma R, et

al. Prediction of Median Lethal Dose

by QSAR method with their

Applications. International Research

Journal of Engineering and

Technology. Jun 2015; 2(3): 994–



  • There are currently no refbacks.