And then everything changed. For the first time since the loss of Gnumeric a spreadsheet was displaying a box and whisker plot. To back up to the beginning, MS 150 Statistics was built around spreadsheets. Students in the course were not statistics majors and the overwhelming majority were not in a scientific field. Most would wind up working on office desktops for which they would not be an administrator. Downloading R would not be an option and R would be steep learning curve for some for whom computers are an unfamiliar technology.
Spreadsheet based statistics, for all the faults and potential for error, would be at the center of the course. The use of Ubuntu in the classroom meant using LibreOffice.org or Gnumeric. Gnumeric provided the capability of including box and whisker plots. A change in computer laboratory technology to Microsoft Windows five years later saw the use of Gnumeric on Windows - until Gnumeric stopped supporting Windows. A further change of my work top to OSX f…
The Secretary-Treasurer of the Awak Farmers Association, Loatis Seneres, presented on leaf sheaf petiole plates being produced by the Awak Farmers Association.
These plates represent a modern evolution in ethnobotanical material culture. These plates are intended to replace single use plastic and styrofoam plates. Being made from the leaf sheaf portion of the petiole of an Areca palm here on Pohnpei, the plates are environmentally friendly and fully biodegradable.
The process begins with collecting, cleaning, and storing fallen Areca catechu palm fronds. The fronds should be stored in a dry place. The sooner the frond is collected from the ground, the lighter the color of the leaf sheath.
Plate production begins with soaking the petiole for ten to fifteen minutes to make the leaf sheath more flexible and pliable. The leaf sheath is then allowed to dry slightly for fifteen to twenty minutes.
The Google Statistics add-on for Google Sheets can display multiple boxplots in a single chart. The key is the layout of the data. One column should be the variable by which the data is to be grouped, the other column should be the data to be box plotted.
Set up the Statistics add-on with the data to be plotted as the variable, and the grouping column as the "by" variable. In this image I had deselected all but the boxplot option, the result was the appearance of the Moment, Standard errors, and Confidence intervals options. The default is apparently a 95% confidence interval for the mean.
The result is multiple boxplots on a single chart with a common scale. The new tab that is created also quotes 95% confidence intervals for the mean. Note that as of 2018 the Google Statistics add-on cannot be found by search in the add-ons. In addition, as of May 2018 the add-on no longer verifies, possibly due to the add-on not having been updated since August 2017. One may have to essen…