Easier Frequency Distribution With Dynamic Arrays - Episode 2321

У вашего броузера проблема в совместимости с HTML5

Creating a Frequency Distribution in Office 365 Excel is easier thanks to dynamic arrays.
First: make sure you have a function called UNIQUE. You don’t need UNIQUE in this method, but if you don’t have UNIQUE, then you don’t have spillable arrays and you need to watch this instead: https://www.youtube.com/watch?v=jbaXnT5CX18

Included in this video:
1. Creating a frequency distribution from random data using a bins array and the FREQUENCY spilling function.
2. An odd bug with the Histogram chart. Why you could choose Pareto first and then switch back to Histogram to avoid the bug.
3. Using NORM.INV instead of RANDARRAY or RANDBETWEEN to generate data that has a standard normal distribution.