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.