Modelling, Artificial Intelligence and Simulation using Microsoft Excel

, , No Comments
I am beginning to consider myself very lucky to know Excel extremely well. 
Why? It's because all the good books I have on data analysis and predictive analytics teach using Excel. I have been learning the following -

  • Probability theory
  • K-Means clustering
  • K-Median clustering
  • Cosine Similarity
  • Naive Bayes
  • Optimization Modelling
  • Linearizing nonlinear models
  • Linear Regression
  • Nonlinear Regression
  • Network Graph
  • Exponential Smoothing
  • Turkey Fences


Some also touch on implementation on R and I have one that is completely on R, but the ones I found easiest to follow for a non-statistic guy like me use Excel.

I have learned how to build a model that can intelligently classify things into specified categories. I will soon be using it in a long-term work I do for a client. It will save us hours of manual classification of thousands of user feedback.

I have also learned how to break down a business problem into a robust model in Excel that can be used for simulating real business situations/decisions.

I also learned many use cases that are not yet relevant for me now but may be in the future when I meet a client with a special need.

Microsoft Excel is extremely versatile and powerful. I have seen people build complex games with it; games with sound, movement controls and characters. It's more like an enabler, once you can mathematically think out what you want to do, Excel will help you do it.


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.