Winners and Losers The associated data set1 has quite a lot of information on almost all the Super Bowls played. The two variables we are most interested in Winner Pts and Loser Pts, which are the number of points the winning and losing teams scored, respectively. 1.) Compute a 99% confidence interval for the average number of points the losing team scores. {15 points} 2.) State your hypothesesin words and with mathematical notationabout whether the winning teams, on average, scores more points than the upper bound of the confidence interval from #1 for the losing teams. {10 points} 3.) Compute your test statistic. {10 points} 4.) Compute your p-value. {5 points} 5.) What do you conclude and why? {5 points} 6.) What does your findings from #1 and #5 tell you? Explain them in words a person who has not taken a statistics course could understand.

Copy and paste on excel to see the data

DateSBWinnerWinner PtsLoserLoser PtsMVPStadiumCityStateFeb 2 2020LIV (54)Kansas City Chiefs31San Francisco 49ers20Patrick MahomesHard Rock StadiumMiami GardensFloridaFeb 3 2019LIII (53)New England Patriots13Los Angeles Rams3Julian EdelmanMercedes-Benz StadiumAtlantaGeorgiaFeb 4 2018LII (52)Philadelphia Eagles41New England Patriots33Nick FolesU.S. Bank StadiumMinneapolisMinnesotaFeb 5 2017LI (51)New England Patriots34Atlanta Falcons28Tom BradyNRG StadiumHoustonTexasFeb 7 201650Denver Broncos24Carolina Panthers10Von MillerLevi's StadiumSanta ClaraCaliforniaFeb 1 2015XLIX (49)New England Patriots28Seattle Seahawks24Tom BradyUniversity of Phoenix StadiumGlendaleArizonaFeb 2 2014XLVIII (48)Seattle Seahawks43Denver Broncos8Malcolm SmithMetLife StadiumEast RutherfordNew JerseyFeb 3 2013XLVII (47)Baltimore Ravens34San Francisco 49ers31Joe FlaccoMercedes-Benz SuperdomeNew OrleansLouisianaFeb 5 2012XLVI (46)New York Giants21New England Patriots17Eli ManningLucas Oil StadiumIndianapolisIndianaFeb 6 2011XLV (45)Green Bay Packers31Pittsburgh Steelers25Aaron RodgersCowboys StadiumArlingtonTexasFeb 7 2010XLIV (44)New Orleans Saints31Indianapolis Colts17Drew BreesSun Life StadiumMiami GardensFloridaFeb 1 2009XLIII (43)Pittsburgh Steelers27Arizona Cardinals23Santonio HolmesRaymond James StadiumTampaFloridaFeb 3 2008XLII (42)New York Giants17New England Patriots14Eli ManningUniversity of Phoenix StadiumGlendaleArizonaFeb 4 2007XLI (41)Indianapolis Colts29Chicago Bears17Peyton ManningDolphin StadiumMiami GardensFloridaFeb 5 2006XL (40)Pittsburgh Steelers21Seattle Seahawks10Hines WardFord FieldDetroitMichiganFeb 6 2005XXXIX (39)New England Patriots24Philadelphia Eagles21Deion BranchAlltel StadiumJacksonvilleFloridaFeb 1 2004XXXVIII (38)New England Patriots32Carolina Panthers29Tom BradyReliant StadiumHoustonTexasJan 26 2003XXXVII (37)Tampa Bay Buccaneers48Oakland Raiders21Dexter JacksonQualcomm StadiumSan DiegoCaliforniaFeb 3 2002XXXVI (36)New England Patriots20St. Louis Rams17Tom BradyLouisiana SuperdomeNew OrleansLouisianaJan 28 2001XXXV (35)Baltimore Ravens34New York Giants7Ray Lewis+Raymond James StadiumTampaFloridaJan 30 2000XXXIV (34)St. Louis Rams23Tennessee Titans16Kurt Warner+Georgia DomeAtlantaGeorgiaJan 31 1999XXXIII (33)Denver Broncos34Atlanta Falcons19John Elway+Pro Player StadiumMiami GardensFloridaJan 25 1998XXXII (32)Denver Broncos31Green Bay Packers24Terrell Davis+Qualcomm StadiumSan DiegoCaliforniaJan 26 1997XXXI (31)Green Bay Packers35New England Patriots21Desmond HowardLouisiana SuperdomeNew OrleansLouisianaJan 28 1996XXX (30)Dallas Cowboys27Pittsburgh Steelers17Larry BrownSun Devil StadiumTempeArizonaJan 29 1995XXIX (29)San Francisco 49ers49San Diego Chargers26Steve Young+Joe Robbie StadiumMiami GardensFloridaJan 30 1994XXVIII (28)Dallas Cowboys30Buffalo Bills13Emmitt Smith+Georgia DomeAtlantaGeorgiaJan 31 1993XXVII (27)Dallas Cowboys52Buffalo Bills17Troy Aikman+Rose BowlPasadenaCaliforniaJan 26 1992XXVI (26)Washington Redskins37Buffalo Bills24Mark RypienMetrodomeMinneapolisMinnesotaJan 27 1991XXV (25)New York Giants20Buffalo Bills19Ottis AndersonTampa StadiumTampaFloridaJan 28 1990XXIV (24)San Francisco 49ers55Denver Broncos10Joe Montana+Louisiana SuperdomeNew OrleansLouisianaJan 22 1989XXIII (23)San Francisco 49ers20Cincinnati Bengals16Jerry Rice+Joe Robbie StadiumMiami GardensFloridaJan 31 1988XXII (22)Washington Redskins42Denver Broncos10Doug WilliamsJack Murphy StadiumSan DiegoCaliforniaJan 25 1987XXI (21)New York Giants39Denver Broncos20Phil SimmsRose BowlPasadenaCaliforniaJan 26 1986XX (20)Chicago Bears46New England Patriots10Richard Dent+Louisiana SuperdomeNew OrleansLouisianaJan 20 1985XIX (19)San Francisco 49ers38Miami Dolphins16Joe Montana+Stanford StadiumPalo AltoCaliforniaJan 22 1984XVIII (18)Los Angeles Raiders38Washington Redskins9Marcus Allen+Tampa StadiumTampaFloridaJan 30 1983XVII (17)Washington Redskins27Miami Dolphins17John Riggins+Rose BowlPasadenaCaliforniaJan 24 1982XVI (16)San Francisco 49ers26Cincinnati Bengals21Joe Montana+Pontiac SilverdomePontiacMichiganJan 25 1981XV (15)Oakland Raiders27Philadelphia Eagles10Jim PlunkettLouisiana SuperdomeNew OrleansLouisianaJan 20 1980XIV (14)Pittsburgh Steelers31Los Angeles Rams19Terry Bradshaw+Rose BowlPasadenaCaliforniaJan 21 1979XIII (13)Pittsburgh Steelers35Dallas Cowboys31Terry Bradshaw+Orange BowlMiamiFloridaJan 15 1978XII (12)Dallas Cowboys27Denver Broncos10Harvey MartinRandy White+SuperdomeNew OrleansLouisianaJan 9 1977XI (11)Oakland Raiders32Minnesota Vikings14Fred Biletnikoff+Rose BowlPasadenaCaliforniaJan 18 1976X (10)Pittsburgh Steelers21Dallas Cowboys17Lynn Swann+Orange BowlMiamiFloridaJan 12 1975IX (9)Pittsburgh Steelers16Minnesota Vikings6Franco Harris+Tulane StadiumNew OrleansLouisianaJan 13 1974VIII (8)Miami Dolphins24Minnesota Vikings7Larry Csonka+Rice StadiumHoustonTexasJan 14 1973VII (7)Miami Dolphins14Washington Redskins7Jake ScottMemorial ColiseumLos AngelesCaliforniaJan 16 1972VI (6)Dallas Cowboys24Miami Dolphins3Roger Staubach+Tulane StadiumNew OrleansLouisianaJan 17 1971V (5)Baltimore Colts16Dallas Cowboys13Chuck HowleyOrange BowlMiamiFloridaJan 11 1970IV (4)Kansas City Chiefs23Minnesota Vikings7Len Dawson+Tulane StadiumNew OrleansLouisianaJan 12 1969III (3)New York Jets16Baltimore Colts7Joe Namath+Orange BowlMiamiFloridaJan 14 1968II (2)Green Bay Packers33Oakland Raiders14Bart Starr+Orange BowlMiamiFloridaJan 15 1967I (1)Green Bay Packers35Kansas City Chiefs10Bart Starr+Memorial ColiseumLos AngelesCalifornia