(Calculating Batting Averages)

 

Who do you think were the best and the worst hitters on each team during the World Series?
Look at their statistics and make an educated guess.


Florida Marlins

PLAYER

 HITS AT BATS AVERAGE
Alex Gonzalez 6 22
Jeff Conine 7 21
Miguel Cabrera 4 24
Derrek Lee 5 24
Mike Lowell 5 23
Luis Castillo 4 26

My guess for the best Marlins hitter is .
My guess for the worst Marlins hitter is .

 

 

New York Yankees

PLAYER HITS AT BATS AVERAGE
Hideki Matsui 6 23
Jason Giambi 4 17
Alfonso Soriano 5 22
Bernie Williams 10 25
Derek Jeter 9 26
Jorge Posada 3 19

My guess for the best Yankees hitter is .
My guess for the worst Yankees hitter is .

WERE YOU CORRECT? LET'S FIND OUT!

To calculate a batting average, divide hits by at bats. 
Answer should be made to have 3 decimal places.

Example:  2 hits out of 5 times at bat = 2/5 = .400
(But don't worry. You won't actually have to do the math.)

Open Excel and follow directions for writing and using formulas.