Description
In the Patrick Mahomes data please complete the following tasks:a. Calculate his completion percentage for each game in the data (CMP divided by ATT). Which game had the highest completion percentage? Which had the lowest?b. The AVG statistic computes his yards (YDS) per attempt (ATT) for each game. Calculate his mean yards per attempt for the entire data (not per game). Is this computed by calculating the totals and dividing them, or by taking the mean of the AVG statistic across all the games?c. Calculate the mean and standard deviation of his yards (YDS) across the whole data. Using this information, discuss how rare it would be for him to have a game with 400 passing yards. How about 500 yards?d. Does he seem to perform better in wins than in losses? (Wins are W in the Result variable, and losses are L.) Calculate the mean of some of his statistics for wins and for losses and compare them. You can pick the statistics to compare. As a suggestion, maybe compare YDS, TDs, and RTG (quarterback rating) between wins and losses.e. Investigate whether there is an opposing team that he has played particularly well or particularly poorly against. It should be a team he has faced at least 4 times. Look at his wins and losses against that team and also compare some of his statistics against that team with his overall statistics.