St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Systems
RUS  ENG    JOURNALS   PEOPLE   ORGANISATIONS   CONFERENCES   SEMINARS   VIDEO LIBRARY   PACKAGE AMSBIB  
General information
Latest issue
Archive

Search papers
Search references

RSS
Latest issue
Current issues
Archive issues
What is RSS



Computing, Telecommunication and Control:
Year:
Volume:
Issue:
Page:
Find






Personal entry:
Login:
Password:
Save password
Enter
Forgotten password?
Register


St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Systems, 2016, Issue 3(247), Pages 35–47
DOI: https://doi.org/10.5862/JCSTCS.247.4
(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.
Document Type: Article
UDC: 517.4+004.942
Language: Russian
Citation: S. A. Gorozhankin, A. A. Shitov, N. V. Savenkov, “Procedures for approximating dependences of several variables in MS Excel and Mathcad software environment”, St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Sys, 2016, no. 3(247), 35–47
Citation in format AMSBIB
\Bibitem{GorShiSav16}
\by S.~A.~Gorozhankin, A.~A.~Shitov, N.~V.~Savenkov
\paper Procedures for approximating dependences of several variables in MS Excel and Mathcad software environment
\jour St. Petersburg Polytechnical University Journal. Computer Science. Telecommunication and Control Sys
\yr 2016
\issue 3(247)
\pages 35--47
\mathnet{http://mi.mathnet.ru/ntitu159}
\crossref{https://doi.org/10.5862/JCSTCS.247.4}
Linking options:
  • https://www.mathnet.ru/eng/ntitu159
  • https://www.mathnet.ru/eng/ntitu/y2016/i3/p35
  • Citing articles in Google Scholar: Russian citations, English citations
    Related articles in Google Scholar: Russian articles, English articles
    Computing, Telecommunication and Control
    Statistics & downloads:
    Abstract page:231
    Full-text PDF :140
     
      Contact us:
     Terms of Use  Registration to the website  Logotypes © Steklov Mathematical Institute RAS, 2024