Karl Pearson's Correlation Coefficient - Step by Step Calculation - in Excel

Поділитися
Вставка
  • Опубліковано 1 гру 2024

КОМЕНТАРІ • 34

  • @abhishekgupta8934
    @abhishekgupta8934 3 роки тому +1

    this is absolutely what I wanted
    create more video like this please

  • @SuperOpioid
    @SuperOpioid 3 роки тому +3

    When you are calculating small x and small y, what is the dollar sign for in the formula?

    • @RamyaRachel
      @RamyaRachel  3 роки тому +2

      The dollar signs pin down the value... so that when you drag the formula, it takes only that value for calculation.

  • @EdwinNyaoza
    @EdwinNyaoza Місяць тому

    what must i do to predict the y value , if the x value is 37 from your data

  • @shey1146
    @shey1146 3 роки тому +2

    Can you use the Pearson function for this

    • @RamyaRachel
      @RamyaRachel  3 роки тому

      Yes you can. Check out this video: ua-cam.com/video/sPgm9e8pDQM/v-deo.html

    • @shey1146
      @shey1146 3 роки тому

      thank you so much, i had missed the video

    • @RamyaRachel
      @RamyaRachel  3 роки тому

      Glad to help!

  • @mehakbakshi8212
    @mehakbakshi8212 3 роки тому +1

    Greatly explained maam.
    Can you provide me the file of this solved question ?

  • @savitaabarjunagi9266
    @savitaabarjunagi9266 2 роки тому +2

    Tq mam i needed this. Can u please make a vedio on how to find moments for grouped data plzz mam plzz mam

  • @zra__4246
    @zra__4246 Рік тому

    what if our sample size is 360? do i have to use t distribution? or normal?

  • @rumiroy9817
    @rumiroy9817 2 роки тому

    Very helpful video mam thank you so much ❤❤❤

  • @Miss_smiling_brunette
    @Miss_smiling_brunette 3 роки тому +1

    Very helpful 👍

  • @jolenedsouza7907
    @jolenedsouza7907 3 роки тому +1

    superb. thank you

  • @mehakbakshi8212
    @mehakbakshi8212 3 роки тому +1

    Maam, do you have the downloaded excel sheet of this question. It will be of great help. As it isn't clear through the screen.

    • @RamyaRachel
      @RamyaRachel  3 роки тому +1

      I have added a link for the excel file in the description. Hope it helps!

    • @mehakbakshi8212
      @mehakbakshi8212 3 роки тому

      @@RamyaRachel Maam, the file isn't opening. Please send me the solved excel file of this question please. Can i give you my email id?

  • @sanjivniburnwal9485
    @sanjivniburnwal9485 Рік тому

    How did you put x bar and sigma signs correctly

  • @raghavgarg520
    @raghavgarg520 Місяць тому

    ya data analytics k tools m ja kr directly nahi hoga kya mam

  • @ilaila3504
    @ilaila3504 Рік тому

    'pin down the x bar value' sorry what does this mean at 1.27? i can't understand what you are typing in that square

  • @rhajibasadil9504
    @rhajibasadil9504 2 роки тому

    dont forget to pin down the what? sorry i dont understand that part where she was able to get the all tge data at once on the lower case column thanks

    • @RamyaRachel
      @RamyaRachel  2 роки тому

      You just need to insert dollar signs for the average value in the formula so that when you drag it down, the value doesn't change.
      Hope this helps!

  • @shivamdwivedi7723
    @shivamdwivedi7723 2 роки тому

    how to put time interval data on pearson correlation

  • @harsham1816
    @harsham1816 7 місяців тому

    Which method is this?

  • @bibinjacob846
    @bibinjacob846 Рік тому

    Y bar short cut key?

  • @rhajibasadil9504
    @rhajibasadil9504 2 роки тому

    i dont get how he calculated the lower case x as one

  • @jeremyhue4735
    @jeremyhue4735 3 роки тому +1

    helpful

  • @zra__4246
    @zra__4246 Рік тому

    what if our sample size is 360? do i have to use t distribution? or normal?