5. Basketball Statistics

Essential Question: How can I use Microsoft Excel to keep track of my favorite teams?

Objectives:

• Learn to create formulas in Microsoft Excel.

• Learn how to access commonly used formulas to calculate statistics.

• Learn to format cells in Microsoft Excel.

Directions: Create a spreadsheet using statistics from a sports team and use formulas to calculate the statistics.

Resources:

http://www.nba.com/celtics/stats/

http://www.nba.com/

http://www.basketball-tips-and-training.com/basketball-statistics.html

Project Directions:

Select 10 players from the statistics page for a basketball team.  Type in 5 types of statistics for your players.  You need to use the following functions in your table:

=COUNTA( )     This function counts the total text

=AVERAGE( )     This function calculates an average

=SUM( )     This function adds everything up

=MAX( )     This function finds the largest number

=MIN( )      This function finds the smallest number

Requirements:

• Create a chart with 10 players.

• Provide the numbers for 4 different statistics.

• Provide a graph for one of the statistics.

• Make the chart pretty using colors and formatting.