Box plot calculator plus#
Table 1: Monthly sales of stores in 2018 to 2020ġ) Copy the range A1:D14 from Table 1 to a blank Calc worksheet.Ģ) Save this worksheet with the name BoxplotBranches.Ĭalculate the concepts mentioned in the Introduction 1) Select and right click cells A16:D16 and select Merge Cells in the context menu or select Format ▸ Merge Cells on the main menu bar.Ģ) Type the text Summary Minimum, Median, Maximum, 1st and 3rd quartiles.ģ) In cells A17, A18, A19, A20, and A21, type Minimum (Q0), First quartile (Q1), Median (Q2), Third Quartile (Q3), and Maximum (Q4).Ĭalculate the minimum 1) To calculate the minimum over the year 2018, place the mouse pointer in cell B17, type the equal sign (=) and select the Function Wizard icon on the Formula Bar, which will open the Function Wizard dialog box Figure 2.įigure 6: Worksheet with the result in B17 and the function in the Input line of the Formula Bar 6) In the black-outlined cell B17, place the mouse pointer on the small black square at the bottom right until the mouse pointer changes shape (under Windows into a plus sign). This is shown schematically in Figure 1.įigure 1: Schematic representation of a box plot with an even distribution of the numbersĬalc does not currently have a prepared diagram to create a box plot, so we need to build a box plot using the above theory.Īs an example we will use Table 1, which shows the annual sales of the stores in 2018, 20. Then draw a rectangle between the first and third quartiles and place a line in this rectangle at the height of the median. Then place a dot at the lowest value, the first quartile, the median, the third quartile and the highest value. First make a line with numbers in which the box plot should be placed. In a box plot we will further use the minimum and the maximum. Now that we know what the median, the first and the third quartiles mean, we can start making a box plot.
Box plot calculator series#
It should be clear from the above explanation that the differences between the minimum, 1st quartile, median, 3rd quartile and maximum are only equal if the numbers in the series are evenly (uniformly) distributed. The third quartile in the italicized right part is between 780 and 934 and is then (780 + 934) / 2 = 857. The first quartile in the bold left part of the number sequence is therefore between 317 and 356 in and is then (317 + 356) / 2 = 336.5. These can be determined in the same way as explained above. The first quartile is the median of the left portion and the third quartile is the median of the right portion. The median splits the data series into two parts, as it were, creating a left and a right part. The middle, bold, number, the fifth, in the range 223-317-356-483- 721-780-934-942-966 is the median.Īfter we have determined the median, we can also calculate the quartiles. With an odd number of numbers, the median is the middle number. Median for an odd number of numbers in a number sequence The median is between the 2 middle bold numbers and is then (483 + 721) / 2 = 602. The median is then the mean of these two middle numbers. With an even number of numbers, the median is always between the 2 middle numbers. Median for an even number of numbers in a number sequence If the number of numbers is even, the average of the two middle numbers is taken. The median of an odd number of numbers is the value of the middle number of that row of numbers after the row is sorted by size. This data set can be, for example, a large database or a sample from a population. This tutorial was written by Henk van der Burg, Harry Croon, Rob Westein and Kees Kriek.Ī box plot is a graphical representation of a data set, showing:
0 kommentar(er)
