Year 2017, Volume 2, Issue 2, Pages 91 - 100 2017-10-09

A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models

Didem Tetik Küçükelçi [1] , Atıf Evren [2]

219 600

In this study we have tried to compare the results obtained by Microsoft Excel Solver program with those of NCSS and SPSS in some nonlinear regression models. We fit some nonlinear models to data present in http//itl.nist.gov/div898/strd/nls/nls_main.shtml by the three packages. Although EXCEL did not succeed as well as the other packages, we conclude that Microsoft Excel Solver provides us a cheaper and a more interactive way of studying nonlinear models.
Non-Linear Regression, SPSS, NCSS
  • [1] Bates, D.M., Watts, D.G., Nonlinear Regression Analysis and Its Applications, New York, John Wiley&Sons, (1988).
  • [2] Bevington,P.R., Robinson,D.K., “Data Reduction and Error Analysis for the Physical Sciences”, McGraw Hill, Third edition, (2003) 148-151.
  • [3] Billo, E.J., EXCEL for Scientists and Engineers Numerical Methods,Wiley- Interscience, John Wiley&Sons, (2007).
  • [4] De Levie, R., Advanced Excel for Scientific Data Analysis, Oxford University Press, (2004).
  • [5] Huet,S., Bouvier,A., Gruet,M., Jolivet,E., Statistical Tools for Nonlinear Regression: A Practical Guide with S-Plus Examples, Springer-Verlag, New York, Springer Series in Statistics, (1996).
  • [6] Motulsky, H., Christopoulos, A., Fitting Models to Biological Data Using Linear and Nonlinear Regression: A Practical Guide to Curve Fitting, USA, Oxford University Press, (2004).
  • [7] Neter J., Wasserman W., Kutner M. H., “Applied Linear Statistical Models”, Second edition,Illinois, Richard D. Irwin. (1985). 466-490.
  • [8] Ross, G.J.S., Nonlinear Estimation, Springer Series in Statistics , Springer-Verlag, (1990).
  • [9] Seber G.A.F., WILD C.J., “Nonlinear Regression”, USA, John Wiley&Sons., (1989) 91-102.
  • [10] http//itl.nist.gov/div898/strd/nls/nls_main.shtml
Primary Language en
Subjects Engineering
Journal Section Research Article
Authors

Author: Didem Tetik Küçükelçi
Country: Turkey


Author: Atıf Evren
Country: Turkey


Bibtex @research article { jetas336853, journal = {Journal of Engineering Technology and Applied Sciences}, issn = {}, eissn = {2548-0391}, address = {Muhammet KURULAY}, year = {2017}, volume = {2}, pages = {91 - 100}, doi = {10.30931/jetas.336853}, title = {A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models}, key = {cite}, author = {Tetik Küçükelçi, Didem and Evren, Atıf} }
APA Tetik Küçükelçi, D , Evren, A . (2017). A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models. Journal of Engineering Technology and Applied Sciences, 2 (2), 91-100. DOI: 10.30931/jetas.336853
MLA Tetik Küçükelçi, D , Evren, A . "A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models". Journal of Engineering Technology and Applied Sciences 2 (2017): 91-100 <http://dergipark.org.tr/jetas/issue/31347/336853?publisher=jetas?publisher=jetas>
Chicago Tetik Küçükelçi, D , Evren, A . "A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models". Journal of Engineering Technology and Applied Sciences 2 (2017): 91-100
RIS TY - JOUR T1 - A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models AU - Didem Tetik Küçükelçi , Atıf Evren Y1 - 2017 PY - 2017 N1 - doi: 10.30931/jetas.336853 DO - 10.30931/jetas.336853 T2 - Journal of Engineering Technology and Applied Sciences JF - Journal JO - JOR SP - 91 EP - 100 VL - 2 IS - 2 SN - -2548-0391 M3 - doi: 10.30931/jetas.336853 UR - https://doi.org/10.30931/jetas.336853 Y2 - 2017 ER -
EndNote %0 Journal of Engineering Technology and Applied Sciences A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models %A Didem Tetik Küçükelçi , Atıf Evren %T A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models %D 2017 %J Journal of Engineering Technology and Applied Sciences %P -2548-0391 %V 2 %N 2 %R doi: 10.30931/jetas.336853 %U 10.30931/jetas.336853
ISNAD Tetik Küçükelçi, Didem , Evren, Atıf . "A Comparison Between Mıcrosoft Excel Solver and Ncss, Spss Routines for Nonlinear Regression Models". Journal of Engineering Technology and Applied Sciences 2 / 2 (October 2017): 91-100. https://doi.org/10.30931/jetas.336853