**URGENT** due in a couple of hours. Please do all of the parts. Excel file is there.
Denise Lau is an avid football fan and religiously follows every game of the National football League. During the 2017 season, she meticulously keeps a record of how each quarterback has played throughout the season. Denise is making a presentation at the local NFL fan club about these quarterbacks. The accompanying table shows a portion of the data that Denise has recorded with the following variables: the player's name (Player), team's name (Team), completed passes (Comp), attempted pass (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).
c. Which original variable is given the highest weight to compute the first principal component? Which original variable is given the highest weight 10 compute the second principal component?
d. What is the principal component 1 score for the first record (Aaron Rodgers)? (Round your final answer to 4 decimal places.)