Thursday, January 27, 2005

Bowling Stat Sheet

You need to create a spreadsheet that gives the scores for the four members of a bowling team.

The team plays four games each week.

You should have scores listed for each game in a 4 week tournament (a total of 16 games apiece).

For each week you need to give a total score for each player as well as a total score for each game for the team. You also need to give the average, maximum, and minimum for each player each week.

At the bottom you need to give the total, average, maximum, and minimum for each player. These final stats should be given for total weekly scores, and also for individual games.

Be sure to include formatting to make the tables easier to read.

I will be giving an example of one of the weeks.

Week 1










Game 1 Game 2 Game 3 Game 4 Total Average Minimum Maximum
Francis 156 89 6 75 326 81.5 6 156
Jeremiah 149 264 123 184 720 180 123 264
Ezekiel 216 299 245 206 1046 241.5 206 299
Jude 31 78 102 122 333 83.25 31 122
Total 552 730 476 587 2345 586.25 476 730