how to slove this problem step by step

Background Michigan State University (MSU) and University of Michigan (UM) have been bitter rivalries in all sports for decades. In football especially, banter between fans flies both ways as people argue over supremacy. Verbal arguing only goes so far, so a quantitative assessment of the teams is needed to finally settle who has been the better team in the last decade. Problem Statement You are arguing with one of your Michigan friends about how to come up with a quantitative model to assess success in a football season and have reached an agreement that each individual season will receive a rating which corresponds to a score (1-6). You decide upon six different ratings to characterize the quality of a season: Awful, Poor, Fair, Good, Great, and Amazing. There are several factors that impact the quality of a season: . total number of wins winning or losing the UM/MSU game (called "rivalry games); winning, losing, or not going to a bowl game. . You and your friend decide upon the following conditions for each type of season: Table 1: Criteria for an individual and the corresponding rating Conditions 0 -3 wins Ratin Awful Poor Fair wins 6 - 8 wins 9 - 12 wins AND Lose both bowl and rivalry games Win exactly one of bowl or rivalry gameGreat Win both bowl and rivalry game Good Amazin Amazin 13 + wins To finish your quantitative analysis, you have decided that the ratings will receive a score as shown below in Table 2: Background Michigan State University (MSU) and University of Michigan (UM) have been bitter rivalries in all sports for decades. In football especially, banter between fans flies both ways as people argue over supremacy. Verbal arguing only goes so far, so a quantitative assessment of the teams is needed to finally settle who has been the better team in the last decade. Problem Statement You are arguing with one of your Michigan friends about how to come up with a quantitative model to assess success in a football season and have reached an agreement that each individual season will receive a rating which corresponds to a score (1-6). You decide upon six different ratings to characterize the quality of a season: Awful, Poor, Fair, Good, Great, and Amazing. There are several factors that impact the quality of a season: . total number of wins winning or losing the UM/MSU game (called "rivalry games); winning, losing, or not going to a bowl game. . You and your friend decide upon the following conditions for each type of season: Table 1: Criteria for an individual and the corresponding rating Conditions 0 -3 wins Ratin Awful Poor Fair wins 6 - 8 wins 9 - 12 wins AND Lose both bowl and rivalry games Win exactly one of bowl or rivalry gameGreat Win both bowl and rivalry game Good Amazin Amazin 13 + wins To finish your quantitative analysis, you have decided that the ratings will receive a score as shown below in Table 2