Author Archives: mathscinotes

Super Bowl Winners and Losers Using Power Query

I was reading a post on Statista showing the NFL teams with the most Super Bowl wins. Since my staff includes a number of football fans — mainly Viking and Packer supporters — I decided it would be a good training exercise to show them how to gather the football statistics and present them in the same manner as shown on Statista. I should mention that I do not follow football at all; this is purely a data analysis exercise for me. Continue reading

 
Posted in Excel, Statistics | Leave a comment

My Star Trek TOS Database

The people on my team frequently chide me for using management analogies drawn from the original Star Trek television series, which fans refer to as Star Trek TOS. Because of these analogies, I need to provide exact references for the younger folks on our team who have not memorized every episode. I decided that it was time for me to put together an online list that I could search and sort as the need arises. I grabbed the data from the Internet Movie Database (IMBD), including their overall reviews of each episode. Continue reading

 
Posted in Science Fiction | 4 Comments

Cannon Bore Measured in Pounds

I have been pulling together some WW2 data for an article that I want to publish in the next year or two. During my research, I have noticed that the British specified the caliber of their artillery by the nominal mass of the projectile (lbm or pound mass) and not by the bore diameter. I was curious as to how the British came to this particular system and decided to investigate further. As with many military standards, it traces its history back hundreds of years. Continue reading

 
Posted in Military History | Leave a comment

The Pacific War and Manufacturing Capacity

I was watched a particularly interesting lecture by Victor Davis Hanson on his new book The Second World Wars. While Hanson is generally thought of as an ancient Greek scholar, he does an excellent job of analyzing WW2 from a novel set of viewpoints: ideas, air, water, earth, fire, and people. Continue reading

 
Posted in History Through Spreadsheets, Military History | Leave a comment

Statistics of US Senate Disciplining Its Members

The controversial senate candidacy of Roy Moore has resulted in some discussion of how the US Senate would respond if he won the election. Senate Majority Leader Mitch McConnell has mentioned the possibility of expulsion. I could not recall hearing of anyone being expelled from the Senate recently, so I decided to grab some data from the Senate web site and summarize it here. Continue reading

 
Posted in Civics Through Spreadsheets | 3 Comments

An Interstellar Visitor?

Astronomers are now working on determining if a recently discovered asteroid is an interstellar visitor. The first observations of this asteroid were made by a team of researchers at the University of Hawaii's Pan-STARRS 1 telescope on Haleakala in Hawaii (Figure 1). Continue reading

 
Posted in Astronomy | Leave a comment

Estimating Asteroid Sizes Using Excel 2D Data Table

I recently gave a seminar on how to design products using Thermoelectric Coolers (TECs). During this presentation, I showed the audience how to generate various tables and graphs using Excel data tables. I was surprised to learn that no one in the audience had ever seen an Excel data table in action. Since the middle of a seminar on TECs is probably not the best time to divert to some Excel training, I decided to prepare a simpler example the would be easier to understand on first exposure. Continue reading

 
Posted in Astronomy, Excel | 1 Comment

Great Lakes Shipwreck Statistics

I was driving home from my cabin construction project yesterday when I heard on the radio Gordon Lightfoot singing about the sinking of the Great Lakes freighter Edmund Fitzgerald (Figure 1). The sinking occurred when I was in high-school, and it was the first I had ever heard of a sinking on Lake Superior. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment

A Math Error I Wish Were True

Quote of the Day Because Bushwacker, PBR Bucking Bull just isn't his spirit animal. His spirit animal is more of that of a millennial who works at his dad's law office after graduating with a bachelor of business in 6 … Continue reading

 
Posted in Humor | Leave a comment

Santa Rosa Fires And My Coworkers

I work for a company that is headquartered in Petaluma, California, which is just south of the Santa Rosa fire region. Six employees lost their homes in this fire. One employee, Danny Pomplun, and his wife, narrowly escaped the fire by sheltering in their pool. Their dramatic story is told very well in this Washington Post article. If you cannot gain access to the original news article, try this PDF of this story. Continue reading

 
Posted in Personal | Leave a comment