What is alpha?

Super helpful, beyond helpful. I can get through the chapters but they're not as easy to follow through without getting to see it simulated.

thank you for the explaining, it's clear a lot, but i have question what does mean by a good variable

You hero, thank you for this, I was stressing about how to keep track of this on a ss and you saved the day.

Nice

Hello, Dr. Garcia. I work in a government facility as an accountant of contracts and expenses. The nature of my work requires me to make a record of the contractors' monthly payments. As you know, monthly payments come from different locations, each site has a referral decision, a purchase order is different from the other, and there are fines for the contractors. Can you give us a record of them through Excel ? I would be thankful ❤

Being a simple linear regression, the p value will be the same as the sig F. They are both testing the same null hypothesis (coeff = 0). I don't see how the answer different questions here.

Can i use regression analysis for data collected at irregular intervals?

Wow! You explained this very well. Thank you! I look forward to using this very soon.

Fantastic video. I will try this reverse method.

This is soooo clear!!! thank you so much.

It would be so kind if you saved your Excel file from the video and included it in a link here in the comments for others to play with!

thank you so much i wish u were my teacher humour and education always works with me (life saviour)

Use of tstat?

Just watched your Part 2. Is there a formula to add a percent factor to contributions and withdrawals if you want to increase those to keep up with inflation? i.e. 1st year contribution $300 per month, 2nd year contribution $309 per month and so on. The same thing with withdrawals, if you want that to increase by 3 or 4% each year.

THANK YOU SO MUCH ,BUT I GET LOST ON SIGN WHY WOULD YOU SAY TS SMALL YET WE HAVE 2.33 MORE BIG THAN 0.01

thank you!!

Best video I've seen on this topic. Thanks! Love how you broke it down in to answering the 4 core questions and how to answer them

thank you

Thank you very much Sir

Hi, thanks. I have a large dataset of 100,000+ points. How does this affect the linear regression analysis? I got a very large F, an extremely small p value, and a small R^2.

Hii, I have done my data analysis and the p value for the model as a whole is not significant, but one of the independent variable is significant. Can I still report it's results ?

THAAAAAANK YOU..JUST ABOUT TO DO MY EXAMS

Such a perfect video ,thank you so much.

You are amazing! Thank you.

Hi Sergio! How would you adjust the spreadsheet to calculate a one time additional payment or a additional payments at different times? Someone may want to add additional payments but not every month. Can this be modified?

I thought the coefficient have to be between 1 and 0, my results are pretty similar to yours with high coefficients and I was confused?

Which pen do you use

Thank you !!!

Hi Sergio. I loved being able to build my own calculator. I learned so much in this small video alone. Would you be able to direct me on how to make the payments come out accelerated biweekly? Also, I make an extra payment monthly but also make additional payments through the year. Any ideas how I could set that up? I love to watch the principal go down and it gives me incentive to make more payments against the principal. Thank you again!

I read the reading material for school, but you explained it in a way that made much more sense. Thank you so much!

wonderful explanation, bravo

I thought "Y" was the dependent varibale?

I finally understood this topic , thank you

This is the best video on explaining significance. Learned so much from this!

you taught in this Vedio more than I learned in my whole semester. Thank you very much for upload this Vedio

If x variables are inputs, shouldn't those be independent variables? Since the output (y) depends on x variables?

How cool is that?!

I finally understand i have been struggling to understand this topic

So helpful, this video is so amazing

If you added an extra column to show principal amount would that mess up your spreadsheet?

Nice job, thank you. So sad that the price inputs and mortgage rates are now so incredibly high. Would make me laugh at your comments if I weren't crying.

Hi Sergio, great video and I have replicated with a few additional features (interest saved and months saved) that work when the loan is set to max term but then fail when it's reduced. I've tried all I can to fix but it's beyond me. Are you able to offer any assistance ?

Great video and instruction! Really learned a lot! Thanks!

Thanks Sergio, I studied this years ago during my Degree but it got rusty for not using it. Now with your tutorial I remember it even better than then and I think this is one of the most detailed tutorials here! Most of them don't talk about the Alfa coeficient or not going on depth like you did. Thanks again!

Very helpful!

Thank you for helping us with your knowledge and experience

Thanks prof <3

Hi. Good review. I have a mortgage calculation that I need to solve. I would like a formula to calculate the net Present Value of the interest payment stream (so a payment that declines each montg for the term of the loan). I need it to calculate bank prepayment penalties. Any ideas?

Sir... Share something on Conjoint Analysis