Control charts are essential for statistical quality control purposes, such as for monitoring performance and defects measurements. Control charts are also known as Shewhart charts or process-behavior charts as they are tools used to monitor and analyze the behavior of a process over time. They help identify variations in the process and determine whether those […]
Search Results for: soccer
Euro 2024 Analyzed with Visuals
Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]
Champions League: Probabilities, Odds, Payouts
The Champions League final is set, featuring Borussia Dortmund versus Real Madrid. This post will cover the betting odds, payouts, and probabilities of various outcomes, as well as how to interpret and calculate them on your own. Who will you root for? An article I read online recently stated that according to Bet365, the Borussia […]
Charting Team Lineups & Formations (Excel)
We have all seen the team lineups and formations graphics on TV for soccer (European football) games. It got me wondering if I could create a chart instead of a static image that can be easily scaled for any teams, any formations just by updating the underlying tables. It turns out, I can. It takes […]
Butterfly Chart (Excel)
Butterfly chart (aka Tornado or Divergent chart) is a type of bar chart used to compare two data sets side by side.It plots the data as two horizontal bars with the same X-axis in the center, resembling the butterfly wings.It gives a quick glance at the difference between two groups with the same parameters. It’s […]
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]
Timelapse animation in Excel
Not long ago I demonstrated how to create and share animated charts using Excel (search for “soccer” or “excel” in the search box of my site). Here, I present a cool 3D chart created in Excel with various dimensions including time and geo-location. This animation is based on a dataset for power stations across different […]
Anatomy of a goal (part 2)
This is a continuation of the original soccer goal tracking chart and animation posted @: https://flyingsalmon.net/blog/?p=869 It’s recommended that you read that blog first for context. In this blog, I added actual players involved in that goal (denoted by their jersey and individual numbers). The players data are added as an addition series (much like […]
Behind every goal, there’s science. Anatomy of a goal (part1)
With the World Cup, Copa America underway, obviously I try to catch some games and follow the scores on matches I missed. The other day I noticed a chart on BBC site that showed charts with points plotted on a field where the ball had traveled on a particular game. This got me thinking, how […]