- Видео 113
- Просмотров 431 111
Sergio Garcia, PhD
США
Добавлен 10 дек 2015
Expected Return and Residuals
This video describes how to conduct arithmetic and weighted returns in Excel. It also calculated residuals for both.
Просмотров: 102
Видео
Exploratory Data Analysis in R using Diamonds Dataset
Просмотров 3232 месяца назад
This video walks through the Diamonds dataset using Exploratory Data Analysis in a basic and rudimentary manner.
Residuals from Simple Linear Regressions
Просмотров 3648 месяцев назад
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: ruclips.net/video/D8kIu1kjsgE/видео.html Simple Linear Regression: ruclips.net/video/oAoMzvHKeSM/видео.html Interpreting Linear ...
investment projection spreadsheet 2
Просмотров 911Год назад
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: ruclips.net/video/s72852xR74g/видео.html It is built on an annual...
Building out an Investment Projection Spreadsheet
Просмотров 3,3 тыс.Год назад
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
Просмотров 710Год назад
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
Просмотров 313Год назад
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
Просмотров 4212 года назад
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
Просмотров 1632 года назад
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
Просмотров 1892 года назад
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
Просмотров 2182 года назад
Dataset Basics. Variables and Observations. KC Housing Dataset: www.kaggle.com/datasets/shivachandel/kc-house-data
Practice Problem: Difference of Means
Просмотров 1532 года назад
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
Просмотров 5412 года назад
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
Просмотров 43 тыс.2 года назад
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.
Просмотров 3643 года назад
Texas drops mandatory state-wide mask use.
Feb 2021 discussion on vaccination rates
Просмотров 463 года назад
Feb 2021 discussion on vaccination rates
Covid19 cross sectional analysis of US states as of 12/07/2020
Просмотров 1553 года назад
Covid19 cross sectional analysis of US states as of 12/07/2020
Tableau: Two regressions from one dataset
Просмотров 9053 года назад
Tableau: Two regressions from one dataset
Time series and caloric input (and covid19 parallel)
Просмотров 1413 года назад
Time series and caloric input (and covid19 parallel)
Texas, Covid, Thanksgiving and the Anchor Point Bias
Просмотров 2054 года назад
Texas, Covid, Thanksgiving and the Anchor Point Bias
How to report multiple regression models in one table
Просмотров 6 тыс.4 года назад
How to report multiple regression models in one table
stats prof - Building a Scatterplot in Excel
Просмотров 4954 года назад
stats prof - Building a Scatterplot in Excel
Interpreting Linear Regression Results
Просмотров 324 тыс.4 года назад
Interpreting Linear Regression Results
Hypothesis Testing: ANOVAs - single factor
Просмотров 2074 года назад
Hypothesis Testing: ANOVAs - single factor
Practice Problem - Sample Mean - right tail, extreme example
Просмотров 654 года назад
Practice Problem - Sample Mean - right tail, extreme example
nate silver!
If I have more than 1 independent variable, how may I know which factors are the strongest predictors?
❤❤❤❤❤
Great refresher ! Thank you
How to download file?
Finally I got it, Thank you
Thank you, so helpful!
I can't tell you thank you enough!!!! literally gearing up to do my predictive analytics project and this was a lifesaver!!! THANK YOU!!
Hi Sergio, Thanks for your video. How can I put for the extra payment like 1 time in a year, not every month like your demonstration.
All voic3 command labeled as us currency of legal tender private and public safety. Activated sec91406 /00000000.90-4.49 44.86/482.74 1009.00 1450 79.28. 05775DDTME1010 613 edit code thank you GitHub installment GVMedia copyrighted luxury software datalinked company 2001/2109
I'm lost, 11:05 . I thought x is the independant used to predict y, the dependent
yes. this is an error in my video. I have commented on this many times. You are correct. Y is the DEPENDENT. X is the INDEPENENT
This is amazing. One question, however what if I make extra payments of varying amounts on different months. How does work into this scenario?
Observation please: X is considered independent variable while Y is considered dependent variable
yes. this is an error in my video. I have commented on this many times. You are correct. Y is the DEPENDENT. X is the INDEPENENT
How can you edit this so you can make a half payment biweekly?
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.
no argument. but we're also setting up the future transitions into multiple regressions down the road.
Can i use regression analysis for data collected at irregular intervals?
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.
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
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).
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.
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 ?
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