- 111
- 383 417
Sergio Garcia, PhD
United States
Registrace 10. 12. 2015
Residuals from Simple Linear Regressions
How we get residuals after running a linear regression. I use a smaller version of the dataset found at: www.kaggle.com/datasets/shivachandel/kc-house-data.
For a better explanation on how to run and interpret linear regression, check these out:
Basic Linear Modeling: czcams.com/video/D8kIu1kjsgE/video.html
Simple Linear Regression: czcams.com/video/oAoMzvHKeSM/video.html
Interpreting Linear Regression: czcams.com/video/rLkysIyO7-U/video.html
For a better explanation on how to run and interpret linear regression, check these out:
Basic Linear Modeling: czcams.com/video/D8kIu1kjsgE/video.html
Simple Linear Regression: czcams.com/video/oAoMzvHKeSM/video.html
Interpreting Linear Regression: czcams.com/video/rLkysIyO7-U/video.html
zhlédnutí: 200
Video
investment projection spreadsheet 2
zhlédnutí 397Před 7 měsíci
This video is Part 2 of "Building out an Investment Projection Spreadsheet. It includes an additional couple of features that may make the decision making process easier for you in the end. The original video will show you how to build out a rudimentary spreadsheet to help estimate future investment forecasts. It can be found at: czcams.com/video/s72852xR74g/video.html It is built on an annual ...
Building out an Investment Projection Spreadsheet
zhlédnutí 1,2KPřed 7 měsíci
This video will show you how to build out a rudimentary spreadsheet to help estimate future investment forecasts. It is built on an annual (year-by-year) basis and should not be used for precise forecasts. The idea is to build out a first model and then you can do whatever you want with it later. This is a rough Future Value (FV) calculation model and will be imprecise given our violation of ba...
Diamond Data and Storytelling
zhlédnutí 435Před rokem
This video takes a quick look at the very popular diamond dataset and discusses how we might walk through an exploratory process to extract a 'story' from the data. We want to look at a piece of data and have it tell us what is going on and to do that, we have to dig in a little and get our hands dirty. This is one example of how to go about that process.
Basic linear modeling in Excel
zhlédnutí 292Před rokem
This is a fairly basic intro to linear modeling in Excel. Pay attention to the direction that the information on the right side (the INDEPENDENT X variable) has on the left side (DEPENDENT Y variable). We are using the right side to predict the left.
5 step Exploratory Dataset Process
zhlédnutí 270Před rokem
Very similar to other videos. The exploratory process is messy and sometimes ill defined. That said, there are some basic steps that can help you walk through the data so that it makes more sense before moving on to more sophisticated methodologies.
Exploratory Dataset Process
zhlédnutí 149Před rokem
This is a fast and short run through of how I perform basic exploratory work on a dataset. Checking for missing data, outliers and walking through basic descriptive statistics to ensure that we can move forward with more sophisticated methodologies. data from: www.kaggle.com/datasets/shivachandel/kc-house-data
Datasets: Exploratory Techniques
zhlédnutí 155Před rokem
This is a short and basic process to explore your datsets. Exploratory Datset Techniques is a basic place to start when you first look at data in order to understand the underlying characteristics of the dataset and try to figure out what the data 'looks' like in order to do more advanced analysis. KC Housing Dataset: www.kaggle.com/datasets/shivachandel/kc-house-data
Dataset Basics
zhlédnutí 189Před rokem
Dataset Basics. Variables and Observations. KC Housing Dataset: www.kaggle.com/datasets/shivachandel/kc-house-data
Practice Problem: Difference of Means
zhlédnutí 139Před rokem
This video describes a practice problem for a difference of means. It is a direct application on how to do a difference of means test using Excel. This video does not include the lecture explaining the problem nor does it cover the use of alpha as a means to test the P-value. It focuses specifically on getting the problem done. direct application.
Two Sample T-Test (Bivariate) - Sales Training Example
zhlédnutí 402Před rokem
This video describes how to conduct a Two-Sample T-test using a sales training scenario. In this case, we are using a two-tail example testing the question: Is there a difference between salespeople if they have taken the sales training? Note that since this is a two-tail test, we only care about whether or not the two groups (trained or untrained) are different. We are not asking the question:...
Building a Mortgage Calculator in Excel with Amortization Table
zhlédnutí 33KPřed 2 lety
In this video, we're going to build a rudimentary Mortgage Amortization Table for you to practice your Excel skills as well as have a powerful tool to use in your home purchase decision-making process.
Texas drops mandatory state-wide mask use.
zhlédnutí 361Před 3 lety
In this video, I describe the Texas specific Covid19 forecasts in three different scenarios to try and discuss what Austin might be thinking regarding the change in statewide policy vis-a-vis mandatory masks.
Feb 2021 discussion on vaccination rates
zhlédnutí 46Před 3 lety
Feb 2021 discussion on vaccination rates
Covid19 cross sectional analysis of US states as of 12/07/2020
zhlédnutí 154Před 3 lety
Covid19 cross sectional analysis of US states as of 12/07/2020
Tableau: Two regressions from one dataset
zhlédnutí 716Před 3 lety
Tableau: Two regressions from one dataset
Time series and caloric input (and covid19 parallel)
zhlédnutí 130Před 3 lety
Time series and caloric input (and covid19 parallel)
Texas, Covid, Thanksgiving and the Anchor Point Bias
zhlédnutí 201Před 3 lety
Texas, Covid, Thanksgiving and the Anchor Point Bias
How to report multiple regression models in one table
zhlédnutí 5KPřed 3 lety
How to report multiple regression models in one table
stats prof - Building a Scatterplot in Excel
zhlédnutí 461Před 3 lety
stats prof - Building a Scatterplot in Excel
Interpreting Linear Regression Results
zhlédnutí 295KPřed 3 lety
Interpreting Linear Regression Results
Hypothesis Testing: ANOVAs - single factor
zhlédnutí 195Před 3 lety
Hypothesis Testing: ANOVAs - single factor
Practice Problem - Sample Mean - right tail, extreme example
zhlédnutí 64Před 3 lety
Practice Problem - Sample Mean - right tail, extreme example
Hypothesis Testing: 2 populations- small samples and unknown sigmas
zhlédnutí 225Před 3 lety
Hypothesis Testing: 2 populations- small samples and unknown sigmas
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?
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...
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?
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).
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!
This is a great idea...I'll put this video on my list and let you know. Thank you.
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?
It is. (facepalm emoji) that one flub will be with me for eternity...
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?
yes. you are correct. That is my mistake and it keeps me humble as more and more people watch (and correct) the video.
@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!
How cool is that?!
It's the COOLEST!!
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?
not at all..run it as you wish...just add the additional column and plug in your principal calculation..and then leave it alone..
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.
I would love to see this also as I want to include the interest and months saved.@@sergiogarciaphd7142
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!
thanks for the comment. I appreciate it.
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
Super Explanation... Amazing
Hi, thanks for the video. Is there a way to show the trend/regression line for the entire dataset (i.e., the first one you showed) at the same time as the subsetted ones (i.e., the second and third you showed)? I am trying to show a comparison of my entire dataset to a specific subset...
This video should be removed. He does not analyze all the results. Skips over many options in regressing. Dumb I hate CZcams
hi sir, i really need your help. what if i got 0.00000 significant F? is that a good or bad sign? i mean.. it's too good? is it even possible? thankyou!!
Excellent explanation. Thank you.
Sir how can I calculate y=mx+b equation
Amazing video. I can see the light at the end of the tunnel 😅 Clearly explained. Thank you so much!
Hello brother! Can you help me for regression data ?
Excellent and straight to the point. THANK YOU!
Thank you! Well Explained!
this was an amzing video saved a student today thankyou
Is the extra payment going to the principal only?
That is a great question. yes. In this case, the interest gets assessed monthly, so anything over that interest payment goes to the principal. You'd have to modify this spreadsheet if you wanted extra payments to go to future payments.
Wow this helped me so much with my data analytics major project. Thank!
Sir thank you for your clear demonstration just got a question, if I am right the video is doing a single-tail test, if I am doing a two-tail test is it the same way to accept or reject the H0 by comparing the p-value of the coefficient with the significance level(i.e. 5%)?
The Ftest by definition is a one tail test. You can't do a two tail test in a regression. Technically, it is the same process when testing the pvalue, but it is a different distribution.
@@sergiogarciaphd7142 Thank you for the reply sir but I still wonder why a two-tail test cannot be carried out in a regression and also what distribution are you referring to? I apologise if the question is unnecessary, but I would greatly appreciate it if I can hear further explanation from you.
Do you have something that includes escrow payments calculations?
I do not, but maybe I can do a part 2 for this video later and include that. I have done it for clients int he past, just do additional columns and keep them the same. Maybe use an input at the top and fill it in from there.
What if you don't make extra payments every month. How will you set up a formula for that?
Simply cut it out or make it zero. No big deal.