![]() In the first example I show how to make a histogram with a bell shaped curve like in Microsoft's example (like the image at the top), and you don't need Analysis Toolpak. ![]() You can make histograms manually, if you have installed Analysis Toolpak, but it is tedious work (see a guide here) - it is much, much faster to use macros. To be sure about the normal distribution-thing you need to test statistically, but I'll leave that to you - this is about VBA! It could be the population's age distribution or quality data, and from the shape you get a pretty good idea if it is a normal distribution or not. I also show how to make a bell shaped curve with normal distribution and the same standard deviation and mean value as the histogram.Ī histogram is a graphical representation of data distribution. On this page I show how to make a histogram fast and easy in Excel with VBA macro code.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |