Look Who it Was Random video

Excel - Master Excel for Baseball Stats: Calculate ERA and Customize Display - Episode 477

886 views · Published 11 May 2009 · 2:23 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel for Baseball Stats: Calculate ERA and Customize Display.

Welcome back to another episode of the MrExcel netcast. Today, we have a special baseball-related topic in honor of opening day in the United States. As I was traveling through Ohio, I made a stop at the resting place of the legendary pitcher, Denton "Cy" Young. With an impressive record of 500 games won and a very low ERA, Young is considered to be the greatest pitcher in the history of the world. So, let's take a quick look at how we can use Excel to calculate ERA, one of the most popular statistics in baseball.

First, we need to format our numbers to show fractions of thirds, as innings pitched are often presented in decimals. We can do this by going to Format Cells and selecting the Fraction tab. Then, we can choose to show the numbers in thirds and click OK. Next, we can use the formula for ERA, which is the number of earned runs multiplied by 9, divided by innings pitched. We can then format the result to show two decimal places, as is customary in baseball.

Now, let's take a look at the career numbers for Cy Young. In his 874 major league games from 1890 to 1911, he pitched a total of 7354 and two thirds innings, with 2147 earned runs and an impressive ERA of 2.63. He also holds the record for 3 no-hitters and one perfect game, in which no man reached first base. It's safe to say that Young truly was the greatest pitcher of all time.

As we celebrate the return of baseball, let's also take a moment to remember the incredible legacy of Cy Young. Thank you for tuning in to this netcast from MrExcel. Be sure to subscribe for more Excel tips and tricks, and we'll see you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Play ball! In honor of baseballs opening day, learn how to display a number in fractions, such as the Innings Pitched column in Cy Youngs lifetime stats. Episode 477 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

Table of Contents:
(00:00) Introduction and baseball related topic 
(00:26) Visiting the resting place of CY YOUNG 
(00:36) Calculating ERA in Excel 
(01:09) Customizing the display of innings pitched 
(01:19) Formatting ERA with two decimal places 
(01:32) Career numbers for CY YOUNG 
(01:45) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Baseball statistics in Excel
Calculation for ERA in baseball
Career numbers of CY YOUNG
Custom formatting for thirds in Excel
CY YOUNG's earned runs
CY YOUNG's ERA
CY YOUNG's innings pitched
CY YOUNG's major league baseball games
CY YOUNG's wins and no-hitters in baseball
Format Cells in Excel for fractions
Formatting decimal places in Excel
How to calculate ERA in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152406/

More from this channel