Forcing an xy scattergraph for short columns in Google Sheets

In a data exploration involving hoop rotation period versus diameter Google Sheets does not always produce the desired scatter graph. The issue appears to small sample size or short columns. 


Selecting a scatter chart for this data results in the following chart for some students:

 


Note the monotonic spacing on the x-axis. Google Sheets has defaulted to a form of line graph with monotonic spacing on the horizontal axis. To reunite the paired data, select Use column A as label under edit chart on a laptop or desktop computer. 


Note that this option is not accessible from the Google Sheets mobile app. Of note is that while working inside the Google Sheet chart module in the mobile app the chart appears to configure as expected. Once one exits the chart module, the columns split into two data sets. There is no known easy fix on mobile. The repair essentially requires getting onto a laptop or desktop. 


There are hackarounds. One is to manually type the data into Statisty. Copy and paste from Google Sheets from the mobile app into Statisty does not work. A screenshot can the capture the scatter graph. In theory. 

Another interesting hackaround was found by a student. 


Select a bubble chart. The chart module displays an error. Ignore the error and continue in the chart module.


Manually add the horizontal axis title. 


The result is a scatter graph with enlarged data points, which, while not optimal, is more correct than the split column scatter graph.


The bubbles are at least correctly located, which cannot be said for the original split column graph. The author thanks Ikaia E.A.G. for discovering this option. 

Comments

Post a Comment

Popular posts from this blog

Experimenting with the PlantNet and iNaturalist apps

Image
The application of image recognition technologies as the back end to botany apps is providing increasingly relevant search results. Over the recent winter break I began looking at whether the apps now available might be useful to the ethnobotany class here on Pohnpei. Some apps had a more regional focus in the past and were better at north american or european plants. Pohnpei has a both unique indigenous plants and many introduced plants from around the world -  a challenging environment for any image recognition system. A student working with a plant identification app for the first time My criterion was that the app had to be appropriate for use in my classroom. The app could not contain advertising and the app had to be free, my students typically do not have the ability to pay for an app. The app would also have to be fairly small as my students often use phones with limited memory and processing power. I settled on PlantNet and was impressed with the ability of the a...
Read more

Setting up a boxplot chart in Google Sheets with multiple boxplots on a single chart

Image
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 ha...
Read more

Traditional food dishes of Micronesia

Image
Clara, Jennette, and Joanie presented ground hard taro cooked in an umw, effectively a hot rock oven. Pohnpeian: rotama. Pingelapese: sero. Mwoakillese: rodma. Mortlockese: Amahd. Kosrae: rodoma. After cooking in an umw the rotama is pounded with the petiole of a palm frond. Rotama is made from hard or swamp taro, known as mwahng on Pohnpei, mweian on Pingalap, pula in Mortlockese, and pahsruhk on Kosrae. In traditional times on the outer islands the women had primary responsibility for tending the taro while the men handled fishing and climbing tasks. Joesen and Noeleen presented fermented breadfruit from the outer islands of Yap such as Woleai and Eauripik. The raw ingredients were actually brought in from Yap, Noeleen prepared the maare.  The leaf wrap is ti leaf - Cordyline fruticosa. Pauleen, Barnson, Trisha, Verginia, Con-ray, and Maylanda from Kitti, Pohnpei brought in mahi umw, koahpnoair koakihr, and uht sukusuk. Above is breadfruit umw, mahi umw, o...
Read more