Excel for mac box and whisker

broken image
broken image

The whiskers are drawn down to the 10th percentile and up to the 90th. The whiskers go down to the smallest value and up to the largest. Prism offers six ways to create whiskers in box-and-whiskers plots: You can not choose a different value, but Prism also lets you put a '+' at the mean. The line in the middle of the box is plotted at the median. Prism uses a standard method, but a different method than Excel uses. Surprisingly, there are multiple ways to compute these percentile values.

broken image

These limits are sometimes called the hinges of the plot. The box always extends from the 25th to 75th percentiles. Prism lets you create box-and-whisker plots from stacks of values entered into a Column table, or side-by-side replicates entered into an XY or Grouped table. Before creating a box-whiskers plot, consider a violin plot instead.