Excel Normal Distribution Calculations

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

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

  • @peerbr7849
    @peerbr7849 9 лет назад +3

    Hi Cody, that was awesome. I've been struggling with statistics all my live but am ever curious, and this really gave me a push in the right direction! You've got a great gift of explaining, thank you for making that video.

  • @carlosrmuskusr4468
    @carlosrmuskusr4468 9 лет назад +1

    Cody
    This video is very very useful
    I have a question about a problem that maybe you can explain me the way you show at your video.
    This is about how to find the variable value for which the probability is about a stated value, like this next:
    Which is the value of "t" for a normal distribution N(1,0), mean 0, standard deviation 1, the probability stated is 0,80, the condition is P( -2 t < Z < t )
    I´m a little bit confuse about how to calculate it
    I would appreciate a lot your information
    Thanks in advance

  • @shariaaviles9504
    @shariaaviles9504 7 лет назад

    Thank you for this video. I struggled with this area and you helped me to get through it! Thanks a billion!!!

  • @haledaniels
    @haledaniels 8 лет назад

    Thanks for the video! It really helped. I also shared the link with my Stats class so they could watch too if they were having problems!

  • @naveenjolly5637
    @naveenjolly5637 4 года назад

    Hello Cody, this video was very helpful , do you have a similar video for Poisson distribution

    • @codytabbert
      @codytabbert  4 года назад

      Naveen Jolly I have not. As this was just for an elementary stats course and we don’t cover that topic.

  • @TheMaynn
    @TheMaynn 10 лет назад +1

    Really good tutorials!

  • @maxortiz9075
    @maxortiz9075 9 лет назад +1

    Great explanations! Thanks!

  • @RosaMasLinda
    @RosaMasLinda 10 лет назад +1

    thanks for posting, just what I needed!

  • @cesarbeltran9578
    @cesarbeltran9578 7 лет назад

    Hey Cody, Great video. Do you have a video on creating an excel sheet that you used to complete the calculations?

  • @skhan9277
    @skhan9277 4 года назад

    i'm having trouble understanding the z score and the table. which part of this excel sheet gives us the number from the z table?

  • @bingo111172
    @bingo111172 7 лет назад

    Great Information...thanks!!

  • @intendandinspire
    @intendandinspire 8 лет назад +1

    I am trying to figure out how to plug this into MS excel. Is it possible to do so?
    Assume that a population is normally distributed with a mean of 100 and a standard deviation of 15. Would it be unusual for the mean of a sample of 3 to be 115 or more?

  • @jpol9657
    @jpol9657 10 лет назад +1

    can you show how you made those graphs from d beginning?

  • @triztantraustason7931
    @triztantraustason7931 8 лет назад

    U are really good In exel

  • @gigante87
    @gigante87 9 лет назад +2

    In the norm.dist formula, what does selecting false for the cumulative option mean?

    • @SNPolka56
      @SNPolka56 6 лет назад

      I think selecting false gives you density rather than cumulative distribution.

  • @giovannahurtado3041
    @giovannahurtado3041 5 лет назад

    Thank you!!

  • @triztantraustason7931
    @triztantraustason7931 8 лет назад

    U just got another subscriber

  • @nitinkapoor3225
    @nitinkapoor3225 7 лет назад

    Hi Cody! great video. Can you pls tell me what formula did you use to calculate the "Area" of the "range" (59.8 - 70)? As "Norm.Dist" function doesn't allow to calculate the range!

    • @nitinkapoor3225
      @nitinkapoor3225 7 лет назад +1

      Got it!! :)

    • @DevineDigital
      @DevineDigital 7 лет назад

      You would not want to share how you got it would you? I've been trying to sole a problem for the past 2 hours only because I don't know how to do this in excel.

    • @codytabbert
      @codytabbert  7 лет назад

      you say "got it", but I have no idea what you are talking about. You have to be specific.

    • @DevineDigital
      @DevineDigital 7 лет назад

      Sorry Cody, I wasn't expecting you to to reply, I was replying to Nitin who mention they got how to a range to work with normal distribution.

    • @codytabbert
      @codytabbert  7 лет назад +1

      oh - well just off the top of my head, if you want a range between values.....REMEMBER, that this finds the area to the LEFT of a number. So let's say I want between 6 and 10. I would find the area to the LEFT of 10 then subtract off the area to the LEFT of 6. Leaving the area between 6 and 10. Does that help?

  • @OSSovik
    @OSSovik 9 лет назад +1

    Where can we download this xls file you re using?

    • @codysctc
      @codysctc 9 лет назад +6

      OSSovik You don't. You create it by watching the video! The point is to also learn how to use EXCEL. There would be no learning if I just gave you the document and you clicked a button.

  • @RahShanProductionsMTU
    @RahShanProductionsMTU 8 лет назад

    What is the equivalent on a mac i select norm dist and it doesnt give me the same window as the one you got

  • @lennymiskey6727
    @lennymiskey6727 7 лет назад

    Great Article; Can I CREATE a graph to show the results? (Area between z-scores) Similar to your hand drawn one, but based on the actual data in the chart?

  • @fakhrialam9917
    @fakhrialam9917 8 лет назад

    hi sir, i have daily data of rainfall, if i snd u my data, can u will analyze it for me according to normal distribution in excel...

  • @phucho5702
    @phucho5702 7 лет назад

    thank you so much.

  • @harithsaeed9011
    @harithsaeed9011 10 лет назад +1

    thanks a lot