SSE: Using the NFL data below, rank the teams (top-to bottom) based on the rating/prediction technique discussed in the chapter on ranking sports teams. predicted home score margin = home field edge + home team rating - visiting team rating negative ratings are possible average rating = 0 The ratings should be selected based on the minimum sum of squared forecast errors. Sort the teams (Team#, Team Name and Rating) by rating in the descending order. Make sure the sort settings are saved. Do not change any Solver options. This model will be tested on different sets of input data. Home Field Edge: Mean Rating: Team# Team Name game# 1 Home Team # 19 Away Team # 14 Home Score Away Score 27 24 Rating 2 26 1 17 10 1 Arizona Cardinals 3 8 3 20 3 2 Atlanta Falcons 3 Baltimore Ravens 4 Buffalo Bills 4 22 7 31 24 5 6 11 16 20 6 4 15 10 13 5 Carolina Panthers 7 25 23 24 21 6 Chicago Bears 8 13 27 20 27 7 Cincinnati Bengals 9 20 29 7 21 8 Cleveland Browns 10 32 30 16 10 9 Dallas Cowboys 11 17 31 7 17 10 Denver Broncos 11 Detroit Lions 12 Green Bay Packers 12 28 2 19 21 13 18 9 35 17 14 24 21 31 17 13 Houston Texans 15 10 16 34 24 14 Indianapolis Colts 16 5 12 14 24 15 Jacksonville Jaguars 17 16 5 17 28 16 Kansas City Chiefs 18 12 6 10 21 17 Miami Dolphins 19 15 10 7 6 18 Minnesota Vikings 20 11 13 28 16 19 New England Patriots 21 31 14 17 31 20 New Orleans Saints 22 3 25 30 13 21 New York Giants 23 20 28 30 27 22 New York Jets 24 2 26 34 17 23 Oakland Raiders 25 21 32 20 14 24 Philadelphia Eagles 26 30 29 6 10 25 Pittsburgh Steelers 27 23 4 13 10 26 St. Louis Rams 28 9 8 19 12 27 San Diego Chargers 29 1 19 12 23 28 San Francisco 49ers 30 27 22 28 34 C NOTE: In this problem you can hard-code the v Add more columns below (I suggest three more