Question

* Please include Excel formulas so I can check my work *

Alignment Number A recent article reported that there are approximately 11 minutes of actual playing time in a typical National Football League (NFL) game (The Wall Street Journal, January 15, 2010). The article included information about the amount of time devoted to replays, the amount of time devoted to commercials, and the amount of time the players spend stand- ing around between plays. Data consistent with the findings published in The Wall Street Journal are in the file named Standing. These data provide the amount of time players spend standing around between plays for a sample of 60 NFL games. Use the Standing data set to develop a point estimate of the number of minutes during an NFL game that players are standing around between plays. Compare this to the a. actual playing time reported in the article. Are you surprised? What is the sample standard deviation? b. Develop a 95% confidence interval for the number of minutes players spend standing around between plays.

STANDING
58
47
66
60
60
55
54
62
59
65
56
60
57
68
63
60
62
62
56
59
65
59
56
57
62
63
65
57
62
58
58
57
61
59
66
61
66
68
62
65
57
58
57
62
54
64
56
51
66
63
60
62
60
58
61
62
59
61
63
62

Answer 1

(a) Point estimate = sample mean = $\bar{x}$ = 60.2 minutes.
Yes, I am very much surprised, because the difference is quite big (60 minutes compared to 11 minutes).
Excel formula -> =AVERAGE(A2:A61)

(b) Sample s.d. = 4.0245 minutes.
Excel formula -> =STDEV.S(A2:A61)