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.
maybe...but the words irregular intervals suggest you are running a time series analysis and that requires a different set of assumptions. The results of a simple linear regression may be misleading for that type of analysis, which is not to say that it sounds like you may have a lack of data as well.
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.
You may be confusing the actual statistic with the P-value here. I am assuming that you are looking a classic back of the textbook table here. Consider what it is that you are getting out of the table and do not confuse the tstat (on the axis) with the pvalue (area under the curve).
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.
This can be tricky....you need to talk to your stats person directly. Sometimes when you have a very large number of observations, everything is significant. You'll want to talk to someone directly about your work and get better guidance.
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 ?
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?
yeah, people keep asking this question..I'll have to find some time to come up with a mechanism to make that happen. It's difficult to throw in a one-time deal..maybe just go to that time period and type it in.?....for now at least...
There are other methodologies where that is true, like a logistic regression. You may also be confusing coefficients with traditional probabilities......(emoji with guy shrugging his shoulders here).
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!
@sergiogarciaphd7142 Thank you for confirming. Your videos helped me pass my finals. I didn't forget this one since I had to dig. Worth it. Great videos!
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 ?
not off the top of my head, I'd have to see how you built it. You can always go the long route and construct some in between variables..like count one and then count the other and then subtract them. It's a bit of an elementary solution, but as my python coding buddy says, "Let the computer do the heavy lifting, noone ever sees the code." lol.
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!
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?
