To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single column. To calculate the first quartile, select a blank cell, and ente... More »

The interquartile range, or IQR, can be found after the median has been determined by dividing the data sets that are above and below the median in half, which divides the entire set into quarters, and then combining the... More »

The interquartile range shows the size of the span between the middle half of the numbers in a set. The interquartile range is calculated by subtracting the number at the lower quartile from the number at the upper quart... More »

Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represents the values in cells to be summed. More »

The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is represented using the “less than” and “greater than” mathematica... More »

To perform a linear regression in Microsoft Excel, input a set of values, for both the y-axis and the x-axis. A scatter plot will be produced, followed by a "Linear" trend-line to depict the regression. More »

Designing a work schedule in Microsoft Excel involves creating a table and inputting the appropriate values where necessary. It is also possible to use Excel to create a formula to display the total number of hours per w... More »