How to Automatically Calculate the Multiple Regression Analysis in Excel using Matrix Algebra Form
Good day and welcome to this wonderful episode of Statistics Video Tutorial. I still remember when I was in School taking up my Degree in Statistics and I terribly missed the traditional method of teaching wherein my professor was trying to teach how to calculate or compute Statistical Test without the use of a Computer Software. I am very much thankful that I was able to experience this way of teaching because I was able to understand the concept, rationale and how the formula was derived. Because of the utilization of Computer Software, there are other steps and procedures which often neglected and set-aside. In a Machine Learning Model such as Multiple Regression, it is a must to understand the behavior and pattern of the data before performing the modelling part. One should test the assumptions involved in a Machine Learning Model. If any of the assumptions is/are violated, it is predominantly important to address the violation, to fix the violated assumptions and once it...