Denise Lau is an avid football fan and religiously follows every college football game. During the current season, she meticulously keeps a record of how each quarterback has played throughout the season. Denise is making a presentation at the local college football fan club about these quarterbacks. The accompanying table shows a portion of the data that Denise has recorded, with the following variables: the player number (Player), completed passes (Comp), attempted passes (Att), completion percentage (Pct), total yards thrown (Yds), average yards per attempt (Avg), yards thrown per game (Yds/G), number of touchdowns (TD), and number of interceptions (Int) 

a. Perform k-means clustering using k = 3 on all variables except the player number. Standardize the variables. What are the size and cluster center values of the largest cluster? 

b. Select only the quarterbacks with at least 150 attempted passes and repeat part a. Note: For Analytic Solver, use the Filter option in Excel to select the observations. Copy the observations to a new worksheet. Do not alter the order of the observations. 

c. Comment on the differences in the clustering results of parts a and b. 

Transcribed Image Text:

Player 1 2 ⠀ 43 Comp 107 238 ⠀ 184 Att 166 353 B 294 *** Int 4 4 *** 3