Sergio Garcia, PhD
Sergio Garcia, PhD
  • Видео 113
  • Просмотров 431 111
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.
Levels of Measurement and Examples
Просмотров 762 года назад
Levels of Measurement and Examples
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
How to read a T-dist Table
Просмотров 1744 года назад
How to read a T-dist 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
Xbar Chart
Просмотров 934 года назад
Xbar Chart
Zscore and Normal Distribution
Просмотров 974 года назад
Zscore and Normal Distribution
Hypothesis Testing ANOVAs
Просмотров 1534 года назад
Hypothesis Testing ANOVAs

Комментарии

  • @BradleyFowler-d8y
    @BradleyFowler-d8y 14 часов назад

    nate silver!

  • @M89-f4o
    @M89-f4o 3 дня назад

    If I have more than 1 independent variable, how may I know which factors are the strongest predictors?

  • @kaikinkaoyang
    @kaikinkaoyang 4 дня назад

    ❤❤❤❤❤

  • @ntorrente
    @ntorrente 4 дня назад

    Great refresher ! Thank you

  • @bhavneshparikh8283
    @bhavneshparikh8283 12 дней назад

    How to download file?

  • @sedarathnadcd
    @sedarathnadcd 13 дней назад

    Finally I got it, Thank you

  • @LilySteinbach
    @LilySteinbach 26 дней назад

    Thank you, so helpful!

  • @Bruhmaster20084
    @Bruhmaster20084 29 дней назад

    I can't tell you thank you enough!!!! literally gearing up to do my predictive analytics project and this was a lifesaver!!! THANK YOU!!

  • @std3041
    @std3041 Месяц назад

    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.

  • @Formadvpart2BillionaireGuillen
    @Formadvpart2BillionaireGuillen Месяц назад

    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

  • @SoundBenda-ug1bz
    @SoundBenda-ug1bz Месяц назад

    I'm lost, 11:05 . I thought x is the independant used to predict y, the dependent

    • @sergiogarcia9044
      @sergiogarcia9044 Месяц назад

      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

  • @CheriseWilliams-kx7ks
    @CheriseWilliams-kx7ks Месяц назад

    This is amazing. One question, however what if I make extra payments of varying amounts on different months. How does work into this scenario?

  • @victoressieneyo
    @victoressieneyo Месяц назад

    Observation please: X is considered independent variable while Y is considered dependent variable

    • @sergiogarcia9044
      @sergiogarcia9044 Месяц назад

      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

  • @DavidThompson-jz7ue
    @DavidThompson-jz7ue Месяц назад

    How can you edit this so you can make a half payment biweekly?

  • @deepansarvan355
    @deepansarvan355 2 месяца назад

    What is alpha?

  • @jesuschristo5071
    @jesuschristo5071 2 месяца назад

    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.

  • @wassimwoof9485
    @wassimwoof9485 2 месяца назад

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

  • @tyx3513
    @tyx3513 2 месяца назад

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

  • @astepoutsidethecamp
    @astepoutsidethecamp 2 месяца назад

    Nice

  • @mohammedissaq7832
    @mohammedissaq7832 3 месяца назад

    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 ❤

  • @TomasTeitelbaum
    @TomasTeitelbaum 3 месяца назад

    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.

    • @sergiogarcia9044
      @sergiogarcia9044 2 месяца назад

      no argument. but we're also setting up the future transitions into multiple regressions down the road.

  • @TR-rx5ej
    @TR-rx5ej 3 месяца назад

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

    • @sergiogarcia9044
      @sergiogarcia9044 2 месяца назад

      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.

  • @monicabouteiller8482
    @monicabouteiller8482 3 месяца назад

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

  • @SystemsProjectEngineer
    @SystemsProjectEngineer 3 месяца назад

    Fantastic video. I will try this reverse method.

  • @zishanahmed1461
    @zishanahmed1461 3 месяца назад

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

  • @marcolsen5179
    @marcolsen5179 3 месяца назад

    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!

  • @mariemmouakher457
    @mariemmouakher457 4 месяца назад

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

  • @nikitasingh5271
    @nikitasingh5271 4 месяца назад

    Use of tstat?

  • @HerbShoufler
    @HerbShoufler 4 месяца назад

    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.

  • @munirumutebi5805
    @munirumutebi5805 4 месяца назад

    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

    • @sergiogarcia9044
      @sergiogarcia9044 2 месяца назад

      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).

  • @tathianaarones380
    @tathianaarones380 5 месяцев назад

    thank you!!

  • @roylam3083
    @roylam3083 5 месяцев назад

    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

  • @mithonaphal
    @mithonaphal 5 месяцев назад

    thank you

  • @tadarjamja2721
    @tadarjamja2721 6 месяцев назад

    Thank you very much Sir

  • @LA-cm9uo
    @LA-cm9uo 7 месяцев назад

    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.

    • @sergiogarcia9044
      @sergiogarcia9044 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.

  • @evelynfurtado1240
    @evelynfurtado1240 7 месяцев назад

    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 ?

  • @estherwanjohi1411
    @estherwanjohi1411 7 месяцев назад

    THAAAAAANK YOU..JUST ABOUT TO DO MY EXAMS

  • @aayushshukla342
    @aayushshukla342 7 месяцев назад

    Such a perfect video ,thank you so much.

  • @Sindibad007
    @Sindibad007 7 месяцев назад

    You are amazing! Thank you.

  • @justTanyaM
    @justTanyaM 7 месяцев назад

    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?

    • @sergiogarciaphd7142
      @sergiogarciaphd7142 6 месяцев назад

      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...

  • @niamhbeattie4759
    @niamhbeattie4759 8 месяцев назад

    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?

    • @sergiogarciaphd7142
      @sergiogarciaphd7142 8 месяцев назад

      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).

  • @cmartcinematography
    @cmartcinematography 8 месяцев назад

    Which pen do you use

  • @Gigi-qv8qp
    @Gigi-qv8qp 9 месяцев назад

    Thank you !!!

  • @cindywalsh424
    @cindywalsh424 9 месяцев назад

    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
      @sergiogarciaphd7142 8 месяцев назад

      This is a great idea...I'll put this video on my list and let you know. Thank you.

  • @tom_fors
    @tom_fors 9 месяцев назад

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

  • @DelilahLutengano
    @DelilahLutengano 9 месяцев назад

    wonderful explanation, bravo

  • @kaltiny1997
    @kaltiny1997 10 месяцев назад

    I thought "Y" was the dependent varibale?

    • @sergiogarciaphd7142
      @sergiogarciaphd7142 8 месяцев назад

      It is. (facepalm emoji) that one flub will be with me for eternity...

  • @Sexifries
    @Sexifries 11 месяцев назад

    I finally understood this topic , thank you

  • @MichaelMooreboston
    @MichaelMooreboston 11 месяцев назад

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

  • @yuviydv00
    @yuviydv00 11 месяцев назад

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