ABOUT 14 HOURS AGO • 4 MIN READ
Stop reporting the average. Google Sheets now plots the whole distribution.
TL;dr: On October 22, Google added native box and whisker charts to Sheets, for all Workspace customers and personal Google accounts. You select a range of raw numbers and Sheets calculates the minimum, first quartile, median, third quartile, maximum, mean, and outliers, with no helper formulas needed. You can choose inclusive or exclusive quartile calculation, and show or hide inner points, outliers, mean markers, and mean lines. Charts imported from Excel are no longer dropped, and Sheets...
Read Now