To download the file used in today's video, visit the article at: www.mrexcel.com/excel-tips/place-people-on-bell-curve/
@OzduSoleilDATA
6 жыл бұрын
Very nice! I've never used the NORM functions. This was good to see.
@MrXL
6 жыл бұрын
Thank you Excel On Fire. The NORM functions are cool.
@jamesperry3837
6 жыл бұрын
Thank you Mr. Excel. That's a load of valuable teaching info. Tbh this is the first bell curve vid I'm looking at.
@MrXL
6 жыл бұрын
Thank you James Perry. I never realized Bell Curves where so popular. But a recent look at my KZitem stats showed that my most-watched video was the one on how to create a bell curve. It always surprises me which videos take off in popularity.
@dasrotrad
6 жыл бұрын
Thank you again for a great and practical presentation.
@MrXL
6 жыл бұрын
Thank you robert cline. I am glad to hear the video was helpful.
@DougHExcel
6 жыл бұрын
Thanks for the statistics video!
@MrXL
6 жыл бұрын
Thank you Doug H. I appreciate your continued viewership!
@simfinso858
6 жыл бұрын
Amazing Mr .Excel Thanks.
@MrXL
6 жыл бұрын
Thank you sandeep kalyankar. In the original video, I use Mean Plus/Minus 3 Standard Deviations because that covers 99+% of the normal distribution. (Confession: I only mildly paid attention in statistics class. So I learned to use Mean + 3 times StDev, but I can't fully explain why you do this.)
@barttitulaerexcelbart9400
6 жыл бұрын
Hello Bill: if someone don't use the normal distribution often, I recommend using two columns one with the TRUE and one with the FALSE argument. Then make 2 graphs and you will understand better. As for the video well explained but I have (as often ha ha) some suggestions: remove the Y value axes: this has no meaning: chart-junk. To the names I would add the cumulative percentage (the other column I just refered to), then the graph makes sense: so Name, x% means : x% of the population has a lower value than Name. But actually the average and the stdev. should come from the population, not from the sample. In that case this graph makes real sense. Greetings, Bart
@MrXL
6 жыл бұрын
Bart Titulaer thanks Bart
@Adam_K_W
5 жыл бұрын
I'm looking for an elegant way to plot a budgetary dollar value for a project over a period of variable months into a bell curve as a spend curve. As an example, I want to spend a $1,000,000 over a period of 14 months, and plot the spend in a bell curve automatically, but also allow for adjusting the number of months as the project progresses. I've gotten close but I can't figure out how to lock the plot down into the variable months. I'll need to do the same with Front Loaded, Back Loaded and S-Curves (I have an S-Curve solution, but I'm curious what your take on that might be)
@unisoft5956
6 жыл бұрын
Nice
@MrXL
6 жыл бұрын
Thank you sartaj alam. I am glad to hear the video was helpful.
@omtek3921
Жыл бұрын
How do you fix Excel not responding?
@calilthomas
4 жыл бұрын
The way used to get average and STD deviation is incorrect. These must be calculated from the original source, not from the average on the pivot.
Пікірлер: 18