AN MS EXCEL TOOL FOR PARAMETER ESTIMATION BY MULTIVARIATE NONLINEAR REGRESSION IN ENVIRONMENTAL ENGINEERING EDUCATION


DEMİR S., KARADENİZ A., CİVELEK YÖRÜKLÜ H., MANAV DEMİR N.

SIGMA JOURNAL OF ENGINEERING AND NATURAL SCIENCES-SIGMA MUHENDISLIK VE FEN BILIMLERI DERGISI, cilt.35, sa.2, ss.265-273, 2017 (ESCI) identifier

  • Yayın Türü: Makale / Tam Makale
  • Cilt numarası: 35 Sayı: 2
  • Basım Tarihi: 2017
  • Dergi Adı: SIGMA JOURNAL OF ENGINEERING AND NATURAL SCIENCES-SIGMA MUHENDISLIK VE FEN BILIMLERI DERGISI
  • Derginin Tarandığı İndeksler: Emerging Sources Citation Index (ESCI), Academic Search Premier, Directory of Open Access Journals
  • Sayfa Sayıları: ss.265-273
  • Anahtar Kelimeler: Environmental modeling, optimization, multivariate nonlinear regression, MS Excel, WATER DISTRIBUTION NETWORKS, SOURCE APPORTIONMENT, MARINE ENGINEERS, PRESSURE-DROP, OPTIMIZATION, SIMULATION, SYSTEMS, MATLAB, MODEL
  • Yıldız Teknik Üniversitesi Adresli: Evet

Özet

This paper presents the implementation of an MS Excel tool for parameter optimization in environmental engineering education. Visual Basic for Applications v7.0 were used for implementation of the program. A number of test cases were also provided to test the performance of the tool including the fields of air pollution control, water treatment, and anaerobic treatment. For each test case, calculated coefficients of determination were 0.98 and above. Results suggested that the MS Excel tool produces satisfactorily fast and reliable results, and can be used confidently for optimization works in environmental studies.