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 its done, then it is the time that we can start building the model and choosing the best model.

One effect of using Computer Software is the people forget how to compute statistics manually by following the formula guided procedures such as calculating the Sum of Square Regression, Sum of Square Residuals, Mean Square Regression, Mean Square Residuals, F-Ratio, etc. This is one of the main reasons why some of the analysts nowadays don’t understand the behavior of the data if for example, what happened to the R Square if you remove one Independent Variables. Will it go high or go down? If the R Square Change go down because of removing an independent variable, what does it mean? Is it good? Does is affect the accuracy or reliability of the Model?

These are the things that we should consider if we want to build a highly reliable and valid model.

In this Video, I am going to discuss few of the concepts and steps to calculate a Multiple Regression. I will be going to discuss and show how to do Multiple Regression using SPSS, using Microsoft Excel Data Analysis Add-ins, and using the Matrix Algebra Procedures.

As you noticed, it is easy to compute Statistics using Computer Software – SPSS, very straightforward. It is also easy to use the Microsoft Excel Data Analysis Add-ins.

Now, I am going to show you how to calculate Multiple Regression in Excel using Matrix Algebra. Using this Method, I am going to introduce certain key terminology such as Matrices, Inverse Matrix, Transpose Matrix and Vectors. I am also going to introduce certain functions such as Transpose, mmult and minverse. These are the functions we will be using for us to calculate the Slope of the Xs and the Intercept in a Multiple Regression Model.

But before that, we will discuss further about Multiple Regression, Alright

Comments

Post a Comment

Popular posts from this blog

Ways to Correct Errors in Birth Certificate

-
QUESTION: What should we do in order to correct the date of birth of my mother in her birth certificate? ANSWER: There are two ways in correcting dates of birth in one’s certificate of live birth. One is through judicial process by filing a petition for correction of entry before the court in accordance with Rule 108 of the Rules of Court and the other is through administrative process by filing a petition at the Local Civil Registry Office in accordance with Republic Act (R.A.) No.9048 and R.A. No. 10172. If the error in the date of birth of your mother pertains to the day or month of birth only, she may have the same corrected by filing a petition for correction of entry before the Local Civil Registry of the place where her birth certificate is registered. However, if she has migrated to another place within the Philippines and it is not practical for her, in terms of transportation expenses, time and effort to appear before the local civil registry office of her place o
Read more

Mygz Molino [Actor]: Totoong Pangalan, Family, Education, Showbiz Journey, Movie List

-
Image
Mygz Molino  Si Mygz Molino ay nakilala ng husto mula ng makita itong kasama ni Mahal or Noemi Tesorero sa tunay na buhay sa kanilang mga content sa YouTube at maging sa Tiktok . Kinagiliwan ng lahat ang kanilang tambayan at kinakitaan si Mygz Molino ng kakaibang uri ng pag-aalaga kay Mahal na kung mapapansin mo at ng karamihan ay tila may something sa kanilang samahan na hindi lamang tandem sa paggawa ng content, kundi tila higit pa sa pagkakaibigan subalit anng bagay na ito ay tanging si Mygz Molino at Mahal lamang ang nakaka-alam sa tunay nilang ugnayan at relasyon.  Si Mygz Molino o GLEMO sa totoong buhay ay isinilang noong December 10, 1985. Ipinanganak sya Marikina City si Mygyz subalit ang pamilyang Molino ay taga Batangas.  Sila ay apat na magkakapatid at bata pa lamang siya ng mamatay ang kanilang ama. Lingid sa kaalaman ng lahat si Mygz Molino ay nagtapos sa kursong Computer Engineering  kaya hindi naman nito kailangan pang mag-artista o maging YouTuber kung tutuusin da
Read more

COMIDA CRAVINGS FOOD SHOP

-
Image
  The Comida Cravings Special and Signature Food Products which cannot be Resist and Ignore: Variety of Foods That Could Satisfy a Hungry Stomach   Comida Cravings was born to supply foods products for a hungry stomach. Comida Cravings was run by Etech International Online Shop - The first and only digital online business in the Philippines. Etech International is committed to provide easiness, seamless, fastest, and cost-effective delivery of products and services without compromising the quality, reliability and affordability of its products and services.    The Survival Strategies during the Global Pandemic Outbreak are now being handled seriously not only by the consumers, but also business and enterprises. This critical situation in our history is reshaping the business landscape because the mobility restrictions imposed around the world is diving consumers to embrace online transactions and collaborations. With this changes, everyone was expected to communicate in the onlin
Read more