Histograms and Normal Distribution curves in Google Sheets

[@NathanAdams]

This is the most useful video I have seen in a long time.

[@JoshPeak]

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.

[@haleywilt1230]

This helped me so much for creating a histogram for my stats class, thank you so much!

[@gabrieldossantos3195]

8 years has passed and this video still useful as f*ck

[@irenereolid2776]

this video saved my life

[@clementn3034]

Wow I learned a lot in this video ! Thank you for sharing

[@captainobvious208]

thank you so much, helped me alot in my statistics class :)

[@ThisOne-pv1ws]

amazing work scaling the Norm.Dist! Lifesaver!!

[@INTERX3]

perfect and in straight to the point!

[@derjagerhalt3281]

is it bad when my data set is so small that there is no mode?

[@aymansaid1253]

That is the sexiest graph in the world.

[@shanehatcher5093]

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?

[@fishinglover1828]

Thanks heaps mate. Really helpful

[@harryhwang9353]

so what is the reason why we need to copy histogram datas?

[@agnivachakraborty719]

Amazing video . Thanks

[@joejekpenyong]

Why did you multiply by 5000?

[@avyagarg3980]

What’s the difference between normal distribution and histogram method ?

[@kirenotnat]

How do i do what you did at 4:00 on a windows?

[@patriziomurdocca4528]

phenomenal guide, thank you

[@findthetruth3021]

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.

[@Luggruff]

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?

[@Brian_youk]

THANK YOU!!

[@Sara-kz3bs]

What if the data is skewed?

[@twentysix37]

Nice, very helpful

[@haashim-ali]

Epic video :)

[@jotagustavo]

Great mate!

[@seanosgood8332]

Thank you!

[@debajyotimajumder2656]

thank you

[@lio9432]

Thanks A Lot

[@g4sacademyinternational]

very helpful

[@evanrushton1]

Beautiful. #iteachmath #histogram #normal #distribution #Gauss

[@djryanashton]

Thanks for the video. How do I create random numbers with Sheets that conform to a normal distribution curve?

[@Luggruff]

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

[@ramiuspruiss9561]

why do you multiply by 5000

[@joejekpenyong]

He said it's because there's 1000 values multiplied by bin size 5. Still don't get it.

[@datapiburma6908]

@@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?

[@dgn9505]

@@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.

[@mahikoushikreddy8928]

Why the cummulative is false !? Why not true!?

[@joejekpenyong]

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.