![]() Now, the total length of box and whiskers is equal to the range. To manage range names, go to the Formulas tab, select Name Manager, choose a name, then select Delete or Edit. Alternatively, highlight the desired range, select the Formulas tab on the ribbon, then select Define Name. The highest and lowest values of a given set a plotted at the end of on a whiskers graph. Highlight the desired range of cells and type a name in the Name Box above column A in the worksheet. The range is also used in other mathematical formulas of statistics such as standard deviation.Īnother application of Range can be seen in whiskers plot or boxplot. It is very easy to calculate as it involves basic arithmetic operations. Range offers a brilliant way to understand the spread of a given data set. So, if your middle values are varying largely it’s better to opt other methods such as mean, median and mode.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |