Statistics chapter three: basic charts

There is a 3.1 circle and column chart data sets spreadsheet that frames the introduction to charts. This data is updated from an institutional dashboard.


On Monday, circle charts, column charts, and Pareto charts were covered using the data in the spreadsheet. the data derives from an institutional dashboard in LookerStudio that pulls data from Instructure Canvas.


On Wednesday I worked the 3.1 Pareto chart homework. After working the homework on the SMARTboard using the Data: Sort range with header row option enabled, I briefly showed the class the new Convert to Table option on the Format menu. This provides "safer" sorting as preselection is not necessary. Note that the 2023 census data still has not yet been released. 

Then the class engaged in the favorite colors exercise, which I lost badly when black beat blue nine to four. Green tied for third place with white with two votes each, red was a single selection. Cyan, olive green, and purple were singletons. There isn't, however, a trend. Since the pandemic blue has beat black three out of five times. There is no clear signal of a swing to black dominance. 



Friday worked 3.2 homework and then used two terms worth of heart rates to make a ratio level histogram. 

Monday redistributed marbles based on rolls of a die to generate a pseudo-random distribution of marbles per student. Students started with seven marbles, thus no student could lose all of their marbles. 

The class started with seven students at 9:00, so I stalled into the marble trading exercise. Eventually 18 students showed up. 


Despite the directions given, one pair engaged in a double roll of their die. Bear in mind that students start with seven marbles and can lose no more than six on a single roll of the die. A student who rolls a one and gives away one will have six. The most they can receive from the student on the left is six, thus 12 is the largest possible number. Only by rolling again did one student wind up with 14 marbles. This created a high outlier and an opportunity to talk about the validity of a statistical study: if directions are not followed in the same fashion by those engaged in the survey or study, then the results will not be statistically comparable. 


Five marbles also went unaccounted for in the post distribution. Perhaps a typing error. This reduces the mean and cost me the common mean. All errors are ultimately good: I used this to note that errors in sampling are unavoidable. 


The histogram before was literally unimodal.


After was problematic. Arguing symmetry was made tougher by the lone outlier. Nothing I could do with the bucket rescued symmetry from this data.

Comments

Post a Comment

Popular posts from this blog

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

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

Plotting polar coordinates in Desmos and a vector addition demonstrator

Image
In an earlier post I noted that Desmos did not directly plot polar coordinates. Not only was I incorrect, but Desmos responded to my blog to correct me! Although I had at some point seen that one could define a function f(x)=3x+5 and then have Desmos calculate f(6), I had not absorbed how this might be used to plot polar coordinates. The above works beautifully . Realizing that I could effectively program Desmos, I applied this thinking to demonstrating how to add two vectors when given the magnitudes m and the direction angles theta. The graph calculates the i and j components for the two vectors and then adds the vectors, graphically displaying the result while also providing information on the magnitude and direction of the vector sum. m1 and theta1 are the magnitude and direction angle for one of the two vectors, m2 and theta2 are the magnitude and direction for the other vector. All four are dynamically interactive and can be changed. The diagram purports to illustra...
Read more