Correlation Analysis In Excel: Correlation and Causation With Example

Поделиться
HTML-код
  • Опубликовано: 1 окт 2024

Комментарии • 14

  • @hafijulshaikh1305
    @hafijulshaikh1305 2 года назад +2

    Very very impressive explanation

    • @learnandapply
      @learnandapply  2 года назад

      Thank you so much for your valuable comments and appreciation 🙏🙏☺

  • @hafijulshaikh1305
    @hafijulshaikh1305 2 года назад +2

    Sir, kindly explain and confirm me that...The word "Effect" is use only in experimental researcher? Can I use the word as "EFFECT OF" in correlational research ? I confused..kindly dee that.

    • @learnandapply
      @learnandapply  2 года назад

      Yes, you can use either of that. It conveys the same meaning. I appreciate your learning approach to such a deeper level.🙏🙏

  • @hendrahendra8356
    @hendrahendra8356 3 месяца назад +1

    Very very good video...thank alot

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

      Thank you so much for your valuable comments and appreciation! 🙏😊

  • @kupetska
    @kupetska Год назад +1

    Thank you for the video. But still i did not get how ti see causation vs correlation from the excel data. Both coefficients are mire then 0,9. Just logically or there some signs that data shows us?

    • @learnandapply
      @learnandapply  Год назад

      Thank you for your valuable comments and appreciation.
      Causation or correlation, you need subject matter expertise to understand that. If there is a cause-and-effect relationship, then it's Causation. Otherwise, it's a correlation.

    • @kupetska
      @kupetska Год назад +1

      @@learnandapply but in your example both sun burn and temperature shows more then 0,9 correlation. If put logic aside, use just excel result, how we know what is the cause?

    • @learnandapply
      @learnandapply  Год назад

      correlation and causation, it is not decided based on the value. Based on the type of relationship.
      Please revisit the video. You need cause and effect relationship for Causation.

  • @dr.kamrankundi9819
    @dr.kamrankundi9819 2 года назад +1

    Dear researchers, I have MSR (meta cognitive self regulation) learning strategy as independent variable while Students' Score (Students'GPA) is my dependent variable. MSR is on five point Likert scale while for Students'GPA each student put his own GPA on the questionnaire in form of digits like 2 , 2.1, 2.7, 2.3, 3, 3.6, 4 etc.
    The students score is in random form.
    Each student put his own score whatever he got in the previous semester. Now my question is which kind of correlation should I use? Can I go for the Pearson correlation? How to handle with the Students'GPA variable? The sample size is 300 students which means that I have 300 Students'GPAs. It's a confusing whether I should consider the Students'GPA as ordinal, interval or ratio variable? Which kind of correlation should I go for?
    Please, guide.

    • @learnandapply
      @learnandapply  2 года назад +1

      Thank you for the detailed description of the scenario. You need to use Logistic Regression Analysis in this case.

  • @krishnakumar-rh2jj
    @krishnakumar-rh2jj 2 года назад +2

    Really superb explanation

    • @learnandapply
      @learnandapply  2 года назад

      Thank you so much for your valuable comments and appreciation 🙏🙏😊