Stats with Gavin
Stats with Gavin
  • 40
  • 16 846
Regression in R with Help from ChatGPT
In this video, I introduce simple and multiple regression in R. I show how chatGPT can do most of the work for us so that everyone can do complicated statistics in R now.
มุมมอง: 529

วีดีโอ

Summer 2022 Course Introduction Video
มุมมอง 1822 ปีที่แล้ว
This video goes over the Canvas page, and how to access the online textbook and homework.
Lecture Video 1.1: Introduction to Course
มุมมอง 2223 ปีที่แล้ว
This video introduces students to the instructor and the resources they'll need to successfully complete QUAN 3610 in Summer 2021.
Homework 3.2 Help Video
มุมมอง 2973 ปีที่แล้ว
This video shows how Excel's Data Analysis Toolpak "Regression" option can be used to estimate a linear relationship between an independent and dependent variable; find the coefficient of determination (R-Square); find the standard error of the regression equation estimate; find the standard error, t-statistic, and p-value of the slope estimate; find the sums of squares; find the F-statistic an...
Homework 2.4 Help
มุมมอง 2633 ปีที่แล้ว
This video uses an example from the homework to explain how to find the minimum sample size necessary to achieve a given power. It shows how use Excel to find a numerical solution to this type of problem.
Section 2.3 Homework Help: Paired/Matched Difference-in-mens test in Excel
มุมมอง 3343 ปีที่แล้ว
This video uses a homework example to show how to do a paired/matched sample difference-in-means hypothesis test in Excel. It shows how to do it using formulas and using the Data Analysis Toolpak.
Video 2.2 HW Help: Hypothesis Tests with Proportions & Calculating the Probability of Type II Errors
มุมมอง 3803 ปีที่แล้ว
This video uses homework examples to show how to do hypothesis tests with proportions in Excel, and how to calculate the probability of Type II Errors in Excel.
Video 2.1 Homework Help
มุมมอง 3393 ปีที่แล้ว
Video 2.1 Homework Help
Lecture Video 1.7: Confidence Interval Application in Excel
มุมมอง 673 ปีที่แล้ว
This video shows three different methods for calculating confidence intervals in Excel using data from CO2 emissions.
Lecture Video 4.2: Multiple Regression in Excel
มุมมอง 2503 ปีที่แล้ว
This video shows how to implement multiple regression in Excel using housing data as an example.
Lecture Video 2.5: Differences-in-proportions/means in Excel.
มุมมอง 1883 ปีที่แล้ว
This video shows students how to implement differences-in-means and proportions hypothesis tests in Excel.
Lecture Video 2.3: P-value Approach
มุมมอง 2693 ปีที่แล้ว
This video explains the p-value approach to hypothesis testing. It also shows how to implement the p-value approach and the critical value approach in Excel.
Lecture Video 4.1: Introduction to Multiple Linear Regression
มุมมอง 1804 ปีที่แล้ว
This video introduces students to the multiple linear regression model. It covers differences in interpretation of estimated slopes and R-square values in the case of multiple linear regression.
Lecture Video 3.4: Hypothesis Testing for Slopes
มุมมอง 1634 ปีที่แล้ว
This video goes over hypothesis testing for slopes estimated using regression. The video shows how to implement these tests in Excel and covers three different types of data sets common in regression.
Lecture Video 3.3: Project Draft
มุมมอง 2774 ปีที่แล้ว
This video goes over the Project Draft Assignment for QUAN 3610.
Lecture Video 3.2: Introduction to Regression
มุมมอง 2114 ปีที่แล้ว
Lecture Video 3.2: Introduction to Regression
Lecture Video 3.1: Algebra Review and Regression Notation
มุมมอง 1584 ปีที่แล้ว
Lecture Video 3.1: Algebra Review and Regression Notation
Section 2 Homework Help
มุมมอง 1554 ปีที่แล้ว
Section 2 Homework Help
Lecture Video 2.4: Intro to difference-in-means/proportions tests
มุมมอง 1994 ปีที่แล้ว
Lecture Video 2.4: Intro to difference-in-means/proportions tests
Lecture Video 2.2: Hypothesis Testing - Critical Value Approach
มุมมอง 2704 ปีที่แล้ว
Lecture Video 2.2: Hypothesis Testing - Critical Value Approach
Lecture Video 2.1: Research questions and setting up hypotheses.
มุมมอง 2234 ปีที่แล้ว
Lecture Video 2.1: Research questions and setting up hypotheses.
Section 1 Homework Help
มุมมอง 1494 ปีที่แล้ว
Section 1 Homework Help
Lecture Video 1.6: Confidence intervals
มุมมอง 2374 ปีที่แล้ว
Lecture Video 1.6: Confidence intervals
Lecture Video 1.5: z-statistics, t-statistics, and probabilities
มุมมอง 2434 ปีที่แล้ว
Lecture Video 1.5: z-statistics, t-statistics, and probabilities
Lecture Video 1.4: The sampling distribution of sample proportions
มุมมอง 1644 ปีที่แล้ว
Lecture Video 1.4: The sampling distribution of sample proportions
Lecture Video 1.3: The sampling distribution of the sample mean
มุมมอง 2374 ปีที่แล้ว
Lecture Video 1.3: The sampling distribution of the sample mean
Lecture Video 1.2: The Logic of Sampling Distributions
มุมมอง 2394 ปีที่แล้ว
Lecture Video 1.2: The Logic of Sampling Distributions
Lecture Video 4.8: Scenario Analysis in Excel
มุมมอง 1664 ปีที่แล้ว
Lecture Video 4.8: Scenario Analysis in Excel
Lecture Video 4.7: Home Price Forecast in Excel
มุมมอง 2.2K4 ปีที่แล้ว
Lecture Video 4.7: Home Price Forecast in Excel
Lecture Video 4.6: More Categorical Variables in Excel
มุมมอง 2654 ปีที่แล้ว
Lecture Video 4.6: More Categorical Variables in Excel

