It's not easy to make a histogram in google spreadsheets without replicating data. The "countif" function would be great, except it only allows very simple criteria. However, there's a workaround:
=count(Filter('Grades'!V2:V30,'Grades'!V2:V30>0.9))
=count(Filter('Grades'!V2:V30,'Grades'!V2:V30<0.9,'Grades'!V2:V30>0.8))
The Filter() function returns an array, which can be operated on like any other set of cells.
It's still not easy to make a nice-looking histogram, but the output of this process is at least usable.
Wednesday, July 28, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment