Define the bands for distributionĪssuming the test scores range from 0 to 100, you can define score bands like 10,20,30,40,50,60,70,80,90,100 2. Also, download the statistical distributions example workbook and play with it. Just follow the below 2 steps to create statistical distribution / frequency of any set of values using excel. This is a part of our spreadcheats series of posts where we aim to solve 30 common work related excel problems, one at a time. Today we will learn how you can make a statistical distribution of test scores using excel. Excel has very powerful formulas and add-ins for performing almost any kind of statistical analysis.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |