# How to Calculate Win Percentage (Formula and Examples) Win percentage is the number of games a team or player has won divided by the total number of games played. If a team went 27-15, that is 27 wins out of 42 games, or 0.6429. This article shows how to calculate win percentage for a full season, how ties change the formula, and how to do it in Excel or Python. ## Quick Answer - Win percentage = wins ÷ total games played. - Total games = wins + losses + ties. - A tie counts as half a win, so the numerator becomes wins + 0.5 × ties [1]. - A 27-15 record gives 27 ÷ 42 = 0.6429, or 64.29%. - In North American sports, the result is usually written as a three-decimal value like .643 instead of a percentage [1]. ## The Formula The basic formula for a record with no ties is: $$\text{Win percentage} = \frac{\text{wins}}{\text{wins} + \text{losses}}$$ When ties or draws are possible, the standard formula adds half a win for each tie [1]: $$\text{Win percentage} = \frac{\text{wins} + 0.5 \times \text{ties}}{\text{wins} + \text{losses} + \text{ties}}$$ Each symbol means the following: - **Wins**: games the team finished ahead, or matches the player won. - **Losses**: games the team finished behind. - **Ties**: games that ended level. Each one contributes 0.5 to the numerator. - **Total games**: every game played, win, loss or tie. This is the denominator. Multiply the result by 100 to express it as a percentage. Leave it as a decimal to match the North American convention, where .650 means 65.0% [1]. ## How to Calculate It Step by Step 1. Count the wins. Write down the number of games won. 2. Count the losses. Write down the number of games lost. 3. Count the ties, if your sport allows them. If not, use zero. 4. Add the three counts to get total games played. 5. Add half the tie count to the win count to get adjusted wins. 6. Divide adjusted wins by total games. That is the win percentage as a decimal. 7. Multiply by 100 if you want a percentage. For a record with no ties, steps 3 and 5 drop out and you simply divide wins by games played. ## Worked Example The table below holds five teams' season win-loss records. No ties appear, so the simple formula applies. | Team | Wins | Losses | |---|---|---| | Falcons | 27 | 15 | | Bears | 22 | 20 | | Comets | 18 | 24 | | Dolphins | 14 | 28 | | Eagles | 9 | 33 | Take the Falcons. Games played is wins plus losses: 27 + 15 = 42 Win percentage is wins divided by games: 27 / 42 = 0.6429 As a percentage: 0.6429 * 100 = 64.29% The same division for every team gives the full standings: | Team | Wins | Losses | Games | Win % | |---|---|---|---|---| | Falcons | 27 | 15 | 42 | 0.6429 | | Bears | 22 | 20 | 42 | 0.5238 | | Comets | 18 | 24 | 42 | 0.4286 | | Dolphins | 14 | 28 | 42 | 0.3333 | | Eagles | 9 | 33 | 42 | 0.2143 | The Falcons lead at 64.3% and the Eagles trail at 21.4%. You can also compute a rolling win percentage over a recent stretch. If the Falcons won 7 of their last 10 games, that window gives: 7 / 10 = 0.7000 A rolling figure like this shows current form, while the season figure shows the whole year. Here is the same calculation in Python: ```python wins, losses = 27, 15 win_pct = wins / (wins + losses) print(round(win_pct, 4)) # 0.6429 ``` Output: ```text 0.6429 ``` ## How to Interpret the Result A win percentage of 0.6429 means the team won about 64% of its games. Values above 0.500 mean more wins than losses. Values below 0.500 mean more losses than wins. Exactly 0.500 is an even record. Win percentage is a rate, so it lets you compare teams that played different numbers of games. A 27-15 team and a 22-20 team have both played 42 games here, but that will not always be true. Dividing by games played puts every team on the same 0-to-1 scale. The number is also easy to convert. To turn a win percentage into an expected win total, multiply it by the games in a season. To compare two teams, subtract one win percentage from the other. The gap between the Falcons at 0.6429 and the Bears at 0.5238 is 0.1191, or about 12 percentage points. If you need to convert between decimals and percentages in general, the same mechanics apply as in [how to calculate a percentage](/blog/data-analysis/how-to-calculate-a-percentage). ## Doing It in Software (Excel, R or Python) **Excel.** Put wins in column A and losses in column B, starting at row 2. In C2, enter: ```excel =A2/(A2+B2) ``` That returns 0.6429 for the Falcons row. Format column C as a number with three decimals, or multiply by 100 for a percentage. If you have a ties column, the formula becomes `=(A2+0.5*C2)/(A2+B2+C2)` with ties in column C and the formula entered in column D. **Python.** The snippet above uses plain division. For a whole table, pandas handles it in one line: ```python import pandas as pd df = pd.DataFrame({"wins": [27, 22, 18, 14, 9], "losses": [15, 20, 24, 28, 33]}) df["win_pct"] = df["wins"] / (df["wins"] + df["losses"]) print(df) ``` **R.** With a data frame called `df` holding `wins` and `losses` columns: ```r df$win_pct <- df$wins / (df$wins + df$losses) ``` All three approaches use the same arithmetic. The software only saves you from repeating the division by hand. ## Common Mistakes - **Dividing by wins plus losses when ties exist.** Ties belong in the denominator. Use wins + losses + ties, and add 0.5 per tie to the numerator [1]. - **Counting a tie as a full win or a full loss.** A tie is worth half a win in the standard formula [1]. Treating it as a win inflates the result. - **Dividing by games remaining instead of games played.** The denominator is games already played, not the season length. - **Mixing percentage and decimal formats.** 0.643 and 64.3% are the same value. Writing 0.643% is wrong by a factor of 100. - **Comparing win percentages across sports with different tie rules.** A sport that allows ties and one that does not will produce different denominators for the same number of decisions. - **Using win percentage on a tiny sample.** A 2-0 start gives 1.000, which says almost nothing about team quality. ## Limitations Win percentage ignores margin of victory. A team that wins every game by one point and a team that wins every game by twenty points both finish at 1.000. It also ignores strength of schedule, so a 0.700 record against weak opponents can rank below a 0.600 record against strong ones. For ranking purposes, win percentage is a starting point, not a complete measure. The statistic also depends on how ties are handled. The half-win convention is standard in many standings, but some competitions use different rules, and a few exclude tied games from the denominator entirely. Always check the tie policy before comparing numbers from two sources [1]. ## Frequently Asked Questions ### How do you calculate win percentage with ties? Add half the number of ties to the win total, then divide by wins plus losses plus ties. A 30-15-5 record becomes (30 + 2.5) ÷ 50, which is 0.650 [1]. The five ties contribute 2.5 adjusted wins. ### What is the difference between win percentage and win-loss percentage? They are the same statistic. "Win-loss percentage" and "winning percentage" both mean wins divided by total games played [1]. The hyphenated name simply references the win-loss record the number comes from. ### Can win percentage be higher than 1? No, if every game is counted once. The numerator can never exceed the denominator, so the maximum is 1.000, or 100%. A value above 1 means the wins and games played counts disagree, usually because of a data entry error. ### How do I calculate win percentage in Excel? Divide the wins cell by the sum of the wins and losses cells. With wins in A2 and losses in B2, the formula `=A2/(A2+B2)` returns the decimal value. Format the cell to show three decimals or multiply by 100 for a percentage. The steps mirror those in [how to find percentage in Excel](/blog/data-analysis/how-to-find-percentage-in-excel). ### Is win percentage the same as winning percentage? Yes. Both terms describe wins divided by games played, and both appear in standings and sports statistics [1]. Use whichever your audience expects, and keep the format consistent across a table. If you want to check a single division or convert between decimals and percentages, the [Percentage & Percent Change Calculator](/tools/percentage-calculator) handles it quickly. For related rate calculations, see [how to average percentages correctly](/blog/data-analysis/how-to-average-percentages) and the [percentage decrease formula](/blog/data-analysis/percentage-decrease-formula). ## References 1. [Winning percentage - Wikipedia](https://en.wikipedia.org/wiki/Winning_percentage) ## Further Reading - [NIST/SEMATECH e-Handbook of Statistical Methods](https://www.itl.nist.gov/div898/handbook/index.htm) - [OpenStax. Introductory Statistics 2e](https://openstax.org/details/books/introductory-statistics-2e) - [Krzywinski M, Altman N (2013). Importance of being uncertain. Nature Methods](https://doi.org/10.1038/nmeth.2613) - [Krzywinski M, Altman N (2013). Significance, P values and t-tests. Nature Methods](https://doi.org/10.1038/nmeth.2698) - [Wasserstein RL, Lazar NA (2016). The ASA Statement on p -Values: Context, Process, and Purpose. The American Statistician](https://doi.org/10.1080/00031305.2016.1154108) ## Related Articles - [How to Calculate a Percentage: Formula and Examples](/blog/data-analysis/how-to-calculate-a-percentage) - [Percentage Increase Formula in Excel: How to Calculate](/blog/data-analysis/percentage-increase-formula-excel) - [How Do You Calculate Percentile? Formula and Example](/blog/data-analysis/how-to-calculate-percentile) - [How to Find Percentage in Excel (Step by Step)](/blog/data-analysis/how-to-find-percentage-in-excel) - [How to Average Percentages Correctly (With Examples)](/blog/data-analysis/how-to-average-percentages) - [Test Statistic Formula: How to Calculate and Use It](/blog/guides/test-statistic-formula-how-to-calculate-and-use-it)