Refer to the previous exercise for a description of the data set. Denise feels that, for her
Question:
Refer to the previous exercise for a description of the data set. Denise feels that, for her presentation, it would remove some biases if the player names and team names are suppressed. Remove these variables from the data set.
a. Denise also wants to remove outlier cases where the players have less than five touchdowns or more than 20 interceptions. Remove these observations from the data set. How many observations were removed from the data?
b. Return to the original data set. Use the imputation strategy to handle missing values. If there are missing values for Comp, Att, Pct, Yds, Avg, or Yds/G, impute the missing values using the mean of the variable. If there are missing values for TD or Int, impute the missing values using the median of the variable. What are the average values of Comp, Att, Pct, Yds, Avg, and Yds/G after imputation?
Data from Exercises 28
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 passes (Att), completion percentage (Pct), total yards thrown (Yds), average yards per attempt (Avg), yards thrown per game (Yds/G), number of touch downs (TD), and number of interceptions (Int).
Step by Step Answer:
Business Analytics Communicating With Numbers
ISBN: 9781260785005
1st Edition
Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen