Algorithm and EXCEL Application for Data Stepwise Approximation by Solution of the System of Equations Using Gauss Method

Authors

  • S. Polanowski Uniwersytet Morski w Gdyni, Morska 81-87, 81–225 Gdynia, Wydział Mechaniczny, Katedra Siłowni Okrętowych

DOI:

https://doi.org/10.26408/05.11

Keywords:

least squares method, stepwise approximation, polynomial model, Gaussian algorithm, EXCEL application

Abstract

The paper presents the algorithm and the application in Excel of the stepwise least squares data approximation for a polynomial model linear with respect to coefficients. The term approximating polynomial is understood as a generalized polynomial which monomials are any linearly independent functions. The coefficients of the approximating polynomial are determined by the Gaussian method. Specially created information table enables an optimal selection of monomials and building a model step by step, by incorporating the monomials with most decreasing sums of squared deviations. In this table, the sum of squared deviations, extreme deviations and standard deviation values are indicated at each approximation step. This is the basis for making the decision to complete the approximation, as well as the selection of points with excessive deviations.

References

Charchalis, A., Polanowski, S., 2016, Modeling of Torque Characteristics and its Derivative for Ship Propultion System with Fixed Pitch Propellers, Journal of KONES, vol. 23, no. 3.

Efroymson, M.A., Ralston, A., Wilf, H.S. (eds.), 1960, Multiple Regression Analysis. Mathematical Methods for Digital Computers, John Wiley, New York.

Enslein, K., Ralston, A., Wilf, H.S., 1977, Statistical Methods for Digital Computers, John Wiley & Sons, New York.

EXCEL 2016.

Giernalczyk, M., Górski, Z., 2016, Siłownie okrętowe, cz. I, Wydawnictwo Akademii Morskiej w Gdyni, Gdynia.

Hartmann, K., Lezki, E., Schäfer, W., 1974, Statistische Versuchsplanung und-ausvertung in der Stofftwirtschaft, VEB Leipzig.

Polanowski, S., Pawletko, R., 2015, Modelowanie i wyznaczanie charakterystyk mocy układu napędo¬wego statku wypornościowego ze śrubą o stałym skoku, Zeszyty Naukowe Akademii Morskiej w Gdyni, nr 91, s. 122–131.

Stepwise regression, http: en.wikipedia.org.

Published

2018-08-31

How to Cite

Polanowski, S. (2018). Algorithm and EXCEL Application for Data Stepwise Approximation by Solution of the System of Equations Using Gauss Method. Scientific Journal of Gdynia Maritime University, (105), 124–135. https://doi.org/10.26408/05.11

Issue

Section

Articles