Category Archives: Statistics

Minnesotans In the Olympics

I spend a lot of time in northern Minnesota now that I have a home there. I have been surprised as to how popular curling is in the area (Figure 1). The US curling team at the 2018 Olympics is dominated by people from northern Minnesota. I also notice that there are quite a few Minnesotans participating in the games other sports – the numbers are large enough that the New York Times has even written an article called "Team USA? More Like Team Minnesota" on the topic (PDF of the article). Our state does not have a huge population, ~5 million, and most of that population is concentrated around Minneapolis and St. Paul. The northern part of the state is only sparsely populated as it is covered with national forests and wilderness areas. Continue reading

Posted in Excel, Statistics | Leave a comment

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

US Manufacturing Employment Versus Time

The only television news program that I watch is the PBS Newshour. I particularly like the discussions between Mark Shields, a reasonable liberal, and David Brooks, a reasonable conservative. On inauguration day (20-Jan-2017), they had an interesting discussion about the challenges the US faces and what can be done about them. Continue reading

Posted in History Through Spreadsheets, Statistics | 4 Comments

Naked and Afraid Statistics

I do not watch much reality television, but one show I do watch is Naked and Afraid (N&A). I have always been interested in primitive survival skills (e.g. I have blogged about knot tying and rigging), and this show really puts those skills to the test. I like the fact that the participants are presented with survival challenges from around the world (Figure 1). They have been on all the continents but Antarctica – I could not imagine someone surviving naked in Antarctica for any length of time. Continue reading

Posted in Statistics | 42 Comments

MTBF and Annualized Failure Rates

One of the more distasteful tasks I need to do is make estimates of annual product failure rates using MTBF predictions based on part count methods. I find this task distasteful because I have never seen any indication that MTBF predictions are correlated in any way with field failure rates. This is not solely my observation – the US Army has cancelled its use of part count method MTBF predictions (i.e. based on MIL-HDBK-217). However, the telecommunications industry has continued to use these predictions through their use of SR-332. If you want to see a simple example of an SR-332-based reliability prediction, see this very clear example from Avago. Continue reading

Posted in Statistics | 5 Comments

Modeling Coal Energy Output

I had never seen coal until my first trip to China when I saw people on bicycles transporting coal to their homes for heat. I started to wonder just how much coal a home would need for heating. I have seen numerous values for the heat content of the various types of coal. I recalled from primary school that there were three types of coal: anthracite, bituminous, and lignite. So I would have expected three values for the heat output of coal. When I actually looked, I found dozens of grades of three primary types of coal. Each of the different grades would generate different amounts of heat per kilogram. I thought I would take a closer look at how the heat output from coal could be modeled using regression and a simplified model based on chemical heats of formation. Continue reading

Posted in General Science, Statistics | 1 Comment

Statistics Example from World War 2

I recently finished a course on Bayesian analysis from and I have been looking for application examples that will provide me with some experience using these methods. I like to compare the Bayesian solutions with the standard solutions (usually called Frequentist). Continue reading

Posted in Statistics | Leave a comment

My Online Statistics Education Experience

Quote of the Day I can't mate in captivity. — Gloria Steinem on why she never married I have been fortunate in having worked for companies that have had enlightened education policies, which I have always taken advantage of. These … Continue reading

Posted in Statistics | 3 Comments

My ANOVA and Gage R&R Self-Education

Quote of the Day Who are a little wise the best fools be. — John Donne Introduction I recently took an excellent class at called "Prediction & Tolerance Intervals, Measurement and Reliability" taught by Dr. Tom Ryan, a former … Continue reading

Posted in Statistics | 2 Comments