Type your name(s) here: Insert Histogram (FG%) Here 1. Calculate the average scores (M) and standard deviations (SD) for FG%, 3P%, FT%, OREB, AST, DREB, STL, and BLK using Excel functions "average" and "stdev"(2pts.). 2. Calculate the z scores for FG%, 3P%, FT%, OREB, AST, DREB, STL, & BLK under ZFG%, Z3p%, ZFT%, ZOREB, ZAST, Z DREB, ZSTL, & ZBLK using function "standardize" or Zscore formula (5pts.). 3. Calculate the average scores (M) and standard deviations (SD) for ZFG%, Z3P%, ZFT%, ZOREB, ZAST, ZDREB, ZSTL, and ZBLK using Excel functions "average" and "stdev"(5pts.). 4. Calculate the average Z scores for Z_FG%, Z_3P%, Z_FT%, Z_OREB, Z_AST, ZDREB, ZSTL, and ZBLK (5pts.) 5. Based on the average_Z_scores, who is the MVP (using the "Sort & Filter" tab to find the highest average Z score) ? _____________________(Type the MVP name, 5pts.) 6. Calculate the T scores for all of players based on the average Z-score (5 pts) 7. Calculate the 68.26% of observations for age __________ (type the range, 2.5 pts), and the 95.44% of observations for FG%___________ (type the range, 2.5 pts.) 8. Make a statistic chart (histogram) for the FG% (3pts.) M SD ID PLAYER TEAM AGE PTS FG% 3P% FT% OREB AST DREB STL BLK ZFG% Z3P% ZFT% ZOREB ZAST ZDREB ZSTL ZBLK Average Zscores T scores 1 Payton Pritchard BOS 26 9.6 46.8 38.5 82.1 0.9 3.4 2.4 0.5 0.1 2 Sam Hauser BOS 26 9 44.6 42.4 89.5 0.6 1 2.9 0.5 0.3 3 Derrick White BOS 29 15.2 46.1 39.6 90.1 0.7 5.2 3.5 1 1.2 4 Cason Wallace OKC 20 6.8 49.1 41.9 78.4 0.6 1.5 1.6 0.9 0.5 5 Chet Holmgren OKC 22 16.5 53 37 79.3 1.6 2.4 6.3 0.6 2.3 6 Christian Braun DEN 23 7.3 46 38.4 69.4 1 1.6 2.8 0.5 0.4 7 Jayson Tatum BOS 26 26.9 47.1 37.6 83.3 0.9 4.9 7.2 1 0.6 8 Michael Porter Jr. DEN 25 16.7 48.4 39.7 83.6 1.3 1.5 5.7 0.5 0.7