by Soumyadip Pal | Jul 28, 2020

What-If is a function built in to Microsoft Excel to compute answers to “what if” questions, exactly as the name suggests! A business would be faced many such “what if” questions – “What if we need to earn a profit of Rs. 10000,...
by Soumyadip Pal | May 5, 2019

Quartiles are a frequently used method to split the data and understand the spread. In general, data can be divided in various groupings such that an equal number of points are in each group. Such groups are formed by cutting at specific points called quantiles. If...
by Soumyadip Pal | Apr 3, 2017

Previously, we have seen situations where an outcome (the dependent variable) is based on a single input variable (independent variable). Sadly, real life is rarely as simple. Most outcomes in real situations are affected by multiple input variables. To...
by Soumyadip Pal | Apr 1, 2017

We have talked about regression models in the context of linear regression models in the previous post. A nonlinear regression model is one that describes a nonlinear relationship between the dependent and the independent variables. Naturally, the equation of the...
by Soumyadip Pal | Mar 16, 2017

What is regression? In the dictionary, the word regression basically means ‘to go back’. In terms of statistics too, the meaning is not too different – it means ‘to go back to the past data to explain the process that generates the data’....