alternate method of rating is to assign a numerical score to each player based on the player's status, numberof goals and number of games played.Write a formula in cell F2, which can be copied down the column, todetermine the player's quality score based on the following criteria:A regular player's quality score is their number of goals multiplied by 1.5 plus the number of games played.A rotation player's quality score is their the number of goals multiplied by 2 plus the number of games played