excel help 3

Excel Project 1

Download the csv file which contains your data. You can open it with Excel. Once you have it opened, be sure to save it with EP1_{yourname}.xlsx (as an Excel file type). Warning – if you leave it as a csv file type, it may not save your formulas.

Using the NBA data file provided,

1. Calculate the mean, variance, and standard deviation of weight, height, age of all NBA players.

2. Calculate quartiles and the IQR for all players

3. Create a frequency table (use a pivot table) showing players by position along with their weight, height, or age.

4. Develop a 5NS for each position.

5. Create a frequency table of position showing mean weight, height, and age for the positions (use a pivot table).