How to Create Bell Curve in Excel

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

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

  • @ianhnizdo4787
    @ianhnizdo4787 4 года назад +3

    OHHH since its not evenly distributed it won't look smooth! THANK YOU SO MUCH FOR THE EXAMPLE WITH THE STUDENTS! I've been racking my brain trying to find an answer for the graph I had.

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

    excellent teacher, very clear

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

    Why do I get #num after pressing down

  • @TheNemesis442
    @TheNemesis442 5 лет назад +7

    thank you for going over the practical bell curve at the end of the video, I kept getting something similar to what you had in the practical example and thought that because it didn't look like the bell curve that you had in the first example that I was doing something wrong.

    • @stephenjackson5628
      @stephenjackson5628 5 лет назад +2

      They are doing something wrong. They are related the data back to the number of markers instead of the grades. If you look, the x axis should be from 30 to 100, but it's from 0-30.

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

      @@stephenjackson5628 Thanks Stephen for your feedback. The x-axis shows the count of data points in the bell curve. In our example, there were 27 data points, hence the x-Axis is showing from 0-30.
      Do let me know in case of further clarification.

    • @thebusinessguruji8198
      @thebusinessguruji8198  5 лет назад +2

      Thanks TheNemesis. The smoothness of the bell curve depends on the smoothness of the data. If we have perfectly distributed data (like in our first example), then we can get the smooth curve. In all practical cases, we will get a somewhat distorted curve (like in second example).
      Hope this clarifies.

  • @yasirt.m2455
    @yasirt.m2455 3 года назад

    great... thanks

  • @sammngi
    @sammngi 5 лет назад +4

    Thanks alot for your tutorial, very simple and easy to understand. Be blessed

  • @cuevas8405
    @cuevas8405 4 года назад +1

    But what about the student numbers? It's like saying that student 10 suddenly got a score from 80 to 75

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

    Thanks bro..GOD BLESS YOU🎉

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

    What did you click after coping the normal distribution ?

  • @ladybug5335
    @ladybug5335 3 года назад +1

    My f4 button is not working. Is there another way i could freeze the mean ang standard deviation

    • @shabrabradford3566
      @shabrabradford3566 3 года назад +1

      F4 didn't work for me either. I have to press function (fn) and F4 together.

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

    nice... thank you..!!!

  • @tmp1442
    @tmp1442 5 лет назад +2

    what did you click after selecting the data in order to get the std devation ?

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

      Hello Mohammed. I pressed enter. Please retry and let me know in case of any challenges.

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

    keeps saying too few arguments.... im screwed

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

    my normal distribution is showing a log graph... help...

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

    how do you smooth the bell curve in your example to be like your first example?

  • @pakaymastarichkul7521
    @pakaymastarichkul7521 3 года назад +1

    Great!!

  • @chadeee16
    @chadeee16 2 года назад +3

    my curve is not belling lol lol

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

    thank you so much guruji your a genius

  • @anilamoloo4663
    @anilamoloo4663 3 года назад

    why you used standard deviation for sample for marks

  • @vigisbigtm
    @vigisbigtm 5 лет назад +4

    This is the best tutorial I found. Keep up the good work. Great going!

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

    how is this done for a two tailed t-test?

  • @mohitgu123456
    @mohitgu123456 4 года назад +3

    Truly great effort and I still have few questions.
    Q1. Area , SD, %age and values significance?
    Q2. How are we using Mean and SD in Bell curve ( I believe Mean should be peak of this curve a line in between and SD the gap between intervals on X Axis. Need more on this.
    Q3. NormDist is plotted on Y Axis....But what does it give to me? What is its significance?
    Q4. What is the usage of this Curve/ Bad and Good Curve?

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

    Thank you

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

    Thank you, sir

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

    fantastic!

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

    Obrigada

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

    Thank you it was very helpful.

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

    Please Sir, on EViews how can we do a forecast by distribution?

  • @nikitadsouza4731
    @nikitadsouza4731 3 года назад

    Thanks, this was helpful

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

    Amazing presentation

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 3 года назад

    Fantastic explanation...keep it up

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

    Thank you so much ...

  • @rakeshthakur-nd5sk
    @rakeshthakur-nd5sk 4 года назад

    Nice Video

  • @lukechalk6214
    @lukechalk6214 3 года назад

    i love u

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

    Using the FALSE function might lead students (e.g., me) into thinking these normal distribution values are the actual probabilities (or you might also call it "areas") of getting data less than or equal to the raw data that corresponds to a z-score. I hope you could explain this more thoroughly. Still, thanks for the video!

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

    1:50

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

    how to freeze the cell

  • @mahijeet5852
    @mahijeet5852 3 года назад

    how do i work if the data is values? instead of numbers , i have two columns with dates and sales value