RUS  ENG
Full version
JOURNALS // Computing, Telecommunication and Control // Archive

St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Sys, 2016 Issue 3(247), Pages 35–47 (Mi ntitu159)

Simulations of Computer, Telecommunications, Control and Social Systems

Procedures for approximating dependences of several variables in MS Excel and Mathcad software environment

S. A. Gorozhankin, A. A. Shitov, N. V. Savenkov

Donbas National Academy of Civil Engineering and Architecture

Abstract: The article suggests a technique for approximating the original data via continuous smooth functions of several variables when performing the experimental part of a scientific study. The material is based on using such relatively common software like MS Excel and Mathcad, it can be implemented in structurally and functionally similar computer programs, and also provides results of practical application on the example of approximating the characteristics of a modern automobile internal combustion engine via functions of several variables of different kinds. In addition, the paper presents recommendations for rational use of the suggested methods and possible related difficulties in their implementation in the considered software shells. Theoretical material and practical examples of the approximation procedures prepared by the authors aredistinguished by a lot of options, flexibility of application to different types of representation of the original data, as well as the relative ease of use, because they are based on a simple-to-complex basis.

Keywords: approximation, dependent, function of several variables, argument, study, experiment, discrete data, computer program, spline, algorithm.

UDC: 517.4+004.942

DOI: 10.5862/JCSTCS.247.4



© Steklov Math. Inst. of RAS, 2024