I wrote about regression equation using algebraic method in my previous post Linear Regression. Now, I’ll show you how to compute it using LibreOffice Calc.
Choose your data set. I’m choosing same data set I used in my previous post. You may check if my algebraic method computation is correct or wrong!
Choose variable 1, which is our X.
Here is how we choose Variable 1
Here is how we choose Variable 2, which is our Y.
Choose the output cell, where you want LibreOffice to write the output.
Finally these are what we selected.
And, here is the output. You may check the slope and intercept value with my previous post 🙂
See you in another interesting post.