Question

The National Football League (NFL) polls fans to develop a rating for each football game (NFL website, October 24, 2012). Each game is rated on a scale from (forgettable) to (memorable). The fan ratings for a random sample of games follow. Excel File: data07-11.xlsx a. Develop a point estimate of mean fan rating for the population of NFL games. b. Develop a point estimate of the standard deviation for the population of NFL games (to 4 decimals).

Answer 1

This question is incomplete, in that the Excel File: data07-11.xlsx a. was not provided, but I was able to get the information on the Excel File: data07-11.xlsx a. from google as below:

57 61 86 74 72 73

20 57 80 79 83 74

The image of the Excel File: data07-11.xlsx a. is also attached below.

Answer:

a) Point estimate of sample mean  = 68

b) Point estimate of standard deviation (4 decimals) = 17.8122

Step-by-step explanation:

a) Point estimate of sample mean, \bar{x}  =  ∑Xi / n = (57 + 61 + 85 + 74 + 73 + 72 + 20 + 58 + 81 + 78 + 84 + 73)/12 = 68

b) Point estimate of standard deviation = sqrt ∑ Xi² - n\bar{x}² / n-1)

= sqrt(((57 - 68)^2 + (61 - 68)^2 + (85 - 68)^2 + (74 - 68)^2 + (73 - 68)^2 + (72 - 68)^2 + (20 - 68)^2 + (58 - 68)^2 + (81 - 68)^2 + (78 - 68)^2 + (84 - 68)^2 + (73 - 68)^2)/11) = 17.8122