Aplicarea Metodelor Numerice de Interpolare a Funcţiilor în Microsoft Excel

Abstract

Interpolation has a very large application in practice. For example: planning schedule of an activity, generating movement of a body in the plan or space, processing of graphical information for neglecting some shades of color, that are hardly recognized by human’s eyes etc. The problem that is described in this document is application of numerical methods of interpolation in order to determinate the unknown values in Microsoft Excel. The reason of study consists in researching of numerical methods of polynomial interpolation and development teaching guide of interpolation of functions in Microsoft Excel. The numerical methods of function of interpolation are investigated. Applications are presented of several polynomial interpolation such as: Lagrange and Newton in case of arbitrary or equidistant nodes and Gauss, Sterling in case of equidistant symmetrical nodes. The way of polynomial interpolation in Microsoft Excel is described step by step. These algorithms are presented in Microsoft Excel, and also practical examples that are solved with analyzed results.