Skip to content
Playback Speed:

Imagine that you have been chosen to manage your school baseball team.

As a manager, you are responsible for choosing the batting order of the nine members of your team.

Use your knowledge of probability to help you choose the batting order.

Batting average is an expression of probability in baseball.

It measures the likelihood of a certain event—the likelihood that a batter will get a hit.

In this extension, you will create the batting order for your school baseball team based on probability.

You will use a formula in Google Sheets to calculate batting averages and use data sorting to help organize your data.

Batting average is the number of hits divided by the number of at bats.

Batting averages are expressed as decimals with three digits— for example, point four zero zero is called a four hundred average.

A batter who averages four hundred is a better hitter than a batter who averages two hundred.

In general, you can expect a player with a four hundred average to hit the ball about forty percent of the time and a player with a two hundred average to hit the ball about twenty percent of the time.

Managers prefer high-average hitters to bat first and low-average hitters to bat last.

This allows the team to get more hits because the players at the front of the batting order bat more than those at the end.

Now, create your own batting order!

To begin, open the starter project linked on this page.

Make a copy and give it a title.

Your table lists player name, position, at bats, hits, and batting average.

First, calculate batting average for each of your players.

Use a formula.

Divide the data in the Hits column by the data in the At Bats column.

Next, calculate batting average for the rest of your team.

Batting averages only have three digits.

Decrease the decimal places in each result.

There is still a zero to the left of the decimal.

Batting average does not include the zero.

Remove the zero in each result.

Good job!

You have calculated and formatted your batting average data.

Now, look at your data to determine the best and worst hitters.

Currently, the order of your table is determined by the players’ first names.

Re-sort your data so that batting average determines the order of players listed in your table.

Because your table has headers, you can sort by category.

In this case, sort by the Batting Average category.

Sort batting averages in ascending order, from highest to lowest.

Z refers to the highest number, A to the lowest number.

Now the batting averages are ranked in order from highest to lowest.

Notice that the sequence of player names has changed—this is because the order of your table is now determined by batting average.

Use this sequence of player names for your batting order.

The highest-average hitters will be first, the lowest-average hitters will bat last.

Great job creating a strong batting order!

Now, it’s your turn: Calculate the batting averages of your players, Sort your data, And choose a batting order.

Choose an Extension
Illustrate Probability with Conditional Formatting

In this extension lesson, students illustrate probability data using conditional formatting in Google Sheets.

Create an Event Based on the Weather Forecast

Students use Google Search to find the weather forecast and then they create an event in Google Calendar.

Make a Table to Visualize Probability

Students visualize and solve a probability problem using a table in Google Sheets.

Learn the Law of Large Numbers

Students learn the law of large numbers and demonstrate the law using Google Sheets.

Format Titles and Tables with Google Sheets

Students learn how to enhance a spreadsheet by formatting titles and tables in Google Sheets.

Create a Batting Order Using Probability

Students create a batting order by analyzing and sorting probability data in Google Sheets.


Choose an extension from the list to continue learning ways to use Google Sheets to perform calculations.