Hello, this video is great but when I perform the normal distribution function I get different data or N/A. What normal distribution function are you using?
When I do this with my data, for some reason the curve is not symmetrical. The only difference for me is that my bin size is 1, and data is 1000, so I just multiplied by 1000 instead of 5000. The height and location of the curve seems to fit though.. what might I do wrong?
Hello I have another suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
Probably like in Excel: =NORM.INV(RAND(),MEAN,STDEV),1), then just drag down for as many rows of "data" you want (where "MEAN" and "STDEV" is number or an absolute reference to a cell with the number like $A$2 and $B$2 if you have a title called "Mean" in A1 and "Std. Dev." in B1
@@joejekpenyong I'm also confused that part. He mentioned 'scaling' but how should we assume the multiply value (like 1000 or 5000 or 10000) in different data ? Does it depend on decimal values?
@@datapiburma6908 Step 9: Scale the normal distribution curve We need to scale our normal distribution curve so that it’ll show on the same scale as the histogram. Since we have 1,000 values in bins of 5, our scale factor is 5,000. Meaning, when I multiply the normal distribution values by 5,000, they’ll be comparable to the histogram values on the same axis.
A cumulative distribution function plots for the cumulative probability at a certain point x (meaning the probability that a random variable is equal to or less than x), which is not what is sought here. Here, he's trying to find the probability at that particular point x, rather than including the points before it. A cumulative distribution function looks like a stretched S graph, it's always increasing, whereas this graph starts decreasing after the mean/median/mode. Sorry if my response is too technical. I can revise it.
This is the most useful video I have seen in a long time.
That was awesome. I thought I was pretty handy with google sheet but there was easily half a dozen new things I learnt in the last ten minutes.
This helped me so much for creating a histogram for my stats class, thank you so much!
8 years has passed and this video still useful as f*ck
is it bad when my data set is so small that there is no mode?
Hello, this video is great but when I perform the normal distribution function I get different data or N/A. What normal distribution function are you using?
When I do this with my data, for some reason the curve is not symmetrical. The only difference for me is that my bin size is 1, and data is 1000, so I just multiplied by 1000 instead of 5000. The height and location of the curve seems to fit though.. what might I do wrong?
amazing work scaling the Norm.Dist! Lifesaver!!
What’s the difference between normal distribution and histogram method ?
so what is the reason why we need to copy histogram datas?
Hello I have another suggestion, how can we use the google sheet as database function, like having the table of raw data and having a separate bar above the raw data, having the following buttons, start date: 01/01/2020 end date: 02/02/2020 Car Type: Nissan only or Nissan and Toyota. Country: USA. Once I have chosen these filters then reflect in the raw data that I have in the raw one based on the chosen filter. Thanks in advance. You are always make even better than this things way better. There are no videos like that so far.
Why did you multiply by 5000?
this video saved my life
Wow I learned a lot in this video ! Thank you for sharing
perfect and in straight to the point!
What if the data is skewed?
thank you so much, helped me alot in my statistics class :)
How do i do what you did at 4:00 on a windows?
Amazing video . Thanks
Thanks for the video. How do I create random numbers with Sheets that conform to a normal distribution curve?
Probably like in Excel:
=NORM.INV(RAND(),MEAN,STDEV),1), then just drag down for as many rows of "data" you want (where "MEAN" and "STDEV" is number or an absolute reference to a cell with the number like $A$2 and $B$2 if you have a title called "Mean" in A1 and "Std. Dev." in B1
That is the sexiest graph in the world.
Thanks heaps mate. Really helpful
phenomenal guide, thank you
THANK YOU!!
why do you multiply by 5000
He said it's because there's 1000 values multiplied by bin size 5. Still don't get it.
@@joejekpenyong I'm also confused that part. He mentioned 'scaling' but how should we assume the multiply value (like 1000 or 5000 or 10000) in different data ? Does it depend on decimal values?
@@datapiburma6908 Step 9: Scale the normal distribution curve
We need to scale our normal distribution curve so that it’ll show on the same scale as the histogram. Since we have 1,000 values in bins of 5, our scale factor is 5,000. Meaning, when I multiply the normal distribution values by 5,000, they’ll be comparable to the histogram values on the same axis.
Beautiful. #iteachmath #histogram #normal #distribution #Gauss
Nice, very helpful
Great mate!
Thank you!
Epic video :)
Thanks A Lot
thank you
very helpful
Why the cummulative is false !?
Why not true!?
A cumulative distribution function plots for the cumulative probability at a certain point x (meaning the probability that a random variable is equal to or less than x), which is not what is sought here. Here, he's trying to find the probability at that particular point x, rather than including the points before it. A cumulative distribution function looks like a stretched S graph, it's always increasing, whereas this graph starts decreasing after the mean/median/mode. Sorry if my response is too technical. I can revise it.