IIT Roorkee · Mathematics & Statistics

EXCELing with Mathematical Modeling

Prof. Sandip Banerjee · 60 free video lectures

Mathematical modeling is an important aspect of the study of science and engineering. Even social sciences involve mathematical modeling. The primary aim of the course is to create an awareness of the concepts involved in mathematical modeling so as to build a solid foundation in the subject. The…

▶ Play on Open Lecture HallCourse page ↗

Lectures

  1. Introduction, Importance and Limitations
  2. Units and Dimensions
  3. Scaling
  4. How to build mathematical models?
  5. Basics of Excel 1
  6. Basics of Excel 2
  7. Basics of Excel 3
  8. Linear, Quadratic, Cubic Models
  9. Linear Stability Analysis-I
  10. Linear Stability Analysis-II
  11. Lyapunov Stability
  12. Phase Plane Analysis 1
  13. Phase Plane Analysis 2
  14. Phase Plane Analysis 3
  15. Growth Models(Continuous model)
  16. Predator-Prey models
  17. Two species competition model
  18. Arms Race Model
  19. Combat Model I
  20. Combat Model II
  21. Carbon Dating
  22. Drug Distribution
  23. Growth and decay in L-R circuit
  24. Rectilinear motion under variable force
  25. Dynamice of Rowing
  26. Horizontal oscillations
  27. Vertical oscillations
  28. Epidemic model 1
  29. Epidemic model 2
  30. Rumor model
  31. Varying Gravity model
  32. Tumor model I
  33. Tumor model II
  34. Vegetation in a desert model
  35. Mathematical model of love affairs
  36. Discrete models: Difference Equation 1
  37. Difference Equations 2
  38. Basics of Excel 4
  39. Stability Analysis I
  40. Stability Analysis II
  41. Population models
  42. Bank Account Models
  43. Economic Model (Harrod Model)
  44. Lake Pollutant Models
  45. Mathematical Model of the Dynamics of Alcohol
  46. Linear Predator-Prey Model
  47. Forsenic Model
  48. Drug Delivery Models
  49. Lanchester's Combat Model
  50. Two-Species Competition Model (Discrete)
  51. Infection model
  52. Smoking Model
  53. Price and Demand Model
  54. Paper towel model, Burning Calories Model
  55. Learning model, Kidney function Model
  56. Empirical Modeling
  57. Estimation of Parameters - I
  58. Estimation of Parameters II
  59. Estimation of Parameters III
  60. Simulation Modeling

From NPTEL (IITs and IISc) · CC BY-NC-SA. More from IIT Roorkee.

Open Lecture Hall is free, with no ads and no sign-up. It is not run by or connected to any university; the lectures are the universities' own free recordings, played from where they host them. About & rights