Numerical Methods with Excel: : Practical Guide for Engineers

Authors

Néstor Humberto Agudelo Díaz
Fundación Universidad de América
https://orcid.org/0000-0003-3614-6995
DOI: https://doi.org/10.29097/9789585303034

Keywords:

Excel, engineering, linear equations, mathematical problems, analytical solution, numerical approximation
Synopsis Chapters Author Biography References Downloads

Synopsis

Numerical methods with Excel: Practical guide for engineers reflects more than ten years of academic and research work at the University of America Foundation. This guide presents a dynamic and interactive course based on the use of the digital computer. It should be noted that the results of the algorithms will be compared, as far as possible, with the values of the analytical solution to establish the error, accuracy, precision, and stability of that method. Most of the models an engineer works on lack an analytical solution, therefore, numerical approximations for problem-solving become relevant. It should also be noted that each algorithm involves numerous arithmetic and logical operations, which require pseudocodes for the student to program in Excel the methods proposed in each chapter. In addition, the text is oriented towards problem-solving since engineering students appropriate learning better if motivated by the solution of models with applications to their interest areas. It also emphasizes a pedagogical methodology in which the algorithm and its demonstration are formulated, and practical examples are proposed and developed clearly and explicitly with tables, figures, and analysis of results.

Chapters

  • Aproximaciones y errores
  • Solución de ecuaciones no lineales de una variable
  • Solución de sistemas de ecuaciones lineales y no lineales
  • Interpolación
  • Derivación, integración y ecuaciones diferenciales
  • Referencias

Downloads

Download data is not yet available.

Author Biography

Néstor Humberto Agudelo Díaz, Fundación Universidad de América

Ingeniero Catastral y Geodesta egresado de la Universidad Distrital Francisco José de Caldas (1989). Magíster en Planeación Urbana y Regional, Pontificia Universidad Javeriana (1993). Especialista en Estadística Aplicada, Fundación Universitaria los Libertadores (2003). Profesor de pregrado y postgrados en varias Universidades de Bogotá,  He participado como autor en objetos virtuales de aprendizaje, para las asignaturas de Muestreo y Diseño Experimental, Probabilidad y Estadística, Estadística Inferencial e Investigación de Operaciones. Más de treinta años de ejercicio docente en áreas de Matemáticas, Estadística, Investigación de Operaciones, Topografía y Cartografía.                            

References

Burden, R., y Faires, J. (2000) Análisis numérico (6.a ed.). Thomson.

Chapra, S., y Canale, R. (2011) Métodos numéricos para ingenieros (6.a ed.). McGraw–Hill.

Kreyszig, E. (2003). Matemáticas avanzadas para ingeniería (3.a ed.). Limusa Wiley.

Nieves, A., y Domínguez, F. (2006). Métodos numéricos aplicados a la ingeniería (2.a ed.). Compañía Editorial Continental.

Downloads

PDF
Published
October 15, 2021
Categories
Copyright (c) 2021 Publicaciones Universidad de América

How to Cite

Agudelo Díaz, N. H. (Ed.). (2021). Numerical Methods with Excel: : Practical Guide for Engineers. Publicaciones Universidad de América. https://doi.org/10.29097/9789585303034