ความคิดเห็น

  • @joycefred6913
    @joycefred6913 3 หลายเดือนก่อน

    Please how do I access these assignmnents

  • @XMEN1113
    @XMEN1113 11 หลายเดือนก่อน

    Great video. Question I couldn't figure out the answer to. Why use time squared as an independent variable? Is that to introduce non linearity in the equation

    • @statswithgavin6297
      @statswithgavin6297 11 หลายเดือนก่อน

      Yes it helps student think about nonlinearity and shows how nonlinearity can be introduced even in a linear regression model. It's also pretty common in quick and dirty forecasts to use squared (and higher terms.) However, over fitting quickly becomes a risk.

    • @XMEN1113
      @XMEN1113 11 หลายเดือนก่อน

      @@statswithgavin6297 you've explained the concepts really well. Thank you 🙏

  • @julianchan8594
    @julianchan8594 ปีที่แล้ว

    Economics is SOOOO sexy! I am definitely going to take this class. I like the course set up with HW and posting homework questions/videos! Also I am super bald and need a nice hat like yours.

  • @jayantiyer9739
    @jayantiyer9739 ปีที่แล้ว

    Thanks! Where can i find these formulas? Any reference/link?

    • @statswithgavin6297
      @statswithgavin6297 ปีที่แล้ว

      We use this book in the statistics class that I teach and you can find them there: www.amazon.com/Statistics-Business-Economics-David-Anderson/dp/1337901067?ref=d6k_applink_bb_dls&dplnkId=65b8466f-2a03-4fa3-acd9-5bee417b0c2c

  • @cblockston
    @cblockston 2 ปีที่แล้ว

    The #1 rule of forecasting is it is NEVER right :) as brought to us by Supply Chain Management 3050

    • @statswithgavin6297
      @statswithgavin6297 2 ปีที่แล้ว

      Small edit required: The #1 rule of forecasting (when forecast is performed by a Supply Chain Manager) is it is NEVER right :) as brought to us by Supply Chain Management 3050

  • @cblockston
    @cblockston 2 ปีที่แล้ว

    Binary variables 🙃

  • @Omaha_Paulie_E
    @Omaha_Paulie_E 2 ปีที่แล้ว

    great vid! say do you have a link for the data from zillow? was trying to replicate your excel spreadsheet and wanted to use the same data.

    • @statswithgavin6297
      @statswithgavin6297 2 ปีที่แล้ว

      You should be able to download the data here: www.zillow.com/research/data/

  • @drewmercs9005
    @drewmercs9005 2 ปีที่แล้ว

    great video !

  • @asssets
    @asssets 2 ปีที่แล้ว

    I just looked up the Tesla IPO year - 2010. Wow, I'm old :)

    • @statswithgavin6297
      @statswithgavin6297 2 ปีที่แล้ว

      No one's getting younger. Except for Musk. He appears to be getting younger...

  • @asssets
    @asssets 2 ปีที่แล้ว

    3:35 Critical value review 6:00 P-value approach in under 6 min 11:50 2 tail test 15:30 Excel magic

  • @asssets
    @asssets 2 ปีที่แล้ว

    1:50 If you know the population mean - Z score 18:40 if you estimate the standard deviation with the sample standard deviation, use t-stat. (fixed) 22:32 Excel formulas to Z score and T-stat 24:10 2 Tail test T-stat

    • @MrGavinomics
      @MrGavinomics 2 ปีที่แล้ว

      18:40 should be "if you estimate the standard deviation with the sample standard deviation, use a t-stat." You could have a problem where a sample mean is given but a population standard deviation is provided/assumed rather than calculating a sample standard deviation.

  • @duanebarrosfonseca
    @duanebarrosfonseca 2 ปีที่แล้ว

    Can I use the same formulas for nonlinear regressions?

  • @iancox7273
    @iancox7273 2 ปีที่แล้ว

    How would you adjust for log-linear regression?

    • @statswithgavin6297
      @statswithgavin6297 2 ปีที่แล้ว

      If it's a log-linear regression with just one independent variable and you are building the intervals around logged predicted values then you don't need to make any adjustments to the method in the video.

    • @iancox7273
      @iancox7273 2 ปีที่แล้ว

      @@statswithgavin6297 Thanks!

  • @ghossein21
    @ghossein21 3 ปีที่แล้ว

    Thank you so much, you explained it so well and in a very easy to understand manner

    • @statswithgavin6297
      @statswithgavin6297 3 ปีที่แล้ว

      You're very welcome. I'm glad it was helpful.

  • @sunrayminor4726
    @sunrayminor4726 3 ปีที่แล้ว

    Splendid, just splendid. Showing the actual statistical formulas applied to Excel and excel formulas with a practical use demonstration . Thank you. Hope to see more.

  • @brianrees2837
    @brianrees2837 3 ปีที่แล้ว

    Gavin you're such a freaking stud.

  • @user-uy7mt7vr6f
    @user-uy7mt7vr6f 3 ปีที่แล้ว

    Helpful lecture! Thank you from Ottawa Canada

  • @huajunxu5816
    @huajunxu5816 3 ปีที่แล้ว

    Thank you so much! It is the most detailed video I have found.

    • @statswithgavin6297
      @statswithgavin6297 3 ปีที่แล้ว

      You're welcome! I'm glad you found it helpful.

  • @maarten4132
    @maarten4132 3 ปีที่แล้ว

    Thx

  • @MangoAndMucho
    @MangoAndMucho 3 ปีที่แล้ว

    What if my independent variables are ordinal variables (likert scale) while my dependent variable is continuous? What type of statistical tool should I use? Can I still proceed with using multiple linear regression?

    • @statswithgavin6297
      @statswithgavin6297 3 ปีที่แล้ว

      You can use ordinary multiple regression but it might lead to biased estimates, so most people would use something else. For example an ordered probit or ordered logit model. This would be very complicated to set up in Excel so I would suggest using different software such as Stata or R if you decided to do that. en.wikipedia.org/wiki/Ordered_probit en.wikipedia.org/wiki/Ordered_logit

    • @MangoAndMucho
      @MangoAndMucho 3 ปีที่แล้ว

      @@statswithgavin6297 I have changed my variables entirely. My independent variable is the respondents' monthly income and my dependent variable is their total expenditure (for the last 12 months). I ran the tests using simple linear regression and pearson correlation and found that they have no correlation or significant relationship at all.. Is there something wrong with my data, my tests, or is that an uncommon result? I dont really know to move forward 😕

    • @statswithgavin6297
      @statswithgavin6297 3 ปีที่แล้ว

      @@MangoAndMucho Standard OLS regression, like used in video, will be a better fit for that data.

  • @Kanixmentor
    @Kanixmentor 3 ปีที่แล้ว

    Thank you very much for such detailed video. It helped me a lot for research article.

    • @statswithgavin6297
      @statswithgavin6297 3 ปีที่แล้ว

      You're welcome, Raja. I'm glad it was helpful.

  • @rikchakraborti2885
    @rikchakraborti2885 4 ปีที่แล้ว

    Good stuff, Dr. Roberts!

  • @katherinehartwig1668
    @katherinehartwig1668 4 ปีที่แล้ว

    How are your students not commenting? LOL

    • @statswithgavin6297
      @statswithgavin6297 4 ปีที่แล้ว

      They probably see this behavior as pretty standard.