Monday, March 30, 2015

Super Bowl Project


  1. Using the Excel document to your data source, enter the scores of the winning and losing teams into your calculator. The winning teams 'scores will be entered into L1 and the losing teams' scores shouldnt be entered in L2. You should check to make sure your que date was entered and check Correctly That You Have 48 entries L1 and L2 is Both.

  2. Determine the average score for the winners and the score average for the losers. All scores shouldnt be rounded to the nearest integer.

    For winners: 30 points per match
For Losers: 16 points per match

  1. Create a box and whisker chart for Both the winners 'and losers' scores. How do the median scores compare? Remember, in order to construct a box and whisker chart, you will need to find the minimum, median, maximum and the 1 st and 3 rd quartiles. Make sure the scales are accurate que.

Winner (BLUE)
Minimun: 14
Median: 30.5
Maximum: 55
Q1: 23
Q2: 35

Loser (RED)
Minimum: 3
Median: 16.5
Maximum: 31
Q1: 10
Q2: 20.5

4.  Compare the Standard Deviations between the winning and losing scores. How are similar they? How are they different? What do they mean?

Winning = 6.8
Losing = 9.8
Similar: because the numbers are close to each other and the range of the points are close. For example, if we compare a football match with a baseball game, the points will be far apart, but the scores are in one range because They are all in the football game. If we compare basketball and football points points the points would be far apart.

Different: because the numbers are bigger standard deviation

5.Could there be a correlation between the Super Bowl number and the score of the game? Calculate the linear regression between the Super Bowl number and the winning score. What is the correlation coefficient? What does that tell us? Passing numbers have Increased over the past few years due to changes in rules. Has there Been an Increase in scores over the past few games? How did you come to that Conclusion?

Appearently, the Super Bowl games have not Affect Been through the years. Its clear que there's the correlation with the years and the score because the scores of the winning teams and lossing osilates throughout the history of Super Bowl. I came to this Conclusion because the first Super Bowl in 1967 Green Bay won 35 to 10 of Kansas City to score really similar to the Super Bowl of 2001. In 2001, Baltimore won 34 to 7 of NY Gaints and this happened 44 years later. The next year, 2002, New England won 20 to 17 of St. Louis, showing que The Possibility of having a similar or different score is possible because the years does not Affect the scores.

6.Calculate the linear regression between the winning team and the losing team. What does the correlation coefficient tell us? Based on your model, if the winning team scores 35 points, how many points will the losing team score? If the losing team scores 12 points, how many will the winning team score?

Linear regression: 
number and winner 
a = -2.95 
b = 42.21 

The correlation coefficient is When the scores or date is Increasing with the team. 

In this case, the correlation coefficient tells us if the scores are rising every year. 

No comments:

Post a Comment